FINOC_RT_SOI

Transparent Table Application Table
13 Fields 4 CDS Views

Organizational Change: Runtime Table for Sales Order Item

FINOC_RT_SOI is an SAP database table in S/4HANA. Organizational Change: Runtime Table for Sales Order Item. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FINOC_PACKAGE_BAL_SOI view from Organizational Change: Packaging BAL_SOI
FINOC_RT_SOI_OPEN_ORGL view from Orgl Change: Fill RT Sales Doc (Hist.)
finoc_vbap_incorrect_prctr view_entity from Sales Doc Items with Incorrect PrftCtr
I_ProfitCenterToSalesOrderItem view from BASIC Assgmt of PrftCtr to SlsOrd Item

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kdauf kdauf Sales Order
KEY kdpos kdpos Sales Ord. Item
KEY valid_from finoc_valid_from Valid from
srce_ps_psp_pnr finoc_srce_ps_psp_pnr Source WBS Element
srce_ps_prj_pnr finoc_srce_ps_prj_pnr Source Project
srce_aufnr finoc_srce_aufnr Source Order
srce_matnr finoc_srce_matnr Source Product
srce_werks finoc_srce_werks Source Plant
pra_status finoc_pra_status PredAcc Upd. Status
pra_timestamp finoc_pra_timestamp PRA Timestamp
srce_kostl finoc_srce_kostl Source Cost Center
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: Runtime Table for Sales Order Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_RT_SOI (
    MANDT,            -- Client [mandt]
    KDAUF,            -- Sales Order [kdauf]
    KDPOS,            -- Sales Ord. Item [kdpos]
    VALID_FROM,       -- Valid from [finoc_valid_from]
    SRCE_PS_PSP_PNR,  -- Source WBS Element [finoc_srce_ps_psp_pnr]
    SRCE_PS_PRJ_PNR,  -- Source Project [finoc_srce_ps_prj_pnr]
    SRCE_AUFNR,       -- Source Order [finoc_srce_aufnr]
    SRCE_MATNR,       -- Source Product [finoc_srce_matnr]
    SRCE_WERKS,       -- Source Plant [finoc_srce_werks]
    PRA_STATUS,       -- PredAcc Upd. Status [finoc_pra_status]
    PRA_TIMESTAMP,    -- PRA Timestamp [finoc_pra_timestamp]
    SRCE_KOSTL,       -- Source Cost Center [finoc_srce_kostl]
    OBJNR,            -- Object number [j_objnr]
    PRIMARY KEY (MANDT, KDAUF, KDPOS, VALID_FROM)
);

Learn More