topic Re: Sample code in Application Development and Automation Discussions

Sample code

Former Member — Mon, 20 Mar 2006 16:25:18 GMT

Can anybody give me a sample code for the following :

I have to get the address from the following logic using joins:

To get the address number select single ADRNR from TVST into TVST where VSTEL=LIKP-VSTEL.

Then ADDR1_DATA-ADRNR=TVST-ADRNR to get the address number and then the address details .

addr_data-name1 etc..

Please advise.

Regards

Pavan

Re: Sample code

ferry_lianto — Mon, 20 Mar 2006 16:36:40 GMT

Hi Kumar,

Have you looked at this FM?

<b>ST_LOCATION_ADDR_GET</b>

Hope this will help.

Regards,

Ferry Lianto

Re: Sample code

Former Member — Mon, 20 Mar 2006 16:41:04 GMT

Hi Pavan,

Access table ADRC for the details...

Put the below in where condition.

<b> SELECT * FROM ADRC INTO IT_ADRC

WHERE ADRC-ADDRNUMBER = TVST-ADRNR.</b>

Re: Sample code

Former Member — Mon, 20 Mar 2006 16:41:26 GMT

once u get ADRNR, put that as ADDRNUMBER in ADRC table n get the address.

Hope it helps,

Regards,

Bikash

Re: Sample code

Former Member — Mon, 20 Mar 2006 17:06:30 GMT

Hi Pavan,

if you want to select on TVST and ADRC at the same time using joins, your select statement should look something like this:

select TVST_{VSTEL TVST}ADRNR ADRC_{NAME1 ADRC}NAME2 (...)

into corresponding fields of workarea

from TVST inner join ADRC on

( TVST_{ADRNR eq ADRC}ADDRNUMBER )

where TVST~VSTEL eq ...

'Inner join' will only select records with matching entries in both tables, whereas 'left join' will select data from TVST also, if no match can be found in ADRC.

Hope this helps, kind regards, Kathrin!