How can i convert this query to sql..or steps to convert this will also be helful.

Tue, 05 May 2015 09:19:48 GMT

PO_ALL:

SELECT MPL.IBCONO COMPANY_NO, MPL.IBFACI FACILITY, MPL.IBITNO ITEM_NUMBER,

(SELECT MAX(MO.AHATAV)

FROM M3EDBPRD.MOATTR MO

WHERE MO.AHATNR = MPL.IBATNR AND MO.AHCONO = MPL.IBCONO

AND IBCONO = '500' AND IBPUSL BETWEEN '15' AND '49'

And IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')) PUT_AWAY_CODE,

MPD.PMMTNO PRODUCT,

MPD.PMCNQT QUANTITY,

ROUND((SUM(CASE WHEN MPL.IBCFQA = 0 THEN MPL.IBORQA ELSE MPL.IBCFQA END - MPL.IBRVQA)) * (MPD.PMCNQT/(SELECT SUM(MPDM.PMCNQT) FROM M3EDBPRD.MPDMAT MPDM WHERE MPDM.PMCONO = MPL.IBCONO AND MPDM.PMFACI = MPL.IBFACI

AND MPDM.PMPRNO = MPL.IBITNO)),2) WIP

FROM M3EDBPRD.MPLINE MPL

LEFT OUTER JOIN M3EDBPRD.MPDMAT MPD

ON MPL.IBCONO = MPD.PMCONO AND MPL.IBFACI = MPD.PMFACI

AND MPL.IBITNO = MPD.PMPRNO

WHERE MPL.IBCONO = '500'

AND MPL.IBPUSL BETWEEN '15' AND '49'

AND MPL.IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')

GROUP BY MPL.IBCONO, MPL.IBFACI, MPL.IBITNO,

(SELECT MAX(MO.AHATAV)

FROM M3EDBPRD.MOATTR MO

WHERE MO.AHATNR = MPL.IBATNR AND MO.AHCONO = MPL.IBCONO

AND IBCONO = '500' AND IBPUSL BETWEEN '15' AND '49'

And IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')),

MPD.PMMTNO, MPD.PMCNQT

Re: How can i convert this query to sql..or steps to convert this will also be helful.

Tue, 05 May 2015 09:21:08 GMT

it is very urgent to solve please help me

Re: How can i convert this query to sql..or steps to convert this will also be helful.

Tue, 05 May 2015 09:54:51 GMT

Help Plz

Re: How can i convert this query to sql..or steps to convert this will also be helful.

Tue, 05 May 2015 11:23:47 GMT

Need Help

topic Re: How can i convert this query to sql..or steps to convert this will also be helful. in QlikView

How can i convert this query to sql..or steps to convert this will also be helful.

Re: How can i convert this query to sql..or steps to convert this will also be helful.

Re: How can i convert this query to sql..or steps to convert this will also be helful.

Re: How can i convert this query to sql..or steps to convert this will also be helful.