Solved: Re: sap query

Former Member · ‎2007 May 04

hi,

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

appreciate your help.

Former Member · ‎2007 May 04

are you looking for ABAP query??

chk this

Former Member · ‎2007 May 04

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 · ‎2007 May 04

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 · ‎2007 May 04

are you looking for ABAP query??

chk this

Former Member · ‎2007 May 04

sailaja , excellent work

sap query