Example: Maintenance of the Price Determination Usage for Short-Term Trade Promotion Planning 

Condition Tables

Condition table 172 is delivered for the Price Determination usage with the key fields Campaign ID (CMPGN_ID) and Material (MATNR).

We recommend you define new condition tables in Customizing for SAP ECC under Sales and Distribution ® Basic Functions ® Pricing ® Pricing Control ® Define Condition Tables ® Create Condition Tables. For example, you can additionally define the following condition tables.

·        Condition table 523 with key fields Campaign ID (CMPGN_ID) and Material (MVGR1)

·        Condition table 524 with key fields Campaign ID (CMPGN_ID), Customer (KUNNR) and Material (MATNR)

·        Condition table 525 with key fields Campaign ID (CMPGN_ID), Customer (KUNNR), and Material (MVGR1)

·        Condition table 526 with key fields Campaign ID (CMPGN_ID), Customer (KUNNR), Main Group and Material (PRODH1), Group (PRODH2), and Subgroup (PRODH3)

·        Condition table 527 with key fields Campaign ID (CMPGN_ID), Main Group (PRODH1), Group (PRODH2), and Subgroup (PRODH3)

Access Sequences

For these condition tables you can define access sequence ZCP0 with the following accesses in Customizing for SAP ERP under Sales and Distribution ® Basic Functions ® Pricing ® Pricing Control ® Define Access Sequences ® Maintain Access Sequences:

No.	Tab
11	524
21	172
31	525
41	523
51	526
61	527

 

For these accesses, you can define the following fields:

Access ZCP0, Table 524

Condition	Docmt Structure	Doc.field
CMPGN_ID	KOMP	CMPGN_ID
KUNNR	KOMK	KUNNR
MATNR	KOMP	PMATN

 

Access ZCP0, Table 172

Condition	Docmt Structure	Doc.field
CMPGN_ID	KOMP	CMPGN_ID
MATNR	KOMP	PMATN

 

Access ZCP0, Table 525

Condition	Docmt Structure	Doc.field
CMPGN_ID	KOMP	CMPGN_ID
KUNNR	KOMK	KUNNR
MVGR1	KOMP	MVGR1

 

Access ZCP0, Table 523

Condition	Docmt Structure	Doc.field
CMPGN_ID	KOMP	CMPGN_ID
MVGR1	KOMP	MVGR1

 

Access ZCP0, Table 526

Condition	Docmt Structure	Doc.field	ATyp	Prio
CMPGN_ID	KOMP	CMPGN_ID
KUNNR	KOMK	KUNNR
PRODH1	KOMP	PRODH1	A	3
PRODH2	KOMP	PRODH2	A	2
PRODH3	KOMP	PRODH3	A	1

 

Access ZCP0, Table 527

Condition	Docmt Structure	Doc.field	ATyp	Prio
CMPGN_ID	KOMP	CMPGN_ID
PRODH1	KOMP	PRODH1	A	3
PRODH2	KOMP	PRODH2	A	2
PRODH3	KOMP	PRODH3	A	1

 

Condition Types

Next, you can define condition types ZCPO Price Group and ZCP1 Price Group in Customizing for SAP ERP under Sales and Distribution ® Basic Functions ® Pricing ® Pricing Control ® Define Condition Types ® Maintain Condition Types.

Condition Type ZCP0 with:

Access sequence	ZCP0
Condition class	Discount or surcharge (A)
Calculation type	Percentage (A)
Plus/minus	Negative (X)

 

Condition Type ZCP1 with:

Access sequence	ZCP0
Condition class	Discount or surcharge (A)
Calculation type	Quantity (C)
Plus/minus	Negative (X)

 

Pricing Procedures

...

       1.      In Customizing for SAP ERP, create a new pricing procedure, for example ZCP001, under Sales and Distribution ® Basic Functions ® Pricing ® Pricing Control ® Define and Assign Pricing Procedures.

       2.      In the same IMG activity, assign condition types ZCP0 and ZCP1 to pricing procedure ZCP001.

       3.      In Customizing for SAP ERP, create a new customer pricing procedure, for example ‘Z’, under Sales and Distribution ® Basic Functions ® Pricing ® Pricing Control ® Define and Assign Pricing Procedures ® Define Customer Pricing Procedure.

       4.      Maintain the determination of the pricing procedure in Customizing for SAP ERP under Sales and Distribution ® Basic Functions ® Pricing ® Pricing Control ® Define and Assign Pricing Procedures ® Define Pricing Procedure Determination.

Make the following (example) settings:

¡        Sales organization 1000

¡        Distribution channel: 10

¡        Division: 00

¡        Document pricing procedure: A

¡        Customer pricing procedure: Z

¡        Pricing procedure: ZCP001

¡        Condition type: PR00