{"id":402,"date":"2023-01-23T14:25:33","date_gmt":"2023-01-23T13:25:33","guid":{"rendered":"http:\/\/www.pierre-vincent.com\/memosap\/?p=402"},"modified":"2023-01-23T14:25:50","modified_gmt":"2023-01-23T13:25:50","slug":"ibp-formulas-in-kf","status":"publish","type":"post","link":"http:\/\/www.pierre-vincent.com\/memosap\/2023\/01\/23\/ibp-formulas-in-kf\/","title":{"rendered":"IBP Formulas in KF"},"content":{"rendered":"\n

https:\/\/help.sap.com\/docs\/SAP_INTEGRATED_BUSINESS_PLANNING\/bf99e931b8d44aafb4e306ec3602cbdd\/b8582c558934753ce10000000a174cb4.html?version=2105&locale=en-US<\/a><\/p>\n\n\n\n

Standard Functions<\/h2>\n\n\n\n
Syntax<\/th>Details<\/th>Example<\/th><\/tr><\/thead>
IF(intarg , arg2, arg3)<\/samp><\/td>Return arg2<\/samp> if intarg<\/samp> is considered true (not equal to zero), else return arg3<\/samp>.<\/td>CAPACITYOVERLOADS@PERLOCRES = IF(\u201cCAPADEMANDUTILPCT@PERLOCRES\u201d> 1,1,0)<\/samp><\/td><\/tr>
ISNULL(arg1)<\/samp><\/td>Return 1 (= true), if arg1<\/samp> is set to null.<\/td>MARKETINGFORECASTQTY@PERPRODCUST = IF(ISNULL(MARKETINGFORECASTQTY@PERPRODCUST), SALESFORECASTQTY@PERPRODCUST, MARKETINGFORECASTQTY@PERPRODCUST)<\/samp><\/td><\/tr>
CASE(arg1, default)<\/samp>CASE(arg1, cmp1, value1, cmp2, value2, …, default)<\/samp><\/td>Return value1<\/samp> if arg1 == cmp1<\/samp>, value2<\/samp> if arg1 == cmp2<\/samp>, and so on, default if there is no match.<\/td>CASE(SELECTEDOPTION@PERPROD, 1, KF1@PERPROD, 2, KF2@PERRPROD,KF@PERPROD)<\/samp><\/td><\/tr>
ABS(arg)<\/samp><\/td>Returns arg<\/samp>, if arg<\/samp> is positive or zero, else \u2013arg<\/samp>.<\/td>IF(ABS(SUPPLYREV@PERPRODFML – CONSENSUSDEMANDREV@PERPRODFML)\/CONSENSUSDEMANDREV@PERPRODFML > 0.2,1,0<\/samp>)<\/td><\/tr>
ROUND(double, int)<\/samp><\/td>ROUND(123.456, 0) = 123<\/samp>ROUND(123.456, 1) = 123.5<\/samp>ROUND(-123.456, 1) = -123.5<\/samp>ROUND(123.456, -1) = 120<\/samp><\/td>KF1@PERPRODLOCSRC = ROUND(KF@ PERPRODLOCSRC, 0)<\/samp><\/td><\/tr>
ROUNDDOWN(double, int)<\/samp><\/td>ROUNDDOWN(123.456, -1) = 120<\/samp>ROUNDDOWN(-123.456, -1) = -130<\/samp><\/td>KF1@PERPRODLOCSRC = ROUNDDOWN(KF@ PERPRODLOCSRC, 0)<\/samp><\/td><\/tr>
FLOOR(double)<\/samp><\/td>FLOOR(35.1) = 35<\/samp><\/td>KF1@PERPRODLOC = FLOOR(KF@ PERPRODLOC)<\/samp><\/td><\/tr>
CEIL(double)<\/samp><\/td>CEIL(35.1) = 36<\/samp><\/td>KF1@PERPRODLOC = CEIL(KF@ PERPRODLOC)<\/samp><\/td><\/tr>
LTRIM(string)<\/samp>LTRIM(string,string)<\/samp><\/td>Remove a whitespace prefix from a string. The whitespace characters may be specified in an optional argument.<\/td> <\/td><\/tr>
RTRIM(string)<\/samp>RTRIM(string,string)<\/samp><\/td>Remove trailing whitespace from a string. The whitespace characters may be specified in an optional argument.<\/td> <\/td><\/tr>
TRIM(string)<\/samp>TRIM(string,string)<\/samp><\/td>Remove whitespace from the beginning and end of a string.<\/td> <\/td><\/tr>
UPPER(arg1)<\/samp><\/td>Returns arg1<\/samp> in upper case<\/td>KF1@PERPRODCUST = IF(UPPER(\u00a0\u00bbATTR1\u00a0\u00bb) = \u00a0\u00bbAPPROVED\u00a0\u00bb, \u00ab\u00a0KF2@PERPRODCUST\u00a0\u00bb, NULL)<\/samp><\/td><\/tr>
MIN(arg1,arg2,…)<\/samp><\/td>In the case of several input key figures, there is no aggregation; it returns the lowest value of the input key figures.<\/td>MINCAPACITY@MTHPRODLOC = MIN(\u00ab\u00a0CAPACITYMORNING@MTHPRODLOC\u00a0\u00bb, \u00ab\u00a0CAPACITYAFTERNOON@MTHPRODLOC\u00a0\u00bb, \u00ab\u00a0CAPACITYNIGHT@MTHPRODLOC\u00a0\u00bb)<\/samp><\/td><\/tr>
MAX(arg1,arg2,…)<\/samp><\/td>In the case of several input key figures, there is no aggregation; it returns the highest value of the input key figures.<\/td>MAXCAPACITY@MTHPRODLOC = MAX(\u00ab\u00a0CAPACITYMORNING@MTHPRODLOC\u00a0\u00bb, \u00ab\u00a0CAPACITYAFTERNOON@MTHPRODLOC\u00a0\u00bb, \u00ab\u00a0CAPACITYNIGHT@MTHPRODLOC\u00a0\u00bb)<\/samp><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Example<\/strong><\/p>\n\n\n\n

Sample configuration for aggregation of standard deviation<\/p>\n\n\n\n

Take the sum of the squares; then calculate the square root of the total:<\/p>\n\n\n\n

    \n
  1. Calculate the squares:\n
      \n
    1. Square the values:HKF1@PL = PROPAGATEDDEMANDSTDEV@PL ** 2<\/samp><\/li>\n\n\n\n
    2. Sum the squares:HKF1@REQUEST = SUM(HKF1@PL)<\/samp><\/li>\n<\/ol>\n<\/li>\n\n\n\n
    3. Calculate the square root of the total:PROPAGATEDDEMANDSTDEV@REQUEST= HKF1@REQUEST ** 0.5<\/samp><\/li>\n<\/ol>\n\n\n\n

      Example<\/strong><\/p>\n\n\n\n

      ISNULL<\/p>\n\n\n\n

      The ISNULL condition works only when an underlying time series record exists for the planning object.<\/p>\n\n\n\n

      Imagine that Sales Forecast Quantity<\/strong> and Marketing Forecast Quantity<\/strong> are the stored key figures for planning level PERPROD.<\/p>\n\n\n\n

      Planning Object<\/th>Period<\/th>Key Figure: Sales Forecast Qty<\/th>Key Figure: Marketing Forecast Qty<\/th><\/tr><\/thead>
      P1<\/td>Jan 2018<\/td>100<\/td> <\/td><\/tr>
      P1<\/td>Mar 2018<\/td> <\/td>100<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      With the above data, IF(ISNULL(SALESFCSTQTY),1,0)<\/samp> exhibits the following behavior:<\/p>\n\n\n\n

      Period<\/th>ISNULL Value<\/th>Notes<\/th><\/tr><\/thead>
      Jan 2018<\/td>0<\/td>January 2018 has the value \u201c100\u201d.<\/td><\/tr>
      Feb 2018<\/td>Not evaluated<\/td>The planning object for the time period February 2018 does not exist.<\/td><\/tr>
      Mar 2018<\/td>1<\/td>Though there is no value for Sales Forecast Quantity<\/strong>, the Marketing Forecast Quantity<\/strong> key figure (for the same planning level) has a valid value. Therefore, a record exists in the time series for this planning object.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Sample Expressions<\/h2>\n\n\n\n
      Key Figure<\/th>Calculation Expression<\/th><\/tr><\/thead>
      Actuals Price<\/strong><\/td>ACTUALSPRICE@REQUEST = IF(\u201cACTUALSQTY@REQUEST\u201d=0,0, \u201cACTUALSREV@REQUEST\u201d\/\u201cACTUALSQTY@REQUEST\u201d)<\/samp><\/td><\/tr>
      Capacity Overloads<\/strong><\/td>CAPACITYOVERLOADS@PERLOCRES = IF(\u201cCAPADEMANDUTILPCT@PERLOCRES\u201d> 1,1,0)<\/samp><\/td><\/tr>
      Capacity Usage<\/strong><\/td>CAPAUSAGE@PERPRODLOCRES = \u201cCAPADEMAND@PERPRODLOCRES\u201d*\u201c(IF(CAPASUPPLYPERDEMAND@PERLOCRES\u201d>1,1, \u201cCAPASUPPLYPERDEMAND@PERLOCRES\u201d))<\/samp><\/td><\/tr>
      Marketing Forecast Profit<\/strong><\/td>MARKETINGFORECASTPROFIT@PERPRODCUST = \u201cMARKETINGFORECASTREV@PERPRODCUST\u201d- \u201cHMARKETINGFORECASTCOST@PERPRODCUST\u201d<\/samp><\/td><\/tr>
      Marketing Forecast Quantity<\/strong><\/td>MARKETINGFORECASTQTY@PERPRODCUST = IF(ISNULL(\u00ab\u00a0MARKETINGFORECASTQTY@PERPRODCUST\u00a0\u00bb), \u00ab\u00a0SALESFORECASTQTY@PERPRODCUST\u00a0\u00bb, \u00ab\u00a0MARKETINGFORECASTQTY@PERPRODCUST\u00a0\u00bb)<\/samp><\/td><\/tr>
      Constrained Versus Consensus Demand Revenue<\/strong><\/td>CONSTRAINEDVSCONSENSUSREV@PERPRODFML = IF(ISNULL(\u00ab\u00a0CONSENSUSDEMANDREV@PERPRODFML\u00a0\u00bb)OR \u00ab\u00a0CONSENSUSDEMANDREV@PERPRODFML\u00a0\u00bb=0,0, IF(ABS(\u00ab\u00a0SUPPLYREV@PERPRODFML\u00a0\u00bb – \u00ab\u00a0CONSENSUSDEMANDREV@PERPRODFML\u00a0\u00bb)\/\u00a0\u00bbCONSENSUSDEMANDREV@PERPRODFML\u00a0\u00bb > 0,2,1,0))<\/samp><\/td><\/tr>
      Supply Quantity<\/strong><\/td>SUPPLYQTY@PERPRODLOC = IF(\u00ab\u00a0HPROJECTEDINVENTORYQTY@PERPRODLOC\u00a0\u00bb>=0, \u00ab\u00a0DEPENDENTDEMANDQTY@PERPRODLOC\u00a0\u00bb, \u00ab\u00a0DEPENDENTDEMANDQTY@PERPRODLOC\u00a0\u00bb+ \u00ab\u00a0HPROJECTEDINVENTORYQTY@PERPRODLOC\u00a0\u00bb)<\/samp><\/td><\/tr>
      Bill Cost per Area Demand Revenue<\/strong><\/td>BILL_COST_PER_AREA@BSCIRTRSCFRCTOUFRUTO2L3AVG_A = IF(isnull(\u00ab\u00a0ASSETAREA5@BSCIRTRSCFRCTOUFRUTO2L3AVG_A\u00a0\u00bb) or \u00ab\u00a0ASSETAREA5@BSCIRTRSCFRCTOUFRUTO2L3AVG_A\u00a0\u00bb=0,0,\u00a0\u00bbBILL_COST5@BSCIRTRSCFRCTOUFRUTO2L3AVG_A\u00a0\u00bb\/\u00a0\u00bbASSETAREA5@BSCIRT<\/samp><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

      https:\/\/help.sap.com\/docs\/SAP_INTEGRATED_BUSINESS_PLANNING\/bf99e931b8d44aafb4e306ec3602cbdd\/b8582c558934753ce10000000a174cb4.html?version=2105&locale=en-US Standard Functions Syntax Details Example IF(intarg , arg2, arg3) Return arg2 if intarg is considered true (not equal to zero), else return arg3. CAPACITYOVERLOADS@PERLOCRES = IF(\u201cCAPADEMANDUTILPCT@PERLOCRES\u201d> 1,1,0) ISNULL(arg1) Return 1 (= true), if arg1 is set to null. MARKETINGFORECASTQTY@PERPRODCUST = IF(ISNULL(MARKETINGFORECASTQTY@PERPRODCUST), SALESFORECASTQTY@PERPRODCUST, MARKETINGFORECASTQTY@PERPRODCUST) CASE(arg1, default)CASE(arg1, cmp1, … Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-402","post","type-post","status-publish","format-standard","hentry","category-ibp"],"_links":{"self":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/comments?post=402"}],"version-history":[{"count":1,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/402\/revisions"}],"predecessor-version":[{"id":404,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/402\/revisions\/404"}],"wp:attachment":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/media?parent=402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/categories?post=402"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/tags?post=402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}