FINOC_RH_SOX

Transparent Table Application Table

Orgl Change: History Table for Intercompany Sales Order Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_SOX_FILL_HISTORY view from Orgl Change: Fill RT IC SOI (Hist.)

Fields (6)

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
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.

-- Orgl Change: History Table for Intercompany 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_SOX (
    MANDT,             -- Client [mandt]
    CHANGE_UUID,       -- UUID [sysuuid_x16]
    KDAUF,             -- Sales Order [kdauf]
    KDPOS,             -- Sales Ord. Item [kdpos]
    VALID_FROM,        -- Valid from [finoc_valid_from]
    CHANGE_TIMESTAMP,  -- Changed on [finoc_rh_timestamp]
    PRIMARY KEY (MANDT, CHANGE_UUID, KDAUF, KDPOS, VALID_FROM)
);