The monthly calculation of the cost estimate starts with four steps. Run every month since D-6 until D-2 or D-1 depends of each company. In order to continue for the other steps we need the approval from all controllers.






STEP 1


Instructions for each parameter:


    • Costing Run Date: normally set as last day of closing month

    • Costing Date From: normally set as first day of next new month

    • Costing Date To: always 31.12.9999

    • Qty Structure Date: normally set as first day of next new month

    • Valuation Date: normally set as first day of next new month

The cycle starts with the selection of the materials that are costed. Click on   in the column « Parameter » / line « Selection »








STEP 2

A new screen appears

  1. Click on  beside Material Type
  2. Enter the Material type :

    1. WP2
      1. ZMAT : Finished product & RM & SF
      2. ZVER : Packaging
















    2. PF2 - Enter Dynamic Selections  - Instructions for each parameter:

      1. Maintenance status (include materials with both accounting view and costing view created):

        1. *G*B*

        • *B*G*

      2. DF at client level

      3. DF at plant level

      4. X-plant matl status (to exclude some status, see list here)

      5. Plant-sp.matl status (to exclude same status as above list) and execute 

      6. Material Type: click here to get the full list.

      7. Tick on ‘Always Recost Material’

      8. Tick on ‘Background Processing’

      9. Tick on ‘Print Log’

         




WP2

PF2

STEP 3

WP2 + PF2

In the same screen update the plants:

  1. Click on  beside Plant
  2. In tab Exclude single values
  3. Add the plants from SQ00 in tab excludes





STEP 4

WP2 (ONLY)

To remove Trading Plants (Négoce/NDIR) from WP2 Costing Run the following selections must be performed:


  1. Go to SQ00, user group "Costing", choose the Query "PLANTS" and execute

  2. In case you get an error message saying that your User is not assigned to any User Group, go to Environment -> Work areas and choose Standard area. After go to Edit -> Other User Group -> Costing.
  3. Select Layout /PLNT_CHECK and confirm for your scope if Plants listed are excluded from CK40N parameters.

Conclusion : The Plants should be included/added to the already existing exclude list in CK40N (do not delete the Plants already in the List).

1

2

3




STEP 5

WP2

Check Background Processing 

and save 


The message “Values of variant xxxx” appears

Go back by clicking 











 

 

PF2


Instructions for each parameter:


    • Material Type: click here to get the full list.

    • Tick on ‘Always Recost Material’

    • Tick on ‘Background Processing’

    • Tick on ‘Print Log’

 


 

WP2


 

PF2



STEP 6

  1. Click on  in the column « Execute » / line « Selection »
  2. Check Start Immediately
  3. Click on 



 

STEP 1

WP2 + PF2

The cycle continues by the determination of quantities. Click on the icon  of column Parameter  on the line Struct explosion.









STEP 2

WP2 

A new screen appears

  • Uncheck Background processing and save 

A message appears : "values of variant xxxx saved"

  • Go back by clicking 







PF2


WP2


PF2



STEP 3

WP2 + PF2

  1. Click on  in the column Execute / line Struct explosion
  2. Check Start Immediately
  3. Click on 











WP2



STEP 4

Click on  until the job is finished: the icon  appears in the column log with a status  or

 

 

STEP 1

WP2 + PF2

The cycle continues by the costing. Click on the icon of column Parameter on the line Costing.








STEP 2

WP2

A new screen appears

  • Uncheck Background processing and save 

A message appears : "values of variant xxxx saved"

  • Go back by clicking 














PF2


WP2

PF2



STEP 3

WP2 + PF2

  1. Click on  in the column Execute / line Costing
  2. Check Start Immediately
  3. Click on 





STEP 4

WP2 + PF2

  1. Click on   until the job is finished: the icon   appears in the column log with a status  or




STEP 1

WP2 + PF2

The cycle continues with the analysis of the calculation:
Click on the icon of column Parameter  / line Analysis








STEP 2

WP2

A new screen appears

Select your variant according to your company.

  • Select the variant "ZEPREVAL" for example. 














PF2

A new screen appears

Select your variant according to your company.

  • Select the variant "/SPS" for output report format.

 

 




WP2

PF2

 

 



STEP 3

WP2

A new screen appears

  1. Enter the currency = 1 (currency of the company)
  2. Layout: SAP03 (It has to be created previously by the user)

Save  

A message appears : "values of variant xxxx saved"

  • Go back by clicking 

 

 

 

 

 

 

 


 

 

PF2

 

A new screen appears

 

  1. Enter comparison Value = 1 (Variance costing /MM)
  2. Flag Display Positive and Negative Variances
  3. Material Master Price = 2 (Moving Average Price / Periodic Unit Price)
  4. Layout: /SPS Project (It has to be created previously by the user)
  5. Flag Price Unit in Material Master

 

Save  

 

A message appears : "values of variant xxxx saved"

 

  • Go back by clicking 

 


WP2

PF2



STEP 4


Click on  in the column Execute / line Analysis






STEP 5

WP2

The report is displayed with the list of material codes & plants 

  • A = F / D = Variation in % 
  • B = C x F = Anticipated revaluation
  • C = Total stock (quantity)
  • D = Standard costing M
  • E = Standard costing M+1
  • F = E - D = Costing variation 


The report must be saved in excel by clicking on 

 

PF2 - In progress

 

  • Analyze directly in CK40N 

  • OR alternatively use S_ALR_S_ALR_87099930 transaction 

  • OR new transaction ZZK_MAT_COST_EST with selection variant /SPS V2

 


To be completed!



STEP 6

WP2 + PF2

Check Spreadsheet

WP2 + PF2

Enter the folder & the file name and