DCASSIGNMENT

5 Fields

DCASSIGNMENT is an SAP database table in S/4HANA. It contains 5 fields.

Fields (5)

KeyField CDS FieldsUsed in Views
KEY DistributionChannel DistributionChannel 3
KEY SalesOrganization SalesOrganization 3
KEY SalesProductHierarchyPurpose SalesProductHierarchyPurpose 1
UniversalHierVersValidFrom UniversalHierVersValidFrom 1
UniversalHierVersValidTo UniversalHierVersValidTo 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DCASSIGNMENT (
    DISTRIBUTIONCHANNEL,
    SALESORGANIZATION,
    SALESPRODUCTHIERARCHYPURPOSE,
    UNIVERSALHIERVERSVALIDFROM,
    UNIVERSALHIERVERSVALIDTO,
    PRIMARY KEY (DISTRIBUTIONCHANNEL, SALESORGANIZATION, SALESPRODUCTHIERARCHYPURPOSE)
);

Learn More