Skip to Content
0
Former Member
May 22, 2007 at 08:27 PM

AFS Sort - Sequence (table J_3ASORT)

138 Views

We are in the process of upgrading from SAP 4.5B (AFS 2.5B) to ECC 5 (AFS 5). Table J_3ASORT has been marked as 'obsolete' by SAP and no new/substitute table is mentioned (in the SAP documentation nor notes - that I could find) that will contain data that I can use in its place.

J_3ASORT is used in many of our customer applications to control the sequence of our sizes / dimensions as they are presented on the screen or report.

If I let the screen display in the sequence based on the dimension then we will get (for example):

Dimension value Sort sequence
1X              00001350     
28              00000100     
2X              00001400     
30              00000200     
32              00000300     
34              00000400     
36              00000500     
38              00000600     
3X              00001500     
40              00000700     
42              00000800     
44              00000900     
46              00001000     
48              00001100     
4X              00001600     
50              00001200     
52              00001300    

The dimensions are not in the correct 'size' sequence, but rather they are in the ASCII sort sequence.

When I use the sort sequence, I get the better readable version of:

Dimension value Sort sequence
28              00000100     
30              00000200     
32              00000300     
34              00000400     
36              00000500     
38              00000600     
40              00000700     
42              00000800     
44              00000900     
46              00001000     
48              00001100     
50              00001200     
52              00001300     
1X              00001350     
2X              00001400     
3X              00001500     
4X              00001600    

Short of creating a new Z table does somebody know of a table that can be used to the same effect of being able to assign a sort sequence to the various dimensions?

I very much appreciate your time and effort.

Henry