ERDK

Transparent Table Application Table
73 Fields 6 CDS Views

Print Document/Header Data

ERDK is an SAP database table in S/4HANA. Print Document/Header Data. It contains 73 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
CRMS4_IU_I_UID view_entity inner Utilities Invoice Document
E_UtilitiesInvoicingDocument view from EXTENSION Utilities Invoicing Document Extension
I_UtilitiesInvoicingDocument view from BASIC Invoicing Document
ISU_C4C_V2_BILL_AMOUNT view_entity from Get the Billing amount details
P_ISU_CSML_PRINTORIGDOCVH_BR view from BASIC
SHSM_M_ERDKC view from Invoicing Document by FI/CA Document Number Search Help

Fields (73)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel E_PRINTDOC Print document
druckdat DRUCKDAT Print Date
faedn FAEDN_KK Net Due Date
faeds FAEDS_KK Disct Due Date
sktpz SKTPZ_KK Discount rate
budat BUDAT Posting Date
bldat BLDAT Document Date
stokz STOKZ Doc. Reversed
intopbel INTOPBEL Rev. Doc. No.
erdz_v ERDZ_V ERDL/ERDZ exts
erdr_v ERDR_V ERDR exists
erdo_v ERDO_V ERDO exists
erdb_v ERDB_V ERDB exists
erdu_v ERDU_V ERDU exists
erdts_v ERDTS_V ERDTS exists
fica_v FICA_V FICA Posted
total_amnt BETRW_KK Amount
total_waer BLWAE_KK Currency
total_amnt_use TOTAL_AMNT_USE Sum total use
pymet PYMET_KK Payment Method
zsbtr E_ZSBTR Pymt Form Amt
zlsch FIDZT Form ID
nrzas NRZAS_KK Payment Form
partner BU_PARTNER Busn. Partner
vkont VKONT_KK Contract Acct
portion PORTION Portion
abrvorg ABRVORG Billing Trans.
formkey FORMKEY Applicat. form
fikey FIKEY_KK Reconcil. Key
tobreleasd TOBRELEASD Not released
simulated SIMULATED Doc. simulated
invoiced INVOICED Document posted
abwvk ABWVK_KK Coll. Bill Acct
abwbl ABWBL_KK Sub. Doc.
ergrd ERGRD Creation reason
langu LANGU_ACC Language
invoicing_party INVOICING_PARTY Inv. Serv. Prov
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
verart VERART_KK Clearing Type
sto_budat STO_BUDAT Orig. Rev. Date
sto_opbel STO_OPBEL Orig. Doc. No.
icreason BCREASON Reversal reason
mazae MAZAE_KK Dunning counter
items_archived ITEMS_ARCHIVED Lines archived
exkid EXKID_KK Key ID
exbel EXBEL_KK Offic. Doc. No.
mazae_abs MAZAE_KK Dunning counter
printlock E_PRINTLOCK Print block
edidispatch E_EDIDISPATCH EDI transmiss.
edisenddate EDISENDDAT EDI Gener. Date
taxdate E_TAXDATE Tax Determ. Dat
creation_time E_CREATION_TIME Creation Time
billing_period E_BILLING_PERIOD Bill. Key Date
osb_group E_OSB_GROUP OSB Group
dummy_utilsinvcdoc_incl_eew_ps E_UTILSINVCGDOC_INCL_EEW Dummy
revlock E_REVLOCK Rev.Blck for Pr.Doc.
sepa_prenot E_SEPA_PRENOT Pre-Notif.
invdocno INVDOCNO_KK Invoic. Doc.
isu2ci_category ISU2CI_CATEGORY CI Integr.Cat.
recnum E_PRINTDOC_RECNUM Number of Items
selection_date ABSDAT_INV Selection date
cologrp_bp E_COLOGRP_BP Coloc. Grp BP
cologrp_bp_l E_COLOGRP_BP Coloc. Grp BP
outsort1 OUTSORT_IN Outsrt. Invoic.
zszlcat AUSGRUP_IN Inv.outs.chk grp
numcopy NUMC5 numc5
mounted CHAR1 Single-Character Flag

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.

