topic Re: ISSUE WITH ACCESSING DATA FROM TABLES in Application Development and Automation Discussions

ISSUE WITH ACCESSING DATA FROM TABLES

Former Member — Wed, 08 Nov 2006 17:03:54 GMT

Hi all,

Iam having problem accesing the fields from se11 selection screen of a ztable.

I have a field (primary key) with data type numc length 4

I have uploaded data from the text file to this ztable .

data in my text file is like this

101

1009 etc

Now data in my ztable looks like this

1009

101

99 etc...

But when i give 1 or 0001 in my selection screen of ztable it says no entries found.

when i see all the entries i can see entry 1 in the data.

Please let me know whats wrong in here

Thanks

WAITING FOR REPLIES.

kAJOL

Re: ISSUE WITH ACCESSING DATA FROM TABLES

Former Member — Wed, 08 Nov 2006 17:17:33 GMT

Hi Kajol,

This is just one possible solution, it might not be optimal.

If you are using a program to upload the data, you will be getting an internal table from the upload FM. Now before you send the data to the database table, you can convert it into the desired form.

Hope this helps.

Regs,

Sameer

Re: ISSUE WITH ACCESSING DATA FROM TABLES

Former Member — Wed, 08 Nov 2006 18:02:09 GMT

Hi Kajol,

Well thats unusual issue.

One thing if your field is NUMC4 then the entries it should display should be like:

0001

0010

0002 etc.... not 1, 10,2..

So just check again the data type assigned to the field and try to load again..

Hope this helps.

Manish

Re: ISSUE WITH ACCESSING DATA FROM TABLES

Former Member — Thu, 09 Nov 2006 13:29:53 GMT

definitely prob with data elemnt and types defined i believe

kiran

Re: ISSUE WITH ACCESSING DATA FROM TABLES

Former Member — Thu, 09 Nov 2006 13:33:05 GMT

Try selecting it with ...1

where . means space