topic Re: abap code for query in Application Development and Automation Discussions

abap code for query

abdallah_mustafa — Sat, 01 Feb 2020 12:34:13 GMT

i have a query with two table AFVC , LFA1 and matched

in table LFA1 i have ID and name database for employee in fields LFA1-SORTL and LFA1-NAME1

i use field AFVC-WEMPF to write ID

i create additional field E_NAME1

i want to write the name of employee from table LFA1 in additional field E_NAME1

TammyPowlas — Sat, 01 Feb 2020 13:10:09 GMT

Hello - the easiest way to do this is to use SAP Adhoc Query - see https://blogs.sap.com/2008/06/16/sap-adhoc-query-sq01-sq02-sq03/

It can do the joins in the infoset using SQ00

You can create an additional field as well.

It can also generate ABAP