THRFIO_ORGVPSC

Transparent Table Customizing Table
4 Fields 1 CDS Views

OrgChart: Views Per Scenario

THRFIO_ORGVPSC is an SAP database table in S/4HANA. OrgChart: Views Per Scenario. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMOrgChartViewsPerScenario view_entity from BASIC Views Per Scenario

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY scenario_id hrfio_org_scenario_id Scenario ID
KEY view_id hrfio_org_view_id View ID
view_order hrfio_order_value Order

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.

-- OrgChart: Views Per Scenario
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THRFIO_ORGVPSC (
    CLIENT,       -- Client [mandt]
    SCENARIO_ID,  -- Scenario ID [hrfio_org_scenario_id]
    VIEW_ID,      -- View ID [hrfio_org_view_id]
    VIEW_ORDER,   -- Order [hrfio_order_value]
    PRIMARY KEY (CLIENT, SCENARIO_ID, VIEW_ID)
);

Learn More