Hi,
I have a problem with a select statement.
I need to retrieve data from S889 table. I have written a select statement as follows. But it is not working.
Please let me know my mistake.
SELECT SSOUR
VRSIO
SPMON
SPTAG
SPWOC
SPBUP
BZIRK
KDGRP
VTWEG
SPART
HIEZU04
MVGR1
ZZPRODH1
MATNR
WERKS
ABSAT
LFIMG
OAUME
ZZSALES_12
ZZSALES_24
FROM S889
INTO TABLE T_S889
WHERE VRSIO = '000'
AND SPMON = P_MONTH
AND BZIRK = P_SADIS
AND KDGRP = P_CUGRP
AND VTWEG = P_SADCH
AND SPART = P_SADIV
AND HIEZU04 = P_CUPAR
AND MVGR1 = P_MAGRP
AND ZZPRODH1 = P_PRHIE
AND MATNR IN S_MATNR
AND WERKS = P_PLANT.