Skip to Content
avatar image
Former Member

Debit or credit mapping issue in bi

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 27, 2017 at 03:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded