topic Re: Get the data from data base tables in Application Development and Automation Discussions

Get the data from data base tables

Former Member — Sun, 25 Nov 2007 12:56:42 GMT

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.

Re: Get the data from data base tables

former_member195698 — Sun, 25 Nov 2007 13:11:55 GMT

can you please explain the requirement in detail?

Re: Get the data from data base tables

asik_shameem — Sun, 25 Nov 2007 13:15:43 GMT

hi,

In the select query,

use inner join or

use two internal tables with for all entries..

Re: Get the data from data base tables

Former Member — Sun, 25 Nov 2007 14:17:24 GMT

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

Reward points if useful

Saket Sharma

Re: Get the data from data base tables

Former Member — Mon, 26 Nov 2007 04:56:42 GMT

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.