07-31-2006 10:09 AM
Hi,
Currently i am working on a report for VF02 transaction.
Can anyone please tell me
1. how to get the shipment number from the billing document number / delivery number and where it can be found in VF02 transaction.
2. how to get the external license number from the billing document number
Is there any function module for getting the shipment number.
Thanks IN Advance
Guhariyan S
07-31-2006 10:17 AM
Hi,
Shipping details are found in the Delivery document of the billing document, you can check in LIKP/LIPS details,
Rgds,
07-31-2006 10:42 AM
hi
I need to get the shipment number for each, delivery.
is there any function module or.. how to get the shipment number from billing document number
Thanks
Guhapriyan
07-31-2006 11:03 AM
check table...
VTTK : Shipment header details
VTTP : Shipment Item details.
ex...
data: izplatform type table of zplatform.
SELECT * INTO CORRESPONDING FIELDS OF table iZplatform
FROM VTTK
inner JOIN vttp
ON VTTKTKNUM = vttpTKNUM
inner JOIN likp
ON vttpvbeln = likpvbeln
inner Join KNA1
ON likpkunnr = KNA1kunnr
WHERE vttk~TKNUM = lv_tknum.
loop at izplatform.
insert zplatform from izplatform.
endloop.
07-31-2006 11:06 AM
07-31-2006 11:38 AM
Hi,
In table VBFA (Document flow), VBELN is the billing document number if VBTYP_N = M, if VBTYP_N is 'J' it is the delivery document number. Get the delivery document number for the billing document.
Then in table: VTTP, input delivery doc number in field VBELN. In this table, you will get the shipment number, TKNUM.
If you want the shiptment cost number then use table VFKP and input TKNUM in field 'REBEL'
Go thru the below link, which will be a further help.
http://www.sapgenie.com/abap/tables_sd.htm
Hope this helps.
Thanks,
Viswanath
07-31-2006 11:15 AM
Hi
Use the function module
RV_SHIPMENT_VIEW
Award points if found useful.
Regards
Inder