SAP table ERDK (Print Document/Header Data)

SAP table ERDK has 2 primary key fields being MANDT,OPBEL.

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
OPBEL Number of print document CHAR 12 0 E_PRINTDOC
DRUCKDAT Print Date DATS 8 0 DRUCKDAT
FAEDN Due date for net payment DATS 8 0 FAEDN_KK
FAEDS Due Date for Cash Discount DATS 8 0 FAEDS_KK
SKTPZ Cash Discount Percentage Rate DEC 5 3 SKTPZ_KK
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
STOKZ Document Has Been Reversed CHAR 1 0 STOKZ
INTOPBEL Number of Print Document Used to Reverse Document CHAR 12 0 INTOPBEL
ERDZ_V ERDZ/ERDL exists for ERDK CHAR 1 0 ERDZ_V
ERDR_V ERDR exists for ERDK CHAR 1 0 ERDR_V
ERDO_V ERDO exists for ERDK CHAR 1 0 ERDO_V
ERDB_V ERDB exists for ERDK CHAR 1 0 ERDB_V
ERDU_V ERDU exists for ERDK CHAR 1 0 ERDU_V
ERDTS_V ERDTS exists for ERDK CHAR 1 0 ERDTS_V
FICA_V FI-CA Document Posted CHAR 1 0 FICA_V
TOTAL_AMNT Amount in Transaction Currency with +/- Sign CURR 13 2 BETRW_KK
TOTAL_WAER Transaction Currency CUKY 5 0 BLWAE_KK
TOTAL_AMNT_USE Indicator: Use of bill sum total CHAR 2 0 TOTAL_AMNT_USE
01 No payment (amount falls below minimum amount)
02 Credit (no repayment method specified in master data)
03 Credit (no repayment method qualifies)
PYMET Payment Method CHAR 1 0 PYMET_KK
ZSBTR Total Amount from Bill Items in Payment Form CURR 13 2 E_ZSBTR
ZLSCH Form ID for Attached Payment Medium CHAR 1 0 T048X FIDZT
NRZAS Payment Form Number CHAR 12 0 NRZAS_KK
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
VKONT Contract Account Number CHAR 12 0 VKONT_KK
PORTION Portion CHAR 8 0 PORTION
ABRVORG Billing Transaction CHAR 2 0 ABRVORG
01 Periodic Billing (01)
02 Interim Billing (02)
03 Final Billing for Move-Out (03)
04 Period-End Billing (04)
05 Service Territory Transfer (05)
06 Manual Credit Memo/Backbilling (06)
07 Contract Change (07)
08 Customer change (08)
FORMKEY Application form CHAR 30 0 * FORMKEY
FIKEY Reconciliation Key for General Ledger CHAR 12 0 * FIKEY_KK
TOBRELEASD Indicator: document not released yet CHAR 1 0 TOBRELEASD
SIMULATED Indicator: invoicing generates a simulated document CHAR 1 0 SIMULATED
INVOICED Indicator: document posted CHAR 1 0 INVOICED
ABWVK Alternative Contract Account for Collective Bills CHAR 12 0 * ABWVK_KK
ABWBL Number of the Substitute FI-CA Document CHAR 12 0 ABWBL_KK
ERGRD Reason for creating print document CHAR 2 0 ERGRD
01 Print Consumption Billing (01)
02 Print Budget Billing Request (02)
03 Print Partial Bill (03)
04 Print Reversal Bill (04)
05 Print Collective Bill (05)
06 Print Consumption Billing + Partial Bill (06)
07 Print Budget Billing Change Document (07)
08 Print Budget Billing Requests for Industrial Customers (08)
RF Print Aggregated Billing (RF)
LANGU Language in connection with the contract account LANG 1 0 T002 LANGU_ACC
INVOICING_PARTY Service Provider That Invoices the Contract CHAR 10 0 INVOICING_PARTY
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM
VERART Clearing Type For Clearing Postings CHAR 3 0 VERART_KK
STO_BUDAT Reversal Date of Original Document (Reversal Only) DATS 8 0 STO_BUDAT
STO_OPBEL Document Number of Original Document (Only for Reversal) CHAR 12 0 STO_OPBEL
ICREASON Reason for Reversal CHAR 2 0 BCREASON
MAZAE Counter for several dunning notices to a business partner NUMC 6 0 MAZAE_KK
ITEMS_ARCHIVED Line items are archived CHAR 1 0 ITEMS_ARCHIVED
EXKID Key Identification CHAR 2 0 EXKID_KK
01 Posting Document in Contract A/R and A/P
02 Not Used
03 Invoicing Document in FI-CA
R4 IS-U Invoicing Document
EXBEL Official Document Number CHAR 16 0 EXBEL_KK
MAZAE_ABS Counter for several dunning notices to a business partner NUMC 6 0 MAZAE_KK
PRINTLOCK Document is Blocked for Printing CHAR 1 0 E_PRINTLOCK
No print block
1 Permanent print block for document
2 Print block can be undone
3 Original document for reversal document was not printed
4 Budget billing item was requested with invoice
5 On-Site Bill - Already Printed
6 Integration with Convergent Invoicing
EDIDISPATCH Transmit Print Document Via EDI CHAR 1 0 E_EDIDISPATCH
EDISENDDATE Generation Date of EDI for Print Document DATS 8 0 EDISENDDAT
TAXDATE Tax Determination Date DATS 8 0 E_TAXDATE
CREATION_TIME Time of Print Document Creation TIMS 6 0 E_CREATION_TIME
BILLING_PERIOD Billing Key Date (For Example January 2002) CHAR 10 0 E_BILLING_PERIOD
OSB_GROUP On-Site Billing Group CHAR 3 0 E_OSB_GROUP
DUMMY_UTILSINVCDOC_INCL_EEW_PS Dummy for Extensibility of Utilities Invoicing Document CHAR 1 0 E_UTILSINVCGDOC_INCL_EEW
REVLOCK Reversal Block Indicator for Print Documents CHAR 1 0 E_REVLOCK
Reversal Lock Not Set
X Reversal Lock Set
SEPA_PRENOT Invoicing Document Contains SEPA Pre-Notification CHAR 1 0 E_SEPA_PRENOT
INVDOCNO Number of Invoicing Document NUMC 12 0 INVDOCNO_KK
ISU2CI_CATEGORY Integration Category in Convergent Invoicing CHAR 4 0 TE482 ISU2CI_CATEGORY
RECNUM Total Number of Items for a Print Document INT4 10 0 E_PRINTDOC_RECNUM
SELECTION_DATE Selection date of a budget billing plan item DATS 8 0 ABSDAT_INV
COLOGRP_BP Colocation group for Business Partner CHAR 12 0 E_COLOGRP_BP
COLOGRP_BP_L Colocation group for Business Partner CHAR 12 0 E_COLOGRP_BP

ERDK foreign key relationships

Table Field Check Table Check Field
0 ERDK ISU2CI_CATEGORY TE482 Type of Integration with Convergent Invoicing MANDT
1 ERDK MANDT T000 Clients MANDT
0 ERDK ZLSCH T048X Attached payment medium: Function modules MANDT
0 ERDK ZLSCH T048X Attached payment medium: Function modules LAND1
0 ERDK ZLSCH T048X Attached payment medium: Function modules ZLSCH