ERDK

Transparent Table Application Table
43 Fields 6 CDS Views

Druckbeleg / Kopfdaten

ERDK is an SAP database table in S/4HANA. Druckbeleg / Kopfdaten. It contains 43 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 (43)

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
verart verart_kk Clearing Type
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
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

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.

-- Druckbeleg / Kopfdaten
-- 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]
    VERART,           -- Clearing Type [verart_kk]
    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]
    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]
    PRIMARY KEY (MANDT, OPBEL)
);

Learn More