sap query

[Former Member]

hi,

can some pl send me the steps create a query. How the joins are used. some info.

appreciate your help.

[Former Member]

Hi Sadhu,

Refer this code :

SELECT a_{matnr a}mEINS A_{MTART D}MAKTx b_{werks c}lgort c~labst INTO CORRESPONDING FIELDS OF TABLE IT_MATERIAL

FROM mara AS a

INNER JOIN MAKT AS D on a_{matnr = d}matnr

inner join marc AS b

ON a_{matnr = b}matnr

inner join MARD as c

ON B_{MATNR = C}MATNR AND B_{WERKS = C}WERKS

where A_{MATNR IN S_MATNR and b}werks in s_werks.

Regards points if helpful.

Regards,

Hemant

[Former Member]

1) create a infoset in sq02, where the required tables will be joined with keys.then generate the infoset.

2) assign this infoset to usergroup.

3)create a query in sq01 by selecting the infoset, select the fields to be dispalyed

in the report, as well as the selection screen fields.

[Former Member]

are you looking for ABAP query??

chk this

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/abap%20query%...

[Former Member]

sailaja , excellent work