AD01C_MATA

Transparent Table Customizing Table
12 Fields 1 CDS Views

DIP profile: Material determination criteria

AD01C_MATA is an SAP database table in S/4HANA. DIP profile: Material determination criteria. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ActyTypeDIPSourceMatlDetnRef view from BASIC

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY profnr AD01PROFNR DIP Profile
KEY dpus AD01USAGE DI usage
KEY linenr AD01LINMAT Mat. Determ. Index
KEY fieldname FIELDNAME Field Name
val_excl AD01VALXCL Exclusion
val_from SETVALMIN From Value
val_to SETVALMAX To Value
setnr SETID Set ID
setname SETNAMENEW Set Name
settab SETTABLE Table
val_sngl SETVAL Value

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.

-- DIP profile: Material determination criteria
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AD01C_MATA (
    MANDT,      -- Client [MANDT]
    PROFNR,     -- DIP Profile [AD01PROFNR]
    DPUS,       -- DI usage [AD01USAGE]
    LINENR,     -- Mat. Determ. Index [AD01LINMAT]
    FIELDNAME,  -- Field Name [FIELDNAME]
    VAL_EXCL,   -- Exclusion [AD01VALXCL]
    VAL_FROM,   -- From Value [SETVALMIN]
    VAL_TO,     -- To Value [SETVALMAX]
    SETNR,      -- Set ID [SETID]
    SETNAME,    -- Set Name [SETNAMENEW]
    SETTAB,     -- Table [SETTABLE]
    VAL_SNGL,   -- Value [SETVAL]
    PRIMARY KEY (MANDT, PROFNR, DPUS, LINENR, FIELDNAME)
);

Learn More