SAP table ERDB (Documents for Print Document (ERDK))

SAP table ERDB has 3 primary key fields being MANDT,OPBEL,LFDNR.

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 MANDT
OPBEL Number of print document CHAR 12 0 E_PRINTDOC
LFDNR Internal Consecutive Numbers of Documents in Invoicing NUMC 6 0 E_DOCLFDNR
INVOPBEL Number of a FI-CA Document CHAR 12 0 OPBEL_KK
INVOPUPW Repetition Item in FI-CA Document NUMC 3 0 OPUPW_KK
INVOPUPK Item Number in FI-CA Document NUMC 4 0 OPUPK_KK
DOC_ID Type of Contract Accounting Document in Invoicing CHAR 1 0 E_DOCID
& Old Municipal Charges Notification Item
+ Items Added to Payment Schema
- Items Removed from Payment Schema
/ Tax on Sls/Prch.Posting at Clearing
7 Document from Integration with Convergent Invoicing
A Invoicing Document
B Clearing Document (Clearing of Budget Billing Payments)
C Clearing document (account maintenance)
D Interest document (cash security deposits)
E Interest document (interest on arrears)
F Request with invoicing
G Debit entry from statistical item
H Down Payment Request for Payment Scheme
I Down Payment Requests
J Release/Adjust Cash Security Deposit
K Payment schema from invoicing
L Budget Billing Request BBP5
N Document from user exit
O Source Receivable of Installment Plan Payment Scheme
P Print with invoicing
Q Budget Billing Request/Reversal Through Invoicing
R Budget billing request
S Actual document from SD billing
T Partial Bill
U Transfer
V Aggregated Bill
W Stamp Tax
X Reference document from SD billing
Y Additional Deregulation Items
Z Collective Bill
AWTYP Reference procedure CHAR 5 0 AWTYP
AWKEY Reference Key CHAR 20 0 AWKEY
OPBEL_M Number of a FI-CA Document CHAR 12 0 OPBEL_KK
COLOGRP_BP Colocation group for Business Partner CHAR 12 0 E_COLOGRP_BP