Formula (It is a one of Rule type in Transformation)
Transformation is basically used to mapping the fields from source system to Destination Data Base. Transformation rules are basically used when some infoObjects not be their in destination, We have to create some Rule type to get required out put .
They are 6 types of Transformation Rule types
- Direct Assignment.
- Constants
- Reading Master Data
- Routines
- Formula
- Initial
Now we have to see FORMULA rule type with an Example :
Take on Sap Delivered Data Source : 0FI_AP_4
Supported DSO : ZFAP_O03
Supported Info Cube : ZFAP_C03
Go to sap BI/BW system
TCODE : RSA1
Select Data Source ----> go to Info Package .
Enter the following values in the Data Selection tab ---> in From value and to value
Check for The Debit amt in LC
Check for the Credit amt in LC
Check for the Bellow fields.
(DMSOL and DMHAB are the Fields)
After this Click on DSO : ZFAP_O03 ,
Double Click on the Transformation
Check this Fields (DMSOL) (DMHAB) (SKNTO) are mapped to their infoobjects ,
But one SKNTO is not mapped .
so you have to Find InfoObject , for this Go to RSOSFIELDMAP table , in fields enter your field name , it can display your infoobject . Map the required Infoobject with SKNTO field .
After Activating Transformation ----> Select the Target Field (0DSC_AMT_LC) ---->
Right Click and Click on Rule Details
Select Rule Type as Formula
You will get the below Screen Shot
Enter the following ----> Click on Check and Check the Status
Now Activate Transformation.
New Data Table - Output
You can see the DSC_AMT_LC (It is the CREDIT_LC - DEBIT_LC)