FARR_D_FLFMT_MI

Transparent Table Application Table
33 Fields 1 CDS Views

Processed Fulfillment RAIs - Main Items

FARR_D_FLFMT_MI is an SAP database table in S/4HANA. Processed Fulfillment RAIs - Main Items. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RAProcdFlfmtRevnAcctItem view_entity from BASIC Processed Fulfillment RA Items

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY srcdoc_comp FARR_RAI_SRCCO Sender Comp.
KEY srcdoc_logsys FARR_RAI_SRCLS Source System
KEY srcdoc_type FARR_RAI_SRCTY SrcDocItemType
KEY srcdoc_id FARR_RAI_SRCID Src. Item ID
timestamp_utc FARR_RAI_TMSTMPL Timestamp
bukrs BUKRS Company Code
header_id FARR_HEADER_ID Header ID
item_id FARR_ITEM_ID Item ID
quantity FARR_QUANTITY Quantity
quantity_unit FARR_QUANTITY_UNIT Unit of Measure
crea_tmstp_utc FARR_RAI_TMSTMP Timestamp
crea_user FARR_CREA_USER CreationUser
proc_tmstp_utc FARR_PROC_TMSTP_UTC ProcessingTime
proc_user FARR_PROC_USER ProcessingUser
log_handle BALLOGHNDL Handle
manually_changed FARR_MANUAL_CHANGED Manual Changed
event_date FARR_EVENT_DATE Event Date
event_time FARR_EVENT_TIME Event Time
event_type FARR_EVENT_TYPE Event Type
delivered_qty_diff FARR_DIFF_DLV_QTY Diff to Dlv Qty
amount FARR_AMOUNT_FF Amount Fulfilled
flfmt_refdoc_id FARR_RAI_FLFMT_REFDOC_ID Ref ID
origdoc_comp FARR_RAI_ORICO OrigItemComp.
origdoc_logsys FARR_RAI_ORILS LogSysOrigItem
origdoc_type FARR_RAI_ORITY OrigItType
origdoc_id FARR_RAI_ORIID OriginalItemID
awtyp AWTYP Ref. procedure
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
awsys AWSYS Logical System
is_blocked FARR_DPP_IS_BLOCKED Blocked
waers WAERS Currency

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.

-- Processed Fulfillment RAIs - Main Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_FLFMT_MI (
    CLIENT,              -- Client [MANDT]
    SRCDOC_COMP,         -- Sender Comp. [FARR_RAI_SRCCO]
    SRCDOC_LOGSYS,       -- Source System [FARR_RAI_SRCLS]
    SRCDOC_TYPE,         -- SrcDocItemType [FARR_RAI_SRCTY]
    SRCDOC_ID,           -- Src. Item ID [FARR_RAI_SRCID]
    TIMESTAMP_UTC,       -- Timestamp [FARR_RAI_TMSTMPL]
    BUKRS,               -- Company Code [BUKRS]
    HEADER_ID,           -- Header ID [FARR_HEADER_ID]
    ITEM_ID,             -- Item ID [FARR_ITEM_ID]
    QUANTITY,            -- Quantity [FARR_QUANTITY]
    QUANTITY_UNIT,       -- Unit of Measure [FARR_QUANTITY_UNIT]
    CREA_TMSTP_UTC,      -- Timestamp [FARR_RAI_TMSTMP]
    CREA_USER,           -- CreationUser [FARR_CREA_USER]
    PROC_TMSTP_UTC,      -- ProcessingTime [FARR_PROC_TMSTP_UTC]
    PROC_USER,           -- ProcessingUser [FARR_PROC_USER]
    LOG_HANDLE,          -- Handle [BALLOGHNDL]
    MANUALLY_CHANGED,    -- Manual Changed [FARR_MANUAL_CHANGED]
    EVENT_DATE,          -- Event Date [FARR_EVENT_DATE]
    EVENT_TIME,          -- Event Time [FARR_EVENT_TIME]
    EVENT_TYPE,          -- Event Type [FARR_EVENT_TYPE]
    DELIVERED_QTY_DIFF,  -- Diff to Dlv Qty [FARR_DIFF_DLV_QTY]
    AMOUNT,              -- Amount Fulfilled [FARR_AMOUNT_FF]
    FLFMT_REFDOC_ID,     -- Ref ID [FARR_RAI_FLFMT_REFDOC_ID]
    ORIGDOC_COMP,        -- OrigItemComp. [FARR_RAI_ORICO]
    ORIGDOC_LOGSYS,      -- LogSysOrigItem [FARR_RAI_ORILS]
    ORIGDOC_TYPE,        -- OrigItType [FARR_RAI_ORITY]
    ORIGDOC_ID,          -- OriginalItemID [FARR_RAI_ORIID]
    AWTYP,               -- Ref. procedure [AWTYP]
    AWREF,               -- Reference Doc. [AWREF]
    AWORG,               -- Refer. Org.Unit [AWORG]
    AWSYS,               -- Logical System [AWSYS]
    IS_BLOCKED,          -- Blocked [FARR_DPP_IS_BLOCKED]
    WAERS,               -- Currency [WAERS]
    PRIMARY KEY (CLIENT, SRCDOC_COMP, SRCDOC_LOGSYS, SRCDOC_TYPE, SRCDOC_ID)
);

Learn More