_HIERARCHYNODE

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 _HIERARCHYNODE (
    CHARTOFACCOUNTS,
    CNSLDTNSUBITEMCATEGORY,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONTROLLINGAREA,
    HIERARCHYNODE,
    VALIDITYENDDATE,
    BILLINGDOCUMENTTYPE,
    BPHIERARCHYNODEDISPLAYID,
    BPHIERARCHYNODEUUID,
    BUSINESSPARTNERHIERARCHYUUID,
    CITCLASSIFICATIONCODEDESC,
    CNSLDTNFINANCIALSTATEMENTITEM,
    CNSLDTNSUBITEM,
    COSTCENTER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    GLACCOUNT,
    GRANTID,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYNODETYPE,
    HIERARCHYVERSION,
    INDUSTRY,
    MATERIALGROUP,
    MDCHGPROCESSRECORDOBJECTTEXT,
    MDCHGPROCESSVALIDATIONSTATUS,
    MDCHGPROCHIERRECORDOBJTEXT,
    MDCHGPROCSRCEOBJBPHIERARCHY,
    NODETYPE,
    PARENTNODE,
    PLANT,
    PRODUCTGROUP,
    SALESDISTRICT,
    SUPPLIER,
    UNIVERSALHIERNODEID,
    UNIVERSALHIERNODEPARENTID,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARTOFACCOUNTS, CNSLDTNSUBITEMCATEGORY, CONSOLIDATIONCHARTOFACCOUNTS, CONTROLLINGAREA, HIERARCHYNODE, VALIDITYENDDATE)
);