database table issue - very urgent pls help

[Former Member]

Hi experts

I have created Ztable. Zprogram uploading data to Ztable.

Records are successfully uploaded. I am triying to select one record in Ztable record is not there.

Example

vbeln bukrs etc..........

123 012 .........

124 012 ........

i am trying to select vbeln = 123. do data found.

Pls help me out

[Former Member]

Hi experts

I have created Ztable. Zprogram uploading data to Ztable.

Records are successfully uploaded. I am triying to select one record in Ztable record is not there.

Example

vbeln bukrs etc..........

123 012 .........

124 012 ........

i am trying to select vbeln = 123. do data found.

Pls help me out

[Former Member]

hi use the proper value ...use this..

vbeln----0000000123

regards,

venkat

[Former Member]

Hi

Table have vbeln = 600000067 data.

I tried 0600000067 and 600000067. no data found

[Former Member]

Hi,

check the value of vbeln because I think you must pad a 0 in vbeln.

your vbeln must have a value like this '00000123'. the length of vbeln must be occupy.

thanks..

james

[Former Member]

Hi,

Make sure that you have used data elements VBELN and BUKRS for the fields in the Z table.

regards,

Advait

[Former Member]

Advait

I used the same data element

[vinod_vemuru2]

Hi Kumar,

First did u tried checking data in table with out without leading zeros? If yes then with what value of input u r getting data. Pass the same value in ur select also. Also what are all other conditions u are giving in select? Probably one of the conditions is failing!. Can u post ur select statement.

Mean while u can try with select single.

Select Single vbeln from ztab InTO w_vbeln where vbeln = 'ur vbeln'.

Also let me know from where ur passing data in where clause. Is it select options/Parameters. If yes then declare those with same type as ur ztable eg: so_vbeln FOR ztab-vbeln.

Thanks,

Vinod.

[Former Member]

Hi Vinod

I just select data in SE16 only. Not select query

[Former Member]

Hi,

It seems the way the data is uploaded is the problem. Instead of prefixing 0's prefix that many number of blank spaces. That should solve the problem.

Regards,

Aravinda Sarma M.

[Former Member]

Hi Aravind

Thanks a lot. Issue solved