Skip to Content
0
Former Member
Mar 17, 2009 at 04:40 PM

problem with select statement in production

230 Views

Hello Guruz,

select statement sucess in development is unsuccessful in production.plz advise:(

SELECT vbuk~vbeln

likp~vstel

likp~kunag

likp~wadat

likp~erdat

lips~lgort

lips~posnr

lips~matkl

vbfa~vbeln

vbpa~kunnr

ltak~bdatu

FROM ( vbuk

INNER JOIN likp

ON vbukvbeln = likpvbeln

INNER JOIN lips

ON likpvbeln = lipsvbeln

INNER JOIN vbfa

ON lipsvbeln = vbfavbelv

INNER JOIN vbpa

ON vbfavbelv = vbpavbeln

INNER JOIN ltak

ON ltaktanum = vbfavbeln )

INTO TABLE gt_deliveries

WHERE vbuk~lvstk = 'B'

AND vbuk~vbeln IN s_vbeln

AND likp~vstel IN s_vstel

AND lips~lgort IN s_lgort

AND vbpa~kunnr IN s_kunnr

AND ltak~bdatu IN s_bdatu

AND vbpa~parvw = '1C'

AND vbfa~posnn = '1'

AND vbfa~vbtyp_n = 'Q'.

Edited by: BrightSide on Mar 17, 2009 4:41 PM