FINOC_RH_POI

Transparent Table Application Table
31 Fields 1 CDS Views

Organizational Change: History Table for Purchase Order Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_POI_FILL_HISTORY view_entity from Orgl Change: Fill RT POI (Hist.)

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY change_uuid SYSUUID_X16 UUID
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY zekkn DZEKKN Account Assgmt No.
KEY valid_from FINOC_VALID_FROM Valid from
valid_to FINOC_VALID_TO Valid to
kokrs KOKRS CO Area
bukrs BUKRS Company Code
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_ps_psp_pnr FINOC_SRCE_PS_PSP_PNR Source WBS Element
srce_ps_prj_pnr FINOC_SRCE_PS_PRJ_PNR Source Project
srce_matnr FINOC_SRCE_MATNR Source Product
srce_werks FINOC_SRCE_WERKS Source Plant
srce_kdauf FINOC_SRCE_KDAUF Source Sales Order
srce_kdpos FINOC_SRCE_KDPOS Source Sales Order Item
srce_anln1 FINOC_SRCE_ANLN1 Source Main Asset Number
srce_anln2 FINOC_SRCE_ANLN2 Source Asset Subnumber
srce_kostl FINOC_SRCE_KOSTL Source Cost Center
srce_aufnr FINOC_SRCE_AUFNR Source Order
srce_vornr FINOC_SRCE_VORNR Source Activity / Operation
srce_service_doc_type FINOC_SRCE_SERVICE_DOC_TYPE Source Service Document Type
srce_service_doc_id FINOC_SRCE_SERVICE_DOC_ID Source Service Document ID
srce_service_doc_item_id FINOC_SRCE_SERVICE_DOC_ITEM_ID Source Service Document Item ID
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 Purchase Order Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_RH_POI (
    MANDT,                     -- Client [MANDT]
    CHANGE_UUID,               -- UUID [SYSUUID_X16]
    EBELN,                     -- Purchasing Doc. [EBELN]
    EBELP,                     -- Item [EBELP]
    ZEKKN,                     -- Account Assgmt No. [DZEKKN]
    VALID_FROM,                -- Valid from [FINOC_VALID_FROM]
    VALID_TO,                  -- Valid to [FINOC_VALID_TO]
    KOKRS,                     -- CO Area [KOKRS]
    BUKRS,                     -- Company Code [BUKRS]
    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_PS_PSP_PNR,           -- Source WBS Element [FINOC_SRCE_PS_PSP_PNR]
    SRCE_PS_PRJ_PNR,           -- Source Project [FINOC_SRCE_PS_PRJ_PNR]
    SRCE_MATNR,                -- Source Product [FINOC_SRCE_MATNR]
    SRCE_WERKS,                -- Source Plant [FINOC_SRCE_WERKS]
    SRCE_KDAUF,                -- Source Sales Order [FINOC_SRCE_KDAUF]
    SRCE_KDPOS,                -- Source Sales Order Item [FINOC_SRCE_KDPOS]
    SRCE_ANLN1,                -- Source Main Asset Number [FINOC_SRCE_ANLN1]
    SRCE_ANLN2,                -- Source Asset Subnumber [FINOC_SRCE_ANLN2]
    SRCE_KOSTL,                -- Source Cost Center [FINOC_SRCE_KOSTL]
    SRCE_AUFNR,                -- Source Order [FINOC_SRCE_AUFNR]
    SRCE_VORNR,                -- Source Activity / Operation [FINOC_SRCE_VORNR]
    SRCE_SERVICE_DOC_TYPE,     -- Source Service Document Type [FINOC_SRCE_SERVICE_DOC_TYPE]
    SRCE_SERVICE_DOC_ID,       -- Source Service Document ID [FINOC_SRCE_SERVICE_DOC_ID]
    SRCE_SERVICE_DOC_ITEM_ID,  -- Source Service Document Item ID [FINOC_SRCE_SERVICE_DOC_ITEM_ID]
    CHANGE_TIMESTAMP,          -- Changed on [FINOC_RH_TIMESTAMP]
    PRIMARY KEY (MANDT, CHANGE_UUID, EBELN, EBELP, ZEKKN, VALID_FROM)
);

Learn More