ERDB_ERDK SAP (Generated Table for View) Table View details
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
ERDB_ERDK is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The ERDB_ERDK table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include OPBEL (Number of print document), LFDNR (Internal Consecutive Numbers of Documents in Invoicing), INVOPBEL (Number of Contract Accts Rec. & Payable Doc.), INVOPUPW (Repetition Item in Contract Account Document).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP ERDB_ERDK table view 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 | MANDT | ||||
OPBEL | Number of print document | E_PRINTDOC | CHAR | 12 | ALPHA | E_PRINTDOC | E_PRINTDOC | ||
LFDNR | Internal Consecutive Numbers of Documents in Invoicing | E_DOCLFDNR | NUMC | 6 | LFDNR6 | ||||
INVOPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | ALPHA | OPBEL_KK | 80B | ||
INVOPUPW | Repetition Item in Contract Account Document | OPUPW_KK | NUMC | 3 | OPUPW_KK | ||||
INVOPUPK | Item number in contract account document | OPUPK_KK | NUMC | 4 | OPUPK_KK | ||||
DOC_ID | Type of Contract Accounting Document in Invoicing | E_DOCID | CHAR | 1 | E_DOCID | ||||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | AWTYP | ||||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
OPBEL_M | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | ALPHA | OPBEL_KK | 80B | ||
DRUCKDAT | Print Date | DRUCKDAT | DATS | 8 | DATUM | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
STOKZ | Document Has Been Reversed | STOKZ | CHAR | 1 | KENNZX | ||||
INTOPBEL | Number of Print Document Used to Reverse Document | INTOPBEL | CHAR | 12 | ALPHA | E_PRINTDOC | |||
ERDZ_V | ERDZ/ERDL exists for ERDK | ERDZ_V | CHAR | 1 | KENNZX | ||||
ERDR_V | ERDR exists for ERDK | ERDR_V | CHAR | 1 | KENNZX | ||||
ERDO_V | ERDO exists for ERDK | ERDO_V | CHAR | 1 | KENNZX | ||||
ERDB_V | ERDB exists for ERDK | ERDB_V | CHAR | 1 | KENNZX | ||||
ERDU_V | ERDU exists for ERDK | ERDU_V | CHAR | 1 | KENNZX | ||||
ERDTS_V | ERDTS exists for ERDK | ERDTS_V | CHAR | 1 | KENNZX | ||||
FICA_V | FI-CA Document Posted | FICA_V | CHAR | 1 | KENNZX | ||||
TOTAL_AMNT | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
TOTAL_WAER | Transaction Currency | BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
TOTAL_AMNT_USE | Indicator: Use of bill sum total | TOTAL_AMNT_USE | CHAR | 2 | TOTAL_AMNT_USE | ||||
PYMET | Payment Method | PYMET_KK | CHAR | 1 | PYMET_KK | ||||
ZLSCH | Form ID for Attached Payment Medium | FIDZT | CHAR | 1 | T048X | FIDZT | |||
NRZAS | Payment Form Number | NRZAS_KK | CHAR | 12 | ALPHA | NRZAS_KK | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
PORTION | Portion | PORTION | CHAR | 8 | PORTION | TPR | E420 | ||
ABRVORG | Billing Transaction | ABRVORG | CHAR | 2 | ABRVORG | ABV | |||
FORMKEY | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | FIKEY_KK | FKFI1 | |||
TOBRELEASD | Indicator: document not released yet | TOBRELEASD | CHAR | 1 | KENNZX | ||||
SIMULATED | Indicator: invoicing generates a simulated document | SIMULATED | CHAR | 1 | KENNZX | ||||
INVOICED | Indicator: document posted | INVOICED | CHAR | 1 | KENNZX | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
ABWBL | Number of the substitute FI-CA document | ABWBL_KK | CHAR | 12 | ALPHA | ABWBL_KK | |||
ERGRD | Reason for creating print document | ERGRD | CHAR | 2 | ERGRD | ||||
LANGU | Language in connection with the contract account | LANGU_ACC | LANG | 1 | T002 | ISOLA | SPRAS | ||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
VERART | Clearing Type For Clearing Postings | VERART_KK | CHAR | 3 | CHAR3 | ||||
STO_BUDAT | Reversal Date of Original Document (Reversal Only) | STO_BUDAT | DATS | 8 | DATUM | ||||
STO_OPBEL | Document Number of Original Document (Only for Reversal) | STO_OPBEL | CHAR | 12 | ALPHA | E_PRINTDOC | |||
ICREASON | Reason for Reversal | BCREASON | CHAR | 2 | BCREASON | TE272_BCREASON_F4 | |||
MAZAE | Counter for several dunning notices to a business partner | MAZAE_KK | NUMC | 6 | NUMC6 | ||||
ITEMS_ARCHIVED | Line items are archived | ITEMS_ARCHIVED | CHAR | 1 | ISU_ARCH_KENNZ1 | ||||
EXKID | Key Identification | EXKID_KK | CHAR | 2 | EXKID_KK | ||||
EXBEL | Official Document Number | EXBEL_KK | CHAR | 16 | ALPHA | EXBEL_KK | |||
MAZAE_ABS | Counter for several dunning notices to a business partner | MAZAE_KK | NUMC | 6 | NUMC6 | ||||
PRINTLOCK | Document is Blocked for Printing | E_PRINTLOCK | CHAR | 1 | E_PRINTLOCK | ||||
EDIDISPATCH | Transmit Print Document Via EDI | E_EDIDISPATCH | CHAR | 1 | KENNZX | ||||
EDISENDDATE | Generation Date of EDI for Print Document | EDISENDDAT | DATS | 8 | DATUM | ||||
TAXDATE | Tax Determination Date | E_TAXDATE | DATS | 8 | DATS | ||||
CREATION_TIME | Time of Print Document Creation | E_CREATION_TIME | TIMS | 6 | TIME |
Key field | Non-key field |
How do I retrieve data from SAP table ERDB_ERDK using ABAP code
The following ABAP code Example will allow you to do a basic selection on ERDB_ERDK to SELECT all data from the tableDATA: WA_ERDB_ERDK TYPE ERDB_ERDK.
SELECT SINGLE *
FROM ERDB_ERDK
INTO CORRESPONDING FIELDS OF WA_ERDB_ERDK
WHERE...
How to access SAP table ERDB_ERDK
Within an ECC or HANA version of SAP you can also view further information about ERDB_ERDK 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