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
ON A~WERKS EQ B~WERKS
AND A~LGORT EQ B~LGORT
AND A~MATNR EQ B~MATNR
WHERE A~WERKS EQ GT_TEMP-WERKS
AND A~MATNR EQ GT_TEMP-MATNR
AND A~LVORM EQ ' '
AND B~LVORM EQ ' '.
ENDIF.
