Skip to Content

I would like to explain step by step procedure to create Target settings in SAP BO SCPM 2.0.

.

Step 1: 

           Create New Aggregation Level from Info cube directly or by using Tcode:  RSPLAN.

solo1.JPG

Step 2:

  •             Design a Bex Query by using Query DesigneràNewàFindàAggregation level (Ex: 0spm_A27).
  • /wp-content/uploads/2012/05/step2_98263.jpg

Step3:

           Choose Key figures 0spm_kf_tuc, 0spm_kf_trd in columns and Dimensions like Brand, companycode, version, calday, calyear, and calyear_month in Rows.

/wp-content/uploads/2012/05/step3_98264.jpg

Step 4:

  • Make all Key figure entries as Input-ready query through properties–>Planning Tab.
  • /wp-content/uploads/2012/05/step4_98265.jpg

Step 5:

  • Extended Tab and Ensure that Result Rows for dimensions like Calendar day and Plant should be suppressed and for remaining Display as Key or Text.
  • /wp-content/uploads/2012/05/step5_98266.jpg

Step 6:

            Create New “Characteristic Variables with user input” or use SAP exit variable for the same if it is available.

/wp-content/uploads/2012/05/step6_98273.jpg

Step 7:

            Choose Start Query in Change Mode as option in Query Properties as below.

/wp-content/uploads/2012/05/step7_98274.jpg

Step 8:

            Save Bex Query (spm_Arc07) as Workbook by using Bex Analyzer in Scpm with Role as “User Technical Roles” and then open workbook in Design mode, choose Push Buttons and set properties with Planning specific Save Button to save the data.

/wp-content/uploads/2012/05/step8_98275.jpg

Step9:

  •            We need to ensure that the Real Time Cube should be in Plan Mode (Real Time Cube-àPlanning Specific Properties–>Change Real Time Load Behavior).
  • /wp-content/uploads/2012/05/step9_98276.jpg
To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply