Skip to Content
0
Former Member
Aug 08, 2016 at 12:51 PM

how to use case when in routine

118 Views

hi every one,

i am creating transformation between DS: ZVBSEGK and ODS: Z_FIAP.

in the datasource ZVBSEGK there are 2 fields: Debit / Credit indicator and Ammount

in the ODS there is a field: ammount in local currency:

Now want to join 2 fields Debit / Credit indicator and Ammount of Datasource with ammount in local currency of ODS and write the Routine to the transformation with logic:

  • If the value in Debit / Credit indicator is 'H' then ammount in local currency = - Ammount
  • If the value in Debit / Credit indicator is 'S' then ammount in local currency = + Ammount

Can you please help me how to do that?

Thanks