LEVEL1

20 Fields

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

Fields (20)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 1
KEY Level1Document Level1Document 2
CustomerReturnItem CustomerReturnItem 1
CustomerReturnType CustomerReturnType 1
DistributionChannel DistributionChannel 1
Level1DocumentCategory Level1DocumentCategory 2
Level1DocumentItem Level1DocumentItem 1
node_id NodeIDStage1 1
node_level NodeLevelStage1 1
node_lval NodeLowValueStage1 1
node_pid HierNodeParentID1 1
node_type NodeTypeStage1 1
OrganizationDivision OrganizationDivision 1
RetsMgmtProcItmQtySplit RetsMgmtProcItmQtySplit 1
SalesOrganization SalesOrganization 1
UniversalHierNodeID NodeIDStage1 1
UniversalHierNodeLevel NodeLevelStage1 1
UniversalHierNodeLowValue NodeLowValueStage1 1
UniversalHierNodeParentID HierNodeParentID1 1
UniversalHierNodeType NodeTypeStage1 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 LEVEL1 (
    CUSTOMERRETURN,
    LEVEL1DOCUMENT,
    CUSTOMERRETURNITEM,
    CUSTOMERRETURNTYPE,
    DISTRIBUTIONCHANNEL,
    LEVEL1DOCUMENTCATEGORY,
    LEVEL1DOCUMENTITEM,
    NODE_ID,
    NODE_LEVEL,
    NODE_LVAL,
    NODE_PID,
    NODE_TYPE,
    ORGANIZATIONDIVISION,
    RETSMGMTPROCITMQTYSPLIT,
    SALESORGANIZATION,
    UNIVERSALHIERNODEID,
    UNIVERSALHIERNODELEVEL,
    UNIVERSALHIERNODELOWVALUE,
    UNIVERSALHIERNODEPARENTID,
    UNIVERSALHIERNODETYPE,
    PRIMARY KEY (CUSTOMERRETURN, LEVEL1DOCUMENT)
);

Learn More