topic Re: select in Application Development and Automation Discussions

select

Former Member — Fri, 25 Apr 2008 09:22:42 GMT

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

Re: select

Former Member — Fri, 25 Apr 2008 09:26:39 GMT

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

Re: select

Former Member — Fri, 25 Apr 2008 09:29:45 GMT

hi jumnum,

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

regards

neelesh

Re: select

Former Member — Fri, 25 Apr 2008 09:29:58 GMT

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

Re: select

Former Member — Fri, 25 Apr 2008 09:34:40 GMT

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.

Re: select

Former Member — Fri, 25 Apr 2008 09:34:46 GMT

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,