02-21-2006 8:21 AM
Hi,
Can some one help in this?
I have to find out the Material cost relating to particular shipment. From what i know this seems to be coming from condition records EK01 or EK02. I think this has to be taken from the KONV table but i dont know how to find out the same and what would be link between the shipment number (TKNUM) and the condition table KONV.
Thanks in advance,
Arshad
02-21-2006 9:46 AM
Hi,
You don't have the direct link between shipment number and condition table.But it is linked with shipment cost document number FKNUM ( Tbale VFKP).
Shipment cost document number for a shipment number can be obtained from the table VTFA ( Field VBELN).
Select the KNUMV ( Document cond.No ) from the VFKP table and select the reqd values from KONV table.
I hope this helps you!
Thank you.
Regards,
Karun M
02-21-2006 10:02 AM