I would like to explain step by step procedure to create Target settings in SAP BO SCPM 2.0.
Create New Aggregation Level from Info cube directly or by using Tcode: RSPLAN.
Choose Key figures 0spm_kf_tuc, 0spm_kf_trd in columns and Dimensions like Brand, companycode, version, calday, calyear, and calyear_month in Rows.
- 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.
Create New “Characteristic Variables with user input” or use SAP exit variable for the same if it is available.
Choose Start Query in Change Mode as option in Query Properties as below.
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.