FINOC_RH_FA

Transparent Table Application Table

Organizational Change: History Table for Fixed Asset

FINOC_RH_FA is an SAP database table in S/4HANA. Organizational Change: History Table for Fixed Asset. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_FA_FILL_HISTORY view_entity from Orgl Change: Fill RT FA (Hist.)

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY change_uuid sysuuid_x16 UUID
KEY bukrs bukrs Company Code
KEY anln1 anln1 Asset
KEY anln2 anln2 Sub-number
KEY valid_from finoc_valid_from Valid from
valid_to finoc_valid_to Valid to
kokrs kokrs CO Area
prctr_old finoc_prctr_before_orgl_change Old Profit Center
prctr finoc_prctr_new New Profit Center
orgl_change finoc_orgl_change Organizational Change
reassgmt_timestamp finoc_reassgmt_timestamp Reassignment Timestamp
reassgmt_status finoc_reassgmt_status Status
prctr_drvtn_source_type finoc_prctr_drvtn_source_type Profit Center Source
marker finoc_marker Marker
srce_kostl finoc_srce_kostl Source Cost Center
srce_ps_psp_pnr finoc_srce_ps_psp_pnr Source WBS Element
srce_aufnr finoc_srce_aufnr Source Order
srce_ps_prj_pnr finoc_srce_ps_prj_pnr Source Project
transfer_status finoc_transfer_status Transfer Status
transfer_timestamp finoc_transfer_timestamp Transfer Time
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 Fixed Asset
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_RH_FA (
    MANDT,                    -- Client [mandt]
    CHANGE_UUID,              -- UUID [sysuuid_x16]
    BUKRS,                    -- Company Code [bukrs]
    ANLN1,                    -- Asset [anln1]
    ANLN2,                    -- Sub-number [anln2]
    VALID_FROM,               -- Valid from [finoc_valid_from]
    VALID_TO,                 -- Valid to [finoc_valid_to]
    KOKRS,                    -- CO Area [kokrs]
    PRCTR_OLD,                -- Old Profit Center [finoc_prctr_before_orgl_change]
    PRCTR,                    -- New Profit Center [finoc_prctr_new]
    ORGL_CHANGE,              -- Organizational Change [finoc_orgl_change]
    REASSGMT_TIMESTAMP,       -- Reassignment Timestamp [finoc_reassgmt_timestamp]
    REASSGMT_STATUS,          -- Status [finoc_reassgmt_status]
    PRCTR_DRVTN_SOURCE_TYPE,  -- Profit Center Source [finoc_prctr_drvtn_source_type]
    MARKER,                   -- Marker [finoc_marker]
    SRCE_KOSTL,               -- Source Cost Center [finoc_srce_kostl]
    SRCE_PS_PSP_PNR,          -- Source WBS Element [finoc_srce_ps_psp_pnr]
    SRCE_AUFNR,               -- Source Order [finoc_srce_aufnr]
    SRCE_PS_PRJ_PNR,          -- Source Project [finoc_srce_ps_prj_pnr]
    TRANSFER_STATUS,          -- Transfer Status [finoc_transfer_status]
    TRANSFER_TIMESTAMP,       -- Transfer Time [finoc_transfer_timestamp]
    CHANGE_TIMESTAMP,         -- Changed on [finoc_rh_timestamp]
    PRIMARY KEY (MANDT, CHANGE_UUID, BUKRS, ANLN1, ANLN2, VALID_FROM)
);