select statement

[Former Member]

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

[Former Member]

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

[former_member156446]

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.

[Former Member]

done