topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 25 Jan 2008 11:38:10 GMT

SELECT vbpa~vbeln

vbpa~kunnr

vbap~vbeln

vbap~posnr

vbap~yygfkto

FROM vbpa INNER JOIN vbap

ON vbpa_{vbeln = vbap}vbeln

INTO TABLE lt_vbpa

WHERE parvw EQ 'RG'

AND vbpa~kunnr EQ lt_knvp-kunn2

AND abgru NE lc_abgru.

this join is giving me error message

that lt_knvp table is without headerline

i dnt want to change it header line

what can be done??

workarea???if yes then how

Re: select statement

Former Member — Fri, 25 Jan 2008 11:41:13 GMT

Hello,

Make this change


if not it_knvp[] is initial.
SELECT vbpa~vbeln
vbpa~kunnr

vbap~vbeln 
vbap~posnr
vbap~yygfkto
FROM vbpa INNER JOIN vbap
ON vbpa~vbeln = vbap~vbeln
INTO TABLE lt_vbpa
For all entries in lt_knvp " Check here
WHERE parvw EQ 'RG'
AND vbpa~kunnr EQ lt_knvp-kunn2
AND abgru NE lc_abgru.
endif.

Cheers,

Vasanth

Re: select statement

former_member156446 — Fri, 25 Jan 2008 11:42:02 GMT


if not lt_knvp [ ] is initial.
SELECT vbpa~vbeln
vbpa~kunnr
vbap~posnr
vbap~yygfkto
FROM vbpa INNER JOIN vbap
ON vbpa~vbeln = vbap~vbeln
INTO TABLE lt_vbpa
for all entries in lt_knvp
WHERE parvw EQ 'RG'
AND vbpa~kunnr EQ lt_knvp-kunn2
AND abgru NE lc_abgru.
endif.

Re: select statement

Former Member — Fri, 25 Jan 2008 12:43:18 GMT

done