Question { TCS, 13355 }

What is ABAP query?

Answer

Many times a need arises for sap user and functional consultants to generate quick reports without getting any ABAP/4 coding done, time taken to complete the code in development transport and test it in QA system and then transport to production sometimes too long.

In such cases, ABAP/4 query is a tool provided by sap for generating these kind of reports.

abap query provide the following type of reports.

*basic list-simple report
*statistics- Report containing statistics function like average and percentage.

ABAP/4 query can be designed in four steps.
* creating a user group
* creating a functional area.
* assignment of user group to functional area.
* creating a query based on functional area.

SAP query tcodes.
* sq01 ABAP/4 query
* sq02 info set/functional area
* sq03 user group

Question { Satyam, 15034 }

Hi i am surya, i have faced this questions plz give me the
answer.
I have requirement like this, i have two internal tbale like
itab and itab1 in itab i have 50 records, in itab1 100
records are there. When execute this question what will be
the output a]50 b]100 c]150? And how to join two internal
tables what is the syntax for that?

Answer

report ZBALA_TEST.

tables: mara,makt.

types: BEGIN OF st_mara,
matnr type mara-matnr,
END OF st_mara.

types: BEGIN OF st_makt,
matnr type makt-matnr,
maktx type makt-maktx,
END OF st_makt.

types:BEGIN OF st_out,
matnr type mara-matnr,
maktx type makt-maktx,
END OF st_out.

data it_mara type TABLE OF st_mara WITH HEADER LINE.
data it_makt type TABLE OF st_makt WITH HEADER LINE.
data it_out type TABLE OF st_out WITH HEADER LINE.

select matnr FROM mara into TABLE it_mara UP TO 50 ROWS.
select matnr maktx from makt into TABLE it_makt UP TO 50 ROWS.

loop at it_mara.
MOVE-CORRESPONDING it_MARA to it_MAKT.
append it_MAKT.
ENDLOOP.