If statement with an AND in Transformation File

[aditya_ponnala]

What would be the right syntax for If statement with an "if" statement and "And"?

INTRN=*IF(EMPGROUP=*STR(C) and *JOB=*STR(TEMP) THEN *STR(S); *STR())

When I use above syntax, transformation file is finding error with "And".

[former_member186338]

aditya.ponnala

You have number of question where I provided the correct answer, but it was not accepted. Please review!

[former_member186338]

List:

https://answers.sap.com/questions/532435/calling-a-script-from-badi.html

https://answers.sap.com/questions/509984/current-month-and-year-in-script-logic.html

https://answers.sap.com/questions/468013/epm-giving-automation-error-after-upgrade.html

https://answers.sap.com/questions/393483/epm-function-to-derive-access-to-dap.html

...

[aditya_ponnala]

I didn't accept in those questions because those answers didn't help. In this case it did and accepted the answer.

Thanks!

[former_member186338]

OK, looks like if you receive correct, but negative answer - you don't accept it!

Then next time you will get no answer from me.

[former_member186338 · Accepted solution]

Why not to read help???

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.34/en-US/f9c4554f6faf1014878bae8cb...

There is no "and" operator supported!

"And" logic can be simulated by:

INTRN=*IF(EMPGROUP+JOB=*STR(CTEMP) THEN *STR(S); *STR())

From help:

"Condition1 and Condition 2 can contain multiple items that are added together (using the plus (+) sign)"

P.S. Even sample is provided in help:

Mapping Function 1: 
Product=*IF (product+ID+Entity=*Str(148552) then *str(MHarn); ID(1:1) = *str(C) then *str(XX); *str(YY))

[aditya_ponnala]

Hi Vadim,

I tried searching in previous comments and couldn't find the help. Hence posted in the forum.

[former_member186338]

Sorry, but EPM help is always located on help.sap.com

How it's possible to work with product without reading help?