ERDB
Documents for Print Document (ERDK)
ERDB is an SAP database table in S/4HANA. Documents for Print Document (ERDK). It contains 11 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /UCOM/I_ERDB | view | from | BASIC | Item Data of Print Document |
| SHSM_M_ERDKC | view | inner | Invoicing Document by FI/CA Document Number Search Help |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | opbel | E_PRINTDOC | Print document | |||
| KEY | lfdnr | E_DOCLFDNR | Cons. number | |||
| invopbel | OPBEL_KK | Document Number | ||||
| invopupw | OPUPW_KK | Repetition Item | ||||
| invopupk | OPUPK_KK | Item | ||||
| doc_id | E_DOCID | CA doc. in inv. | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awkey | AWKEY | Reference Key | ||||
| opbel_m | OPBEL_KK | Document Number | ||||
| cologrp_bp | E_COLOGRP_BP | Coloc. Grp BP |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Documents for Print Document (ERDK)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ERDB (
MANDT, -- Client [MANDT]
OPBEL, -- Print document [E_PRINTDOC]
LFDNR, -- Cons. number [E_DOCLFDNR]
INVOPBEL, -- Document Number [OPBEL_KK]
INVOPUPW, -- Repetition Item [OPUPW_KK]
INVOPUPK, -- Item [OPUPK_KK]
DOC_ID, -- CA doc. in inv. [E_DOCID]
AWTYP, -- Ref. procedure [AWTYP]
AWKEY, -- Reference Key [AWKEY]
OPBEL_M, -- Document Number [OPBEL_KK]
COLOGRP_BP, -- Coloc. Grp BP [E_COLOGRP_BP]
PRIMARY KEY (MANDT, OPBEL, LFDNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA