UHDT_VRSN

Transparent Table Customizing Table
21 Fields 74 CDS Views

Hierarchy Version

UHDT_VRSN is an SAP database table in S/4HANA. Hierarchy Version. It contains 21 fields. 74 CDS views read from this table.

CDS Views using this table (74)

ViewTypeJoinVDMDescription
FAC_CDS_FSV_VERSION view union Universal Financial Statement Version
FAC_CDS_UH_ACTIVITYTYPE view from Universal Functional Activity Type
FAC_CDS_UH_ACTIVITYTYPENODE view inner Universal Hier Activity Type Node
FAC_CDS_UH_ATTR_VAL_JSON view inner Node Attribute Value
FAC_CDS_UH_COMPANYCODEHIER view from Universal Company Code Hierarchy
FAC_CDS_UH_COMPANYCODENODE view inner Universal Hierarchy Company Code Node
FAC_CDS_UH_COSTCENTERHIER view from Universal Cost Center Hierarchy
FAC_CDS_UH_COSTCENTERNODE view inner Universal Hierarchy Cost Center Node
FAC_CDS_UH_FSV_CONTRAITEM view inner Universal Hierarchy FSV Contra Items
FAC_CDS_UH_FSVCONTRAITEM view inner Universal Hierarchy FSV Contra Item
FAC_CDS_UH_FSVHIER view from Universal Financial Statement Version
FAC_CDS_UH_FSVNODE view inner Universal Hierarchy FSV Node
FAC_CDS_UH_FUNCNLAREAHIER view from Universal Functional Area Hierarchy
FAC_CDS_UH_FUNCNLAREANODE view inner Universal Hierarchy Function Area Node
FAC_CDS_UH_GENERICHIER view from Universal Generic Hierarchy
FAC_CDS_UH_GENERICNODE view inner Universal Hierarchy Generic Node
FAC_CDS_UH_GLACCOUNTHIER view from Universal Hierarchy G/L Account
FAC_CDS_UH_GLACCOUNTNODE view inner Universal Hierarchy G/L Account Node
FAC_CDS_UH_HD_ATTR_VAL_JSON view inner Header Attribute Value
fac_cds_uh_node view left_outer Universal Hierarchy Node
FAC_CDS_UH_NODE_ATTR_VALUE view inner Node Attribute Values
FAC_CDS_UH_NOTIFICATION view inner Notification to Be Update
FAC_CDS_UH_PRFTCENTERHIER view from Universal Profit Center Hierarchy
FAC_CDS_UH_PRFTCENTERNODE view inner Universal Hierarchy Profit Center Node
FAC_CDS_UH_REGIONHIER view from Universal Region Hierarchy
FAC_CDS_UH_REGIONNODE view inner Universal Hierarchy Region Node
FAC_CDS_UH_RULEHIER view from Rule Hierarchy
FAC_CDS_UH_RULENODE view inner Universal Hierarchy Company Code Node
FAC_CDS_UH_SEGMENTHIER view from Universal Segment Hierarchy
FAC_CDS_UH_SEGMENTNODE view inner Universal Hierarchy Segment Node
FAC_CDS_UH_STSTCLKEYFIG view from Universal Hier Statistical Key Figure
FAC_CDS_UH_STSTCLKEYFIGNODE view inner Universal Hier Stat Key Figure Node
fac_cds_uh_version view from Universal Hierarchy Version
FAC_CDS_UH_VSRN_TO_UPDATE view inner Hierarchy Version to Be Update
fac_cds_ve_group_node view left_outer Validation Group Node
FAC_SH_UNIVERSALHIERDIRVH view inner Universal Hierarchy Directory Value Help
FAC_VE_GRP_RULE_COUNT view from Validation Group Rule Count
FIISAL_GR_GLAcctGlobHier2 view_entity inner Greece GLAccount hierarchy
FINCS_UH_BUSINESSAREAHIER view from Universal Hierarchy Business Area Hierarchy
FINCS_UH_BUSINESSAREANODE view inner Universal Hierarchy Business Area Node
FINCS_UH_COSTCENTERHIER view from Universal Hierarchy Cost Center Hierarchy
FINCS_UH_COSTCENTERNODE view inner Universal Hierarchy Cost Center Node
FINCS_UH_COUNTRYKEYHIER view from Universal Hierarchy Country/Region Hier
FINCS_UH_COUNTRYKEYNODE view inner Universal Hierarchy Country/Region Node
FINCS_UH_CUSTOMERGRPHIER view from Universal Hierarchy Customer Group Hierarchy
FINCS_UH_CUSTOMERGRPNODE view inner Universal Hierarchy Customer Group Node
FINCS_UH_CUSTOMERHIER view from Universal Hierarchy Customer Hierarchy
FINCS_UH_CUSTOMERNODE view inner Universal Hierarchy Customer Node
FINCS_UH_FINTRANSTYPEHIER view from Universal Hierarchy Transaction Type Hierarchy
FINCS_UH_FinTransTypeNODE view inner Universal Hierarchy Transaction Type Node
FINCS_UH_FSITEMHIER view from Universal Hierarchy Financial Statement Item Hierarchy
FINCS_UH_FSITEMNODE view inner Universal Hierarchy Financial Statement Item Node
FINCS_UH_FUNCTIONALAREAHIER view from Universal Hierarchy Functional Area Hier
FINCS_UH_FUNCTIONALAREANODE view inner Universal Hierarchy Functional Area Node
FINCS_UH_FUNDHIER view_entity from Universal Hierarchy Fund Hierarchy
FINCS_UH_GLACCOUNTHIER view from Universal Hierarchy G/L Account Hierarchy
FINCS_UH_GLACCOUNTNODE view inner Universal Hierarchy G/L Account Node
FINCS_UH_PRODUCTHIER view from Universal Hierarchy Product Sold Hierarchy
FINCS_UH_PRODUCTNODE view inner Universal Hierarchy Product Sold Node
FINCS_UH_PROFITCENTERHIER view from Universal Hierarchy Profit Center Hierarchy
FINCS_UH_PROFITCENTERNODE view inner Universal Hierarchy Profit Center Node
FINCS_UH_PROJECTHIER view from Universal Hierarchy Project Hierarchy
FINCS_UH_PROJECTNODE view inner Universal Hierarchy Project Node
FINCS_UH_RITEMHIER view from Universal Hierarchy Reporting Item Hierarchy
FINCS_UH_RITEMNODE view inner Universal Hierarchy Reporting Item Node
FINCS_UH_SALESORGHIER view from Universal Hierarchy Sales Organization Hierarchy
FINCS_UH_SALESORGNODE view inner Universal Hierarchy Sales Organization Node
FINCS_UH_SEGMENTHIER view from Universal Hierarchy Segment Hierarchy
FINCS_UH_SEGMENTNode view inner Universal Hierarchy Segment Node
FINCS_UH_SUPPLIERHIER view from Universal Hierarchy Supplier Hierarchy
FINCS_UH_SUPPLIERNODE view inner Universal Hierarchy Supplier Node
FINCS_UH_UNITHIER view from Universal Hierarchy - Consolidation Unit Hierarchy
FINCS_UH_UNITNODE view inner Universal Hierarchy - Consolidation Unit Node
I_UniversalHierVersion view from BASIC Universal Hierarchy Version

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY ver_id VRSID Version ID
ver_pid VSPID Parent Version ID
ver_status VRSST Status
ver_vldfm VDTFM Valid From
ver_vldto VDTTO Valid To
ver_msg VMESG Note
ver_nbr VNMBR Version Number
ver_idx VRSIX Version Sequence Ind
hier_hid VHRID Hierarchy ID
hier_catg CAKEY Type
updated_at VRSUT Version Update Time
updated_by VRSUB Version Updated By
created_at VRSCT Creation Time
created_by VRSCB Version Created By
locked_by UNAME User Name
locked_at VRSLT Version Locked At
allow_legacy_tcode_usage CULETCODE Use By Legacy TCode
ver_src VRSRC Source
maintenance_lang LANGU Language
ref_updated_at VRSUT Version Update Time

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.

