topic Re: Data not selected from ztable in Application Development and Automation Discussions

Data not selected from ztable

Former Member — Wed, 22 Sep 2010 05:01:19 GMT

Dear all

I have ztable as below :

FieldName DataElement Type Length

coilno coilno char 10

ordno vbeln char 10

when i am searching data from this table based on coilno, then data can be retreived from table but when i search same data based on ordno only then no data shows. but its sure data exists there, i have checked. domain of vbeln is same in my ztable and vbap table. kindly provide solution. thanks in advance.

Re: Data not selected from ztable

alex_cook — Wed, 22 Sep 2010 05:05:14 GMT

Howdy,

Make sure you are searching with leading zeros, eg instead of VBELN = 12345678, use VBELN = 0012345678.

Try using function module CONVERSION_EXIT_ALPHA_INPUT to insert the leading zeros.

Cheers

Alex

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 06:07:29 GMT

i have already try this. but in case of data searching in vbap table we need not to add zeros in vbeln field. even if we add zeros , zeros eliminates. i need to develop important report based on this search criteria. kindly provide solution.

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 06:16:50 GMT

You can use it in REport by using this Function module for remove leading zero

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

Try this on Goto Se11-->table name ~~>display~~->table content(Ctrlshiftf10)~~>In menu settings~~>user parameter~~>Data browser tab~~>Check conversion Exist enable and try

Thanks

Re: Data not selected from ztable

matt — Wed, 22 Sep 2010 07:59:38 GMT


> i have already try this. but in case of data searching in vbap table we need not to add zeros in vbeln field. even if we add zeros , zeros eliminates. i need to develop important report based on this search criteria. kindly provide solution.

That's probably because you are seeing the conversion exit converting your zeros. If you are unable to SELECT data from the database, and you know the data is there, it is almost certainly because you need to use a conversion exit in your program.

Have you tried it?

matt

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 08:45:20 GMT

Could you post the Select query you have coded.

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 09:39:37 GMT

My Dear

problem is not of leading or trailing zeros. in se11 when i am tring to select record based of ordno field it does not shwo data and based on coilno is shows .in database data is not stored with leading zeros.

in program i am using following very simple query. i have tried with parameter and also with range option. but no result.

DATA : BEGIN OF itab occurs 0.

include structure zhrordlink.

DATA : END OF itab.

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS : mordno FOR zhrordlink-ordno.

*parameters : mord like zhrordlink-ordno.

SELECTION-SCREEN END OF BLOCK b1.

select * from zhrordlink into corresponding fields of itab

where ordno in mordno.

endselect.

loop at itab.

write:/1 itab-ordno.

endloop.

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 09:53:23 GMT

Weird...I tried creating a custom table using Domian used for VBELN and other fields.It shows data if it exists in table.

Well if you are using the domain used for VBELN ,then the conversion will work and in the DATABASE table the data will contain the leading zeroes.

Give us the table look out and the table output which you are trying to get using ORDNO.

Re: Data not selected from ztable

matt — Wed, 22 Sep 2010 09:54:43 GMT


> My Dear
> problem is not of leading or trailing zeros. in se11 when i am tring to select record based of ordno field it does not shwo data and based on coilno is shows .in database data is not stored with leading zeros.
> in program i am using following very simple query. i have tried with parameter and also with range option. but no result.
> 
> DATA : BEGIN OF itab occurs 0.
>       include structure zhrordlink.
> DATA : END OF itab.
> 
> SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.
> SELECT-OPTIONS : mordno FOR zhrordlink-ordno.
> *parameters : mord like zhrordlink-ordno.
> SELECTION-SCREEN END OF BLOCK b1.
> 
> select * from zhrordlink into corresponding fields of  itab
> where ordno in mordno.
> endselect.
> 
> loop at itab.
> write:/1 itab-ordno.
> endloop.

Your code is wrong. You are selecting into the work area of the internal table. NOT the internal table itself.

DATA : itab TYPE STANDARD TABLE OF zhrordlink,
      wa TYPE zhrordlink.

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.
SELECT-OPTIONS : mordno FOR zhrordlink-ordno.
*parameters : mord like zhrordlink-ordno.
SELECTION-SCREEN END OF BLOCK b1.

select * from zhrordlink into corresponding fields of TABLE itab
where ordno in mordno.

loop at itab INTO wa.
write:/1 wa-ordno.
endloop.

Don't use tables with header-lines. It is old and bad practice.

Edited by: Matt on Sep 22, 2010 11:55 AM

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 10:03:42 GMT

dear matt

by using your code, still no result found. confused!!!! why so ?

Re: Data not selected from ztable

matt — Wed, 22 Sep 2010 10:12:20 GMT

Run it with the select-option blank.

matt

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 10:18:09 GMT

with select option blank, it works fine. but i need selective orders data. how it ca be possible? regards

Re: Data not selected from ztable

matt — Wed, 22 Sep 2010 10:21:00 GMT

Put a breakpoint at the SELECT, run the program and see what is in the table MORDNO. Hint - in the debugger use mordno[] to examine the table contents.

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 10:28:29 GMT

In SE11 you check with/without zero based on oreder no or check your data element of orderno having any conversion routine or not?

For conversion routin please enable the tick button as previous post i have mentioned.

if it is not debug the coding and check the select option ranges

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 10:47:47 GMT

i put two values 15756 and 4500012345. it shows 0000015756 and 4500012345.

Re: Data not selected from ztable

matt — Wed, 22 Sep 2010 10:49:31 GMT

How are you getting data into the table?

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 11:00:38 GMT

option mentioned by you already CHECKED. also order number which i am puting in selection range exist in table . ???

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 11:01:58 GMT

data is enterd into table thru screen used by end users.

Re: Data not selected from ztable

Former Member — Wed, 22 Sep 2010 11:02:54 GMT

can we come on chat to understand the query ?

Re: Data not selected from ztable

matt — Wed, 22 Sep 2010 11:07:42 GMT

No. All discussions are to be carried out on line in accordance with the rules of engagement. The problem you are facing is that you have conversion exits on your table. The program you have written is using those conversion exits. When you enter 15756 into the select option, this is correctly converted to 0000015756. The select fails to find 0000015756, which shows that that number does not exist in your table. The problem must therefore lie in the data entry program. It seems when the users enter 15756, that that is what is stored in your table - instead of 0000015756.

You must make sure that all your interactions with the table refer to the correct type.