FINOC_RH_SOI

Transparent Table Application Table
12 Fields 1 CDS Views

Organizational Change: History Table for Sales Order Item

FINOC_RH_SOI is an SAP database table in S/4HANA. Organizational Change: History Table for Sales Order Item. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_SOI_FILL_HISTORY view from Orgl Change: Fill RT Sales Doc (Hist.)

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY change_uuid sysuuid_x16 UUID
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
objnr j_objnr Object number
change_timestamp finoc_rh_timestamp Changed on

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: History 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_RH_SOI (
    MANDT,             -- Client [mandt]
    CHANGE_UUID,       -- UUID [sysuuid_x16]
    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]
    OBJNR,             -- Object number [j_objnr]
    CHANGE_TIMESTAMP,  -- Changed on [finoc_rh_timestamp]
    PRIMARY KEY (MANDT, CHANGE_UUID, KDAUF, KDPOS, VALID_FROM)
);

Learn More