FARR_D_ORD_MI
Processed Order RAIs - Main Items
FARR_D_ORD_MI is an SAP database table in S/4HANA. Processed Order RAIs - Main Items. It contains 89 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_RAProcdRevnAcctItem | view_entity | from | EXTENSION | RAR inbound processed items - Extension |
| I_RAProcdRevnAcctItem | view_entity | from | BASIC | Revenue Accounting Processed RAI |
Fields (89)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||||
| deletion_ind | FARR_DELETION_IND | Delete | ||||
| 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 Order 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_ORD_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]
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]
DELETION_IND, -- Delete [FARR_DELETION_IND]
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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA