Custom Formulas in SAP BW Transformations
Advantages of Custom Formula used in SAP BW Transformations
1. Will be available in formulas list.
2. No need to write same logic again and again.
3. Faster developments.
4. No ABAP expertise required to use.
5. Can be enhanced centrally.
6. Risk of error will be minimized.
How to Build
Create an implementation using classic BADI with BADI name RSAR_CONNECTOR (SE19 T CODE)
Give your implementation name
An implementation class as ZCL_IN_<Implementaion_name> will be assigned by default. You check in Interface Tab.
Save it and edit the class in SE24 T Code and add your desired custom methods in Methods Tab. Method should be static and public
Select your method and click on Parameters button to define parameters of your method.(Methods can only have exporting, importing and returning parameters)
Changing parameters are not allowed. Only one exporting or returning parameter is allowed
Double click on the method name to write the logic
Use Parameter name exactly same as they are defined
Check your methods once defined
Go to T code SE19 and open your implementation in change mode, make it inactive to edit it
Open Get method in Interface Tab, this is the place where you can incorporate your custom methods as formula
Double click on the method name to write the code inside it
it has two parameters i_key and c_operands
Code section comprise of two parts
a)Create new category for custom formula
b) Assign custom formula’s to new categories
Activate your GET method
Now you can see new category of formula’s inside your transformation formula list and can use them during developments
in formula’s list