Select statement.

Hello friends,

I need to extract data from VBFA table in to an Internal Table

based on where condition from IT_VBRK internal table comparing

VBFA-vbeln = it_vbrk-vbeln.

But when doing so i also have a check where i have to check

for it_vbrk-aubel.

However If it_aubel is blank i want to skip that record completely.

I am trying to do without looping it_vbrk.

I dont want to delete the records in it_vbrk where AUBEL is blank.

below is the code that i tried but dosent work,

SELECT vbelv

vbeln

INTO TABLE it_vbfa

FROM vbfa

FOR ALL ENTRIES IN it_vbrk

WHERE vbeln EQ it_vbrk-vbeln

AND vbtyp_v EQ 'C'

and it_vbrk-aubel NE ' '.

Any advice,

Shejal Shetty.