Skip to Content
0
Former Member
Apr 22, 2009 at 10:39 AM

Problem with select statement

85 Views

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.