LEVEL2

20 Fields

LEVEL2 is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 2
KEY Level2Document Level2Document 3
KEY Level2DocumentItem Level2DocumentItem 1
KEY SalesQuotation SalesQuotation 1
CustomerReturnType CustomerReturnType 2
DistributionChannel DistributionChannel 3
Level2DocumentCategory Level2DocumentCategory 3
node_id NodeIDStage2 1
node_level NodeLevelStage2 1
node_lval NodeLowValueStage2 1
node_pid HierNodeParentID2 1
node_type NodeTypeStage2 1
OrganizationDivision OrganizationDivision 3
SalesOrganization SalesOrganization 3
SalesQuotationType SalesQuotationType 1
UniversalHierNodeID NodeIDStage2 1
UniversalHierNodeLevel NodeLevelStage2 1
UniversalHierNodeLowValue NodeLowValueStage2 1
UniversalHierNodeParentID HierNodeParentID2 1
UniversalHierNodeType NodeTypeStage2 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 LEVEL2 (
    CUSTOMERRETURN,
    LEVEL2DOCUMENT,
    LEVEL2DOCUMENTITEM,
    SALESQUOTATION,
    CUSTOMERRETURNTYPE,
    DISTRIBUTIONCHANNEL,
    LEVEL2DOCUMENTCATEGORY,
    NODE_ID,
    NODE_LEVEL,
    NODE_LVAL,
    NODE_PID,
    NODE_TYPE,
    ORGANIZATIONDIVISION,
    SALESORGANIZATION,
    SALESQUOTATIONTYPE,
    UNIVERSALHIERNODEID,
    UNIVERSALHIERNODELEVEL,
    UNIVERSALHIERNODELOWVALUE,
    UNIVERSALHIERNODEPARENTID,
    UNIVERSALHIERNODETYPE,
    PRIMARY KEY (CUSTOMERRETURN, LEVEL2DOCUMENT, LEVEL2DOCUMENTITEM, SALESQUOTATION)
);

Learn More