Function Module to get address from adrc table

[Former Member]

Hi,

Is there any Function module which is retrieving data from ADRC table by passing address number.

I tried in SDN and I got address_read but its obsolete.

[kesavadas_thekkillath]

Check ADDR_GET , ADDR_COMM_GET , ADDR_GET_COMPLETE

[Former Member]

Hi Bachi,

Use this FM RTP_US_DB_ADRC_READ

tihs is what you are looking for.

Thanks

Nishit

[Former Member]

Hi,

Please try this piece of 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

Hiren k.Chitalia

[Former Member]

Use this FMs : ADDR_GET & RTP_US_DB_ADRC_READ

Thanks

Chinni

Edited by: Tirumula Rao Chinni on Mar 6, 2010 3:41 PM

[ldzierza]

Hi

you can use this example:

data:     lv_adrnr           TYPE adrnr,
            ls_addr1_sel    TYPE addr1_sel,
            ls_addr1_val     TYPE addr1_val,
            ls_sadr            TYPE sadr.

DATA:    BEGIN OF ls_addr_groups OCCURS 3.
         INCLUDE STRUCTURE adagroups.
DATA:    END OF ls_addr_groups.

* Read address data and convert it to old structure SADR

   CLEAR ls_addr1_sel.
   ls_addr1_sel-addrnumber = lv_adrnr.
   ls_addr1_sel-date       = '00010101'.

   CALL FUNCTION 'ADDR_GET'
     EXPORTING
       address_selection = ls_addr1_sel
     IMPORTING
       address_value     = ls_addr1_val
     TABLES
       address_groups    = ls_addr_groups
     EXCEPTIONS
       parameter_error   = 01
       address_not_exist = 02
       version_not_exist = 03
       internal_error    = 04.

   IF sy-subrc EQ 0.
     CALL FUNCTION 'ADDR_CONVERT_ADDR1_VAL_TO_SADR'
       EXPORTING
         addr1_val = ls_addr1_val
       IMPORTING
         sadr      = ls_sadr
       EXCEPTIONS
         OTHERS    = 1.
   ENDIF.