Skip to Content
avatar image
Former Member

SAP BEX Requirement in sales

I have a client requirement in which, sales figures of all the dealers are populated for current year, previous year(Previous year is getting calculated in cmod). Now client has new addition to same report. Dealers are changed as wholesalers with a go live dates for each dealer. When a user runs the query for a particular period. The system should check the start date and compare with go live date. If the given input date is before go live date, then system should pick records from go live date, else system should populate data for given period.

Example: Dealer is "ABC" Go live date is 1st Aug 2016. User input dates: 1st Apr 2016 to 31st Mar 2017. Sales should come for the period 1st Aug 2016 to 31st Mar 2017 only. In case go live date is prior to the given date, sales should show for entire given period.

Kindly help me to achieve this requirement in SAP Bex,I was eventually trying with the customer exit variables or any other turn around work here.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers