Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Retrieving data from ADDR1_DATA

Go to solution
Former Member

‎2012 Nov 06 9:57 PM

0 Likes
6,206

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!

1 ACCEPTED SOLUTION
Read only

Go to solution
Sijin_Chandran
Active Contributor

‎2012 Nov 07 6:35 AM

0 Likes
3,896

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.

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!

Reply
2 REPLIES 2
Read only

Go to solution
Sijin_Chandran
Active Contributor

‎2012 Nov 07 6:35 AM

0 Likes
3,897

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.

Read only

Go to solution
former_member193464
Contributor

‎2012 Nov 07 6:54 AM

0 Likes
3,896

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.