CRHS

Transparent Table Application Table
14 Fields 1 CDS Views

Hierarchy Structure

CRHS is an SAP database table in S/4HANA. Hierarchy Structure. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkCenterHierStructure view_entity from BASIC Work Center Hierarchy Structure

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objty_hy CR_OBJTY Object Type
KEY objid_hy CR_OBJID Object ID
KEY objty_ho CR_OBJTY Object Type
KEY objid_ho CR_OBJID Object ID
KEY objty_up OBJTY_UP Type
KEY objid_up OBJID_UP ID
objty_le OBJTY_LE Type
objid_le OBJID_LE ID
vcxpos VCXPOS X position
vcypos VCYPOS Y position
flgav CR_FLGAV Stop explosion
andat ANDAT Created On
annam ANNAM Created by

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 Structure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRHS (
    MANDT,     -- Client [MANDT]
    OBJTY_HY,  -- Object Type [CR_OBJTY]
    OBJID_HY,  -- Object ID [CR_OBJID]
    OBJTY_HO,  -- Object Type [CR_OBJTY]
    OBJID_HO,  -- Object ID [CR_OBJID]
    OBJTY_UP,  -- Type [OBJTY_UP]
    OBJID_UP,  -- ID [OBJID_UP]
    OBJTY_LE,  -- Type [OBJTY_LE]
    OBJID_LE,  -- ID [OBJID_LE]
    VCXPOS,    -- X position [VCXPOS]
    VCYPOS,    -- Y position [VCYPOS]
    FLGAV,     -- Stop explosion [CR_FLGAV]
    ANDAT,     -- Created On [ANDAT]
    ANNAM,     -- Created by [ANNAM]
    PRIMARY KEY (MANDT, OBJTY_HY, OBJID_HY, OBJTY_HO, OBJID_HO, OBJTY_UP, OBJID_UP)
);

Learn More