on 05-28-2009 9:59 AM
Hi,
Where we define the sork key?
how it will help in business process?
Regards,
Pankaj
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...........................................
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.