Internal Orders: Actual Costs Through Delta Extraction (SAP Library

Internal Orders: Actual Costs Through Delta Extraction

Technical name: 0CO_OM_OPA_6

Use

This InfoSource contains all actual costs and quantities that were posted on the internal order.

Note

If required, you can use this InfoSource to load costs and quantities for other order types (such as plant maintenance orders or CO production orders). The corresponding orders are transferred using only the InfoObject 0COORDER.

Note

Order costs in object currency are identified by the system in records with 0CURTYPE = 10 (company code currency).

Unlike the InfoSource 0CO_OM_OPA_1, you can use 0CO_OM_OPA_6 to select delta datasets.

In the OLTP system, DataSources are created so that delta datasets can be recorded. These DataSources select data from the line item table COEP. This enables additional fields (not contained in the COSP and COSS totals tables) to be transferred to the BW.

For more information, see Delta Extraction.

Characteristics

InfoObject	Description		Data Element	Field in Transfer Structure	Source
0COORDER	Order		AUFNR	AUFNR	ICORDCSTA1.AUFNR
0CURTYPE	Currency type		RSCURTYPE	CURTYPE	ICORDCSTA1.CURTYPE
0CO_AREA	Controlling area		KOKRS	KOKRS	ICORDCSTA1.KOKRS
0COSTELMNT	Cost element		KSTAR	KSTAR	ICORDCSTA1.KSTAR
0METYPE	Key figure category		RSMETYPE	MEASTYPE	ICORDCSTA1.MEASTYPE
0PIOVALUE	Partner object value		RSPIOVALUE	RSPAROBVAL	ICORDCSTA1.RSPAROBVAL
0PIOBJSV	Partner object type		RSPIOBJSV	RSPOBART	ICORDCSTA1.RSPOBART
0DB_CR_IND	Sender/receiver		CO_SEKNZ	SEKNZ	ICORDCSTA1.SEKNZ
0VALUATION	Valuation view		VALUTYP	VALUTYP	ICORDCSTA1.VALUTYP
0VERSION	Version		VERSN	VERSN	ICORDCSTA1.VERSN
0VTDETAIL	Details of value type		RSVTDETAIL	VTDETAIL	ICORDCSTA1.VTDETAIL
0VTSTAT	Statistics indicator		RSVTSTAT	VTSTAT	ICORDCSTA1.VTSTAT
0VTYPE	Reporting value type		RSVTYPE	VTYPE	ICORDCSTA1.VTYPE
0AUXACCTYPE	Type of auxiliary account assignment	RSAUXACCTYPE		RSAUXACCTYPE	ICORDCSTA1.RSAUXACCTYPE
0AUXACCVAL	Auxiliary account assignment	RSAUXACCVAL		RSAUXACCVAL	ICORDCSTA1.RSAUXACCVAL
0COMP_CODE	Company code	BUKRS		BUKRS	ICORDCSTA1.BUKRS
0BUS_AREA	Business area	GSBER		GSBER	ICORDCSTA1.GSBER
0FUNC_AREA	Functional area	FKBER		FKBER	ICORDCSTA1.FKBER
0PCOMP_CODE	Partner company code	PBUKRS		PBUKRS	ICORDCSTA1.PBUKRS
0PFUNC_AREA	Partner functional area	SFKBER		PFKBER	ICORDCSTA1.PFKBER
0CHRT_ACCTS	Chart of accounts	KTOPL		KTOPL	ICORDCSTA1.KTOPL
0GL_ACCOUNT	G/L account	SAKNR		SAKNR	ICORDCSTA1.SAKNR
0CREDITOR	Vendor	LIFNR		LIFNR	ICORDCSTA1.LIFNR
0DEBITOR	Customer	KUNNR		KUNNR	ICORDCSTA1.KUNNR
0PLANT	Plant	WERKS_D		WERKS	ICORDCSTA1.WERKS
0MATERIAL	Material	MATNR		MATNR	ICORDCSTA1.MATNR
0EMPLOYEE	Employee	PERNR_D		PERNR	ICORDCSTA1.PERNR
0CO_ITEM_TX	CO document row text	CO_SGTXT		SGTXT	ICORDCSTA1.SGTXT
0DOC_DATE	Document date	CO_BLDAT		BLDAT	ICORDCSTA1.BLDAT
0PSTNG_DATE	Posting date	CO_BUDAT		BUDAT	ICORDCSTA1.BUDAT
0CO_DOC_NO	CO document number	CO_BELNR		BELNR	ICORDCSTA1.BELNR
0CO_ITEM_NO	CO document row	CO_BUZEI		BUZEI	ICORDCSTA1.BUZEI

Note

· The characteristics key figure category, reporting value type, details of value type, and statistics indicator are determined by the system from the value type and business transaction of the data records in the SAP R/3 system (see the mapping table COSP_VTYPE)

· When you extract the data, you can make your selection using the order type (0AUTYP) characteristic.

Time Characteristics

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0FISCPER	Fiscal year/period	RSFISCPER	FISCPER	ICORDCSTA1.FISCPER
0FISCVARNT	Fiscal year variant	RSFISCVAR	FISCVAR	ICORDCSTA1.FISCVAR

Units

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0UNIT	Unit of measure	CO_MEINH	MEINH	ICORDCSTA1.MEINH
0CURRENCY	Currency	RSCURRENCY	WAERS	ICORDCSTA1.WAERS

Key Figures

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0QUANTITY	Quantity consumed	SMEGR	SMEG	ICORDCSTA1.SMEG
0AMOUNT	Amount	SWKGR	SWG	ICORDCSTA1.SWG