Retrieving data from ADDR1_DATA

[Former Member]

Hello Experts,

I am attempting to grab the field EXTENSION2 from ADDR1_DATA for a given delivery number in VL02N. Would anyone happen to know how to grab this field based on the delivery number that is input. Thanks for the help!

[Sijin_Chandran]

Hi Vincent ,

You can get EXTENSION2 field data in ADRC table (ADDR1_DATA is a structure not a table).

For that you need to pass ADDRNUMBER field of ADRC with the value of ADRNR field of KNA1( customer master).

Do the same for the Customer maintained in VL02N.

[former_member193464]

ADDR1_DATA is a structure the DB table is ADRC.
From VBPA you can get the ADRNR for the given VBELN , use this ADRNR in ADRC to get EXTENSION2.