cancel
Showing results for 
Search instead for 
Did you mean: 

Making Key Figure value as blank in Live cache based on condition

Former Member
0 Kudos

Hi Folks,

  key figure value is already exist in Live cache, based on condition want to make it as blank.

For eg:Original  :: keyfigure(Test)      50(value)

           Needed :: Keyfigure(Test)      Blank value( not 0 value)

I am using standard function module BAPI_PBSRVAPS_CHANGEKEYFIGVAL2 for posting values in Livecache.

If I am passing blank value to the function module also is posting as 0(zero) but not blank value.

Please suggest me is there any function module to change the value as blank in live cache.

Thanks in advance,

Smriti.

Accepted Solutions (0)

Answers (6)

Answers (6)

thanga_prakash
Active Contributor
0 Kudos

Hello Smriti,

Did you get solution for the thread, please update thread with solution if it is solved.

Regards,

TP

thanga_prakash
Active Contributor
0 Kudos

Hello Smriti,

Goto the planning area via transaction /SAPAPO/MSDP_ADMIN and in the tab "Key figs" --> Click details --> check whether the "Fixable Zero" column is checked for the key figure which you are trying to make it as blank.

Regards,

Thanga

thanga_prakash
Active Contributor
0 Kudos

Hello Smriti,

Try with function module /SAPAPO/TS_DM_SET which might solve your issue.

Regards,

Thanga

former_member225716
Participant
0 Kudos

Hello Smriti,

Please refer below link,

http://scn.sap.com/docs/DOC-45815

Hope it helps you to fix the problem.

Regards,

Sachin

0 Kudos

Hi Smrity,

I am not aware if there is such function module exists or not but you can make a keyfigure value blank based on the condition using Macro. Create a macro like mentioned below :

Macro [blank out]

    Step [XX Iteration]

     ROW:Keyfigure[Proportional Factor]=

Once you added the keyfigure which you want to make blank as mentioned above right >>click on the same and go to properties >>set the change mode value as "Initialization".

Row: Proportional Factor ( Frm  M 08.2010 ) = Initial

This will make the keyfigure "Proportional Factor" blank in all the buckets.

You can define the same macro based on the condition as per your requirement:

Macro:[blank out]

   Step:[XX Iteration]

    IF

    Condition[keyfigure(Test) = 50]

        ROW:keyfigure(Test)

        =50

    ROW: keyfigure(Test) = Initial

    EndIF

Please note that  the keyfigure which you want to make blank must be "Zero allowed" in planning area setting and you can check the same >> using tcode  /n/sapapo/msdp_admin >> select planning area >>Keyfigure tab >> select your keyfigure from planning area screen and click on details >> Zero allowed check box should be checked.

Hope this helps.

Best Regards

Gaurav

emani_raghavendra
Participant
0 Kudos

Hi Smriti,

Kindly check the key figure settings in planning area. Chnage the key figure settings in planning area to Zero's not allowed and then try again.

Thnaks,

Venkat

Former Member
0 Kudos

Hi Folks,

Please share your ideas..

Thanks,

Smriti

m_manimaran
Active Contributor
0 Kudos

Hi Smriti,

The KF values are always numerical and blank == 0 (zero).

Could you please explain - What are you trying with passing 'blank' instead of 0 to the KF value?

Regards,

Manimaran M.