Regarding ADRNR

[Former Member]

Hi ,

Is there any function that fatches adderess by taking ADRNR as input.

Thanks.

[Former Member]

Hi,

see ADDR_GET

[Former Member]

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

T001L ->Storage Locations

In this table LIFNR /KUNNR are there with this you can get the ADRNR ...becuase the ADRNR consist of the Conversion values of the LIFNR/KUNNR...

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

use this function modules for getting the output ...

[Former Member]

U 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

Try this FM....

ADDRESS_GET_DATA

ADDR_SELECT_ADRC_SINGLE

RTP_US_DB_ADRC_READ

Try in the below code:

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.

Please give me reward points..

Thanks

Murali Poli