topic query in Application Development and Automation Discussions

query

Former Member — Fri, 30 Mar 2007 06:35:20 GMT

Hi,

Please define query for this logic.

Fetch delivery number from table LTAP by passing transfer order

and warehouse number

Thanks

Former Member — Fri, 30 Mar 2007 06:39:43 GMT

Hi ali,

Here is the query....

data:

t_table TYPE

STANDARD TABLE

OF LTAP

SELECT vbeln

FROM ltap

INTO TABLE t_table

WHERE tanum EQ 'XXXXX' AND lgnum EQ 'YYYY'.

Here 'XXXX' and 'YYYY' some related table field values

your required values are in internal table " t_table "

Reagards,.

IF u have any further queries you are welcome......

Hope your problem is solved.

Reward if helpful.

V.Raghavender

Former Member — Fri, 30 Mar 2007 08:16:58 GMT

Hi ali,

Did your problem solved or not ?

If not please provided some more details,

so that I can help you out of the problem.

Regards,

V.Raghavender.

Former Member — Fri, 30 Mar 2007 09:44:30 GMT

please can you hlep me in this.

Ship to address is to be printed along with sold to party address.

Get the ship to party customer number from table VBPA by passing

delivery number and partner as AG. Then pick the address for ship to

party.

Thanks & Regards