Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Different Material costs components tables needed

Former Member

‎2006 Dec 08 4:05 PM

0 Likes
691

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.

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.

Reply
2 REPLIES 2
Read only

Former Member

‎2006 Dec 08 4:07 PM

0 Likes
587

Agasti,

You are right.

First you go to KEKO and then KEPH.

Hope this helps,

Erwan

Read only

Former Member
In response to Former Member

‎2006 Dec 08 4:11 PM

0 Likes
587

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