1. Home
  2. Resources
  3. SAP Tables
  4. ERDB_ERDK - Generated Table for View

SAP Table ERDB_ERDK

Generated Table for View

ERDB_ERDK (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ERDB_ERDK to other SAP tables.

Source: ERDB_ERDK (Generated Table for View)

ERDB_ERDK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OPBEL Number of print document E_PRINTDOC CHAR 12 0
LFDNR Internal Consecutive Numbers of Documents in Invoicing E_DOCLFDNR NUMC 6 0
INVOPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
INVOPUPW Repetition Item in Contract Account Document OPUPW_KK NUMC 3 0
INVOPUPK Item number in contract account document OPUPK_KK NUMC 4 0
DOC_ID Type of Contract Accounting Document in Invoicing E_DOCID CHAR 1 0
& Old Municipal Charges Notification Item
+ Items Added to Payment Schema
- Items Removed from Payment Schema
/ Tax on Sls/Prch.Posting at Clearing
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 Transaction AWTYP CHAR 5 0
AWKEY Reference Key AWKEY CHAR 20 0
OPBEL_M Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
DRUCKDAT Print Date DRUCKDAT DATS 8 0
FAEDN Due date for net payment FAEDN_KK DATS 8 0
FAEDS Due Date for Cash Discount FAEDS_KK DATS 8 0
SKTPZ Cash discount rate SKTPZ_KK DEC 5 3
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
STOKZ Document Has Been Reversed STOKZ CHAR 1 0
NULL Field inactive
X Field active
INTOPBEL Number of Print Document Used to Reverse Document INTOPBEL CHAR 12 0
ERDZ_V ERDZ/ERDL exists for ERDK ERDZ_V CHAR 1 0
NULL Field inactive
X Field active
ERDR_V ERDR exists for ERDK ERDR_V CHAR 1 0
NULL Field inactive
X Field active
ERDO_V ERDO exists for ERDK ERDO_V CHAR 1 0
NULL Field inactive
X Field active
ERDB_V ERDB exists for ERDK ERDB_V CHAR 1 0
NULL Field inactive
X Field active
ERDU_V ERDU exists for ERDK ERDU_V CHAR 1 0
NULL Field inactive
X Field active
ERDTS_V ERDTS exists for ERDK ERDTS_V CHAR 1 0
NULL Field inactive
X Field active
FICA_V FI-CA Document Posted FICA_V CHAR 1 0
NULL Field inactive
X Field active
TOTAL_AMNT Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
TOTAL_WAER Transaction Currency BLWAE_KK CUKY 5 0
TOTAL_AMNT_USE Indicator: Use of bill sum total TOTAL_AMNT_USE CHAR 2 0
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 PYMET_KK CHAR 1 0
ZLSCH Form ID for Attached Payment Medium FIDZT T048X CHAR 1 0
NRZAS Payment Form Number NRZAS_KK CHAR 12 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
VKONT Contract Account Number VKONT_KK CHAR 12 0
PORTION Portion PORTION CHAR 8 0
ABRVORG Billing Transaction ABRVORG CHAR 2 0
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 FORMKEY CHAR 30 0
FIKEY Reconciliation Key for General Ledger FIKEY_KK CHAR 12 0
TOBRELEASD Indicator: document not released yet TOBRELEASD CHAR 1 0
NULL Field inactive
X Field active
SIMULATED Indicator: invoicing generates a simulated document SIMULATED CHAR 1 0
NULL Field inactive
X Field active
INVOICED Indicator: document posted INVOICED CHAR 1 0
NULL Field inactive
X Field active
ABWVK Alternative contract account for collective bills ABWVK_KK CHAR 12 0
ABWBL Number of the substitute FI-CA document ABWBL_KK CHAR 12 0
ERGRD Reason for creating print document ERGRD CHAR 2 0
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 LANGU_ACC T002 LANG 1 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
VERART Clearing Type For Clearing Postings VERART_KK CHAR 3 0
STO_BUDAT Reversal Date of Original Document (Reversal Only) STO_BUDAT DATS 8 0
STO_OPBEL Document Number of Original Document (Only for Reversal) STO_OPBEL CHAR 12 0
ICREASON Reason for Reversal BCREASON CHAR 2 0
MAZAE Counter for several dunning notices to a business partner MAZAE_KK NUMC 6 0
ITEMS_ARCHIVED Line items are archived ITEMS_ARCHIVED CHAR 1 0
NULL Not yet included in archiving
1 Print document line items can be archived
2 Print document line items can be deleted
3 Print document line items were deleted
4 Print document header can be archived
5 Print document header can be deleted
6 Budget billing plan can be archived
EXKID Key Identification EXKID_KK CHAR 2 0
01 Posting Document in Contract A/R and A/P
02 Not Used
EXBEL Official Document Number EXBEL_KK CHAR 16 0
MAZAE_ABS Counter for several dunning notices to a business partner MAZAE_KK NUMC 6 0
PRINTLOCK Document is Blocked for Printing E_PRINTLOCK CHAR 1 0
NULL 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
EDIDISPATCH Transmit Print Document Via EDI E_EDIDISPATCH CHAR 1 0
NULL Field inactive
X Field active
EDISENDDATE Generation Date of EDI for Print Document EDISENDDAT DATS 8 0
TAXDATE Tax Determination Date E_TAXDATE DATS 8 0
CREATION_TIME Time of Print Document Creation E_CREATION_TIME TIMS 6 0

ERDB_ERDK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ERDB_ERDK LANGU ERDB_ERDK LANGU T002 Language Keys (Component BC-I18) SPRAS
ERDB_ERDK ZLSCH ERDB_ERDK MANDT T048X Attached payment medium: Function modules MANDT
ERDB_ERDK ZLSCH * T048X Attached payment medium: Function modules LAND1
ERDB_ERDK ZLSCH ERDB_ERDK ZLSCH T048X Attached payment medium: Function modules ZLSCH