select querry

[Former Member]

Hi friends

Can any one tell me what is wrong in the select querry, its not picking the data.

SELECT vbelv

posnv

vbeln

posnn

FROM vbfa INTO TABLE lt_vbfa

FOR ALL ENTRIES IN lt_lips

WHERE vbelv = lt_lips-vbeln

AND posnv = lt_lips-posnr

AND vbtyp_v = 'J'

AND vbtyp_n = 'M'.

Regards,

Venu

[Former Member]

Hello Venu,

Check the table VBFA is having data for these where conditions.

If useful reward.

Vasanth

[Former Member]

check the vbtyp_v = 'J'

AND vbtyp_n = 'M' values.There may not be any data for this

[Former Member]

Nothing wrong in the select query.

Before writing the select query with for all entries

Check, if not lt_lips[] is initial.

Check the internal table lt_lips contains data also check the database for the condtion you have given in the select query.

Regards,

Prakash.

[Former Member]

check in Debug, wheather PosNR having leading ZERO...

[Former Member]

First check whether data is present in VBFA.

One more thing that you need to keep in mind that before using the table in select query with FOR ALL ENTRIES chcek whether that table is initial or not. If its initial whole data from database table will be selected.

But in your case no data is selectd. So the reason might be data is not present in VBFA.

Best Regards,

Vibha

*Please mark all the helpful answers

[Former Member]

check this also,

SELECT vbelv

posnv

vbeln

posnn

FROM vbfa INTO TABLE lt_vbfa

FOR ALL ENTRIES IN lt_lips

WHERE vbelv = lt_lips-vbeln

AND posnv = lt_lips-posnr

AND ( vbtyp_v = 'J'

OR vbtyp_n = 'M' ). (use of AND is correct..?)

[Former Member]

hi Venu,

there is nothing wrong with your select statement .. in debug mode check whether data is getting populated in to it_lips for that data check whether the data is available in vbfa ... i feel that your select statement is failing as it is not satisfying all the criteria that you have in where statement ... so it is data in sufficiency problem.

Regards,

Santosh