Skip to Content
0
Oct 31, 2012 at 09:54 AM

can you guess the result for the following select queries.? Is it same?

40 Views

SELECT a~matnr a~ersda a~mbrsh a~mtart a~meins a~matkl a~bismt a~zeinr a~mfrpn
b~ekgrp b~dismm b~mtvfp b~bwtty
c~werks c~lgort
d~maktx

INTO CORRESPONDING FIELDS OF TABLE itab1
FROM mara AS a

JOIN marc AS b
ON a~matnr = b~matnr

JOIN mard AS c
ON a~matnr = c~matnr

JOIN makt AS d
ON a~matnr = d~matnr

WHERE a~matnr IN s_matnr.

VS


SELECT matnr ersda mbrsh mtart meins matkl bismt zeinr
FROM mara INTO TABLE itab_mara
WHERE matnr IN s_matnr.

SELECT matnr ekgrp dismm mtvfp bwtty
FROM marc INTO TABLE itab_marc
FOR ALL ENTRIES IN itab_mara
WHERE matnr = itab_mara-matnr.

SELECT matnr werks lgort
FROM mard INTO TABLE itab_mard
FOR ALL ENTRIES IN itab_mara
WHERE matnr = itab_mara-matnr.

SELECT matnr maktx
FROM makt INTO TABLE itab_makt
FOR ALL ENTRIES IN itab_mara
WHERE matnr = itab_mara-matnr.