Skip to Content

Hi Readers,

I am a Techno-Functional consultant working for SAP Global Trade Management (GTM) product. We thought of introducing analytics in our product and, this blog is about the first development that we have done in the analytics area.

So, lets start with the introduction to GTM, followed by existing report and then the problem statement and the solution provided.

Global Trade Management (GTM) is a product used by trading companies to manage their trades. Trading companies live on low profit margin and deal in large volumes. Traders have a profit margin of around 2-3% and more than 1000’s of trading contracts are created daily to cater their trading business.

To optimize this low margin, traders need to analyze their past data, and understand their business trend. Currently, GTM provides an ALV based Long short report, which is used by traders daily. Long Short report shows all the documents along with their Document No., Quantity, Price etc. which are grouped on yearly or monthly basis. Also, report can be viewed for Purchase Side, Sales side or Both side documents.

Basically, Long Short Report shows open material quantities on both the purchasing and the sales side. The open quantities on both sides are calculated and compared with one another. The difference that results from both open quantities is the long quantity or the short quantity for the material:

  • Long quantity: Purchasing-side open quantity is greater than the sales-side open quantity.
  • Short quantity: Purchasing-side open quantity is less than the sales-side open quantity.

Existing Report

Long short report can be viewed in transaction WB2L. In WB2L transaction (refer the below screenshot), traders need to enter the selections side and other fields as per their requirement.

 

 

After the required fields are entered and executed, long short report (refer the below screenshot) is generated.

 

 

Problem Statement:

In the current scenario, an ALV report is generated on executing the Long Short Report transaction. Traders generally use it for viewing the open quantities.

For analyzing open quantities plotting graphs seem to be a better option as they make it easier to understand and interpret the data. Graphs can further help traders in analyzing the trends or relationships in data.

Solution Provided:

We came up with the following three scenarios where:

I.    A bar graph and a pie chart is plotted for Material Group wise Open Quantity.

II.   A bar graph and a pie chart is plotted for Material wise Open Quantity.

III.  Combination of above two.

We have included a Graphical Representation section (highlighted in yellow in below screenshot) in WB2L transaction, where traders can check the checkbox Material Group wise Open Quantity and/or Material wise Open Quantity.

 

 

For Material Group wise Open Quantity and Material wise Open Quantity, traders need to enter Unit of Measure in which they want open quantities to be displayed in graph. The entered Unit of Measure must be maintained in the material master.

Note: Other fields in the transaction can be filled as they were filled earlier. Only difference is that if any checkbox in Graphical Representation is ticked then in place of a report, graph will be displayed.

Now let’s have a look at the result of the three scenarios discussed above.

 

Scenario I:  A bar graph and a pie chart is plotted for Material Group wise Open Quantity.

Traders check the Material wise Open Quantity checkbox, enter the Unit of Measure and, execute the report. A bar graph and a pie chart is displayed.

 

 

In the above screenshot, bar graph shows Material Group wise Open Quantity, with Material Group on x-axis and, Open Quantity (in unit of measure entered before, KG in this case) on y-axis. Blue color bar represents the open quantity for a material group. Exact value of open quantity can be viewed by clicking on the graph and then hovering mouse on the bar of a material group.

Pie chart shows Material Group wise Open Quantity percentage. Percentage figure can be viewed by hovering the mouse on the material group color.

Graphs are plotted for at most 30 material groups (Top 30 material groups) with open quantity. If number of material groups are more than 30 then top 30 material groups with open quantity are plotted.

 

Scenario II:  A bar graph and a pie chart is plotted for Material wise Open Quantity.

Traders check the Material wise Open Quantity checkbox, enter the Unit of Measure and, execute the report. A bar graph and a pie chart is displayed.

 

 

In the above screenshot, bar graph shows Material wise Open Quantity, with Material Number on x-axis and, Open Quantity (in unit of measure entered before, KG in this case) on y-axis. Blue color bar represents the open quantity for a material. Exact value of open quantity can be viewed by clicking on the graph and then hovering mouse on the bar of a material.

Pie chart shows Material wise Open Quantity percentage. Percentage figure can be viewed by hovering the mouse on the material color.

Graphs are plotted for at most 30 materials (Top 30 materials) with open quantity. If number of materials are more than 30 then top 30 materials with open quantity are plotted.

 

From Scenario I example, we can see that Material group ‘01’ has the maximum open quantities. Now, if traders want to see the Materials with open quantity in Material group ‘01’ he needs to enter Material Group as ‘01’ in the WB2L transaction and check the Material wise Open Quantity checkbox.

 

