KBLK SAP (Document Header: Manual Document Entry) Table details
Dictionary Type: Table
Description: Document Header: Manual Document Entry
Description: Document Header: Manual Document Entry
Table field list including key, data, relationships and ABAP select examples
KBLK is a standard SAP Table which is used to store Document Header: Manual Document Entry data and is available within R/3 SAP systems depending on the version and release level.
The KBLK table consists of various fields, each holding specific information or linking keys about Document Header: Manual Document Entry data available in SAP. These include BELNR (Document Number for Earmarked Funds), KVRGNG (Business Transaction), KERFAS (Created by), KERDAT (Entry date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP KBLK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | ALPHA | KBLNR | KBL | ||
KVRGNG | Business Transaction | KBLVORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
KERFAS | Created by | KBLERF | CHAR | 12 | USNAM | ||||
KERDAT | Entry date | KBLERDAT | DATS | 8 | DATUM | ||||
KAENDE | Last changed by | KBLAEN | CHAR | 12 | USNAM | ||||
KAEDAT | Date of Last Change | KBLAEDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
KTEXT | Doc.header text | KBLKTEXT | CHAR | 50 | TEXT50 | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLART | Doc.type: Manual document entry | KBLART | CHAR | 2 | KBLART | KDT | |||
BLTYP | Earmarked Funds Document Category | KBLTYP | NUMC | 3 | KBLTYP | ||||
VARNR | Listscreen variant | KBLVAR | CHAR | 5 | VARNR_021F | ||||
WAERS | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
KLOEKZ | Deletion Indicator | KBLLOEKZ | CHAR | 1 | CHAR1_X | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
LTEXT | Long Text Exists | KBLLTEXT | CHAR | 1 | XFELD | ||||
RBELNR | Reference doc.no. (reference to orig.document in KBLK) | KBLRBELNR | CHAR | 10 | KBLK | ALPHA | KBLNR | KBL | |
LOTKZ | Lot Number for Documents | LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
HWAER | Local currency key | HSWAE | CUKY | 5 | Assigned to domain | WAERS | |||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
NEGVAL | Indicator: Document has Negative Amounts | NEGVAL | CHAR | 1 | XFELD | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLKKZ | Blocking indicator (header) | BLKKZ | CHAR | 1 | CHAR1_X | ||||
FEXEC | Indicator: final completion (paid) | FEXEC | CHAR | 1 | XFELD | ||||
WKAPK | Indicator: document is approved | WKAPK | CHAR | 1 | CHAR1 | ||||
WKAOK | Document already approved once | WKAOK | CHAR | 1 | CHAR1 | ||||
ADDITIV_CONS_LOG | Additive Consumption Logic of Earmarked Funds | ADDITIV_CONSUMPTION_LOGIC | CHAR | 1 | CHAR1_X | ||||
FMREASON | Reason for decision for workflow | FMREASON | CHAR | 2 | Assigned to domain | FMREASON | |||
WF_START | Start workflow | WF_START | CHAR | 1 | CHAR1_X | ||||
ORGVG | Original CO business transaction | CO_ORGVG | CHAR | 4 | T022 | ACTIVITY | |||
KURSUK | Last revaluation rate | KURSU | DEC | 9(5) | EXCRT | KURSF | |||
DATUK | Date of last revaluation | DATU | DATS | 8 | DATUM | ||||
NPRBUDGET | Update in non-profile budget | FM_NPRBUDG | CHAR | 1 | CHAR1 | ||||
PAYBUDGET | Update in Payment Budget | FM_PAYBUDG | CHAR | 1 | CHAR1_X | ||||
COMBUDGET | Update in commitment budget | FM_COMBUDG | CHAR | 1 | CHAR1_X | ||||
DOCLOCK | Funds precommitment document block | FMRDOCLOCK | CHAR | 2 | FMRESLOCKS | FMRLOCK | |||
PMDOCS | Change of document amounts only by value adjustment docs | FMPMDOCS | CHAR | 1 | XFLAG | ||||
RFBLNR | Reference Document Number | AWREF | CHAR | 10 | ALPHA | AWREF | |||
RFORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
RFTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
RFSYS | Logical system of source document | AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
MVSTAT | Document Entry Status (Posted, Parked) | FMR_MVSTAT | CHAR | 1 | FMR_MVSTAT | ||||
INV_CONS | Indicator: Invoice Verification as Separate Consumption | FMRE_INV_CONS | CHAR | 1 | CHAR1_X | ||||
XDATE | Reference Date | SAFM_XDATE | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
FMRO_TEMPLATE | Indicator that document is a recurring obligations template | FMRO_TEMPLATE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
/SAPF15/STATUS | /SAPF15/STATUS | CHAR | 1 | /SAPF15/STATUS | |||||
.INCLU--AP | 0 | ||||||||
CCINS | Payment cards: Card type | CCINS_30F | CHAR | 4 | TCRIN | CCINS_30F | CIN | ||
CCNUM | Payment cards: Card number | CCNUM_30F | CHAR | 25 | CCNUM_30F | CNO | |||
CCNAME | Payment cards: Name of cardholder | CCNAME_30F | CHAR | 40 | CHAR40 | ||||
CCTYP | Payment cards: Card category | CCTYP_30F | CHAR | 2 | CHAR2 | ||||
CRPUDATE | Card Document: Date of Card Transaction (Purchase Date) | CRPUDATE | DATS | 8 | DATUM | ||||
CRAUTHNO | Card Document: Authorization Number of Transaction | CRAUTHNO | CHAR | 15 | CHAR15 | ||||
CRSUPPLIER | Card Document: Trader According to Document | CRSUPPLIER | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
CRWRBTR | Card Document: Paid Transaction Amount | CRWRBTR | CURR | 15(2) | WERT8 | ||||
CRMWSKZ | Card Document: Tax on Sales/Purchases Code | CRMWSKZ | CHAR | 2 | T007A | MWSKZ | |||
CRTXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
CRWMWST | Card Document: Tax on Sales/Purchases Paid | CRWMWST | CURR | 15(2) | WERT8 | ||||
CRCALCTAX | Payment Cards: Calculate Tax | CRCALCTAX | CHAR | 1 | XFELD | XTX | |||
CRNETBTR | Card Document: Net Amount Paid | CRNETBTR | CURR | 15(2) | WERT8 | ||||
CRDMBTR | Card Document: Transaction Amount in Local Currency (Calc.) | CRDMBTR | CURR | 15(2) | WERT8 | ||||
CRMWSTS | Card Document: Tax on Sales/Purchases Paid in Local Currency | CRMWSTS | CURR | 15(2) | WERT8 | ||||
CRNETDMBTR | Card Document: Net Amount Paid in Local Currency | CRNETDMBTR | CURR | 15(2) | WERT8 | ||||
CRMATGOT | Card Document: Goods Received | CRRECIEVED | CHAR | 1 | XFELD | ||||
CREATE_RES | Card Document: Reserve Funds | CREATE_RES | CHAR | 1 | XFELD | ||||
CRMATCH | Card Document: Reduction Earmarked | CRMATCH | CHAR | 1 | CHAR1_X | ||||
CRMATCHDT | Card Documente: Date from which Reduction Is Planned | CRMATCHDT | DATS | 8 | DATUM | ||||
CRSUPNAM | Payment Cards: Name and Address of Vendor | CRSUPNAM | CHAR | 60 | CHAR60 |
Key field | Non-key field |
How do I retrieve data from SAP table KBLK using ABAP code
The following ABAP code Example will allow you to do a basic selection on KBLK to SELECT all data from the tableDATA: WA_KBLK TYPE KBLK.
SELECT SINGLE *
FROM KBLK
INTO CORRESPONDING FIELDS OF WA_KBLK
WHERE...
How to access SAP table KBLK
Within an ECC or HANA version of SAP you can also view further information about KBLK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects