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