FAC_CDS_UH_VERSION

CDS View
11 Fields 4 CDS Views

Universal Hierarchy Version

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FAC_CDS_VE_VALIDATION_GROUP view from Validation Group
FAC_CDS_VE_VALIDATION_GROUP view union_all Validation Group
FAC_CDS_VE_VALIDATION_GROUP_VH view from Validation Group Value Help
FAC_CDS_VE_VALIDATION_GROUP_VH view union Validation Group Value Help

Fields (11)

KeyField CDS FieldsUsed in Views
KEY VersionId VersionId 2
CreatedAt CreatedAt 1
CreatedBy CreatedBy 1
HierarchyCategory HierarchyCategory 2
HierarchyId HierarchyId 1
HierarchyText ValidationGroupDescription 2
LockedAt LockedAt 1
LockedBy LockedBy 1
UpdatedAt ChangedAt 1
UpdatedBy ChangedBy 1
VersionStatus ValidationGroupStatus 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 FAC_CDS_UH_VERSION (
    VERSIONID,
    CREATEDAT,
    CREATEDBY,
    HIERARCHYCATEGORY,
    HIERARCHYID,
    HIERARCHYTEXT,
    LOCKEDAT,
    LOCKEDBY,
    UPDATEDAT,
    UPDATEDBY,
    VERSIONSTATUS,
    PRIMARY KEY (VERSIONID)
);

Learn More