-- Hierarchy Version
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_VRSN (
    CLIENT,                    -- Client [MANDT]
    VER_ID,                    -- Version ID [VRSID]
    VER_PID,                   -- Parent Version ID [VSPID]
    VER_STATUS,                -- Status [VRSST]
    VER_VLDFM,                 -- Valid From [VDTFM]
    VER_VLDTO,                 -- Valid To [VDTTO]
    VER_MSG,                   -- Note [VMESG]
    VER_NBR,                   -- Version Number [VNMBR]
    VER_IDX,                   -- Version Sequence Ind [VRSIX]
    HIER_HID,                  -- Hierarchy ID [VHRID]
    HIER_CATG,                 -- Type [CAKEY]
    UPDATED_AT,                -- Version Update Time [VRSUT]
    UPDATED_BY,                -- Version Updated By [VRSUB]
    CREATED_AT,                -- Creation Time [VRSCT]
    CREATED_BY,                -- Version Created By [VRSCB]
    LOCKED_BY,                 -- User Name [UNAME]
    LOCKED_AT,                 -- Version Locked At [VRSLT]
    ALLOW_LEGACY_TCODE_USAGE,  -- Use By Legacy TCode [CULETCODE]
    VER_SRC,                   -- Source [VRSRC]
    MAINTENANCE_LANG,          -- Language [LANGU]
    REF_UPDATED_AT,            -- Version Update Time [VRSUT]
    PRIMARY KEY (CLIENT, VER_ID)
);

Learn More