topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Wed, 29 Nov 2006 15:35:20 GMT

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

Re: tables

Former Member — Wed, 29 Nov 2006 15:59:11 GMT

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

Re: tables

Former Member — Wed, 29 Nov 2006 16:00:32 GMT

can you be more clear plz

Re: tables

Former Member — Wed, 29 Nov 2006 16:08:27 GMT

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.

Re: tables

Former Member — Wed, 29 Nov 2006 16:48:25 GMT

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