cancel
Showing results for 
Search instead for 
Did you mean: 

Sork Key

Former Member
0 Kudos

Hi,

Where we define the sork key?

how it will help in business process?

Regards,

Pankaj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Pankaj,

Sort key is assgined in GL.

Usage:

The system uses a standard sort sequence for displaying line items.

Among other things, it sorts the items according to the content of the

Allocation field. This field can be filled either manually or

automatically (by the system) when a document line item is entered.

For this purpose, the system requires rules that determine which

information is to be taken from the document header or from the document

line item and placed in the field. The rules can be stored in the master

record of an account which enables you to determine the standard sort

sequence on an account-specific basis.

Thus the sort key in Gl determines what is to be filled in the assignment field.

IMG path for creation of sort key is:

Accounts Receivable and Accounts Payable->Vendor Accounts->Line Items->Display Line Items->Display Line Items without ALV->Determine Standard Sorting for Line Items

or tcode OB16

Regards,

Kiran

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Pankaj,

Where Sort Keys are created

Use Tcode OB16.

Why we are using sort keys.

Straight answer to this is sort key offers great help in Automatic Clearing.

First we understand how does it function. If you have created Bank GL and there you have used 001 (posting date) as sort key then whenever you make entry for that bank Gl your sort key "Posting date" is automatically updated in "Assignment" field unless you manually insert anything in assignment field.

Let's take a simple example for why sort keys are helpful.

Suppose, there is GR/IR account created with sort key 014 (Purchase Order) so at the time of

1. Goods receipt Purchase order with item no will automatically filled in assignment field.

Inventory dr. 15000

GR/IR cr 15000.

In GR/IR account item Assignment would be 150000 10.

2. Invoice through MIRO will also feed Purchase Order with item no in assignment field.

GR/IR dr . 15000

Tax dr. 5000

Vendot cr. 20000

In GR/IR account item Assignment would be 150000 10.

Now your entry is over. There are large number of such entries posted in the period for the GR/IR account.

So, manual clearing becomes very tedious for GR/IR clearing account. In order to avoid that Automatic Clearing program is configured in OB74, where you give field ZUONR i.e. assignment in first criterion. So, line items with same assignment and amount will be cleared automatically upon F.13 transaction.

might help you...........................................

Former Member
0 Kudos

Hi,

Sort key is used to poplulate the` Assigment field` automatically when you post a document.

It is basically some additional details regarding trxtion you post.

For e.g

008- Customer number and you assign to a particular GL.so when you post a transaction using that Gl the assignment field will be populated with CUSTOMER NBR automatically.

you assign the sort key in the GL account of the particular Comy code.

Use tcode FS00 or FSP0 to assign sort key in the GL, Customer and Vendor Master

To define sort key go to SPRO

Edited by: Shireesh22 on May 28, 2009 11:08 AM

former_member182098
Active Contributor
0 Kudos

Hello,

Sort key is defined in GL Account, Customer Account or Vendor Account master.

The purpose of sort key is:

1. To populate the assignment field in FBL1N, FBL3N and FBL5N with the sort key value.

2. Sort the line item report mentioned in point 1 based on sort key.

The system uses a standard sort sequence for displaying line items. Among other things, it sorts the items according to the content of the Allocation field. This field can be filled either manually or automatically (by the system) when a document line item is entered.

For this purpose, the system requires rules that determine which information is to be taken from the document header or from the document line item and placed in the field. The rules can be stored in the master record of an account which enables you to determine the standard sort sequence on an account-specific basis.

Regards,

Ravi