Different Material costs components tables needed

[Former Member]

Hi,

Any tables where i can get all the costs related to particular material-plant combination.

When we go to transaction CK13N, (Material cost estimate), we get different costs for each components like material cost, labour, freight, scrap etc....

From which table can i get the same values. I am using table KEPH, but unable to map all the values. some values are differing.

Thanks,

Ags.

[Former Member]

Agasti,

You are right.

First you go to KEKO and then KEPH.

Hope this helps,

Erwan

[Former Member]

Thanks Erwan for your response.

I am going in the same way.

Have a look at the code below:

SELECT * FROM KEKO WHERE MATNR EQ ITAB-MATNR

AND WERKS EQ ITAB-WERKS

AND BIDAT GE ITAB-BUDAT

AND KADAT LE ITAB-BUDAT

AND BWVAR EQ 'VV1'

AND FEH_STA EQ 'FR'

AND KKZMA NE 'X'.

ENDSELECT.

SELECT * FROM KEPH WHERE

BZOBJ EQ KEKO-BZOBJ AND

KALNR EQ KEKO-KALNR AND

KALKA EQ KEKO-KALKA AND

KADKY EQ KEKO-KADKY AND

TVERS EQ KEKO-TVERS AND

BWVAR EQ KEKO-BWVAR AND

KKZMA EQ KEKO-KKZMA AND

KKZST <> 'X'.

ENDSELECT.

IF SY-SUBRC = 0.

MOVE KEPH-KST001 TO ITAB-EST_MATL.

MOVE KEPH-KST002 TO ITAB-EST_SCRAP.

MOVE KEPH-KST003 TO ITAB-EST_FRGHT.

MOVE KEPH-KST004 TO ITAB-EST_LABR.

MOVE KEPH-KST006 TO ITAB-EST_MFG.

MOVE KEPH-KST017 TO ITAB-EST_DEPRI.

MOVE KEPH-KST019 TO ITAB-EST_DEPSC.

MOVE KEPH-KST021 TO ITAB-EST_WHSBR.

MOVE KEPH-KST032 TO ITAB-EST_WHSSC.

ITAB-EST_VAR = KEPH-KST007 - KEPH-KST008.

MOVE KEPH-KST008 TO ITAB-EST_FIX.

I am getting some values right and some values are not matching eg. Direct labor, depriciation etc.

Any pointers for these will be of great help