Versions Compared

Old Version 24

changes.mady.by.user Willy Madoungou

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HideElements
metastrue
breadcrumbtrue
titletrue



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

Business rules

Global

filters apply to all data in Co$ta :

Exclusion of companies with Conso Method :

  • 020 = Not fully consolidat Nconsolidated
  • 090 = Sold
Specifics

and specifics filters apply for each kind of Origin flow :


Origin flow
Rules
Specific Filters 

COOM

CCA

: Cost Center

OPA

: Order

WBS

: Work Breakdown structure

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
node function 2
  • ZCBS group = EPSRO POST OPERATING RESULT. Today done in the prompt of the query as default exclusion
(production cost centers)
  • .
  • Exclusion of settlements to Asset, that means
ata
  • 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
reason
  • 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
SAMPLE WP1

SAMPLE PF1

data is coming from COPA origin flow

NERP

External data uploaded in BW

data is coming from table ZTK_SAMPLE_COGS (no filter applied)

WCFI_LEASE
data

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