select

[Former Member]

wat is wrong with this code

no rows are getting selected

SELECT vbeln matnr vrkme FROM lips INTO TABLE gt_lips FOR ALL ENTRIES IN

gt_trans WHERE vbeln = gt_trans-vbeln

and matnr = gt_trans-matnr.

even when there are records matching in gt_trans

[Former Member]

hi,

make use of CONVERSION_EXIT_MATN1_INPUT for matnr and CONVERSION_EXIT_ALPHA_INPUT for vbeln before using the select statement in order to convert the data in to database format i.e, for appending the leading zeros...

Regards,

santosh

[Former Member]

hi jumnum,

First check if data is coming in internal table gt_trans in debugging mode.

regards

neelesh

[Former Member]

Hi jamnun,

There is no problem with SELECT query.

try to Debug the code and see,

maybe the problem will be like foll:

vbeln = 5084.

while it maybe comparing the record with vbeln = 0000005084

Regards,

Sunil

[Former Member]

Hi ,

Pass gt_trans-matnr to above FM and based on that fetch the data from data base table. Now u will get it.

Regards,

Kumar.

[Former Member]

Hi,

Pls try the following code....

SELECT vbeln matnr vrkme FROM lips INTO CORRESPONDING FILEDS OF TABLE gt_lips FOR ALL ENTRIES IN

gt_trans WHERE vbeln = gt_trans-vbeln

and matnr = gt_trans-matnr.

hope this helps.

Pls reward if useful..

Thanks,

Sirisha,