FINOC_RULE_T_ORD

Transparent Table Application Table

Organizational Change: Result Table for Order

FINOC_RULE_T_ORD is an SAP database table in S/4HANA. Organizational Change: Result Table for Order. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_ORD_FILL view union_all Orgl Change: Fill Runtime for Order

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufnr AUFNR Order
kokrs KOKRS CO Area
bukrs BUKRS Company Code
orgl_change FINOC_ORGL_CHANGE Organizational Change
prctr_old FINOC_PRCTR_BEFORE_ORGL_CHANGE Old Profit Center
prctr FINOC_PRCTR_NEW New Profit Center
prctr_drvtn_source_type FINOC_PRCTR_DRVTN_SOURCE_TYPE Profit Center Source
autyp AUFTYP Order category
srce_matnr FINOC_SRCE_MATNR Source Product
srce_werks FINOC_SRCE_WERKS Source Plant
srce_kostl FINOC_SRCE_KOSTL Source Cost Center
srce_ps_psp_pnr FINOC_SRCE_PS_PSP_PNR Source WBS Element
srce_ps_prj_pnr FINOC_SRCE_PS_PRJ_PNR Source Project
objnr J_OBJNR Object number

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.

-- Organizational Change: Result Table for Order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_RULE_T_ORD (
    MANDT,                    -- Client [MANDT]
    AUFNR,                    -- Order [AUFNR]
    KOKRS,                    -- CO Area [KOKRS]
    BUKRS,                    -- Company Code [BUKRS]
    ORGL_CHANGE,              -- Organizational Change [FINOC_ORGL_CHANGE]
    PRCTR_OLD,                -- Old Profit Center [FINOC_PRCTR_BEFORE_ORGL_CHANGE]
    PRCTR,                    -- New Profit Center [FINOC_PRCTR_NEW]
    PRCTR_DRVTN_SOURCE_TYPE,  -- Profit Center Source [FINOC_PRCTR_DRVTN_SOURCE_TYPE]
    AUTYP,                    -- Order category [AUFTYP]
    SRCE_MATNR,               -- Source Product [FINOC_SRCE_MATNR]
    SRCE_WERKS,               -- Source Plant [FINOC_SRCE_WERKS]
    SRCE_KOSTL,               -- Source Cost Center [FINOC_SRCE_KOSTL]
    SRCE_PS_PSP_PNR,          -- Source WBS Element [FINOC_SRCE_PS_PSP_PNR]
    SRCE_PS_PRJ_PNR,          -- Source Project [FINOC_SRCE_PS_PRJ_PNR]
    OBJNR,                    -- Object number [J_OBJNR]
    PRIMARY KEY (MANDT, AUFNR)
);