Need FM for retrieving data from ADRC Table

[Former Member]

Hi I want one Function Module to Retrieve the data from ADRC Table for below condition, if u know any table kindly let me know....

SELECT ADDRNUMBER NAME1

NAME2 NAME3

NAME4 CITY1

POST_CODE1 STREET

COUNTRY REGION

TEL_NUMBER FAX_NUMBER

FROM ADRC INTO TABLE GT_ADRC FOR ALL ENTRIES IN GT_LFA1

WHERE ADDRNUMBER = GT_LFA1-ADRNR

Thanx

Akshitha.

[Former Member]

Hi I want one Function Module to Retrieve the data from ADRC Table for below condition, if u know any table kindly let me know....

SELECT ADDRNUMBER NAME1

NAME2 NAME3

NAME4 CITY1

POST_CODE1 STREET

COUNTRY REGION

TEL_NUMBER FAX_NUMBER

FROM ADRC INTO TABLE GT_ADRC FOR ALL ENTRIES IN GT_LFA1

WHERE ADDRNUMBER = GT_LFA1-ADRNR

Thanx

Akshitha.

[Former Member]

<b>RTP_US_DB_ADRC_READ</b>

[Former Member]

HI

try using table adr6.

[Former Member]

Hi,

U can use this function module ADDR_SELECT_ADRC_SINGLE

and u need to pass address number.

Regards,

[Former Member]

Hi

Try RTP_US_DB_ADRC_READ Function module.

Thanks

Sasmita

[Former Member]

Use Fm

SD_ADDRESS_GET

pass the input as adrnr number and collect the address details.

Please Close your previous threads.

Thanks.

Regards,

Vijay