Skip to Content

Transformation File : MVAL with IF Statement

Hi Team,

I have a requirement where we need to load data from BW Cube to BPC. There are multiple key Figures which are mapped to account ID in BPC through MVAL statement.

Now the user wants to filter one of the key figures based on another column say Y in BW to seperate account ID in BPC.

Tried using MVAL with IF Statement the Error states Validation with Data File failed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 01, 2018 at 08:17 AM

    Hi Vadim this link is for the question raised by some other person

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2018 at 09:38 AM

    Please first finish with your first question (https://answers.sap.com/questions/675094/how-to-invoke-nested-logic-script-in-package.html), then I will answer this one!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2018 at 10:45 AM

    Hi Vadim,

    I have attached the sample for the TF

    My original TF File with the following Mapping is working

    ACCOUNT= *MVAL(ZVV110|*NEWCOL(S0200)||ZVV102|*NEWCOL(S0148)||ZVV103|*NEWCOL(S0207)||ZVV139|*NEWCOL(S0093)||ZVV113|*NEWCOL(S0159))

    However I want to use IF Statement here with MVAL refer below the sample mapping. This is not getting validated . The probable reason can be it is unable to understand MVAL and IF Statement Respectively

    ACCOUNT=*IF(0DISTR_CHAN = *str(30) then *MVAL(ZVV110|*NEWCOL(S0200)||ZVV102|*NEWCOL(S0148)||ZVV103|*NEWCOL(S0207)||ZVV139|*NEWCOL(S0093)||ZVV113|*NEWCOL(S0159)); *MVAL(ZVV110|*NEWCOL(S0006)||ZVV102|*NEWCOL(S0148)||ZVV103|*NEWCOL(S0207)||ZVV139|*NEWCOL(S0093)||ZVV113|*NEWCOL(S0159)))


    tf-sample.txt

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2018 at 10:56 AM

    It's not possible to use IF and MVAL in the same line - no way!

    But you can always create a routine badi to do what you want.

    Add comment
    10|10000 characters needed characters exceeded