4 Replies Latest reply: May 28, 2009 1:03 PM by Chintan Joshi RSS

Sork Key

Pankaj Thakker
Currently Being Moderated

Hi,

 

Where we define the sork key?

how it will help in business process?

 

Regards,

Pankaj

  • Re: Sork Key
    Ravi Sankar Venna
    Currently Being Moderated

    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

  • Re: Sork Key
    Shireesh Vaishnaw
    Currently Being Moderated

    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

  • Re: Sork Key
    Kiran Varma
    Currently Being Moderated

    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

  • Re: Sork Key
    Chintan Joshi
    Currently Being Moderated

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

Actions