Now, after executing a bar graph and a pie chart are plotted with Materials (from Material Group ‘01’) having open quantity.

 

 

Scenario III:  Combination of Scenario I and Scenario II.

In this scenario, traders can view both Material Group wise Open Quantity and, Material wise Open Quantity graphs in a single view. Traders need to check both the check boxes i.e. Material Group wise Open Quantity and, Material wise Open Quantity.

 

 

This scenario can also be used if traders are checking for a Materials with Open Quantity for a particular Material group. Suppose traders need to check for Material group ‘01’, then they need to enter Material group as ‘01’ and check both the check boxes i.e. Material Group wise Open Quantity and Material wise Open Quantity. In this case graph of Material wise Open Quantity will only contain Material Group ‘01’.

 

 

Similarly, graphs can be plotted for other scenarios as well using long short report which can be helpful for the traders.

To sum up, in this blog we saw how analytics can be used to enhance the GTM-Long Short report with the help of three different scenarios.

Please provide feedback on the solution provided by us and, also let us know any scenarios which you might be aware of and, which are used by traders in the analysis of long short report.

You can expect future blogs about new developments in GTM Analytics, so stay tuned……

 

Update: We have created a pilot note 2581304 for the above scenarios. So, let us know by dropping a comment below if you are interested in this.

Next Blog –Analytics in GTM using SAP Analytics Cloud

To report this post you need to login first.

7 Comments

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

  1. Peter Langner

    Thank you Chitrarth for sharing this. I think the extension you did are very useful. When and how will this version of the report be available?

    I also want to suggest, that you replace the shown hierarchical ALV by an ordinary flat one, so that the users are more flexible to design the result according to their needs by e.g. filtering, grouping or summing.

    Other helpful information would be:

    • Name of vendor and customer
    • Side of contract (WBGT-SIDE)

    Also, I want to suggest, that the quantity of sold material is displayed as a negative value indicating the direction of the flow of materials. If we do so, we can calculate

    Purchased material A 10000 KG

    Sold material A           – 5000 KG

    Sum:                             5000 KG.

    Which means I am long 5000 KG in that material.

    What do you think?

    Regards,

    Peter

    (2) 
    1. Chitrarth Singh Post author

      Hi Peter,

      Thanks for the positive feedback!

      Currently this version of the report is in pilot phase and we may release it as standard in next year, depending upon the customer feedback.

      May be you can help us with the details of the customers who are interested in this version, and we can release a pilot note for those customers, specific to the release the customers are in.

      Thanks for the suggestions of flat ALV reports and also the negative value indicating the direction of the flow of materials. I shall discuss this internally with my colleagues and let you know our plan on this.

       

      Regards,

      Chitrarth

      (1) 
      1. Chitrarth Singh Post author

        Hi Peter,

        We have released a pilot note 2581304 – Graphical representation in Long Short Report. Kindly, implement it and let us know your feedback.

        Thanks and Regards,

        Chitrarth

        (0) 
  2. Former Member

    Hi Chitrarth,

    I am a from Product Managment for Wholesale Distribution and had a lot of activities in the area of GTM last year (especially customer demos + creating GTM documentation).

    I also consider your doings for WB2L as very useful since I had to demo the Long/Short list each time – and each time it was appreciated. In additon it´s good to see that we can come up with s.th. new in 2018. My question: is there any internal system I can look up & test your doings? I looked up QEX (OP; S/4HANA 1709 Main Test System) – but failed …

    May I also suggest to also work a bit on the “standard” ALV? Like Peter said customers really miss descriptions for certain parameters (at least for field supplier and customer). Just naming the technical ID is too less and supports confusion at end-users side a bit. Is this possible?

    Regards,

    Frank

    Frank

     

    (1) 
  3. Salvator Nduwayezu

     

    Hi Chitrarth

     

    Very good

     

    I have a client who is asking me to integrate pledging, factoring, collateral and reporting to the bank who has financing the stock purchase. when the bank finances the stock, like 90% and the company 10%

    Do you have any standard solution with this?

    BR

    Salvator

    (0) 
    1. Chitrarth Singh Post author

      Hi Salvator,

       

      Apologies for the late reply as I was out of office.

      I am not aware of standard solution which can cater your needs, may be I am not the correct point of contact.

      May be you can get in touch with a SAP banking consultant.

       

      Best Regards,

      Chitrarth

       

      (0) 

Leave a Reply