Get the data from data base tables

[Former Member]

Hi ..

Iam preparing quotation layout . In that i have to display the address in address window form two tables, means i have to get the address by using two tables like have to select the data from that tables ...

How can i do that one?

Can anybody expalin abt that pls...

Regards,

pandu.

[former_member195698]

can you please explain the requirement in detail?

[asik_shameem]

hi,

In the select query,

use <b>inner join</b> or

use two internal tables with <b>for all entries</b>..

[Former Member]

Hello,

If you are looking at fetching the adress details for partner function(Say Ship to, Sold to , payer etc) in the quotation, then you can proceed like this:

Take the Quotataion number and the item number and the respective partner function say PY for payer etc and then Go to VBPA table and fetch field ADRNR from the table for this partner. With this ADRNR call the FM ADDR_SELECT_ADRC_SINGLE and as an output of this FM, you will get address details.

Regards

<b>Reward points if useful</b>

Saket Sharma

Saket Sharma

[Former Member]

Hi Sharma thank u for ur reply ...

Can u pls tell me in a detail how to impliment this function module in a script

where shoud we write this ... means in script or in print program?

Help me pls

Regards,

pandu.