topic Re: how do to abap program for following query in Application Development and Automation Discussions

how do to abap program for following query

Former Member — Wed, 03 Oct 2018 12:15:24 GMT

SELECT A.MANDT,A.MATKL,T023T.WGBEZ AS GRP_DESCR,A.MATNR AS ITEM_CODE,(SELECT MAKTX FROM SAPABAP1.MAKT WHERE MANDT = A.MANDT AND MATNR = A.MATNR) AS ITEM_DESCR,

SUM(A.MENGE) * -1 AS QUANTITY,MAX(A.NET_WT) AS NET_WT,SUM(A.WEIGHT) * -1 AS WEIGHT FROM

(

SELECT MATDOC.MANDT,MARA.MATKL,MARA.MATNR,

CASEWHEN MATDOC.SHKZG = 'H'THEN MATDOC.MENGE * -1 ELSE MATDOC.MENGE ENDAS MENGE,

MARA.NTGEW AS NET_WT,CASEWHEN MATDOC.SHKZG = 'H'THEN MATDOC.MENGE * -1 ELSE MATDOC.MENGE END * MARA.NTGEW AS WEIGHT

FROM SAPABAP1.MATDOC,SAPABAP1.MARA WHERE

MATDOC.MANDT = MARA.MANDT AND MATDOC.MATNR = MARA.MATNR AND

MATDOC.BWART IN ('601','602','641','642') AND

MATDOC.MANDT = '500'

AND ((MATDOC.MATNR BETWEEN'RLTOWT1004WH'AND'RLTOWT1004WH') OR (MATDOC.MATNR LIKE'%RLTOWT1004WH%'OR INSTR('RLTOWT1004WH',MATDOC.MATNR) > 0))

AND ((MARA.MATKL BETWEEN''AND'') OR (MARA.MATKL LIKE'%%'OR INSTR('',MARA.MATKL) > 0))

AND (MATDOC.WERKS LIKE'%3030%'OR INSTR('3030',MATDOC.WERKS) > 0)

AND MATDOC.BUDAT BETWEEN'20180901'AND'20180927'

) A,SAPABAP1.T023T

WHERE A.MANDT = T023T.MANDT AND T023T.SPRAS='E'AND T023T.MATKL = A.MATKL

GROUPBY A.MANDT,A.MATKL,T023T.WGBEZ,A.MATNR;

Re: how do to abap program for following query

mmcisme1 — Wed, 03 Oct 2018 18:21:05 GMT

You aren't getting an answer because none of us know what you really want. Is there a certain place where you have an issue? Do you want an example of something to help you out?

Re: how do to abap program for following query

matt — Wed, 03 Oct 2018 18:55:33 GMT

What have you tried?

Re: how do to abap program for following query

matt — Wed, 03 Oct 2018 18:57:29 GMT

If you don't know the basics of OpenSQL, you can encapsulate the SQL into a string, and then run it via ADBC. Or possibly just use an AMDP.

Re: how do to abap program for following query

Jean_Sagi — Wed, 03 Oct 2018 20:30:47 GMT

With a lot of care !

It looks like the syntax used is sql-server transact sql.

In order to translate that query to an ABAP program do yo need to know ABAP and transact-sql.

So the question is: Do you already know both?

Re: how do to abap program for following query

Former Member — Thu, 04 Oct 2018 07:15:20 GMT

Sorry, I get forget to mention that for which purpose it is need it.

I need it for ALV report.

Re: how do to abap program for following query

sudarshan_d29 — Thu, 04 Oct 2018 09:34:37 GMT

Hi,

Final table structure is denoted as "AS" below + Selection from MATDOC and MARA

MANDT AS MANDT

MATKL AS MATKL

T023T-WGBEZ AS GRP_DESCR

MATNR AS MATNR

(SELECT MAKTX FROM SAPABAP1.MAKT WHERE MANDT = A.MANDT AND MATNR = A.MATNR) AS ITEM_DESCR

SUM(A.MENGE) * -1 AS QUANTITY MAX(A.NET_WT) AS NET_WT

SUM(A.WEIGHT) * -1 AS WEIGHT

CASEWHEN MATDOC.SHKZG = 'H'THEN MATDOC.MENGE * -1 ELSE MATDOC.MENGE END AS MENGE MARA.

NTGEW AS NET_WT CASEWHEN MATDOC.SHKZG = 'H'THEN MATDOC.MENGE * -1 ELSE MATDOC.MENGE END * MARA.NTGEW AS WEIGHT

FROM SAPABAP1.MATDOC,SAPABAP1.MARA

**********Where Condition

WHERE MATDOC.MANDT = MARA.MANDT

AND MATDOC.MATNR = MARA.MATNR

AND MATDOC.BWART IN ('601','602','641','642')

AND MATDOC.MANDT = '500'

AND ((MATDOC.MATNR BETWEEN'RLTOWT1004WH'AND'RLTOWT1004WH') OR (MATDOC.MATNR LIKE'%RLTOWT1004WH%'OR INSTR('RLTOWT1004WH',MATDOC.MATNR) > 0))

AND ((MARA.MATKL BETWEEN''AND'') OR (MARA.MATKL LIKE'%%'OR INSTR('',MARA.MATKL) > 0))

AND (MATDOC.WERKS LIKE'%3030%'OR INSTR('3030',MATDOC.WERKS) > 0)

AND MATDOC.BUDAT BETWEEN'20180901'AND'20180927' ) A,SAPABAP1.T023T

WHERE A.MANDT = T023T.MANDT

AND T023T.SPRAS='E'

AND T023T.MATKL = A.MATKL GROUPBY A.MANDT,A.MATKL,T023T.WGBEZ,A.MATNR;

Hope you got it!!!!