Abap Query

[Former Member]

Abapers need your advise in my current work.

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.

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.

Can you help me on how to do that.

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.

My problem is how would I code in abap query.Can you advise on what to do.

[Former Member]

you can add the additional fields,then in extras,click the coding for addition

in there,you can put your code

may this can help you!