Customer Exit Variable: In BI project, consultant often come across the situation when they need to use a processing type other than manual entry / default value, replacement path, SAP exit, or authorization to fulfill the requirement of the customer, then a customer exit gives the option of setting up a processing type for variables, tailor-made to our specific needs.

Customer Exit variable is used in the BEx Report and Customer Exit Abap program is given below for two different Business scenario’s

I_STEP = 1 is used for both the synario’s.

I_STEP = 1

Call is made directly before variable entry.

Business scenario:1

To fetch Previous four Quarter’s data excluding current
quarter value.

CE1A.jpg

CE1B.jpg

Customer Exit Variable Properties to be maintained:

CE1C.jpg

Business scenario:2

If we are in first quarter of current year,fetch previous
year data.All other quarters of current year fetch current year data

CE2A.jpg

Customer Exit Variable Properties to be maintained:

CE2B.jpg

selection Screen:

Selection Screen.jpg

sample outputs for the 2 variables considering different months:

Calmonth Calquarter Customer Exit Variable 1 Customer Exit Variable 2
7.2013 Q3.2013 Q3.2012 – Q2.2013 Q1.2013 – Q2.2013
8.2013 Q3.2013 Q3.2012 – Q2.2013 Q1.2013 – Q2.2013
9.2013 Q3.2013 Q3.2012 – Q2.2013 Q1.2013 – Q2.2013
10.2013 Q4.2013 Q4.2012 – Q3.2013 Q1.2013 – Q2.2013
11.2013 Q4.2013 Q4.2012 – Q3.2013 Q1.2013 – Q2.2013
12.2013 Q4.2013 Q4.2012 – Q3.2013 Q1.2013 – Q2.2013
1.2014 Q1.2014 Q1.2013 – Q4.2013 Q1.2013 – Q4.2013
2.2014 Q1.2014 Q1.2013 – Q4.2013 Q1.2013 – Q4.2013
3.2014 Q1.2014 Q1.2013 – Q4.2013 Q1.2013 – Q4.2013
4.2014 Q2.2014 Q2.2013 – Q1.2014 Q1.2014 – Q4.2014
5.2014 Q2.2014 Q2.2013 – Q1.2014 Q1.2014 – Q4.2014
6.2014 Q2.2014 Q2.2013 – Q1.2014 Q1.2014 – Q4.2014
To report this post you need to login first.

1 Comment

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

Leave a Reply