FARR_D_INB_MI

Transparent Table Application Table
124 Fields 3 CDS Views

Postponed RAIs - Main Items

FARR_D_INB_MI is an SAP database table in S/4HANA. Postponed RAIs - Main Items. It contains 124 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_RAPostponedItem view_entity from EXTENSION Extension view for RAR Inbound Postponed Items
I_RAPostponedItem view_entity from BASIC RAR Inbound Postponed Item
I_RAPostponedMainItem view_entity from BASIC RAR Inbound Postponed Main Items

Fields (124)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY rai_type FARR_RAI_TYPE Class Type
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
KEY 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
asset_impairment FARR_ASSET_IMPAIRMENT Early Termination
aufnr AUFNR Order
bill_plan_type FARR_BILL_PLAN_TYPE BillPlanTyp
bilrel FARR_BILREL Billing Relevant
business_change_reason FARR_BUSINESS_CHANGE_REASON Bus Chg Reason
delrel FARR_DELREL Delivery-Relevant
effective_date FARR_EFFECTIVE_DATE Effective Date
end_date FARR_END_DATE End Date
fkber FKBER Functional Area
inception_date FARR_INCEPTION_DATE Inception Date
kostl KOSTL Cost Center
paobjnr RKEOBJNR Profit. segment
predoc_comp FARR_PREDOC_COMP PredItemComp
predoc_logsys FARR_PREDOC_LS LogSysPredItem
predoc_type FARR_PREDOC_TY PredItType
predoc_id FARR_PREDOC_ID Pred. Item ID
hildoc_comp FARR_HLDCO HilItemComp
hildoc_logsys FARR_HLDLS LogSysHiLItem
hildoc_type FARR_HLDTY HiLItemType
hildoc_id FARR_HLDID HiLItemID
hierarchy_root FARR_FLAG_HIDOC Root Item
prctr PRCTR Profit Center
ps_posid PS_POSID WBS Element
receiv_account FARR_RECEIV_ACCOUNT ReceivAccount
reference_type FARR_RAI_REFTYPE Ref. Type
reference_id FARR_RAI_REFID Ref ID
segment FB_SEGMENT Segment
start_date FARR_START_DATE Start Date
value_relevant FARR_VALUE_RELEVANT Value-Relevant
xaccass_det FARR_XACCASS_DET Det. Acct. Asg.
xnegative_item FARR_XNEGATIVE_ITEM Negative Amount
xrecacc_det FARR_XRECACC_DET Det. ReceivAcct
x_estimated_quan FARR_X_ESTIMATED_QUAN Estim. Quantity
final_date FARR_FINALIZATION_DATE Finalizat. Date
pob_category FARR_POB_CATEGORY POB Category
gsber GSBER Business Area
kunnr KUNNR Customer
partner BU_PARTNER Busn. Partner
ps_psp_pnr PS_PSP_PNR WBS Element
final_invoice_ind FARR_FINAL_INVOICE_IND FinalInvInd
prdnr FARR_PRDNR Product ID
service_type FARR_RAI_SERVICE_TYPE Service Type
auart AUART Sales Doc. Type
kdgrp KDGRP Customer Group
lgort LGORT_D Location
matkl MATKL Material Group
matnr MATNR Material
posnv POSNV Origin. Item
pstyv PSTYV Item Category
sales_org FARR_SALES_ORG Sales Org.
spart SPART Division
vbelv VBELV Originating Doc
vbtyp FARR_VBTYPL Document Cat.
vtweg VTWEG Distr. Channel
werks WERKS_EXT Plant
abgsl ABGR_SCHL RA Key
crm_category_id COMT_CATEGORY_ID_CO Product Categ.
crm_item_type CRMT_ITEM_TYPE_CO Item Category
crm_object_type CRMT_OBJECT_TYPE_CO CRM Object Type
crm_process_type CRMT_PROCESS_TYPE_CO CRM Trans. Type
crm_product_id COMT_PRODUCT_ID_CO Product ID
crm_service_org CRMT_SERVICE_ORG_CO Service Organization
enterprise_service_org CRMS4_ENTERPRISE_SERVICE_ORG Ent. Service Org.
dummy_contr_itm_incl_eew_ps CFD_DUMMY Dummy
pob_eew_dummy CFD_DUMMY Dummy
rep_eew_dummy CFD_DUMMY Dummy
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
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.
ignore_cost_based_copa FARR_IGNORE_COST_BASED_COPA Ignore Cost-based CO-PA
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
rai_error FARR_INB_ITEM_ERR Item Error Type
postponement_reason FARR_POSTPONEMENT_REASON_CODE Postponement Reason
chg_timestamp_utc FARR_RAI_TMSTMPL Timestamp
enrichment_stage FARR_ENRICHMENT_STAGE Enrichment Stage
deletion_ind FARR_DELETION_IND Delete
posting_date BUDAT Posting Date

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.

