Cost component wise break up of standard cost

[former_member216878]

Dear All,

I want cost component wise break up of standard cost from table level. I`m considering table MBEW,KEKO and KEPH to get data but somehow I think I`m missing something.

Please let me know how o achieve it.

Regards

Nitu

[muhammadusman_raza]

Dear Nitisha

KEKO and KEPH is enough for cost component wise breakup data from tables.

Regards

MuR

[former_member216878]

Hi Muhammad,

I used KEKO and KEPH tables but the final breakup total is not matching with MM03 figure.

Regards

Nitu

[ajaycwa1981]

Hi Nitu

Option 1 - If you wish to develop an ABAP Report, use the Below BAPIs

BAPI_COSTESTIMATE_GETLIST: Determine cost estimate lists

BAPI_COSTESTIMATE_GETDETAIL: Determine detailed information for a cost estimate

BAPI_COSTESTIMATE_ITEMIZATION: Determine itemization for a cost estimate

BAPI_COSTESTIMATE_GETEXPLOSION: Determine BOM explosion for a cost estimate

Execute BAPI_COSTESTIMATE_GETLIST first to get the list of cost estimates. Then you execute the other BAPIs

SAP has also provided the sample program SAPBAPICOPC to demonstrate, with examples, how to use these BAPIs

Option 2 - You can also create a SQ01 Query. My colleague just did that

I prefer ABAP report, as you can perform some calculations in it. SQ01 can also cater to that, but ABAP is more stable

Ajay M

[former_member216878]

Hi Ajay,

I did below steps:

Step-1: To get product cost estimate number:

Table- MBEW

Pass- Material& Plant

Get Product cost estimate number

Step-2 : To get costing Date of last standard cost release:

Table- KEKO (header table)

Pass

Cost estimate number = (from step1)

Costing type

Costing version 

Valuation Variant

Status (FEH_STA) = “FR”

Get

Date (KADKY)

I got multiple dates.

Step-3: Get cost component breakup

Table: KEPH

  Pass:

Cost estimate number = (from step1)

Costing type

Costing version

Valuation Variant

Date –step 2 

Type of CCS (KEART) = “H” Main cost comp

Get

Cost field KST001 to KST040 as cost component

But when I compare the break up total with MM03 standard cost figure, it`s not matching at all. I have used all dates but still none of them is matching with MM03 figure.

Please let me know where I`m missing ???

Regards

Nitu

[muhammadusman_raza]

Dear Nitisha

Please check following

KEKO-FREIG = X

KEPH-KKZST = " " (All)

Regards

MuR

[ajaycwa1981]

Hi Nitu

I would suggest use the BAPIs. They do everything whatever you are trying to do, in a completely automated way. It reduces the development effort as well. thats the reason SAP offered it

We did a Query based on table join between MARC, KEKO and KEPH Table. It works pretty perfect.. So you can try that too

Ajay M