topic Re: Need FM for retrieving data from ADRC Table in Application Development and Automation Discussions

Need FM for retrieving data from ADRC Table

Former Member — Fri, 23 Mar 2007 06:29:42 GMT

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 — Fri, 23 Mar 2007 06:31:35 GMT

Former Member — Fri, 23 Mar 2007 06:40:31 GMT

try using table adr6.

Former Member — Fri, 23 Mar 2007 06:46:49 GMT

Hi,

U can use this function module ADDR_SELECT_ADRC_SINGLE

and u need to pass address number.

Regards,

Former Member — Fri, 23 Mar 2007 06:51:56 GMT

Try RTP_US_DB_ADRC_READ Function module.

Thanks

Sasmita

Former Member — Fri, 23 Mar 2007 06:52:55 GMT

Use Fm

SD_ADDRESS_GET

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

Please Close your previous threads.

Thanks.

Regards,

Vijay