Reg. table

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

>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.

[Former Member]

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.

[Former Member]

hi,

U can assign C as a key filed.

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

thnks & rgds,

raghul

[Former Member]

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.

[Former Member]

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.

[Former Member]

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