KBLK table in SAP ERP or S/4HANA stores Document Header: Manual Document Entry data. There are total 79 fields in KBLK table. The Document Header: Manual Document Entry table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of KBLK table. It is in Earmarked funds (FMRE) ABAP package and is part of the Funds Management (FI-FM) module.
SAP KBLK Table Fields
Following is the list of fields that are available in SAP KBLK table. The primary key fields of Document Header: Manual Document Entry table in SAP are MANDT (Client), BELNR (Document Number for Earmarked Funds).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| BELNR | Document Number for Earmarked Funds | KBLNR | CHAR(10) | |
| KVRGNG | Business Transaction | KBLVORGANG | TJ01 | CHAR(4) |
| KERFAS | Entered By | KBLERF | CHAR(12) | |
| KERDAT | Entered On | KBLERDAT | DATS(8) | |
| KAENDE | Last Changed By | KBLAEN | CHAR(12) | |
| KAEDAT | Date of Last Change | KBLAEDAT | DATS(8) | |
| BLDAT | Document Date in Document | BLDAT | DATS(8) | |
| KTEXT | Document Header Text | KBLKTEXT | CHAR(50) | |
| XBLNR | Reference Document Number | XBLNR1 | CHAR(16) | |
| BLART | Document Type: Manual Document Entry | KBLART | CHAR(2) | |
| BLTYP | Earmarked Funds Document Category | KBLTYP | NUMC(3) | |
| VARNR | List Entry Variant | KBLVAR | CHAR(5) | |
| WAERS | Transaction Currency | TWAER | TCURC | CUKY(5) |
| KLOEKZ | Deletion Indicator | KBLLOEKZ | CHAR(1) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR(4) |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR(4) |
| FIKRS | Financial Management Area | FIKRS | FM01 | CHAR(4) |
| LTEXT | Long Text Exists | KBLLTEXT | CHAR(1) | |
| RBELNR | Reference Doc. No. (Reference to Original Document in KBLK) | KBLRBELNR | KBLK | CHAR(10) |
| LOTKZ | Lot Number for Documents | LOTKZ | CHAR(10) | |
| HWAER | Local currency key | HSWAE | CUKY(5) | |
| KURSF | Exchange rate | KURSF | DEC(9) | |
| WWERT | Translation date | WWERT_D | DATS(8) | |
| NEGVAL | Indicator: Document Has Negative Amounts | NEGVAL | CHAR(1) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS(8) | |
| FMRE_XBLNR2 | Reference 2 | FMRE_XBLNR2 | CHAR(70) | |
| FMRE_XBLNR3 | Reference 3 | FMRE_XBLNR3 | CHAR(70) | |
| PSOEF_MLTYR | Earmarked Funds for Standing Requests: All Years | FMRE_PSOEF_MLTYR | CHAR(1) | |
| BLKKZ | Blocking Indicator (Header) | BLKKZ | CHAR(1) | |
| FEXEC | Indicator: Final Completion (Paid) | FEXEC | CHAR(1) | |
| WKAPK | Indicator: Document Is Approved | WKAPK | CHAR(1) | |
| WKAOK | Document Already Approved Once | WKAOK | CHAR(1) | |
| ADDITIV_CONS_LOG | Additive Consumption Logic of Earmarked Funds | ADDITIV_CONSUMPTION_LOGIC | CHAR(1) | |
| FMREASON | Reason for Decision for Workflow | FMREASON | * | CHAR(2) |
| WF_START | Start Workflow | WF_START | CHAR(1) | |
| ORGVG | Original CO Business Transaction | CO_ORGVG | T022 | CHAR(4) |
| KURSUK | Last Revaluation Rate | KURSU | DEC(9) | |
| DATUK | Date of Last Revaluation | DATU | DATS(8) | |
| NPRBUDGET | Update in Non-Profile Budget | FM_NPRBUDG | CHAR(1) | |
| PAYBUDGET | Update in Payment Budget | FM_PAYBUDG | CHAR(1) | |
| COMBUDGET | Update in Commitment Budget | FM_COMBUDG | CHAR(1) | |
| DOCLOCK | Funds Precommitment Document Block | FMRDOCLOCK | FMRESLOCKS | CHAR(2) |
| PMDOCS | Changes to Doc. Amounts Only Using Value Adjustment Docs | FMPMDOCS | CHAR(1) | |
| RFBLNR | Reference document number | AWREF | CHAR(10) | |
| RFORG | Reference Organizational Units | AWORG | CHAR(10) | |
| RFTYP | Reference procedure | AWTYP | * | CHAR(5) |
| RFSYS | Logical system of source document | AWSYS | * | CHAR(10) |
| MVSTAT | Document Entry Status (Posted, Parked) | FMR_MVSTAT | CHAR(1) | |
| INV_CONS | Indicator: Invoice Verification as Separate Consumption | FMRE_INV_CONS | CHAR(1) | |
| XDATE | Reference Date | SAFM_XDATE | DATS(8) | |
| FMRO_TEMPLATE | Indicator that document is a recurring obligations template | FMRO_TEMPLATE | CHAR(1) | |
| REFT | 30 Characters | CHAR30 | CHAR(30) | |
| MODA | Numc3, internal use | NUMC3 | NUMC(3) | |
| PFM_FOA | Form of Amendment Code | PFM_FOA | PFM_TFOA | CHAR(2) |
| PFM_SPEC | Specification Code | PFM_SPEC | PFM_TSPEC | CHAR(2) |
| PFM_CONTRACT | PTFM: Contract in Purchasing process | PFM_CONTRACT | NUMC(8) | |
| /SAPF15/STATUS | Document Status | /SAPF15/STATUS | CHAR(1) | |
| CCINS | Payment cards: Card type | CCINS_30F | TCRIN | CHAR(4) |
| CCNUM | Payment cards: Card number | CCNUM_30F | CHAR(25) | |
| CCNAME | Payment cards: Name of cardholder | CCNAME_30F | CHAR(40) | |
| CCTYP | Payment cards: Card category | CCTYP_30F | CHAR(2) | |
| CRPUDATE | Card Document: Date of Card Transaction (Purchase Date) | CRPUDATE | DATS(8) | |
| CRAUTHNO | Card Document: Authorization Number of Transaction | CRAUTHNO | CHAR(15) | |
| CRSUPPLIER | Card Document: Trader According to Document | CRSUPPLIER | LFA1 | CHAR(10) |
| CRWRBTR | Card Document: Paid Transaction Amount | CRWRBTR | CURR(23) | |
| CRMWSKZ | Card Document: Tax on Sales/Purchases Code | CRMWSKZ | T007A | CHAR(2) |
| CRTXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR(15) |
| CRWMWST | Card Document: Tax on Sales/Purchases Paid | CRWMWST | CURR(23) | |
| CRCALCTAX | Payment Cards: Calculate Tax | CRCALCTAX | CHAR(1) | |
| CRNETBTR | Card Document: Net Amount Paid | CRNETBTR | CURR(23) | |
| CRDMBTR | Card Document: Transaction Amount in Local Currency (Calc.) | CRDMBTR | CURR(23) | |
| CRMWSTS | Card Document: Tax on Sales/Purchases Paid in Local Currency | CRMWSTS | CURR(23) | |
| CRNETDMBTR | Card Document: Net Amount Paid in Local Currency | CRNETDMBTR | CURR(23) | |
| CRMATGOT | Card Document: Goods Received | CRRECIEVED | CHAR(1) | |
| CREATE_RES | Card Document: Reserve Funds | CREATE_RES | CHAR(1) | |
| CRMATCH | Card Document: Reduction Earmarked | CRMATCH | CHAR(1) | |
| CRMATCHDT | Card Documente: Date from which Reduction Is Planned | CRMATCHDT | DATS(8) | |
| CRSUPNAM | Payment Cards: Name and Address of Vendor | CRSUPNAM | CHAR(60) |
