topic Re: Reg. table in Application Development and Automation Discussions

Reg. table

Former Member — Tue, 12 Aug 2008 15:57:19 GMT

Hi,

I have a custom table with keys A,B and C,D,E as other fields

Now on SE11, when I go to 'contents' and give the values of C in that field and press F8, it does not return any entries though the entires with the given value of C do exist in table.

If I give the corresponding value of A or B, it do return the entries. What am I doing wrong above?

Thanks.

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:00:45 GMT

what is the Type of Field C

May be you are not giving the exact value . Some times you have to provide the Leading zeroes(if the value is with leading zeroes). some time you have to give the spaces as it appeared in DB.

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:05:52 GMT

Thanks Vijay. It is sold-to party field (kunag). Basically I am trying to upload the data from legacy excel file to custom table. The value of sold-to is 1000003. The record exists in the custom table after the upload is complete. However when I try to do the query on SE11 contents, (i tried with leading zeroes, leading spaces, trailing spaces what so ever) but it is not giving any results there.

Does it depend on the type of table? the table is also large (about 70000 records).

Thanks.

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:11:40 GMT

>Does it depend on the type of table? the table is also large (about 70000 records).

I don't think it is causing the issue..

is your Table field C of type KUNAG.

something to do with the field definition.

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:15:05 GMT

hi,

U can assign C as a key filed.

But, I am not sure .......

thnks & rgds,

raghul

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:19:16 GMT

Vijay,

yes, it is of the data element kunag in the custom table.

In the internal table that I use in the program for uploading, I defined it as of structure ztable....

Something like this:

TYPES: BEGIN OF type_upload.

INCLUDE STRUCTURE ztable.

TYPES: END OF type_upload.

DATA: itab_upload TYPE STANDARD TABLE OF type_upload.

Thanks.

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:23:00 GMT

when one is uploading data and inserting data into database, one needs to use the FM CONVERSION_EXIT_ALPHA_INPUT and then insert into the table.

Re: Reg. table

Former Member — Tue, 12 Aug 2008 16:47:58 GMT

Ramesh..

I appreciate your reply.

But they want legacy data into custom table as it is...(with no leading zeroes or spaces etc)..

I think the FM you mentioned will add leading zeroes

Thanks.

Re: Reg. table

Former Member — Wed, 13 Aug 2008 00:10:17 GMT

It is ok with the customer to add leading zeros to the sold-to..so I used CONVERSION_EXIT_ALPHA_INPUT'

Thanks for all your answers, guys