topic Re: HI ALL HOW TO GET DATA FROM ADDR1_DATA in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076154#M729411 <HTML><HEAD></HEAD><BODY><P>Rocky,</P><P></P><P>Use your order number to get partner data from VBPA. You will have to ensure you use the correct partner type: sold-to, ship-to etc. KUAGV also should have ADRNR populated as well and you might not have to do the VBPA select.</P><P></P><P>Use field VBPA-ADRNR to do a call to ADDR_GET.</P><P></P><P>You will have to fill in the address_selection importing parameter of the ADDR_GET function module.</P><P></P><P>Best Regards,</P><P>Chris H.</P></BODY></HTML> Tue, 27 Nov 2007 13:17:35 GMT Former Member 2007-11-27T13:17:35Z HI ALL HOW TO GET DATA FROM ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076150#M729407 <HTML><HEAD></HEAD><BODY><P>HI ALL</P><P></P><P>I WOULD LIKE TO KNOW HOW TO GET CUSTOMER NAME FROM ADDR1_DATA SINCE I HAVE OTHER TABLES TO USE IS VBAK, KUAGV, VBKD AND RV45A AND THESE TABLES DOES NOT HAVE ANY MATCHING FIELD TO FETCH RELEVENT DATA.</P><P></P><P>WHAT IS FIELD LINK BETWEEN ADDR1_DATA AND OTHER TABLES SO THAT I CAN FETCH NAME FROM ADDR1_DATA.</P><P></P><P>THANX IN ADVANCE.</P><P>ROCKY</P></BODY></HTML> Tue, 27 Nov 2007 13:10:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076150#M729407 Former Member 2007-11-27T13:10:29Z Re: HI ALL HOW TO GET DATA FROM ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076151#M729408 <HTML><HEAD></HEAD><BODY><P>ADDR1_DATA is a structure, you will need table ADRC to get the fields you are looking for. If you have a customer number first read table KNA1 to get field ADRNR, tis is then the key for tabel ADRC.</P><P></P><P>REGARDS,</P><P>Nick</P></BODY></HTML> Tue, 27 Nov 2007 13:14:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076151#M729408 Former Member 2007-11-27T13:14:10Z Re: HI ALL HOW TO GET DATA FROM ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076152#M729409 <HTML><HEAD></HEAD><BODY><P>hi Rocky,</P><P></P><P>in VBAK you should have KUNNR (customer number), than:</P><P>VBAK-KUNNR = KNA1-KUNNR (KNA1 is customer master, general data)</P><P>KNA1-ADRNR = ADRC-ADDRNUMBER (ADRC is address master, however many data you can find in KNA1 as well).</P><P></P><P>hope this helps</P><P>ec</P></BODY></HTML> Tue, 27 Nov 2007 13:14:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076152#M729409 JozsefSzikszai 2007-11-27T13:14:18Z Re: HI ALL HOW TO GET DATA FROM ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076153#M729410 <HTML><HEAD></HEAD><BODY><P>Hi Rocky,</P><P></P><P>Just select your data from table KNA1 using KUNNR (most of the address data is already contained in this table) or use FM ADDR_GET_COMPLETE with the field ADRNR of KNA1.</P><P></P><P></P><P>Regards,</P><P></P><P>John.</P></BODY></HTML> Tue, 27 Nov 2007 13:14:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076153#M729410 Former Member 2007-11-27T13:14:44Z Re: HI ALL HOW TO GET DATA FROM ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076154#M729411 <HTML><HEAD></HEAD><BODY><P>Rocky,</P><P></P><P>Use your order number to get partner data from VBPA. You will have to ensure you use the correct partner type: sold-to, ship-to etc. KUAGV also should have ADRNR populated as well and you might not have to do the VBPA select.</P><P></P><P>Use field VBPA-ADRNR to do a call to ADDR_GET.</P><P></P><P>You will have to fill in the address_selection importing parameter of the ADDR_GET function module.</P><P></P><P>Best Regards,</P><P>Chris H.</P></BODY></HTML> Tue, 27 Nov 2007 13:17:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076154#M729411 Former Member 2007-11-27T13:17:35Z Re: HI ALL HOW TO GET DATA FROM ADDR1_DATA https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076155#M729412 <HTML><HEAD></HEAD><BODY><P>Hi Nick,</P><P></P><P>Thank you!</P><P></P><P><SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.sap.com/1336/images/emoticons/happy.gif"></SPAN></P><P></P><P>Regards,</P><P>Giovanni</P></BODY></HTML> Fri, 11 Sep 2015 16:47:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/hi-all-how-to-get-data-from-addr1-data/m-p/3076155#M729412 Former Member 2015-09-11T16:47:50Z