I_UNIVERSALHIERVERSION

CDS View
12 Fields 12 CDS Views

Universal Hierarchy Version

I_UNIVERSALHIERVERSION is a CDS View in S/4HANA. Universal Hierarchy Version. It contains 12 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_CnsldtnBalValdtnRuleGroup view_entity from BASIC Balance Validation Rule Group
I_XB_CostStatementHierarchy view_entity from BASIC C/R-Spfc Cost Statement Hierarchy
P_AllocationCycleGroup view from CONSUMPTION Allocation Cycle Group
P_ProductHierarchyVH view from COMPOSITE Product Hierarchy Value Help
P_ShrtTrmCshPosAccHier view_entity inner COMPOSITE Short Term Cash Position Bank Acc Hier
P_UniversalHierHierarchyVH view from BASIC Value Help for Universal Hierarchies
P_XB_COSTSTATEMENTHIERALLNODE view_entity inner BASIC Cost Statement Hierarchy Node
P_XB_COSTSTATEMENTHIERNODE view_entity inner BASIC Cost Statement Hierarchy Node
R_CostCenterHierarchy view_entity from TRANSACTIONAL Cost Center Hierarchy
R_CostCenterHierarchyNode view_entity inner TRANSACTIONAL Cost Center Hierarchy Node
R_CostCenterHierarchyNodeText view_entity inner TRANSACTIONAL Cost Center Hierarchy Node Text
R_CostCenterHierarchyText view_entity from TRANSACTIONAL Cost Center Hierarchy Text

Fields (12)

KeyField CDS FieldsUsed in Views
KEY UniversalHierHierarchyID CostCenterHierarchyShortID,UniversalHierHierarchyID,XB_CostStatementHierarchy 7
KEY UniversalHierVersValidFrom UniversalHierNodeValidFrom,UniversalHierVersValidFrom,ValidityStartDate 6
KEY UniversalHierVersValidTo UniversalHierNodeValidTo,UniversalHierVersValidTo,ValidityEndDate 6
UniversalHierarchyVersionID UniversalHierarchyVersionID 1
UniversalHierVersCreatedAt UniversalHierVersCreatedAt 1
UniversalHierVersCreatedBy UniversalHierVersCreatedBy 1
UniversalHierVersIsAllowLegacy HierarchyIsSetGroupCompatible 1
UniversalHierVersLockedAt UniversalHierVersLockedAt 1
UniversalHierVersLockedBy UniversalHierVersLockedBy 1
UniversalHierVersStatus UniversalHierVersStatus 1
UniversalHierVersUpdatedAt UniversalHierVersUpdatedAt 1
UniversalHierVersUpdatedBy UniversalHierVersUpdatedBy 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.

-- Universal Hierarchy Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UNIVERSALHIERVERSION (
    UNIVERSALHIERHIERARCHYID,
    UNIVERSALHIERVERSVALIDFROM,
    UNIVERSALHIERVERSVALIDTO,
    UNIVERSALHIERARCHYVERSIONID,
    UNIVERSALHIERVERSCREATEDAT,
    UNIVERSALHIERVERSCREATEDBY,
    UNIVERSALHIERVERSISALLOWLEGACY,
    UNIVERSALHIERVERSLOCKEDAT,
    UNIVERSALHIERVERSLOCKEDBY,
    UNIVERSALHIERVERSSTATUS,
    UNIVERSALHIERVERSUPDATEDAT,
    UNIVERSALHIERVERSUPDATEDBY,
    PRIMARY KEY (UNIVERSALHIERHIERARCHYID, UNIVERSALHIERVERSVALIDFROM, UNIVERSALHIERVERSVALIDTO)
);

Learn More