FARR_D_COST_MI
Processed Cost RAIs - Main Items
FARR_D_COST_MI is an SAP database table in S/4HANA. Processed Cost RAIs - Main Items. It contains 32 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RAProcdCostRevnAcctItem | view_entity | from | BASIC | RAR Inbound Processed Cost Main Item |
Fields (32)
| 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 | ||||
| ignore_cost_based_copa | FARR_IGNORE_COST_BASED_COPA | Ignore Cost-based CO-PA | ||||
| 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 Cost 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_COST_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]
IGNORE_COST_BASED_COPA, -- Ignore Cost-based CO-PA [FARR_IGNORE_COST_BASED_COPA]
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
- 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