Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

se16n is giving performance problem with key fields

former_member307398
Participant
0 Kudos

When I execute transaction se16n and enter the table name with following parameters

Settlement
period: 201510

Company
code: 9953

there are over 127000 entries..

Afterwards when I add into selection select just one of the selected entries, let’s say
(AUFNR)order 5675711, no entry is found.

I do not understand why, the field for order is a key field.

Can any one please suggest the problem?

Regards,

Santhosh G

1 ACCEPTED SOLUTION

former_member182877
Participant
0 Kudos

Hi Gampa,

Try to give as *5675711 in your aufnr field!! and check

Cheers,

Kripa Rangachari.

5 REPLIES 5

former_member182877
Participant
0 Kudos

Hi Gampa,

Try to give as *5675711 in your aufnr field!! and check

Cheers,

Kripa Rangachari.

0 Kudos

Hello Kripa,

Thanks for your reply.

Got the solution.

I gave 5 spaces before 5675711 then it is working fine.

Regards,

Santhosh G

former_member195402
Active Contributor
0 Kudos

Hi,

please check several ways to find the reason.

  • Try it without settlement period and company code. Can you find an entry for your order then?
  • Try it with parts of your order no., for example *5675711*, *0005675*, *5711*. Can you find your order no with one of them?
  • Is it SAP domain and data element AUFNR in that table or a custom one?

Regards,

Klaus

0 Kudos

Hello Klaus,

Thanks for your reply.

Got the solution.

I gave 5 spaces before 5675711 then it is working fine.

Regards,

Santhosh G

raymond_giuseppi
Active Contributor
0 Kudos

Is this a standard or customer table ?

Hint; Standard AUFNR has conversion exit ALPHA, so an external '5675711     ' is internally converted to a '000005675711' value and NEVER a '     5675711', if this table was filled with a custom program without caring of conversion-exit or internal/external format, there is a bug in the program. Later any SELECT JOIN on this AUFNR with AUFK should fail...

Regards,

Raymond