topic Re: Retrieving data from ADDR1_DATA in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149941#M1710327 <HTML><HEAD></HEAD><BODY><P>ADDR1_DATA is a structure the DB table is ADRC.<BR />From VBPA you can get the ADRNR for the given VBELN , use this ADRNR in ADRC to get EXTENSION2.</P></BODY></HTML> Wed, 07 Nov 2012 06:54:47 GMT former_member193464 2012-11-07T06:54:47Z Retrieving data from ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149939#M1710325 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>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!</P></BODY></HTML> Tue, 06 Nov 2012 21:57:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149939#M1710325 Former Member 2012-11-06T21:57:02Z Re: Retrieving data from ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149940#M1710326 <HTML><HEAD></HEAD><BODY><P>Hi Vincent ,</P><P></P><P>You can get EXTENSION2 field data in ADRC table (<SPAN style="color: #333333; font-size: 12px; background-color: #ffffff;">ADDR1_DATA</SPAN> is a structure not a table).</P><P>For that you need to pass ADDRNUMBER field of ADRC with the value of ADRNR field of KNA1( customer master).</P><P>Do the same for the Customer maintained in VL02N.</P></BODY></HTML> Wed, 07 Nov 2012 06:35:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149940#M1710326 Sijin_Chandran 2012-11-07T06:35:41Z Re: Retrieving data from ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149941#M1710327 <HTML><HEAD></HEAD><BODY><P>ADDR1_DATA is a structure the DB table is ADRC.<BR />From VBPA you can get the ADRNR for the given VBELN , use this ADRNR in ADRC to get EXTENSION2.</P></BODY></HTML> Wed, 07 Nov 2012 06:54:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/retrieving-data-from-addr1-data/m-p/9149941#M1710327 former_member193464 2012-11-07T06:54:47Z