| Fields required from COPA03 | ||
| 1 | [QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[0LOGSYS] Source System | |
| 2 | [0CALMONTH] Calendar Year/Month | |
| 3 | Measures in the query: Measure\N8110 - Qty Sold External→ used for Actual Sales (€), Last invoice price and Actual unit price (€/KG), calculation Measures\Net sales External (Sales+Royalties) - LC→ used for Actual Volume (KG), Last invoice price, and Actual unit price (€/KG) calculation Note for Net sales: in the transparency, the car3 fx rate will be used for conversion to Euro | |
| 4 | [C_COMPCDE] Company code\Attributes[K_INTRAT] Company Integ Rate | Alternatively the following fields can be considered with Company integration rate Maesure\N8110 - Qty Sold Internal Measures\Net sales Internal (Sales+Royalties) - LC In this case, to calculate the external sales & quantity, the figures of internal field are multiplied by the company integration rate precentage |
| 6 | CPC (Ship-to+Material+incoterms) Ship-to [QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[C_SHIPID] Ship-to party a table with many attributes Material [QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[C_MATNR2] Material Incoterms [QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[C_INCOTRM] Incoterms_P | |
| 7 | [C_DOCNUMB] Sales document (Key & name) [C_ITM_SD] Sales document item (key & name) [C_ITM_SD] Sales document item\Attributes\[C_CDATE2] Order Line Creation date |
| Term | Definition |
|---|---|
| CPC | For NoveCare is the Combination of the ship to, material, and incoterm |
| Latest closed month | The latest month before the current month in the COPA03 query where there is volume for at least a sale order in that month \N8110 - Qty Sold External <> 0 |
| Latest creation date of a line item | Latest creation date of a line item within the ''latest closed month'' |
| Latest sales order | The biggest sales order number with the same date as ''Latest creation date of a line item'' |
| Latest line item | The last line item created for the ''latest sale order'' |
| Last invoice price | The unit price of the latest line item per CPC which is calculated by the total number of the sale divided by the total volume recorded for the latest line item |
| HL last invoice price | The ''last invoice price'' calculated for a CPC without considering incoterm |
With the example below:
Latest closed month: Current month being July. the latest closed month is May. The month before the current month being June is not considered because the QTY is zero→ May
Latest creation date of a line item→ May 30, 2023
Latest sales order:→ SO4
Latest line item→ SO4/1
Last invoice price (See the records in yellow below)→ Last invoice price= (500+300)/(20+0)=40 euro/kg
Month | Material | Ship to | Incoterm | Sales order/Line item | Line item creation date | Amount | QTY |
Apr | M1 | ST 1 | INC 2 | SO5 | Apr 1, 2023 | 1000 | 50 |
May | M2 | ST 2 | INC 2 | SO2 | May 20, 2023 | 3000 | 50 |
May | M2 | ST 2 | INC 2 | SO3 | May 21, 2023 | 6000 | 0 |
May | M2 | ST 2 | INC 2 | SO3/1 | May 30, 2023 | 4000 | 20 |
May | M2 | ST 2 | INC 2 | SO4 | May 30, 2023 | 300 | 10 |
May | M2 | ST 2 | INC 2 | SO4/1 | May 30, 2023 | 500 | 20 |
Jun | M2 | ST 2 | INC 2 | SO3/1 | Jun 14, 2023 | 2000 | 0 |
Jul | M2 | ST 2 | INC 2 | SO3/3 | 15 July, 2023 | 100 | 10 |
Jul | M2 | ST 2 | INC 2 | SO4/1 | 15 July, 2023 | 300 | 0 |
Jul | M2 | ST 2 | INC 2 | SO2/1 | 15 July, 2023 | 1500 | 300 |