_PROJECTHIERARCHY

_PROJECTHIERARCHY is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ProjectObjectInternalID ProjectInternalID 2
Project Project 2
ProjectObjectDescription ObjectDescription,ProjectObjectDescription 3
ProjectObjectExternalID ProjectObjectExternalID 2
ProjectObjectParentNode ProjectObjectParentNode 5
ProjectObjectRootNode ProjectObjectRootNode 2
ProjectObjectType ProjectObjectType 3
ProjectSelectedObjectText ProjectSelectedObjectText 1
WBSElement WBSElement 3

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 _PROJECTHIERARCHY (
    PROJECTOBJECTINTERNALID,
    PROJECT,
    PROJECTOBJECTDESCRIPTION,
    PROJECTOBJECTEXTERNALID,
    PROJECTOBJECTPARENTNODE,
    PROJECTOBJECTROOTNODE,
    PROJECTOBJECTTYPE,
    PROJECTSELECTEDOBJECTTEXT,
    WBSELEMENT,
    PRIMARY KEY (PROJECTOBJECTINTERNALID)
);