tables

[Former Member]

Guys please help me with this shipment cost tracking report

i need invoice number,frieght,total container and total packages

its very urgent and please tel me

Thanks in advance

[Former Member]

fields are follows

shipment number (TKNUM)

Sum(LIKP. ANZPK) as PKGS

Sum(LIKP. BTGEW), as WEIGHT

VHILM ( for total containers( pallet, carton) )

tbles are needed

VTTS ( Shipmetnt Header Table )

VTTP (Shipment Item)

LIKP ( delivery header table )

VEPO (Handling unit details) Details for a given shipment

first pick the data from VVTS

You will get the Shipment numbers

Ten go to Shpemnt item table

there you will get the delivery numbers for a shipment

get the Material and handling unit( venum) from VEPO based on Delivery numbers

Using Handling unit number get the Type of qty and qty value and weight

based on venum get the weight

thanks

sekhar

[Former Member]

hi

can you be more clear plz

[Former Member]

Hi RK,

Here your requirement is Displaying the report like for

shipment number , invoice number, packages, handling unit and weight

For getting all these

for a shipment you have multiple deliveries.

You will get the shipment number from VTTS

for a shipment you will have more than one delivery atleast.

for getting these deliveries go to VTTP

After getting the deliveries goto LIKP you will get the weights of that

then go to VEPO ( here you will get the handling unit number )

(total number of items are called the packages in VEPO )

Then go to VEKP ( based on handling unit number get the weight )

hi Rk,

try to use the function module .

RV_SHIPMENT_PRINT_VIEW

using these function module you will get whole the shipment information

Then you can read it from the tables (Function module table)

Thanks

Sekahr

Message was edited by:

Lakshmi Sekhar Reddy

[Former Member]

shipment number (TKNUM)

Sum(LIKP. ANZPK) as PKGS

Sum(LIKP. BTGEW), as WEIGHT

VHILM ( for total containers( pallet, carton) )

tbles are needed

VTTS ( Shipmetnt Header Table )

VTTP (Shipment Item)

LIKP ( delivery header table )

VEPO (Handling unit details) Details for a given shipment

select data into <itab1> from VVTS.

select data into <itab2> from VTTP where <condition>.

Based on delivery number of VTTP select data into <itab3> from VEPO.

Based on data from VEPO get the <qty variables>.

claculate the weight.