I_SETNODE

CDS View

Set Node

I_SETNODE is a CDS View in S/4HANA. Set Node. It contains 7 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
C_BudgetPeriodChildGroup view from CONSUMPTION Budget Period Child Groups
C_BudgetPeriodParentGroup view from CONSUMPTION Budget Period Parent Groups
C_ChildGrantGroup view from CONSUMPTION Child Grant Group
C_ChildGroup view from CONSUMPTION Child Group
C_Childgroup_Fund view from CONSUMPTION Fund Child Group
C_Childgroup_Funded_prg view from CONSUMPTION Funded Program Child Group
C_Childgroup_Fundscenter view from CONSUMPTION Funds Center Child Group
C_CommitmentItemChildGroups view from CONSUMPTION Commitment Item Child Groups
C_CommitmentItemParentGroups view from CONSUMPTION Commitment Item Parents Groups
C_FunctionalAreaChildGroups view from CONSUMPTION Functional Area Child Groups
C_FunctionalAreaParentGroups view from CONSUMPTION Functional Area Parent Groups
C_ParentGrantGroup view from CONSUMPTION Parent Grant Group
C_ParentGroup view from CONSUMPTION ParentGroup
C_Parentgroup_Fund view from CONSUMPTION Fund Parent Group
C_Parentgroup_Funded_prg view from CONSUMPTION Funded Program Parent Group
C_Parentgroup_Fundscenter view from CONSUMPTION Funds Center Parent Group
I_CostCenterGroupHierNodeRltn view from COMPOSITE Cost Center Group Hierarchy Relation
I_ProfitCtrStdGrpHierNodeRltn view_entity from COMPOSITE Profit Center Standard Group Hierarchy Relation
P_ActyTypeAllHierNodes view from BASIC
P_CostCenterStdGrpHierNodeRltn view from COMPOSITE
P_InternalOrderGroupNode view from COMPOSITE
P_ProfitCenterGroupNode view from COMPOSITE
R_CostElementGroupHierarchy view union COMPOSITE Cost Element Group Hierarchy

Fields (7)

KeyField CDS FieldsUsed in Views
KEY SetClass SetClass 18
KEY SetID SetID 18
KEY SetLineNumber SetLineNumber 18
KEY SetSubClass SetSubClass 18
ChildSetClass ChildSetClass 16
ChildSetID ChildSetID 16
ChildSetSubClass ChildSetSubClass 16

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.

-- Set Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SETNODE (
    SETCLASS,
    SETID,
    SETLINENUMBER,
    SETSUBCLASS,
    CHILDSETCLASS,
    CHILDSETID,
    CHILDSETSUBCLASS,
    PRIMARY KEY (SETCLASS, SETID, SETLINENUMBER, SETSUBCLASS)
);