AD01C_SELA

Transparent Table Customizing Table
11 Fields 1 CDS Views

DIP profile: Selection criteria

AD01C_SELA is an SAP database table in S/4HANA. DIP profile: Selection criteria. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ActyTypeDIPSourceMatlDetnRef view union BASIC Sources and Material Determination Activity Type References

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY profnr ad01profnr DIP Profile
KEY dpus ad01usage DI usage
KEY linenr ad01linsel Source Select. 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

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: Selection criteria
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AD01C_SELA (
    MANDT,      -- Client [mandt]
    PROFNR,     -- DIP Profile [ad01profnr]
    DPUS,       -- DI usage [ad01usage]
    LINENR,     -- Source Select. Index [ad01linsel]
    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]
    PRIMARY KEY (MANDT, PROFNR, DPUS, LINENR, FIELDNAME)
);

Learn More