FINOC_RH_DLV

Transparent Table Application Table

Organizational Change: History Table for Delivery Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_DLV_FILL_HISTORY view_entity from Org Change: Fill RT DLV Item (Hist.)

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY change_uuid SYSUUID_X16 UUID
KEY vbeln VBELN_VL Delivery
KEY posnr POSNR_VL Item
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
segment_old FINOC_SEGMENT_BEFORE_ORGL_CHG Old Segment
segment FINOC_SEGMENT_NEW New Segment
srce_matnr FINOC_SRCE_MATNR Source Product
srce_werks FINOC_SRCE_WERKS Source Plant
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 Delivery Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_RH_DLV (
    MANDT,                    -- Client [MANDT]
    CHANGE_UUID,              -- UUID [SYSUUID_X16]
    VBELN,                    -- Delivery [VBELN_VL]
    POSNR,                    -- Item [POSNR_VL]
    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]
    SEGMENT_OLD,              -- Old Segment [FINOC_SEGMENT_BEFORE_ORGL_CHG]
    SEGMENT,                  -- New Segment [FINOC_SEGMENT_NEW]
    SRCE_MATNR,               -- Source Product [FINOC_SRCE_MATNR]
    SRCE_WERKS,               -- Source Plant [FINOC_SRCE_WERKS]
    CHANGE_TIMESTAMP,         -- Changed on [FINOC_RH_TIMESTAMP]
    PRIMARY KEY (MANDT, CHANGE_UUID, VBELN, POSNR, VALID_FROM)
);