- SAP Managed Tags:
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:
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
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
7 Comments