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

abap code for query

abdallah_mustafa
Member

‎2020 Feb 01 12:34 PM

0 Likes
657
  • SAP Managed Tags
  • SQL

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

1 REPLY 1
Read only

TammyPowlas
SAP Mentor
SAP Mentor

‎2020 Feb 01 1:10 PM

545
  • SAP Managed Tags
  • SQL

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