topic Re: sap query in Application Development and Automation Discussions

sap query

Former Member — Fri, 04 May 2007 14:28:35 GMT

hi,

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

appreciate your help.

Former Member — Fri, 04 May 2007 14:31:11 GMT

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 — Fri, 04 May 2007 14:45:27 GMT

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 — Fri, 04 May 2007 14:49:37 GMT

are you looking for ABAP query??

chk this

Former Member — Fri, 04 May 2007 15:00:06 GMT

sailaja , excellent work