-- Print Document/Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ERDK (
    MANDT,                           -- Client [MANDT]
    OPBEL,                           -- Print document [E_PRINTDOC]
    DRUCKDAT,                        -- Print Date [DRUCKDAT]
    FAEDN,                           -- Net Due Date [FAEDN_KK]
    FAEDS,                           -- Disct Due Date [FAEDS_KK]
    SKTPZ,                           -- Discount rate [SKTPZ_KK]
    BUDAT,                           -- Posting Date [BUDAT]
    BLDAT,                           -- Document Date [BLDAT]
    STOKZ,                           -- Doc. Reversed [STOKZ]
    INTOPBEL,                        -- Rev. Doc. No. [INTOPBEL]
    ERDZ_V,                          -- ERDL/ERDZ exts [ERDZ_V]
    ERDR_V,                          -- ERDR exists [ERDR_V]
    ERDO_V,                          -- ERDO exists [ERDO_V]
    ERDB_V,                          -- ERDB exists [ERDB_V]
    ERDU_V,                          -- ERDU exists [ERDU_V]
    ERDTS_V,                         -- ERDTS exists [ERDTS_V]
    FICA_V,                          -- FICA Posted [FICA_V]
    TOTAL_AMNT,                      -- Amount [BETRW_KK]
    TOTAL_WAER,                      -- Currency [BLWAE_KK]
    TOTAL_AMNT_USE,                  -- Sum total use [TOTAL_AMNT_USE]
    PYMET,                           -- Payment Method [PYMET_KK]
    ZSBTR,                           -- Pymt Form Amt [E_ZSBTR]
    ZLSCH,                           -- Form ID [FIDZT]
    NRZAS,                           -- Payment Form [NRZAS_KK]
    PARTNER,                         -- Busn. Partner [BU_PARTNER]
    VKONT,                           -- Contract Acct [VKONT_KK]
    PORTION,                         -- Portion [PORTION]
    ABRVORG,                         -- Billing Trans. [ABRVORG]
    FORMKEY,                         -- Applicat. form [FORMKEY]
    FIKEY,                           -- Reconcil. Key [FIKEY_KK]
    TOBRELEASD,                      -- Not released [TOBRELEASD]
    SIMULATED,                       -- Doc. simulated [SIMULATED]
    INVOICED,                        -- Document posted [INVOICED]
    ABWVK,                           -- Coll. Bill Acct [ABWVK_KK]
    ABWBL,                           -- Sub. Doc. [ABWBL_KK]
    ERGRD,                           -- Creation reason [ERGRD]
    LANGU,                           -- Language [LANGU_ACC]
    INVOICING_PARTY,                 -- Inv. Serv. Prov [INVOICING_PARTY]
    ERDAT,                           -- Created On [ERDAT]
    ERNAM,                           -- Created By [ERNAM]
    AEDAT,                           -- Changed On [AEDAT]
    AENAM,                           -- Changed By [AENAM]
    BEGRU,                           -- AuthorizGroup [BEGRU]
    LOEVM,                           -- Delete [LOEVM]
    VERART,                          -- Clearing Type [VERART_KK]
    STO_BUDAT,                       -- Orig. Rev. Date [STO_BUDAT]
    STO_OPBEL,                       -- Orig. Doc. No. [STO_OPBEL]
    ICREASON,                        -- Reversal reason [BCREASON]
    MAZAE,                           -- Dunning counter [MAZAE_KK]
    ITEMS_ARCHIVED,                  -- Lines archived [ITEMS_ARCHIVED]
    EXKID,                           -- Key ID [EXKID_KK]
    EXBEL,                           -- Offic. Doc. No. [EXBEL_KK]
    MAZAE_ABS,                       -- Dunning counter [MAZAE_KK]
    PRINTLOCK,                       -- Print block [E_PRINTLOCK]
    EDIDISPATCH,                     -- EDI transmiss. [E_EDIDISPATCH]
    EDISENDDATE,                     -- EDI Gener. Date [EDISENDDAT]
    TAXDATE,                         -- Tax Determ. Dat [E_TAXDATE]
    CREATION_TIME,                   -- Creation Time [E_CREATION_TIME]
    BILLING_PERIOD,                  -- Bill. Key Date [E_BILLING_PERIOD]
    OSB_GROUP,                       -- OSB Group [E_OSB_GROUP]
    DUMMY_UTILSINVCDOC_INCL_EEW_PS,  -- Dummy [E_UTILSINVCGDOC_INCL_EEW]
    REVLOCK,                         -- Rev.Blck for Pr.Doc. [E_REVLOCK]
    SEPA_PRENOT,                     -- Pre-Notif. [E_SEPA_PRENOT]
    INVDOCNO,                        -- Invoic. Doc. [INVDOCNO_KK]
    ISU2CI_CATEGORY,                 -- CI Integr.Cat. [ISU2CI_CATEGORY]
    RECNUM,                          -- Number of Items [E_PRINTDOC_RECNUM]
    SELECTION_DATE,                  -- Selection date [ABSDAT_INV]
    COLOGRP_BP,                      -- Coloc. Grp BP [E_COLOGRP_BP]
    COLOGRP_BP_L,                    -- Coloc. Grp BP [E_COLOGRP_BP]
    OUTSORT1,                        -- Outsrt. Invoic. [OUTSORT_IN]
    ZSZLCAT,                         -- Inv.outs.chk grp [AUSGRUP_IN]
    NUMCOPY,                         -- numc5 [NUMC5]
    MOUNTED,                         -- Single-Character Flag [CHAR1]
    PRIMARY KEY (MANDT, OPBEL)
);

Learn More