EN- CKM3 Collective-Analysis the cost of materials
PT - CKM3 COLETIVA

CKM3 is the collective cost analysis developed to consolidate material values.

It is a amazing tool to detail collectively the actual costs of material in different months and categories after the execution of Material Ledger.

So, In this transaction CKM3N Collective we can see a lot of detail and informations colletively per month or per type of materials. There are many filter of seletions that is a facilitor when we need to check a big range of material every month.

The program CKM3 Collective was developed with standard functions “MLCCS_KEPH_MLCD_READ'', that is used to get the cost  standard stratification , easily! The second one , ''CKMCD_MLCD_READ''  this functions was important to find  the ''multilevel difference'' and ''no allocated'' within two categories ; Receipt and production.

Details:

Tables CKM3 Collective : CKMLHD, CKMLKEPH, MARA,MBEW, TCKH3 ,TCKH1, CKMLCR,MLIT and MLCRF

First function :MLCCS_KEPH_MLCD_READ

  CALL FUNCTION 'MLCCS_KEPH_MLCD_READ'
    EXPORTING
      i_refresh_buffer = abap_true
      it_kalnr         = lt_kalnr
      i_from_bdatj     = p_bdatj
      i_from_poper     = p_poper
      i_to_bdatj       = p_bdatj
      i_to_poper       = p_poper
      ir_keart         = lr_keart
      ir_mlcct         = lr_mlcct
      ir_kkzst         = lr_kkzst
      ir_curtp         = lr_curtp
    IMPORTING
      et_keph_mlcd     = lt_keph_mlcd.


Second function :CKMCD_MLCD_READ

CALL FUNCTION 'CKMCD_MLCD_READ' "
* EXPORTING
*   i_to_poper =                " ckmlpp-poper  Posting Period
*   i_untper =                  " ckmlpp-untper  Value Structure Type
*   i_run_id =                  " ckml_run_id   Number of Costing Runs for Material Ledger
    .  "  CKMCD_MLCD_READ

Obs: There are many others functions in this development .

Categories:
Beginning Inventory, Production, Receipts, Cumulative Inventory, Consumption, Consumption Production, Ending Inventory

First screen ( Data selection)

Second screen 

1. TMAT( type of material )
2. Material Code
3. Short text of material
4. ArAv( Plant)
5. Tp.Aval.
6. Estoque Total =Total inventory quantity 
7. Unit  ( Kilogram= KG);
8. Valor Total = Total Value (Standard cost of material  within the month)
9. Diferença de Preço = Price difference ( Standard value – Actual  value =Price difference  within the month)
10. Valor Real = Actual Value  (Standard value + Price difference  )

You have opportunity to buy it . 

If you have interest to use this report  for EUR 1000 please , send me an email talking about. After the payment , I will send the``Font``this  fabuloso program . It will be necessary only , a small adjustment on program to run in your enviroment  , but it is quite simple!  Because , every company the cost element stratification is different and because of that It`s necessary a small adjustments on the code.