DAC_D_MATDOC

Transparent Table Application Table
12 Fields 1 CDS Views

Digital Access for Material Line Items

DAC_D_MATDOC is an SAP database table in S/4HANA. Digital Access for Material Line Items. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DgtlAccLicMaterialDocument view from BASIC Digital Access Logging Table for Material Line Items

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mblnr MBLNR Material Doc.
KEY mjahr MJAHR Mat. Doc. Year
KEY document_type RSUVM_UNIT Unit
KEY action_type DAC_ACTION_TYPE Act Type
KEY instance_count INT4 INT4
KEY erdat ERDAT Created On
KEY erzet ERZET Time
dac_pp_component EPP_COMPONENT_ID Component
dac_indirect_access DAC_INDIRECT_ACCESS Indirect
dac_creation_date SYDATUM Current Date
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Digital Access for Material Line Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DAC_D_MATDOC (
    CLIENT,               -- Client [MANDT]
    MBLNR,                -- Material Doc. [MBLNR]
    MJAHR,                -- Mat. Doc. Year [MJAHR]
    DOCUMENT_TYPE,        -- Unit [RSUVM_UNIT]
    ACTION_TYPE,          -- Act Type [DAC_ACTION_TYPE]
    INSTANCE_COUNT,       -- INT4 [INT4]
    ERDAT,                -- Created On [ERDAT]
    ERZET,                -- Time [ERZET]
    DAC_PP_COMPONENT,     -- Component [EPP_COMPONENT_ID]
    DAC_INDIRECT_ACCESS,  -- Indirect [DAC_INDIRECT_ACCESS]
    DAC_CREATION_DATE,    -- Current Date [SYDATUM]
    _DATAAGING,           -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, MBLNR, MJAHR, DOCUMENT_TYPE, ACTION_TYPE, INSTANCE_COUNT, ERDAT, ERZET)
);

Learn More