-- Postponed 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_INB_MI (
    CLIENT,                       -- Client [MANDT]
    RAI_TYPE,                     -- Class Type [FARR_RAI_TYPE]
    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]
    ASSET_IMPAIRMENT,             -- Early Termination [FARR_ASSET_IMPAIRMENT]
    AUFNR,                        -- Order [AUFNR]
    BILL_PLAN_TYPE,               -- BillPlanTyp [FARR_BILL_PLAN_TYPE]
    BILREL,                       -- Billing Relevant [FARR_BILREL]
    BUSINESS_CHANGE_REASON,       -- Bus Chg Reason [FARR_BUSINESS_CHANGE_REASON]
    DELREL,                       -- Delivery-Relevant [FARR_DELREL]
    EFFECTIVE_DATE,               -- Effective Date [FARR_EFFECTIVE_DATE]
    END_DATE,                     -- End Date [FARR_END_DATE]
    FKBER,                        -- Functional Area [FKBER]
    INCEPTION_DATE,               -- Inception Date [FARR_INCEPTION_DATE]
    KOSTL,                        -- Cost Center [KOSTL]
    PAOBJNR,                      -- Profit. segment [RKEOBJNR]
    PREDOC_COMP,                  -- PredItemComp [FARR_PREDOC_COMP]
    PREDOC_LOGSYS,                -- LogSysPredItem [FARR_PREDOC_LS]
    PREDOC_TYPE,                  -- PredItType [FARR_PREDOC_TY]
    PREDOC_ID,                    -- Pred. Item ID [FARR_PREDOC_ID]
    HILDOC_COMP,                  -- HilItemComp [FARR_HLDCO]
    HILDOC_LOGSYS,                -- LogSysHiLItem [FARR_HLDLS]
    HILDOC_TYPE,                  -- HiLItemType [FARR_HLDTY]
    HILDOC_ID,                    -- HiLItemID [FARR_HLDID]
    HIERARCHY_ROOT,               -- Root Item [FARR_FLAG_HIDOC]
    PRCTR,                        -- Profit Center [PRCTR]
    PS_POSID,                     -- WBS Element [PS_POSID]
    RECEIV_ACCOUNT,               -- ReceivAccount [FARR_RECEIV_ACCOUNT]
    REFERENCE_TYPE,               -- Ref. Type [FARR_RAI_REFTYPE]
    REFERENCE_ID,                 -- Ref ID [FARR_RAI_REFID]
    SEGMENT,                      -- Segment [FB_SEGMENT]
    START_DATE,                   -- Start Date [FARR_START_DATE]
    VALUE_RELEVANT,               -- Value-Relevant [FARR_VALUE_RELEVANT]
    XACCASS_DET,                  -- Det. Acct. Asg. [FARR_XACCASS_DET]
    XNEGATIVE_ITEM,               -- Negative Amount [FARR_XNEGATIVE_ITEM]
    XRECACC_DET,                  -- Det. ReceivAcct [FARR_XRECACC_DET]
    X_ESTIMATED_QUAN,             -- Estim. Quantity [FARR_X_ESTIMATED_QUAN]
    FINAL_DATE,                   -- Finalizat. Date [FARR_FINALIZATION_DATE]
    POB_CATEGORY,                 -- POB Category [FARR_POB_CATEGORY]
    GSBER,                        -- Business Area [GSBER]
    KUNNR,                        -- Customer [KUNNR]
    PARTNER,                      -- Busn. Partner [BU_PARTNER]
    PS_PSP_PNR,                   -- WBS Element [PS_PSP_PNR]
    FINAL_INVOICE_IND,            -- FinalInvInd [FARR_FINAL_INVOICE_IND]
    PRDNR,                        -- Product ID [FARR_PRDNR]
    SERVICE_TYPE,                 -- Service Type [FARR_RAI_SERVICE_TYPE]
    AUART,                        -- Sales Doc. Type [AUART]
    KDGRP,                        -- Customer Group [KDGRP]
    LGORT,                        -- Location [LGORT_D]
    MATKL,                        -- Material Group [MATKL]
    MATNR,                        -- Material [MATNR]
    POSNV,                        -- Origin. Item [POSNV]
    PSTYV,                        -- Item Category [PSTYV]
    SALES_ORG,                    -- Sales Org. [FARR_SALES_ORG]
    SPART,                        -- Division [SPART]
    VBELV,                        -- Originating Doc [VBELV]
    VBTYP,                        -- Document Cat. [FARR_VBTYPL]
    VTWEG,                        -- Distr. Channel [VTWEG]
    WERKS,                        -- Plant [WERKS_EXT]
    ABGSL,                        -- RA Key [ABGR_SCHL]
    CRM_CATEGORY_ID,              -- Product Categ. [COMT_CATEGORY_ID_CO]
    CRM_ITEM_TYPE,                -- Item Category [CRMT_ITEM_TYPE_CO]
    CRM_OBJECT_TYPE,              -- CRM Object Type [CRMT_OBJECT_TYPE_CO]
    CRM_PROCESS_TYPE,             -- CRM Trans. Type [CRMT_PROCESS_TYPE_CO]
    CRM_PRODUCT_ID,               -- Product ID [COMT_PRODUCT_ID_CO]
    CRM_SERVICE_ORG,              -- Service Organization [CRMT_SERVICE_ORG_CO]
    ENTERPRISE_SERVICE_ORG,       -- Ent. Service Org. [CRMS4_ENTERPRISE_SERVICE_ORG]
    DUMMY_CONTR_ITM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    POB_EEW_DUMMY,                -- Dummy [CFD_DUMMY]
    REP_EEW_DUMMY,                -- Dummy [CFD_DUMMY]
    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]
    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]
    IGNORE_COST_BASED_COPA,       -- Ignore Cost-based CO-PA [FARR_IGNORE_COST_BASED_COPA]
    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]
    RAI_ERROR,                    -- Item Error Type [FARR_INB_ITEM_ERR]
    POSTPONEMENT_REASON,          -- Postponement Reason [FARR_POSTPONEMENT_REASON_CODE]
    CHG_TIMESTAMP_UTC,            -- Timestamp [FARR_RAI_TMSTMPL]
    ENRICHMENT_STAGE,             -- Enrichment Stage [FARR_ENRICHMENT_STAGE]
    DELETION_IND,                 -- Delete [FARR_DELETION_IND]
    POSTING_DATE,                 -- Posting Date [BUDAT]
    PRIMARY KEY (CLIENT, RAI_TYPE, SRCDOC_COMP, SRCDOC_LOGSYS, SRCDOC_TYPE, SRCDOC_ID, TIMESTAMP_UTC)
);

Learn More