topic Re: Abap Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/abap-query/m-p/3168623#M753909 <HTML><HEAD></HEAD><BODY><P>you can add the additional fields,then in extras,click the coding for addition</P><P>in there,you can put your code </P><P>may this can help you!</P></BODY></HTML> Fri, 07 Dec 2007 00:47:08 GMT Former Member 2007-12-07T00:47:08Z Abap Query https://community.sap.com/t5/application-development-and-automation-discussions/abap-query/m-p/3168622#M753908 <HTML><HEAD></HEAD><BODY><P>Abapers need your advise in my current work.</P><P></P><P>Im doing an abap query using tables lfa1 , adr2 , adr3 and adr6..basically the objective of the program is to download the tel_number , tel_extens , consnumber of each table having a vendor code in lfa1.</P><P></P><P>Problem is in TABLE ADR2 field tel_number and tel_extens and consnumber consist of both TELEPHONE NUMBER AND MOBILE NUMBER.I need to separate those two group and have a filter of FIELD R3_USER = '2' , '3' meaning thats a mobile number. Im thinking that I might need to add fields and so of course code it.</P><P></P><P>Can you help me on how to do that.</P><P></P><P>Again , in table adr2 field tel_number consist of telephone and mobile I need to separate that my filter would be r3_user = '2' , '3' , meaning thats a mobile number.</P><P>My problem is how would I code in abap query.Can you advise on what to do.</P></BODY></HTML> Fri, 07 Dec 2007 00:03:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-query/m-p/3168622#M753908 Former Member 2007-12-07T00:03:27Z Re: Abap Query https://community.sap.com/t5/application-development-and-automation-discussions/abap-query/m-p/3168623#M753909 <HTML><HEAD></HEAD><BODY><P>you can add the additional fields,then in extras,click the coding for addition</P><P>in there,you can put your code </P><P>may this can help you!</P></BODY></HTML> Fri, 07 Dec 2007 00:47:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-query/m-p/3168623#M753909 Former Member 2007-12-07T00:47:08Z