LEVEL3

19 Fields

LEVEL3 is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 1
KEY Level3Document Level3Document 2
KEY SalesQuotation SalesQuotation 1
CustomerReturnType CustomerReturnType 1
DistributionChannel DistributionChannel 2
Level3DocumentCategory Level3DocumentCategory 2
node_id NodeIDStage3 1
node_level NodeLevelStage3 1
node_lval NodeLowValueStage3 1
node_pid HierNodeParentID3 1
node_type NodeTypeStage3 1
OrganizationDivision OrganizationDivision 2
SalesOrganization SalesOrganization 2
SalesQuotationType SalesQuotationType 1
UniversalHierNodeID NodeIDStage3 1
UniversalHierNodeLevel NodeLevelStage3 1
UniversalHierNodeLowValue NodeLowValueStage3 1
UniversalHierNodeParentID HierNodeParentID3 1
UniversalHierNodeType NodeTypeStage3 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 LEVEL3 (
    CUSTOMERRETURN,
    LEVEL3DOCUMENT,
    SALESQUOTATION,
    CUSTOMERRETURNTYPE,
    DISTRIBUTIONCHANNEL,
    LEVEL3DOCUMENTCATEGORY,
    NODE_ID,
    NODE_LEVEL,
    NODE_LVAL,
    NODE_PID,
    NODE_TYPE,
    ORGANIZATIONDIVISION,
    SALESORGANIZATION,
    SALESQUOTATIONTYPE,
    UNIVERSALHIERNODEID,
    UNIVERSALHIERNODELEVEL,
    UNIVERSALHIERNODELOWVALUE,
    UNIVERSALHIERNODEPARENTID,
    UNIVERSALHIERNODETYPE,
    PRIMARY KEY (CUSTOMERRETURN, LEVEL3DOCUMENT, SALESQUOTATION)
);

Learn More