_NODE

15 Fields

_NODE is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 1
KEY ParentNode ProjectCostComponent 1
KEY ProductStructureNodeName ProductStructureNodeName 3
ChartOfAccounts ChartOfAccounts 2
ClassInternalID ClassInternalID 1
FinStmntNodeFormattedID FinStmntNodeFormattedID 1
InventoryValuationType InventoryValuationType 1
isrootnode IsRootNode 1
Plant Plant 1
ProcessCategory ProcessCategory 1
ProductStructureNodeType ProductStructureNodeType 2
ProductStructureNodeUniqueID ProductStructureNodeUniqueID 1
ProductStructureNodeUUID ProductStructureNodeUUID 1
rootnode_ref RootName 1
ValuationQuantityUnit ValuationQuantityUnitInternal 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 _NODE (
    COSTESTIMATE,
    PARENTNODE,
    PRODUCTSTRUCTURENODENAME,
    CHARTOFACCOUNTS,
    CLASSINTERNALID,
    FINSTMNTNODEFORMATTEDID,
    INVENTORYVALUATIONTYPE,
    ISROOTNODE,
    PLANT,
    PROCESSCATEGORY,
    PRODUCTSTRUCTURENODETYPE,
    PRODUCTSTRUCTURENODEUNIQUEID,
    PRODUCTSTRUCTURENODEUUID,
    ROOTNODE_REF,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (COSTESTIMATE, PARENTNODE, PRODUCTSTRUCTURENODENAME)
);

Learn More