LIS (Logistic Information Systems) for Purchasing:

Information Systems are tools for analyzing and gathering specific data in different areas like purchasing, inventory etc.

Concept of Info Structure:

The info tables will start with S, followed by 3 digit integer. Example for standard info structures are S012, S013, S031, S032, S033 etc. The same can be used for ZReports also. Apart from standard info structures, user can define user defined info structures too. The user defined info structures should start with S followed by a three digit number. From S000 to S500 are reserved for standard.

In case of user defined info structures, once the info structure is created with required updating, it will be updated along with standard tables during every relevant transaction. The same info tables can be used for other reporting purposes like zReports etc.

Analysis of Standard Info Structures:

Transaction: MCDG (Path: SAP Easy Access – Information Systems – Logistics – Purchasing – Tools – Flexible analysis – Evaluations – MCDG (Execute)

             

Enter the standard evaluation structure and evaluation method.


System will propose the standard characteristics.

Execute.

Output:




Apart from standard info structure, we can define user defined info structure based on business requirement. For example, we can define an LIS table to update full purchasing cycle – from PO to Invoice.



Creation of user defined Info Structure:

Step1: Create Field Catalog – Characteristic catalog.

        A field catalog defines a group of relevant fields from the application. You can thus use a mixture of fields from any document hierarchies.

        Here, you can define the key fields required in the table.

Transaction Code: MC18

  • Enter name for field catalog.
  • Select Application from F4 List.

Application 02 for purchasing.

Press ENTER.

Click on “Characteristics”:

Now, select the required field and click on “Copy”, or double click on the field.

The selected Items will be visible with tick mark:

The fields can be selected from multiple tables.

Once all the fields required are selected, click on “Copy+Close

Now, click on “ Copy”


Save the characteristics field catalog.

Step 2: Create Key Figures.

            Key figures are values with particular relevance to business. These will be output of the report / analysis.

Eg: Invoiced amount, net order value, number of deliveries

Transaction Code: MC18

Enter the field catalog name, description and select the application.

Press ENTER.

Click on “Key Figures”

Select the required fields as explained in the previous step and click on “Copy+close”

Save the key figures.


Step 3: Create Info Structure

            The area in which data is collected in the Logistics Information System.

            An information structure defines a group of fields and is used for collecting and reducing data from an operative application such as sales or purchasing. It forms the basis for analyses and evaluation and includes:

  • A period unit, giving the structure a time reference
  • Characteristics, information with reference to which other information is cumulated (In short, it is the selection screen – Selection Parameters)
  • Key figures, information that is accumulated with reference to characteristics (This is the output fields)

Transaction Code: MC21

  • Enter info structure name – A four digit key between S501 and S999 (up to S500, is reserved for standard)
  • Info Structure description.
  • Application – Press F4 and select the Application. 02 stand for purchasing. The Applications available are listed below:


  • Select the info-structure type. The following are the examples:

          – Standard type ( ‘ ‘)

                      – Rebate Processing (B)

                      – Type ‘Transfer to SAP BW’ (T)

Please Note that the info structure type cant be changed once its created.

  • Planning Possible Indicator: Indicator that determines if an information structure is relevant in flexible planning. If an information structure is created with this indicator, it can be supplied with planning data (standard).

It is not possible to change the planning characteristic after creating the information structure.

Enter the details and press ENTER.

  • Click on characteristics. Here, you can select the fields to be displayed in the selection screen of the report.

Double click on the characteristics field catalog created in the first step.

Double click on the fields to be selected to the selection screen. The fields can be selected from any field catalog.

  You can select maximum of 9 field characteristics.



Once required fields are selected, click on “Copy + Close”

Now, click on “Copy”

Please follow the part 2 document: How to Create an LIS info structure – Purchasing – Part 2

To report this post you need to login first.

26 Comments

You must be Logged on to comment or reply to a post.

  1. shiva mc

    AKPT HNY 2014,Good Doc Bro..


    Expecting Purchasing–>Reporting—>Maintain General Analyses in that Part if u find any it will be good.

    (0) 
      1. shiva mc

        Above is for Reporting Analysis i know that part, But i have no idea regarding Maintain General Analyses that part if u through some light on it  

        (0) 
        1. PRASOON AK Post author

          Hi shiva mc

             The configuration maintained in Purchasing–>Reporting—>Maintain General Analyses are available in purchasing general analysis report ME80.


          Regards,

          AKPT

          (0) 
  2. taylor dai

    Very useful document. Thank u for kind sharing!

    I actually follow your steps and created an info structure successfully.

    However, I encounter a problem when I define the “counter of purchase orders” as the only key figure and try to generate the updating rules, an error message is popped up, says that ” purchase orders: hierarchy not maintained.”. And the updating rules can’t be generated.

    Could you please give me some idea on how to solve the problem? ? Thank you very much!!

    (0) 
      1. taylor dai

        Hi AKPT,

        The field I set as key figure is “purchase order (Field name: ABEST, table: MCEKKZ). I want to know how many purchase orders are there. The stable is generated successfully, but when i generate updating rules via MC24, I got the message as below: (mainly the one:”purchase order: hierarchy not maintained.”)

        /wp-content/uploads/2014/04/screenshot_4_438695.jpgthank you so much!

        Best regards,

        Taylor

        (0) 
        1. PRASOON AK Post author

          Hi taylor dai,

             In MC24, maintain the update rules for the field ABEST (purchase orders) as shown below: (with hierarchy A as highlighted in screenshot)

             Maintain as above and generate update rules. Revert back if you are facing any other issue.

          Regards,

          AKPT

          (0) 
  3. SAPer Yang

    Hi,AKPT:

    Great document..But how can we  get the source table&source field if we create other kind of info structure?

    Is there any difference to use standard info structure & standard info structure field in below screenshot?

    Thanks.

    QQ图片20140519171349.jpgH不,

    (0) 
    1. PRASOON AK Post author

      Hi,

         Thanks for the feedback.

         The source table and field for the key figure and characteristic catalog will be automatically picked / updated once you select the fields in MC18. If you want to see the source table and fields while selecting the fields in MC18, you may click on “switch display” button as shown below:

         System will show you the source table and field.

      Regards,

      AKPT

      (0) 

Leave a Reply