Sample code

[Former Member]

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

[ferry_lianto]

Hi Kumar,

Have you looked at this FM?

<b>ST_LOCATION_ADDR_GET</b>

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

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>

[Former Member]

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

Hope it helps,

Regards,

Bikash

[Former Member]

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!