Shipment to Shipment Cost Document Table

[Former Member]

Hii

Can anyone suggest any table name wherein by putting the shipment number we get its corresponding shipment cost document number.

I have tried table VBFA but it shows only the preceding document for shipment(ie delivery)

And When I try putting shipment cost document(in follow on doc field) in the screen no output is shown

I just want a table wherein I can find the corresponding shipment cost doc number for the shipment or the cice versa

Thanks

Gaurav Manocha

[reazuddin_md · Accepted solution]

Try this:

Shipment doc no:VTTK

Item - VTTP

Shipment cost doc:VFKK

Shipment doc flow:- VTFA

[Former Member · Accepted solution]

Hii

I tried the tables told by you but still i cannot relate shipment number directly to shipment cost doc number

Thanks & Regards

Gaurav Manocha

[reazuddin_md · Accepted solution]

Hi Gaurav,

what exactly your requirement?

plz specify why you want to relate both the doc's-

for what purpose?

Gavrav,

I have checked Table:VFKP

goto VFKP- enter shipment cost no: XXXXXXXXX

check the details: External Id1 is nothing but your shipment doc number.

Bcoz u create shipment cost doc wrt shipment doc number.

this shipment doc will store in "External ID1" filed in shipment cost doc item level - VFKP table.

check n confirm

Edited by: Riyaj on Apr 25, 2008 5:25 PM

[Former Member · Accepted solution]

Dear Mr Manocha,

Kindly accept my sincere apoligies.

It should be VFKP and no VKFP.

Trust your purpose would be served.

Regards,

K Gopidas.

[Former Member · Accepted solution]

Hii Mr Gopidas

With VFKP its working fine

Thanks for your help

[Former Member · Accepted solution]

With VFKP its working fine

Thanks a lot

[Former Member]

Dear Mr Manocha,

Could you kindly attempt to use the table VKFP, where the shipment number may be referred to as the reference document number.

Tust you find the reply useful.

Regards,

K Gopidas.

[Former Member]

Dear Mr. Gopidas

Table VKFP is not active in the dictionary in my system.

May be if some other table is there then do let me know.

Thanks & Regards

Gaurav Manocha