Skip to Content
Author's profile photo Former Member

Enable Trend Reporting – by Manipulating Variable value

Enable Trend Reporting – by Manipulating Variable value Summary Scenario is pretty simple, Trend Analysis – User enters “Key Date” and is interested in analyzing Key figure values under various heads. For example user enters “Current Date” and is interested in looking at the “Sale on Entered Date”, “Sales for Current Month to Date”, “Sale for Current Year to Date” and also these values for previous year and many more. Scenario presented here takes you step by step (including ABAP Code) to enable this kind of reporting. Overview This particular assignment was meant for Senior Sales Manager, who was interested in looking at the “Tree” (almost current status) and “Jungle” (longer horizon) at the same time. Needs were to analyze the following analytics on “Key Date”. “Key Date” is decided at the runtime. Few of the analytics covered were- # Sales on Day – On the “Key Date” decided at the run time (User Entry). # Month to Date (MTD) – From the 1st of month to “Key Date” – for current year. # Average Month to Date – MTD divided by the “No of Days” in month till “Key Date” for current year. # Previous Year Month to Date – MTD for the Previous Year. # Average Previous Year Month to Date – Average MTD for the Previous Year. # Year to Date (YTD) – From the 1st to entered “Key Date” for the current year. # Average Year to Date – YTD divided by the “No of Days” in year till “Key Date” for current year. # Previous Year to Date – YTD for the Previous Year. # Average Previous Year to Date – Average YTD for the Previous Year **** READ THE APPROACH AND SOLUTION AT ***

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Hello 🙂 Agrawal Vikash,
      How r u ?

      really a good document.

      Best Regards....
      Sankar Kumar
      +91 98403 47141

      Author's profile photo Former Member
      Former Member
      Hi Sankar,

      Thanks a lot.

      Regards

      Vikash

      Author's profile photo Former Member
      Former Member
      What would be really cool is to extend this solution to calculate business days in the 'month, period, quarter, year' by interpretting the factory calendar. As an example, the 3rd of the month could be the 1st or 2nd business day depend on where the weekend falls.
      Author's profile photo Former Member
      Former Member
      Hi John,

      You are right...May be we could work on it some time in future 🙂

      thanks

      Regards
      Vikash

      Author's profile photo Former Member
      Former Member
      If you want to email john.kurgan@inforte.com, I can give you some FMs that read the factory calendar. I'm not an expert ABAP developer, but have some design thoughts.
      Author's profile photo Former Member
      Former Member
      Hi

      It's a good document.

      How can we calcualte YTD with posting period selection.

      Regards,

      Nagesh