Objectives |
|---|
This page contains all the documentations of subjects related to Production Costs. |
Infoarea Name | Infoarea Techname |
|---|---|
Product Cost Controlling | AREA_F_COPC |
ODS: Product Cost Controlling | AREA_F_COPC_ODS |
CCR: Market Margin | AREA_F_COPC_MM |
Infoprovider Name | Infoprovider Techname |
|---|---|
Material Units | IST_PCMA |
CCR: Cost elements matrix | ODS_PCP2 |
CCR: released costs estimates | ODS_PCP3 |
CO-PC: list of materials of utilities (10) | ODS_PC1A |
CO-PC: list of materials of utilities (30) | ODS_PC2A |
CO-PC: order header quantity (10) | ODS_PC1B |
CO-PC: order header quantity (30) | ODS_PC2B |
CCR : Product Cost Planning - All Cost Estimates | CUB_PCP01 |
CCR Exploded Itemization | CUB_PCP02 |
CO-PC: Manufacturing Costs per Process Order (10) | CUB_PC001 |
CO-PC: Manufacturing Costs per Process Order (30) | CUB_PC002 |
CO-PC: Manufacturing Costs per Process Order | MPR_PC001 |
Stock valorisation by costing | MPR_ICPC1 |
CCR : plant transfert - cost transport | ODS_PCP5 |
| Transport Costs & Duties | DBCOPA24 |
CCR: Integrated margin | ODS_PCP4 |
CCR: Integrated margin first-calculation ( Direct Update ) | ODS_PCP6 |
CCR: Product Cost Items | ODS_PCP1 |
Cost Components for Cost of Goods Mfd | ODS_PCP7 |
Resource's Unit Price | ODS_PCP8 |
CCR: Product Cost Items (Market Margin) | DSO_PCP1 |
Purchase Price (Market Margin) | DSO_PCP2 |
CCR: Released Costs Estimates (Market Margin) | DSO_PCP3 |
DataFlow Overiew
Integrated Margin for EP & PI
Core Query Name | Core Query Techname | Infoprovider Name | Infoprovider Techname |
|---|---|---|---|
BW - Integrated Margin (Core Query) | BW_QRY_ODS_PCP4_0001 | CCR: Integrated margin | ODS_PCP4 |
BW - Integrated Margin (Core Query) | BW_QRY_ODS_PCP4_2 | CCR: Integrated margin first-calculation | ODS_PCP6 |
Infoprovider Name | Infoprovider Techname | Source System | Source Infoprovider Name | Source Inforprovider Techname |
|---|---|---|---|---|
CCR: Integrated margin | ODS_PCP4 | WBP_400 | CCR: Integrated margin first-calculation (Direct Update) | ODS_PCP6 |
CCR: Integrated margin first-calculation (Direct Update) | ODS_PCP6 | WBP_400 | Updated by ABAP Program | 1) Z_M_INT |
CCR: Product Cost Items (Market Margin) | DSO_PCP1 | WP1_400 | Cost components | DTS_KEKO_CKIS |
CCR: Released Costs Estimates (Market Margin) | DSO_PCP3 | WP1_400 | Product Cost Planning: Released Calculations | 0CO_PC_PCP_02 |
Purchase Price (Market Margin) | DSO_PCP2 | DW2 | Database: DW2 Table: GL_COST_PURCHASE | 6DB_GL_COST_PURCHASE |
|
|
|
| |
|
|
|
|
Data Update Conditions for DSO_PCP1 from DTS_KEKO_CKIS
Data Source: DTS_KEKO_CKIS
Source System: WP1_400
Data Flow Version: BI 7.0
Transformation: RSDS DTS_KEKO_CKIS WP1_400 -> ODSO DSO_PCP1 (0K1O4SUXOC9DPNTS7R3JSO0DRSOF0BY9)
Start Routine: This start routine is to do 2 main tasks.
1) It is to delete all records where the amount and quantity is equal to zero.
2) It is to delete all records where the costing variants are not equal to ZFO, Z25 and ZEP.
After the start routine, each individual record will have fields that will be set with constant values or formulas.
Individual Constants:
1) Costing Variant is overwrited with the new costing variant value ZIP that is defined for this project.
2) Fiscal Variant is fixed to K4.
3) Cost Component Structure is fixed to Z1.
Individual Routines:
1) Fiscal Year/Period required some ABAP codings to convert the incoming data into the correct format to be updated.
2) For the key figure Variable Amount, a formula is required to take the total amount minus the fixed amount to get just the variable amount.
Data Update Conditions for DSO_PCP3 from 0CO_PC_PCP_02
Data Source: 0CO_PC_PCP_02
Source System: WP1_400
Data Flow Version: BI 7.0
Transformation: RSDS 0CO_PC_PCP_02 WP1_400 -> ODSO DSO_PCP3 (0CY1UWMKPVWXUI74VIAPF3V2S12PIYQ1)
Start Routine: This start routine is to do 2 main tasks.
1) It is to delete all records where the currency type is not equal to Company Currency (Value = 10).
2) It is to delete all records where the costing variants are not equal to ZFO, Z25 and ZEP.
After the start routine, each individual record will have fields that will be set with constant values or formulas.
Individual Constants:
1) Costing Variant is overwrited with the new costing variant value ZIP that is defined for this project.
Individual Routines:
1) For the key figure 0AMOUNT, we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together.
2) For the key figure K_CCR_100 (100 Raw Materials), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 100.
3) For the key figure K_CCR_110 (110 Toll Manufacturing), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 110.
4) For the key figure K_CCR_120 (120 Utilities - VC), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 120.
5) For the key figure K_CCR_200 (200 Labor Costs), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 200.
6) For the key figure K_CCR_210 (210 Supplies & Misc.), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 210.
7) For the key figure K_CCR_220 (220 Maintenance), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 220.
8) For the key figure K_CCR_230 (230 Overheads), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 230.
9) For the key figure K_CCR_240 (240 Utilities -FC), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 240.
10) For the key figure K_CCR_300 (300 Depreciation), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 300.
11) For the key figure K_CCR_310 (310 N/A), we add the Fixed Amount (WERTF) and Variable Amount (WERTV) together if the Cost Component (ELEMT) equals to 310.
End Routine:
1) The purpose of this routine is to check if the current incoming record already exists in the DSO_PCP3 from the previous month loading. If it exists, delete the incoming record.
Data Update Conditions for DSO_PCP2 from 6DB_GL_COST_PURCHASE
Data Source: 6DB_GL_COST_PURCHASE
Source System: DW2
Data Flow Version: BI 7.0
Transformation: RSDS 6DB_GL_COST_PURCHASE DW2 -> ODSO DSO_PCP2 (07G0MUNSUYM2GSSZ09F9Q6CC9OF3LCOZ)
There are 3 individual rountines in this transformation to divide the following key figure values that are of currencies Korean Won (KRW) and Japanese Yen (JPY) by 100.
- C_AMT_CP
- C_AMT_CNP
- C_AMT_AMO
Read more information in :
https://drive.google.com/open?id=0BwtAGBKWM-z-cWdzQ0QyTTFpRHM