Co$ta - Origin flow & Filters

>> Back to the  Co$ta project  home page




Origin flow

You can add the characteristic Origin Flow (1) to see where costs are coming from:

  • CCA: direct posting in cost center (ex: Cost center 0087-1200 (3))
  • OPA: posting in CO or PM order (ex: Order 12141464 (2))
  • WBS: posting in WBS element (ex: WBS MSC-M18100.AA.02.02 (4))
  • COPA: posting done in COPA (commissions & samples in PF1)
  • FI: Packaging & Spare parts reception
  • NERP: Data uploaded manually (Non ERP legal entities)
  • WCFI_LEASE: IFRS16 
  • CORR_FLOW: Correction file (Flow used to transfer costs from a subpackage to another one)
  • SAMPLE: Samples posted in cost centers in WP1 are flagged using the table ZTK_SAMPLE_COGS
  • ADJUSTMENT FLOW: all manual posting related Perimeter Change Adjustment
  • ANAPL_BUDG: Budget data (on version 000) coming from ANAPLAN tool
  • ANAPL_EST: Best estimate (on version F01) data coming from ANAPLAN tool 




Filters

There are global filters apply to all data in Co$ta :

Exclusion of companies with Conso Method :

  • 020 = Not fully consolidated
  • 090 = Sold

and specifics filters apply for each kind of Origin flow :


Origin flowSpecific Filters 

CCA

OPA

WBS

As all the BW controlling's reports, Co$ta uses data coming from SAP CO, with the following filters :

  • Only take into consideration primary costs elements in CO, that means cost element where the cost element category equal to '01'
  • Exclude statistical entries (filter in the model and filter in the query)
  • Exclusion of the KOAO transaction, i.e. exclusion of data with
    • Value Type '10'
    • Key figure type equal to '1000'
    • Key figure sub-type '05' (Excluding the Settlement to Orders, WBS to others WBS/Orders/CCs)
  • Only take into consideration data in company currency (currency type) equal to 10 (the company code currency).
  • Exclusion of Cost center attached to the ZCBS group = EPSRO POST OPERATING RESULT. Today done in the prompt of the query as default exclusion.
  • Exclusion of settlements to Asset, that means data where WBS type = IM + Movement H
  • Exclusion on orders (in the query): Production pay (05) and process order plant (40), Because Co$ta only concerns overhead costs In globals filter: filter on order category: Exclusion of  Z001(eq 40 ) and ZIMB (PF1/WP1) (eq 01), ZDNI, ZZC*, RM01
  • Exclusion reasons:
    • Exclusion 1: Exclude deposit to GL Account
    • Exclusion 2: Exclude spare parts Units
    • Exclusion 3: Exclude Packaging
    • Exclusion 4: Exclude revenue entries
    • Exclusion 5: Exclude data take over (Account document type equal to 'UE' for Rhodia and 'B0' for Solvay)
    • Exclusion 6: Exclude Unloading of Elements from OTP IM to the asset
FI

Data is coming from application Working capital.

Specific filters applied on :

  • Account document type equal to "WE" + "ML" (Good receipt and ML Settlement)
  • GL Account Working Capital Type equal to inventories
  • GL Account Working Capital SubType) equal to Industrial Supplies or Packaging
WCFI_LEASE

Data is coming from Working capital lease (IFRS16)

This flow is based on Financial Account Payables data and restricted to the part of amounts linked to a Real Estate contract and a balance sheet accounts (identified by the flag C_BSCTFAF), to be excluded from Working Capital