FARR_D_INV_MI

Transparent Table Application Table
47 Fields 1 CDS Views

Processed Invoice RAIs - Main Items

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RAProcdInvoiceRevnAcctItem view_entity from BASIC Processed Invoice RA Items

Fields (47)

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
due_date FARR_DUE_DATE Invoice Due Date
exchange_rate KURSF Exchange rate
exchange_rate2 KURS2 Exchange Rate 2
exchange_rate3 KURS3 Exchange Rate 3
final_invoice FARR_FINAL_INVOICE Final Invoice
invoice_cat FARR_INVOICE_CAT InvoiceItemCat
invoice_type FARR_INVOICE_TYPE InvoiceTy.
pinv_comp FARR_RAI_PINVCO PlInvItemComp
pinv_id FARR_RAI_PINVID PlInvItD
pinv_logsys FARR_RAI_PINVLS LogSysPlInvIt
pinv_type FARR_RAI_PINVTY PlInvItTyp
quantity_rel FARR_QUANTREL Quantity Relevant
bldat BLDAT Document Date
wwert WWERT_D Translatn Date
invdocno INVDOCNO_KK Invoic. Doc.
deletion_ind FARR_DELETION_IND Delete
posting_date BUDAT Posting Date
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
hwae2 HWAE2 Local curr. 2
hwae3 HWAE3 Local curr. 3
hwaer HWAER Local Currency
waers WAERS Currency
is_blocked FARR_DPP_IS_BLOCKED Blocked

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 Invoice 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_INV_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]
    DUE_DATE,          -- Invoice Due Date [FARR_DUE_DATE]
    EXCHANGE_RATE,     -- Exchange rate [KURSF]
    EXCHANGE_RATE2,    -- Exchange Rate 2 [KURS2]
    EXCHANGE_RATE3,    -- Exchange Rate 3 [KURS3]
    FINAL_INVOICE,     -- Final Invoice [FARR_FINAL_INVOICE]
    INVOICE_CAT,       -- InvoiceItemCat [FARR_INVOICE_CAT]
    INVOICE_TYPE,      -- InvoiceTy. [FARR_INVOICE_TYPE]
    PINV_COMP,         -- PlInvItemComp [FARR_RAI_PINVCO]
    PINV_ID,           -- PlInvItD [FARR_RAI_PINVID]
    PINV_LOGSYS,       -- LogSysPlInvIt [FARR_RAI_PINVLS]
    PINV_TYPE,         -- PlInvItTyp [FARR_RAI_PINVTY]
    QUANTITY_REL,      -- Quantity Relevant [FARR_QUANTREL]
    BLDAT,             -- Document Date [BLDAT]
    WWERT,             -- Translatn Date [WWERT_D]
    INVDOCNO,          -- Invoic. Doc. [INVDOCNO_KK]
    DELETION_IND,      -- Delete [FARR_DELETION_IND]
    POSTING_DATE,      -- Posting Date [BUDAT]
    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]
    HWAE2,             -- Local curr. 2 [HWAE2]
    HWAE3,             -- Local curr. 3 [HWAE3]
    HWAER,             -- Local Currency [HWAER]
    WAERS,             -- Currency [WAERS]
    IS_BLOCKED,        -- Blocked [FARR_DPP_IS_BLOCKED]
    PRIMARY KEY (CLIENT, SRCDOC_COMP, SRCDOC_LOGSYS, SRCDOC_TYPE, SRCDOC_ID)
);

Learn More