Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks in Advance.
hi every body, kidly find below sap query. how to convert below query into qlikview
IF GT_TEMP-SOBKZ EQ 'E'. SELECT SINGLE KALAB INTO GT_TEMP-LABST FROM MSKA AS A INNER JOIN MARC AS B
ON A~WERKS EQ B~WERKS
AND A~LGORT EQ B~LGORT
AND A~MATNR EQ B~MATNR
WHERE A~MATNR EQ GT_TEMP-MATNR AND A~WERKS EQ GT_TEMP-WERKS
AND A~SOBKZ EQ 'E'
AND A~VBELN EQ GT_TEMP-VBELN AND A~POSNR EQ GT_TEMP-POSNR.
AND B~LVORM EQ ' '.
ELSE. SELECT SINGLE LABST INTO GT_TEMP-LABST FROM MARD AS A INNER JOIN MARC AS B
WHERE A~WERKS EQ GT_TEMP-WERKS AND A~MATNR EQ GT_TEMP-MATNR
AND A~LVORM EQ ' '
ENDIF.