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 akshitha,

Try this FM....

<b>ADDRESS_GET_DATA</b>

Reward,if helpful.

Regards,

V.Raghavender.

[Former Member]

Hi Akshitha,

You could try this one also : ADDR_SELECT_ADRC_SINGLE

Regards,

Aditya

[Former Member]

chk this FM <b>RTP_US_DB_ADRC_READ</b>

[Former Member]

hi,

Check this sample code

  data: wa_addr1_sel like addr1_sel,
        wa_addr1_val like addr1_val.

    clear : wa_addr1_sel, wa_addr1_val.
    wa_addr1_sel-addrnumber = it_adrnr-adrnr.

    call function 'ADDR_GET'
      exporting
        address_selection = wa_addr1_sel
      importing
        address_value     = wa_addr1_val
      exceptions
        parameter_error   = 1
        address_not_exist = 2
        version_not_exist = 3
        internal_error    = 4
        others            = 5.
    if sy-subrc eq 0.
      it_addr-adrnr = wa_addr1_val-addrnumber.
      it_addr-name1 = wa_addr1_val-name1.
      it_addr-street = wa_addr1_val-street.
      it_addr-city = wa_addr1_val-city1.
      it_addr-region = wa_addr1_val-region.
      append it_addr.
      clear it_addr.
    endif.

Regards,

Sailaja.

[Former Member]

Use the function module: ADDRESS_GET_DATA.

Regards