In this example we will create model has a debit posting amount and the credit posting amount, the target DSO has only one key figure to hold the amount, so in this case, one single record will need to split into two records and also need to provide an indicator for debit or credit to identify the records.

You can create a separate rule group in the transformation to solve this problem by executing transaction RSA1 in the SAP Netweaver BW.

1.Create transformation between source and target by default rule group is the STANDARD GROUP, click on RULE GROUP STANDARD GROUP.

2.Map your AMOUNT field to DEBIT key figure and give a constant value for DEBIT/CREDIT indicator ( here DEBIT has S constant value ) to differentiate between the debit amount and credit amount. Map 0DEBIT to amount key figure ZIOPSAAMT.

debit-posting-in-sap-bw-1

3.Create new rule group by clicking RULE GROUP dropdown and then create NEW RULE GROUP. and provide description for it is new rule group.

4.Map your AMOUNT field to CREDIT key figure and give a constant value for DEBIT/CREDIT indicator ( here CREDIT has H constant value ) to differentiate between the debit amount and credit amount. Map 0CREDIT to amount key figure ZIOPSAAMT. When data is loaded we will see one key figure that holds both credit and debit amount.

debit-posting-in-sap-bw-2

Leave a Reply

Your email address will not be published. Required fields are marked *