on 2023 Oct 03 4:09 PM
If you go to the sample planning area SAPIBP1, you will notice, for example in the key figure "Local Demand Plan Qty Final" (FINALLOCALDEMANDPLANQTY), the following formula:
FINALLOCALDEMANDPLANQTY@WKPRODLOCCUST = JF("ADJLOCALDEMANDPLANQTY@WKPRODLOCCUST">=0, "ADJLOCALDEMANDPLANQTY@WKPRODLOCCUST", "LOCALDEMANDPLANQTY@WKPRODLOCCUST")
Why did SAP use JF(...) here instead of a conditional IF(...)? What is the difference?
The JF statement will yield the else part in the event that the key figure used for the condition is null, whereas the IF statement will yield null when the condition key figure is null.
e.x
KF1 = null
if ( kf1>0, kf2, kf3) --> this will return null when you use if statement
jf( kf1>0, kf2, kf3) --> this will return kf3
Regards,
Manikandan Shanmugam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
6 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.