Show TOC

Open-To-Buy DataLocate this document in the navigation structure

Use

Merchandise planning data, in particular, Open-To-Buy (OTB), can be used by the SAP Assortment Planning for Retail application to help set planning targets.

To access OTB-related figures in SAP Assortment Planning for Retail, this data must first be imported into the DDF module in your back-end system, as described in the Integration section below. Once the OTB-related figures are available in your back-end system, SAP Assortment Planning for Retail can access this data directly as follows:

  • My Assortment Lists (Version 2) SAP Fiori app: When building an assortment list, you have access to summarized planned values of that assortment list's product hierarchy level and validity period.

  • Plan Options Workbooks: When planning options, the overall option plan monetary values are aggregated and you can compare them to the OTB-related figures.

Integration

By default, SAP Assortment Planning for Retail is configured to consume merchandise planning data from the SAP Merchandise Planning for Retail application, another add-on to the SAP Customer Activity Repository.

If you are determining the OTB using the SAP Planning for Retail, rapid-deployment solution, the OTB-related figures (KPIs including planned sales, open orders, and purchase quantities) are stored in SAP Business Warehouse (SAP BW) InfoProviders. To access these figures from SAP Assortment Planning for Retail, this data must first be imported from the SAP BW system to your back-end system, as described in SAP Note 2208191 Information published on SAP site.

Activities

To consume merchandise planning data from the SAP Merchandise Planning for Retail application, do the following:

  1. Verify that in the Define SAP BW Application for Merchandise Planning Customizing activity, under Start of the navigation path Cross-Application Components Next navigation step Assortment Planning for Retail Next navigation step Imported Demand Data Foundation Settings Next navigation step Integration End of the navigation path, the default settings are applied as follows:

    • Destination: LOCAL

      If this field is empty, the application assumes that the InfoProvider exists in the back-end system, which is the case if SAP Assortment Planning for Retail and SAP Merchandise Planning for Retail are installed on the same back-end system.

    • InfoProvider: /RAP/MPRC01

  2. Remaining in the Define SAP BW Application for Merchandise Planning Customizing activity, specify the same Fiscal Year Variant as the one maintained under Start of the navigation path Cross-Application Components Next navigation step Assortment Planning for Retail Next navigation step Maintain fiscal year variant End of the navigation path.

  3. Verify that in the Define Field Mapping for Merchandise Planning Customizing activity, also under, Start of the navigation path Cross-Application Components Next navigation step Assortment Planning for Retail Next navigation step Imported Demand Data Foundation Settings Next navigation step Integration End of the navigation path, the default settings for field-mapping to the SAP Merchandise Planning for Retail InfoProvider are maintained.

  4. Set up the SAP BW to Merchandise Plan Interface report (/DMF/BI_IF_MERCH_PLAN in transaction SE38) to run as a background job to regularly import any updates from SAP Merchandise Planning for Retail to DDF.

More Information
  • http://help.sap.com/aprStart of the navigation path Installation and Upgrade Information Next navigation step Installation Guide End of the navigation path

  • http://help.sap.com/mpr

  • http://help.sap.com/bicontentStart of the navigation path <Your Release> Next navigation step SAP Library Next navigation step BI Content & BI Content Extensions Next navigation step BI Content Next navigation step Industry Solutions Next navigation step Trading Industries Next navigation step Retail Trade Next navigation step Merchandise and Assortment Planning Next navigation step Retail Planning Next navigation step MultiProvider Next navigation step Merchandise Retail Plan End of the navigation path

  • http://service.sap.comInformation published on SAP siteStart of the navigation path Products Next navigation step SAP Rapid Deployment Solutions (RDS) Next navigation step A-Z Index Next navigation step P Next navigation step SAP Planning for Retail rapid-deployment solution End of the navigation path