Procedure documentationTransferring the Baseline Sales Quantity

 

You can calculate the baseline sales quantity in SAP Supply Chain Management (SAP SCM), transfer it to Business Planning and Simulation (BPS), and then display it in an enhanced BPS planning layout in volumes and trade spends planning in SAP Customer Relationship Management (SAP CRM) .

Note Note

If you do not calculate the baseline sales quantity in SAP SCM, you can also load this data as external data into BPS or manually fill the appropriate column in the enhanced planning layout.

End of the note.

Prerequisites

You have created the following key figures in the SAP NetWeaver Business Intelligence (SAP NetWeaver BI) system used for SAP SCM:

Key Figure

Name

Disaggregation

Time Disaggregation

Data Type

Unit

ZASPLANB

Supply Plan (Basis)

S

P

QUAN

0UNIT

ZASPLANP

Supply Plan (Promo)

S

P

QUAN

0UNIT

ZASPLANT

Supply Plan (Total)

S

P

QUAN

0UNIT

ZAHISTB

History (Basis)

S

P

QUAN

0UNIT

ZAHISTP

History (Promo)

S

P

QUAN

0UNIT

ZAHISTT

History (Total)

S

P

QUAN

0UNIT

ZAADJUST

Adjustments

S

P

QUAN

0UNIT

Procedure

  1. In the SAP NetWeaver BI system used for SAP SCM, create master InfoCube APO Output (TPMAPOOUT) with the following info objects:

    • Characteristics: APO Planning Version (9AVERSION), APO Product (9AMATNR), APO Location (9ALOCNO)

    • Time characteristics: Calendar/Week (0CALWEEK) (optional: Calendar Year/Month (0CALMONTH))

    • Key figures: Supply Plan (Basis) (ZASPLANB) (optional: Supply Plan (Promo) (ZASPLANP), Supply Plan (Total) (ZASPLANT))

    • Units: Unit of Measure (0UNIT)

  2. Make the baseline sales quantity available in the APO Output InfoCube (TPMAPOOUT).

    For more information, see SAP Note 438307.

  3. In BPS, maintain the attributes for the planning areas as follows:

    • Planning area CP: APO Baseline (4TPM6000)

      In the RFC Connection field, enter the SAP NetWeaver BI system used for SAP SCM that contains InfoCube APO Output (TPMAPOOUT).

      In the InfoCube field, enter InfoCube APO Output (TPMAPOOUT).

    • Planning area CP: TPM Baseline (4TPM7000)

      In the RFC Connection field, enter the SAP NetWeaver BI system that contains InfoCube Baseline Sales Quantity (0CP_SLSC9).

      In the InfoCube field, enter InfoCube Baseline Sales Quantity (0CP_SLSC9).

  4. In BPS, in the planning function Return Plan Data (4TPM5111), maintain the version and value type to suit your needs.

  5. In BPS, in the planning area APO-SEM Integration (4TPM5000), execute planning function Return Plan Data (4TPM5111).

    This planning function is in planning profile CP: Sales Planning with Promotions (4TPM0001).

    The system transfers the baseline sales quantity from InfoCube APO Output (TPMAPOOUT) to InfoCube Baseline Sales Quantity (0CP_SLSC9).

Result

If you choose a suitable planning profile group (for example, 4TPM or 4TPF) when creating the trade promotion, you can display the baseline sales quantity in the enhanced planning layout in volumes and trade spends planning. This allows you to plan, for example, the uplift quantity.