Syensqo IS - Customer Support

Page tree



SCREEN - Consumption analysis

>> Back to the SCREEN - Logistics & Packaging home page




The aim of this query is to provide users with a transversal view of Packaging material consumption in production process in WP1 and PF1

It includes:

  • Packaging components: Actual + target quantities and costs
  • Manufactured materials (so-called products):

    • Actual production quantities and costs (total + variable) of products including “direct” packaging consumption, in order to measure weight of packaging vs production metrics. “Direct” means that if finished B has semi finished A in its BoM, and if A has packaging component P in its BoM, only A is reported as product in Screen report (and not B) => multi level consumption is not supported.  


  • Sold quantity, Net sales and Variables Cost of sales, in order to measure weight of packaging costs vs sales and costs of sales. Same products as identified above.

It mainly includes IMEP - Integrated Manufacturing & Energy Performance data

    • Packaging materials are selected as BoM components (IMEP - Index 1 = 3) according to their Valuation class: WP1 Z110 (stock account 31000300) and PF1 Z051 (2110110000)

    • Related products are all the ones for which packaging is consumed in the same Plant / Period (IMEP - Index 1 = 1)



It also includes P&L data (sales):

    • For all selected products (see above), some related sales infos (including Sold quantity, Net sales and Variable Costs of Sales) are pulled from COPA at Company code / Period level. That means that for ex in Period 01.2021, if Material 10363 is produced in Plant 7851, the whole sales of 10363 in Company 8090 are taken into account, and not only sales from Plant 7851


    • It is assumed that, most of the time, production and sales do not occur during the same period; for this reason, comparisons should be done for several rolling periods in order to minimize this time effect  

    • A technical split is performed in Screen in order to get iMEP packaging costs all along sales dimensions (Customer, Ship-to...) that do not exist in iMEP



Data update 

  • iMEP data: several times a day from D1 to D6, once a day the rest of the month
  • P&L data: several times a day from D2 to D5, once a day the rest of the month


Access the workbook

The workbook to be used is BW_WBK_SCRE_0003   – Pack. Manuf. Consumption analysis (Core Workbook)

=> Go to Analysis for Office in excel 

=> Click "Open Workbook"



Run the workbook

It is mandatory to enter:

  • Conso view (2) : enter 1 to apply the legal entity consolidation rate or 0 not to take the consolidation rate into consideration 
  • Calendar Month/Year (3) : MM.YYYY : from posting date

It is also possible to enter:

  • a Company Code (4)
  • a Plant (5)
  • a PRS Company code (6)
  • Target Curr. for conversion (7) : the exchange rate used is CAR3 
  • UoM for Qty conv. : Unit of Measure (VKG by default)
  • BFC GBU (8)

Click "OK" 



Basic report

The report is displayed with :

  1. Pack. Actual Qty: actual packaging consumption on Production orders (Cost collectors / Process orders) (IMEP - Index 1 = 3. It corresponds to movement types 261/262) 
  2. Pack Costs bef. ML Reval.: value of actual packaging  consumption
    • WP1: same as Actual costs (3)
    • PF1: standard value before month-end ML revaluation
  3. Pack Actual Costs: value of actual packaging consumption
    • WP1: consumed qty at standard price (IMEP - Index 1 = 3)
    • PF1: real value including month-end Material Ledger revaluation (IMEP - Index 1 = 3)



Where to find corresponding data in SAP ?

Display Material movements with the transaction MB51 - Material Document List. 

  • Enter Movement type = 26* in the prompt: 





Consumption of material 1081129 BIG BAG 108X108X202 1T BLCK ST / plant 0087 in 01.2021 in process orders

  1. = 1 739 PC
  2. = 24 972,04 EUR (at standard costs) 



Production quantities & costs

  1. Prod. Actual qty: actual production qty issued from  Production/Process orders (IMEP index 1 = 1) 

  2. QUR *100: Pack. Actual qty / Prod. Actual qty * 100

    • Actual number of packaging units needed to produce 1 unit of finished product

  3. Prod. Actual Costs: Actual production costs
  4. Pack. vs Prod Total Costs %: Actual packaging costs / Prod. Actual Costs (3)
  5. Prod. Actual Var. Costs: Variable production costs (costs of raw materials & energy)
  6. Pack. vs Prod. Var. Costs %: Actual packaging costs / Prod. Actual Var. Costs (5)
  7. QUS *100: Pack. Target qty / Prod. Actual qty * 100
    • Theoritical number of packaging units needed to produce 1 unit of finished product (according to its standard Bill of Materials)
  8. Pack. vs Prod Sdt Costs %: Packaging target costs / Production Actual costs (3) x 100 => Theoritical part of packaging costs in standard production costs
  9. Pack. vs Prod Sdt Var. Costs %: Packaging target costs / Production Actual variable costs (5) x 100 => Theoritical part of packaging costs in variable standard production costs



Sales quantities & costs

  1. Sold Qty: Quantity sold (BFC account = N8110)
  2. Sales: Product net sales (BFC account = R10000 - Net sales)
  3. Var. CoS: Variable costs of goods sold (BFC account = R15400 - Variable costs of sales)

by product sold (=Material (Prod.)



Where to find corresponding data in SAP ?

In KE30 - Profitability report

  1. Sold Qty: Qty unit base
  2. Sales: B00 Net Sales
  3. Var. CoS: D00 VC Variable Cost




Packaging costs / sales

  1. Pack. Costs per Sold unit * 100: Pack. Actual Costs (a) / Sold Qty (b) => Actual packaging cost for 1 unit of product sold
  2. Pack. Costs vs Sales %: Pack. Actual Costs (a) / Sales (c) => Weight of Actual packaging costs compared to related product sales
  3. Pack. Costs vs Var. CoS %: Pack. Actual Costs (a) / Var. CoS (d) => Weight of Actual packaging costs compared to related variable costs of sales



Other Screen packaging workbooks




The best way to get IT support is to use the new Service One Platform.