Skip to Content
0

Debit or credit mapping issue in bi

Aug 24, 2017 at 05:18 AM

45

avatar image
Former Member

The invoice value (aggregation of amount values in the source) in a report does not match the source sbystem. It is pulling data directly from the RSEG table in the source system. In the RSEG table the amount is always positive along with a debit or credit field with an indicator of where it is a debit or a credit transaction ( S OR H) which also indicates whether the amount is positive or negative The value amount is directly mapped into our system to the dso without a check on the credit or debit indicator due to which all the values are coming in as positive and the aggregated invoice value does not match the source as negative values are coming in as positive too. According to our analysis the solution for this is to map the debit or credit field to the invoice value in dso and add a routine in the transformation from amount to invoice where it checks the credit or debit indicator. Could this cause any defects or could there be a better approach to it? Also it would be helpful to get an example of the routine to be added to the transformation from amount to invoice ( from source to dso)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ashu Yadav Aug 27, 2017 at 03:15 PM
0

Hi,

Can you please have a look on datasource 2lis_06_inv meant for RSEG table inspite of creating a custome one :)

if you don't want to go with it then definately you can go with your

and add field level routines or Formula in DSO after mapping

IF

SOURCE FIELD-SHKZG = 'S'

AMOUNT = '-1'* SOURCE FIELD-WRBTR

ELSE

AMOUNT = SOURCE FIELD-WRBTR

ENDIF.

Share
10 |10000 characters needed characters left characters exceeded