FINOC_RH_OI

Transparent Table Application Table
9 Fields 1 CDS Views

Organizational Change: History Table for Open Item

FINOC_RH_OI is an SAP database table in S/4HANA. Organizational Change: History Table for Open Item. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_OI_FILL_HISTORY view from Orgl Change: Fill RT Open Items (Hist.)

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY change_uuid sysuuid_x16 UUID
KEY open_item_id finoc_openitem_id Open Item ID
KEY valid_from finoc_valid_from Valid from
belnr belnr_d Document Number
gjahr gjahr Fiscal Year
buzei buzei Item
spl_no fagl_index Sequence 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 Open Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_RH_OI (
    MANDT,             -- Client [mandt]
    CHANGE_UUID,       -- UUID [sysuuid_x16]
    OPEN_ITEM_ID,      -- Open Item ID [finoc_openitem_id]
    VALID_FROM,        -- Valid from [finoc_valid_from]
    BELNR,             -- Document Number [belnr_d]
    GJAHR,             -- Fiscal Year [gjahr]
    BUZEI,             -- Item [buzei]
    SPL_NO,            -- Sequence Number [fagl_index]
    CHANGE_TIMESTAMP,  -- Changed on [finoc_rh_timestamp]
    PRIMARY KEY (MANDT, CHANGE_UUID, OPEN_ITEM_ID, VALID_FROM)
);

Learn More