topic Re: Material Cost Calculation in Application Development and Automation Discussions

Material Cost Calculation

anuradha_wijesinghe — Mon, 26 Aug 2013 11:42:47 GMT

Hi all...

I have created a ABAP report for cost calculation for a material . It should be divided by sub-material and calculate a finish-good material cost. But this cost has small deferent with comparing CK13N .

Logic Structure is Here ..

{ SubMaterial(2) = SubMaterial(3) + SubMaterial(4) + OverHead(2) }

FinishGood Material Cost = SubMaterial(1) + SubMaterial(2) + OverHead(1) ,

= SubMaterial(1) + SubMaterial(3) + SubMaterial(4) + [ OverHead(2) + OverHead(1) ] .

So can anyone explain how do I get this details from tables.

So bellow is the source code I i have created. So can anyone tell this difference come ?

FORM CALCULATE .
   SELECT * into CORRESPONDING FIELDS OF TABLE imbew FROM MBEW
     WHERE MATNR in MAT.
   LOOP at imbew.
     itab-matnr = imbew-matnr.
     SELECT * FROM ckis INTO CORRESPONDING FIELDS OF TABLE ickis WHERE KALNR = imbew-kaln1.
       SORT ickis by KALNR POSNR.
       DELETE ADJACENT DUPLICATES FROM ickis COMPARING KALNR POSNR.
     loop at ickis.
       if ickis-matnr+11(2) = '20'.
         select SINGLE * from mbew into corresponding fields of imbew2 where matnr = ickis-matnr.
           select * from ckis into corresponding fields of table ickis2 where kalnr = imbew2-kaln1.
             SORT ickis2 by KALNR POSNR.
             delete adjacent duplicates from ickis2 comparing kalnr posnr.
             loop at ickis2.
               if ickis2-matnr+11(2) = '10'.
                           itab-ycost = itab-ycost + ickis2-wertn.
                       ELSE.
                           itab-Overhead = itab-Overhead + ickis2-wertn.
                       ENDIF.
             endloop.
           clear imbew2.
       ELSE.
         if ickis-matnr+11(2) = '60'.
           itab-dcost = itab-dcost + ickis-wertn.
         ELSE.
           itab-overhead = itab-overhead + ickis-wertn.
         ENDIF.
       endif.
     ENDLOOP.
     itab-total = itab-ycost + itab-dcost + itab-overhead.
     APPEND itab.
     CLEAR itab-matnr.
     CLEAR itab-ycost.
     CLEAR itab-dcost.
     CLEAR itab-overhead.
     CLEAR itab-total.
   ENDLOOP.
 ENDFORM.                    " CALCULATE

Re: Material Cost Calculation

former_member201275 — Mon, 26 Aug 2013 13:38:00 GMT

I think the standard FM CK_F_MATERIAL_CALC contains the code for this, if you drill down into it. Maybe run a test and debug the result if it is favourable.

Re: Material Cost Calculation

anuradha_wijesinghe — Mon, 26 Aug 2013 15:17:08 GMT

Hello Dear Glen,

is this a function module or Program ?? how to go this ?

Thanks .

Re: Material Cost Calculation

former_member201275 — Tue, 27 Aug 2013 06:47:55 GMT

Apologies, FM = Function Module. Use SE37.

Re: Material Cost Calculation

anuradha_wijesinghe — Tue, 27 Aug 2013 07:00:46 GMT

Thanks. Im sorry Mr. Glen for asking this again and again.. Can I know how to use it for a finish good material with breakdown. Need to know how to handle the import and exports ?

Thanks you very much .

Re: Material Cost Calculation

former_member201275 — Tue, 27 Aug 2013 11:17:11 GMT

Apologies, I actually don't know any more than this myself, just that the calculation you are looking lies in this FM as far as i am aware.

Sorry I could not be of more help.

Re: Material Cost Calculation

Former Member — Fri, 18 Jul 2014 13:23:21 GMT

I have the same problem! was solved? How?

Re: Material Cost Calculation

anuradha_wijesinghe — Wed, 23 Jul 2014 03:36:15 GMT

Yes. It is done. In CKIS there are more values for deferent dates. So i get the latest date which cost calculated and pick that value. \