I_WORKCENTERGROUPTREEAGGRGN

CDS View

Work Center Group Tree

I_WORKCENTERGROUPTREEAGGRGN is a CDS View in S/4HANA. Work Center Group Tree. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MassMaintCapWrkCtrGrpAggrgn view_entity from CONSUMPTION Work Center Group Tree Aggrigation
C_WorkCenterGroupTree view from CONSUMPTION Work Center Groups Tree
I_CapPlngWrkCtrGrpRespyArea view inner COMPOSITE Workcenters in Workcenter Group AoR
I_EvaltCapWrkCtrGrpAreaOfRespy view_entity inner COMPOSITE Work Center Group Area of Responsibility
I_MassMaintCapAreaOfRespy view_entity inner COMPOSITE Work Center Capacity AOR

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Plant Plant 1
KEY WorkCenterGroupHierarchyNode WorkCenterInternalID 1
KEY WrkCtrGroupHierarchyNodeType WorkCenterGroupTypeCode 1
KEY WrkCtrGroupHierarchyRootNode WrkCtrGroupHierarchyRootNode 1
ObjectDescription WorkCenterDesc 1
WorkCenterGroupRoot WorkCenterGroupRoot 1
WorkCenterGroupRootType WorkCenterGroupRootType 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.

-- Work Center Group Tree
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERGROUPTREEAGGRGN (
    PLANT,
    WORKCENTERGROUPHIERARCHYNODE,
    WRKCTRGROUPHIERARCHYNODETYPE,
    WRKCTRGROUPHIERARCHYROOTNODE,
    OBJECTDESCRIPTION,
    WORKCENTERGROUPROOT,
    WORKCENTERGROUPROOTTYPE,
    PRIMARY KEY (PLANT, WORKCENTERGROUPHIERARCHYNODE, WRKCTRGROUPHIERARCHYNODETYPE, WRKCTRGROUPHIERARCHYROOTNODE)
);