SAP table KBLE (Document Item Processing: Manual Document Entry)

SAP table KBLE has 4 primary key fields being MANDT,BELNR,BLPOS,BPENT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Document Number for Earmarked Funds CHAR 10 0 KBLNR
BLPOS Earmarked Funds: Document Item NUMC 3 0 KBLPOS
BPENT Document Item Processing NUMC 5 0 KBLBPENT
VRGNG Business Transaction CHAR 4 0 TJ01 KBLVORGANG
ERFAS Entered By CHAR 12 0 KBLERF
ERDAT Entered On DATS 8 0 KBLERDAT
AENDE Last Changed By CHAR 12 0 KBLAEN
AEDAT Date of Last Change DATS 8 0 KBLAEDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
ATEXT Reduction Text CHAR 50 0 KBLATEXT
STATS Reduction Is Statistical CHAR 1 0 FMEF_CONS_STATS
ERLKZ Completion Indicator for Line Item CHAR 1 0 KBLERLKZ
WTABB Amount in Transaction Currency CURR 15 2 KBLWTA
STOKZ Indicator: Document was reversed CHAR 1 0 CO_STOKZ
RAUFNR Order Number CHAR 12 0 AUFK AUFNR
RPSPNR WBS Element NUMC 8 0 PRPS PS_POSNR
RBUKRS Company Code CHAR 4 0 BUKRS
RGJAHR Fiscal Year NUMC 4 0 GJAHR
RBELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
RBUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
REBELN Purchasing Document Number CHAR 10 0 EBELN
REBELP Item Number of Purchasing Document NUMC 5 0 EBELP
RZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
RETENR Schedule Line Number NUMC 4 0 ETENR
RSTUNR Step Number NUMC 3 0 STUNR
RZAEHK Condition Counter NUMC 3 0 DZAEHK
RBANFN Purchase Requisition Number CHAR 10 0 BANFN
RBNFPO Item number of purchase requisition NUMC 5 0 BNFPO
RZEBKN Serial number for PReq account assignment segment NUMC 2 0 DZEBKN
RKBLNR Reference Doc. No. (Reference to Original Document in KBLK) CHAR 10 0 KBLK KBLRBELNR
RKBLPOS Reference Doc. Item (Reference to Original Document in KBLP) NUMC 3 0 KBLP KBLRBLPOS
BLCKZ Blocking Indicator for Amounts in KBLE and KBLEW CHAR 1 0 KBLBLCKZ
AWTYP Reference procedure CHAR 5 0 AWTYP
AWREF Reference document number CHAR 10 0 AWREF
AWORG Reference Organizational Units CHAR 10 0 AWORG
RCOBELNR Document Number CHAR 10 0 COBK CO_BELNR
RCOBUZEI Posting Row NUMC 3 0 CO_BUZEI
WTABBAPP Usage Amount to Be Released (TC) CURR 15 2 WTABBAPP
KURSU Last Revaluation Rate DEC 9 5 KURSU
DATU Date of Last Revaluation DATS 8 0 DATU
AWSYS Logical system of source document CHAR 10 0 AWSYS
AWPOS Reference line item CHAR 10 0 AWPOS
BUDAT Posting Date in the Document DATS 8 0 BUDAT
FIKEY Reconciliation Key for General Ledger CHAR 12 0 FIKEY_KK
PSOWO Development record was already processed CHAR 1 0 PSOWO
A Document already cleared
E Request already created

KBLE foreign key relationships

Table Field Check Table Check Field
0 KBLE MANDT T000 Clients MANDT
1 KBLE RAUFNR AUFK Order master data AUFNR
0 KBLE RCOBELNR COBK CO Object: Document Header KOKRS
0 KBLE RCOBELNR COBK CO Object: Document Header BELNR
1 KBLE RKBLNR KBLK Document Header: Manual Document Entry MANDT
1 KBLE RKBLNR KBLK Document Header: Manual Document Entry BELNR
0 KBLE RKBLPOS KBLP Document Item: Manual Document Entry MANDT
0 KBLE RKBLPOS KBLP Document Item: Manual Document Entry BELNR
1 KBLE RPSPNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 KBLE RPSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 KBLE VRGNG TJ01 Business Transactions VRGNG