Table of Contents

Open all
Close all
Preface by Manfred Hirn
19
Preface by Werner Herhuth
21
Preface by Ursula Becker
23
Introduction
25
History of the Pricing and the Condition Technique
25
How Will This Book Help You?
26
What Is the Structure of the Book?
27
Who Is the Target Audience of the Book?
28
Note on the Examples in this Book
29
I Foundations
31
1 Application Areas and Elements of the Condition Technique
33
1.1 Condition Records
34
1.2 Application Areas (Using Condition Tables)
35
1.3 Selected Application Areas (Usages)
37
1.3.1 Usage A: Pricing
37
1.3.2 Usage B: Output
37
1.3.3 Usage C: Account Determination
38
1.3.4 Usage D: Material Determination
38
1.3.5 Usage E: Rebate
39
1.3.6 Usage G: Material Listing and Exclusion
39
1.3.7 Usage N: Free Goods
39
1.3.8 Usage 3: Campaign Determination
40
1.3.9 Usage T: Data Collection
40
1.4 Applications of the Condition Technique
40
1.5 Elements of the Condition Technique
44
1.6 Field Catalog and Communication Structures
46
1.6.1 Field Catalog
46
1.6.2 Communication Structures
47
1.7 Condition Tables
47
1.8 Access Sequences
50
1.8.1 Access Sequence with Different Condition Tables
50
1.8.2 Access Sequence with a Single Condition Table (Access with Partial Key)
53
1.8.3 Exclusive or Additive Access
56
1.8.4 Direct Values
57
1.8.5 Data Determination During Access
57
1.9 Condition Types
58
1.10 Condition Master Data
58
1.10.1 Data Model
59
1.10.2 Maintenance Dialog for Simple Usages (Application Areas)
60
1.10.3 Maintenance Dialog for Complex Usages
61
1.10.4 Validity Periods
62
1.10.5 Release Status and Processing Status
63
1.11 Determination Procedures
63
1.12 Determination Analysis
64
1.13 Requirements
65
1.14 The Complete Process at a Glance
67
1.15 Summary
68
2 Pricing Condition Master Data
69
2.1 Condition Maintenance via Condition Type
69
2.1.1 Details Functionality
71
2.1.2 Additional Data Functionality
72
2.1.3 Scales Functionality
73
2.1.4 Condition Supplement Functionality
74
2.1.5 Validity Periods Functionality
74
2.1.6 Free Goods Functionality
74
2.1.7 Status Information Functionality
74
2.1.8 Cumulative Values Functionality
75
2.1.9 Other Condition Type Functionality
75
2.2 Condition Maintenance via Area Menu
75
2.3 Condition Maintenance via Index
79
2.4 Agreements
80
2.4.1 Sales Deals
80
2.4.2 Rebate Agreements
83
2.5 Price Agreements
84
2.6 Summary
84
3 Condition Lists
85
3.1 Pricing Reports
85
3.1.1 Execution of Pricing Reports
86
3.1.2 Configuration of a Pricing Report
87
3.1.3 Pricing Report for Condition Maintenance via Area Menu
91
3.2 Worklists for the Internal Sales Representative Role
92
3.2.1 Change Query
93
3.2.2 Personalize Query
95
3.2.3 Define New Query
96
3.3 Net Price List
97
3.4 Performance-Optimized Price List
99
3.4.1 Creation of Price Lists
100
3.4.2 Customizing and Customer Enhancements
105
3.4.3 Registration of Fields
105
3.4.4 Define the Data Determination
108
3.4.5 Enhancements of the Selection Screen
114
3.4.6 Enhancements of the Price List Result
118
3.4.7 Customizing Overview
122
3.4.8 Important Programs and Function Modules
124
3.5 Summary
125
II Standard Configuration
127
4 Pricing Configuration
129
4.1 Implementation of an Initial Customer-Specific Scenario
130
4.1.1 Creating a Condition Table
130
4.1.2 Creating an Access Sequence
135
4.1.3 Customizing a Condition Type
138
4.1.4 Creating a Condition Type
141
4.1.5 Inserting a Condition Type into a Pricing Procedure
143
4.1.6 Defining the Pricing Procedure Determination
144
4.1.7 Testing the Pricing Scenario
145
4.2 Elements of Pricing in Detail
146
4.2.1 Condition Table
146
4.2.2 Access Sequence
148
4.2.3 Condition Type
149
4.2.4 Pricing Procedure
161
4.3 Customer-Specific Adaptations and Customer Namespaces
166
4.3.1 Creative Use of the Standard Configuration
166
4.3.2 New Fields for Pricing
167
4.3.3 Requirements and Formulas (Routines)
168
4.3.4 User Exits for Pricing
169
4.4 Example for the Implementation of Complex Pricing Scenarios
170
4.5 Configurable Parameters and Formulas
172
4.5.1 Implementing an Initial Scenario with Configurable Parameters and Formulas
173
4.5.2 Elements of CPF in Detail
185
4.5.3 Customer-Specific Adaptations in CPF
191
4.6 Interface to Profitability Analysis
198
4.7 Summary
200
5 Working with Condition Records
201
5.1 Release Status
201
5.1.1 Available Release Statuses
202
5.1.2 Release Status in Condition Records
202
5.1.3 Release Status in Conjunction with Agreements
203
5.2 Mass Change/Mass Creation with Template
206
5.3 Copying Condition Records
210
5.3.1 Prerequisites
210
5.3.2 Application Example
213
5.4 Condition Maintenance via Area Menus
215
5.5 Other Functionalities in Condition Maintenance
217
5.5.1 Change Documents
217
5.5.2 Texts
218
5.5.3 Condition Supplements
220
5.5.4 Deletion of a Condition Record
220
5.6 Summary
222
6 Pricing in the Sales Document
223
6.1 The Item Conditions Screen
223
6.1.1 Condition Detail
226
6.1.2 Insert Row
229
6.1.3 Delete Row
229
6.1.4 Master Data Condition Record
229
6.1.5 Analysis (Pricing Log)
229
6.1.6 Update Prices
230
6.1.7 Configurable User Interface for Pricing
230
6.2 Header Conditions Screen
232
6.3 Predefined Price Elements in the Item Overview Screen
236
6.4 Price Agreements
237
6.4.1 Creating Price Agreements
237
6.4.2 Searching and Displaying Price Agreements Using the Condition Index
240
6.5 Pricing During Creation of Documents with Reference
240
6.6 Pricing for Special Billing Scenarios
241
6.6.1 Pricing in Rental and Maintenance Contracts (Periodic Billing Plan)
242
6.6.2 Pricing in Fixed Price Contracts (Milestone Billing)
246
6.6.3 Pricing in Resource-Related Billing
252
6.7 Summary
253
7 Special Functions in Pricing
255
7.1 Group Conditions
255
7.1.1 Header Conditions with a Fixed Amount
256
7.1.2 Percentage-Based Header Conditions
256
7.1.3 Scale-Based Conditions without Group Key
257
7.1.4 Scale-Based Conditions without Group Key
257
7.1.5 Percentage-Based and Fixed Amount Group Conditions with Condition Records
257
7.2 Condition Exclusion
258
7.2.1 Simple Condition Exclusion Using Requirements
258
7.2.2 Condition Exclusion Using Exclusion Groups
259
7.2.3 Condition Exclusion Using Formulas
261
7.3 Condition Update
264
7.4 Tax Determination in Sales
267
7.4.1 Simple Tax Determination
267
7.4.2 Tax Determination via Accounting (Tax Trigger)
269
7.4.3 Tax Determination via External Tax Interface
272
7.4.4 Tax Increase
273
7.5 Free Goods in Sales
273
7.6 Cost of Sales
276
7.6.1 Stock Sale (No Cross-Company)
277
7.6.2 Drop Shipment (Third Party)
278
7.6.3 Cross-Company Stock Sale
278
7.6.4 Make-To-Order with/without Production Order
280
7.6.5 Actual-Cost Accounting
280
7.7 Currency Conversion in Sales
281
7.7.1 Local Currency
282
7.7.2 Document Currency and Exchange Rates
282
7.7.3 Exchange Rate for Accounting
283
7.7.4 Condition Currency and Exchange Rates
285
7.7.5 Currency Customizing and Exchange Rates
286
7.7.6 Currency Conversion
286
7.8 Print Formatting of the Pricing Result
289
7.8.1 Functional Scope of the Output Processing
289
7.8.2 Print Formatting of Order Item Values and Document Footer
291
7.9 Summary
293
8 Pricing Procedures and Condition Types in Sales and Distribution
295
8.1 Selected Pricing Procedures
297
8.1.1 Pricing Procedure RVAA01 (Standard B2B)
298
8.1.2 Pricing Procedure RVAA02 (Standard with Price Book)
303
8.1.3 Pricing Procedure RVAB01 (Tax Included in Price)
306
8.1.4 Pricing Procedure PSER01 (Periodic Billing)
307
8.1.5 Pricing Procedure PSER02 (Resource Related Billing)
308
8.1.6 Pricing Procedure ICAA01 (Intercompany Billing)
309
8.1.7 Pricing Procedure WK0001 (Value Contract Procedure)
311
8.1.8 Pricing Procedure RVWIA1 (Plants Abroad/Tax Handling)
311
8.1.9 Pricing Procedure RVACRN (Contract Billing)
311
8.2 Selected Condition Types of the Standard Pricing Procedures
314
8.2.1 Condition Types EDI1/EDI2 (Customer Expected Price)
314
8.2.2 Condition Types RL00/MW15 (Invoice List Conditions)
315
8.2.3 Condition Types SKTV/SKTO (Cash Discount))
315
8.2.4 Condition Type HM00 (Order Value)
316
8.2.5 Condition Types AMIW/AMIZ (Minimum Sales Order Value/Minimum Value Surcharge)
317
8.2.6 Condition Type AZWR (Down Payment/Settlement)
318
8.2.7 Condition Type GRWR (Statistical Value (Cross-Border))
318
8.3 Summary
319
III Advanced Techniques, Tips, and Tricks
321
9 Special Features of the Condition Technique in Pricing
323
9.1 Interfaces, Tables, and Interrelationships
324
9.1.1 Interfaces to Condition Tables and Master Data Maintenance
324
9.1.2 Interfaces to the Pricing Modules
325
9.1.3 Internal Structures and Tables of the Pricing Programs
326
9.1.4 Field Sequence in the Condition Table
328
9.2 Data Determination via Condition Technique
329
9.2.1 Variant 1: Data Determination Within the Access: Used in Subsequent Access
330
9.2.2 Variant 2: Data Determination in the Access, Transfer to Document Item via Requirement
335
9.2.3 Transfer from Condition Record via Formula or Requirement
344
9.2.4 Variant 3: Transfer to XKOMV from Condition Record via Formula
347
9.2.5 Variant 4: Transfer to KOMK from Condition Record via Requirement
348
9.2.6 Variant 5: Utilization of Data of Other Document Conditions in Formula
349
9.3 Fields with Multiple Values
350
9.3.1 The KOMPLOOP Variant for Multiple Value Fields
350
9.3.2 The Repeating Field Variant for Multiple Value Fields
353
9.3.3 Variant Using BAdI SD_COND_LOAD_MVA
353
9.4 Summary
354
10 Important Programs for Pricing
355
10.1 The PRICING Function Module
356
10.1.1 Routine PREISFINDUNG_VORBEREITEN (Pricing Prepare)
358
10.1.2 Routine KONDITIONSVORSTEP (Condition Prestep)
359
10.1.3 Routine KONV_EINLESEN (Read KONV)
363
10.1.4 Routine XKOMV_AUFBAUEN_AUS_KOMT1 (Set Up XKOMV from KOMT1)
363
10.1.5 Routine XKOMV_AUFBAUEN_AUS_TKOMV (Set Up XKOMV from TKOMV)
366
10.1.6 Routine XKOMV_BEWERTEN (Evaluate XKOMV)
366
10.1.7 Routine XKOMV_AUSSCHLUSS (XKOMV Exclusion)
367
10.1.8 Routine XKOMV_UEBERTRAGEN_NACH_TKOMV (Transfer XKOMV to TKOMV)
367
10.2 The PRICING_COMPLETE Function Module
367
10.2.1 Types of Group Conditions
368
10.2.2 Execution of Function Module PRICING_COMPLETE during Order Processing
370
10.2.3 Program Flow of the PRICING_COMPLETE Function Module
372
10.3 The PRICING_COPY Function Module
378
10.4 Data Storage of the Pricing Result in Clustered Table KONV
379
10.5 The PRICING_REFRESH Function Module
380
10.6 Dialog Connection/Other Function Modules
381
10.6.1 Function Module PRICING_LOAD_CONDITION_TYPS
381
10.6.2 Dialog Connection
381
10.6.3 The PRICING_DETERMINE_DATES Function Module
382
10.7 Relationship of Tables and Structures
383
10.8 Summary
384
11 System Adaptation Using Requirements, Formulas, and User Exits
385
11.1 Pricing Types
387
11.1.1 Control via KOMP-KAEND_TYP
387
11.1.2 Control via KOMP-KONAU_TYP
388
11.2 Requirements
388
11.2.1 Manipulation of KOMK Fields and KOMP Fields via Requirements
388
11.2.2 Overriding Pricing Types via Requirements
389
11.2.3 Example 1: Using Table TKSCHLEXCL
389
11.2.4 Example 2: Using Tables TKSCHL and TKSCHLEXCL
390
11.2.5 Processing Time of the Prestep-Requirement (KOBEV Part)
390
11.2.6 Processing Time of the Definite Requirement (KOBED Part)
391
11.2.7 Behavior for Copied Conditions
392
11.3 An Example Using Formulas
392
11.4 Formulas for Pricing Conditions
398
11.4.1 Condition Base Value Formulas
398
11.4.2 Scale Base Formulas
400
11.4.3 Condition Value Formulas
402
11.4.4 Formulas for the Structure of Group Keys (Group Key Routines)
404
11.5 Special Logic for Pricing Type F in Routine XKOM_BEWERTEN
408
11.5.1 Point in Time "A"
409
11.5.2 Point in Time "B"
409
11.5.3 Point in Time "C"
410
11.5.4 Point in Time "D"
410
11.6 Pricing Result in KOMP
410
11.6.1 KOMP-FXMSG (Message Number)
412
11.6.2 KOMP-PRSOK (Pricing Is OK)
412
11.6.3 KOMP-CEPOK (Status Expected Price)
413
11.6.4 KOMP-MPROK (Status Manual Price Change)
413
11.6.5 KOMP-KOUPD (Condition Update)
414
11.6.6 KOMP-NETPR (Net Price)
414
11.6.7 KOMP-NETWR (Net Value of the Item)
414
11.6.8 KOMP-MWSBP (Tax Amount of the Item)
414
11.6.9 KOMP-WAVWR (Cost of the Item)
414
11.6.10 KOMP–BRTWR, KZWI1–KZWI6, Etc. (Subtotals)
415
11.7 Control Flag XKOMV-KSTEU
416
11.8 User Exits
418
11.8.1 User Exits of Function Group V61A
419
11.8.2 User Exits of Function Group V69A
424
11.9 Enhancement of KONV
426
11.10 Performance Aspects
427
11.11 Error Messages/Error Handling
428
11.12 Summary
429
12 Typical Practice Demands on Pricing and Their Solutions
431
12.1 Budgeting Requirements
432
12.1.1 Statistics Tables S060 and S469
433
12.1.2 Statistics Table S071
434
12.1.3 Budgeting Requirements
434
12.2 Why Is the Condition Not Found?
442
12.3 Rounding
445
12.4 Prices with More Than Two Decimal Places
446
12.5 Handling Freight Surcharges
447
12.5.1 Complete Billing of Freight Surcharges with the First Delivery
447
12.5.2 No Freight Surcharges for Free Goods and Returns
448
12.6 Authorizations for the Pricing Screen
449
12.7 Adding Subtotal Fields
449
12.8 Date-Dependent Maintenance of Master Data Fields
450
12.8.1 Data Determination for the Sales Document Item VBAP
451
12.8.2 Data Determination for the Sales Document Header VBAK/Business Data VBKD
453
12.8.3 Example: Substitution of a Customer Group (VBKDKDGRP)
453
12.8.4 Pros and Cons of Data Determination
454
12.8.5 Data Determination for the Billing Documents
455
12.9 Copied Conditions and Subsequent Quantity Changes
455
12.9.1 Simple Solution for Fixed Amount Condition Types
456
12.9.2 Complex Solution for Any Condition Type
458
12.10 Increased Prices in Returns and Credit Notes
462
12.11 Key Figures for Reporting and Analysis
463
12.11.1 Implementation of a Consolidated Pricing Procedure
465
12.11.2 Key Figure 1: The Initial Value (KZWI1)
470
12.11.3 Key Figure 2: The Standard Condition Types (KZWI2)
472
12.11.4 Key Figure 3: The Customer Specific Condition Types (KZWI3)
472
12.11.5 Key Figure 4: Manual Condition Types (KZWI4)
474
12.11.6 Key Figure 5: The Rebate Condition Types (KZWI5)
475
12.11.7 Key Figure 6: The Net Value (NETWR)
475
12.11.8 Key Figure 7: The Cost (WAVWR)
475
12.12 Condition Record Depending Requirements
479
12.12.1 Creation of a New Usage Task
479
12.12.2 Exclusion of Particular Material Groups in a Condition Record
485
12.13 Summary
492
13 Pricing in Selected Applications
493
13.1 Pricing in Sales Orders
494
13.1.1 Routine USEREXIT_PRICING_PREPARE_TKOMK
496
13.1.2 Routine USEREXIT_PRICING_PREPARE_TKOMP
497
13.1.3 Reacting to the Changes of Document Contents
497
13.1.4 Manual Triggering of New Pricing in the Sales Order
499
13.2 Pricing in Billing Documents
500
13.3 Pricing in Purchase Orders
501
13.4 Pricing in Accounting
505
13.5 Tax Determination in Accounting
506
13.6 Pricing in Transport Management (Shipment Cost Calculation)
513
13.7 Summary
514
14 Performance and Testing
515
14.1 SAP Table Buffering
516
14.2 Prestep Conditions and Access Optimization
517
14.3 Field Sequence in the Condition Tables
520
14.4 Usage of Requirements
521
14.5 Group Conditions and Formulas
521
14.6 Peculiarities in Sales Order and Billing Document
522
14.6.1 Peculiarities in the Sales Order
522
14.6.2 Peculiarities in the Billing Document
523
14.6.3 Filling the Communication Structure KOMK
526
14.7 Analytical Tools
529
14.8 Testing
531
14.9 Summary
533
IV Rebate Processing in Sales
535
15 Rebate Processing in Sales
537
15.1 Overview of Rebate Processing
537
15.1.1 Creating a Rebate Agreement
538
15.1.2 Sales Volume: Rebate Condition Types in the Sales Document
541
15.1.3 Settlement of Rebate Agreements
547
15.1.4 Deletion of Rebate Agreements
555
15.1.5 Retroactive Changes and Rebate Index
555
15.2 Elements of Rebate Processing in Detail
560
15.2.1 Condition Technique for Rebate Processing
560
15.2.2 Rebate Agreements
563
15.2.3 Activation of Rebate Processing
569
15.2.4 Document Types for Rebate Processing
570
15.2.5 Activation of the New Rebate Method
571
15.2.6 Important Reports
571
15.2.7 Scale Base Determination Based on Grouped Condition Records
579
15.2.8 Replacement of the Rebate Index Table
580
15.3 Extended Rebate Processing
581
15.3.1 Implementation of a First Customer-Specific Scenario
582
15.3.2 Customizing the Extended Rebate Processing
588
15.4 System Adaptation in Rebate Processing
594
15.4.1 Business Transaction Event 00503201
594
15.4.2 BAdI BADI_SD_REBATES
595
15.4.3 BAdIs of Extended Rebate Processing
597
15.5 Typical Practice Demands
600
15.5.1 Exclusion
600
15.5.2 Settlement Material and Tax Classification
601
15.5.3 External Control of Rebate Processing
601
15.6 Summary
603
Appendices
605
A Condition Type Profiles
605
A.1 AMIW (Minimum Sales Order Value)
605
A.2 AMIZ (Minimum Value Surcharge)
606
A.3 AZWR (Down Payment/Down Payment Settlement)
607
A.4 BO01 (Material/Material Group Rebate)
607
A.5 DIFF (Rounding of the Total)
609
A.6 DUPL (Condition to Be Duplicated)
610
A.7 EDI1 (Customer Expected Price)
610
A.8 EDI2 (Customer Expected Value)
611
A.9 EK01 (Actual Cost)
612
A.10 EK02/EK03 (Calculated Costs)
612
A.11 GRWR (Statistical Value)
613
A.12 HA00 (Percentage Discount)
614
A.13 HB00 (Discount (Value))
615
A.14 HD00 (Freight)
616
A.15 HI02 (Hierarchy/Material Discount)
616
A.16 HM00 (Order Value)
617
A.17 IV01 (Intercompany Price)
618
A.18 KP00 (Pallet Discount)
619
A.19 KP01 (Incomplete Pallet Surcharge)
620
A.20 KP02 (Mixed Pallet Discount)
621
A.21 KP03 (Mixed Pallet Surcharge)
622
A.22 KUMU (Cumulative Condition)
623
A.23 KW00 (Group Valuation, Transfer Price)
624
A.24 MW01 (Tax Trigger)
625
A.25 MW15 (Factoring Discount Tax) (Full Tax)
626
A.26 MWSI (Output Tax, Percentage Included)
627
A.27 NETP (Rounding Difference)
627
A.28 NETW (Value of Goods)
628
A.29 NRAB (Free Goods)
628
A.30 PBBS (Base Price)
629
A.31 PBU (Price Book Determination)
630
A.32 PBUD (Price Book, Basis)
631
A.33 PBUP (Price Book, Gross Price)
632
A.34 PC00 (Profit Center Valuation Transfer Price)
633
A.35 PI01 (Intercompany Price)
634
A.36 PMIN (Minimum Price)
635
A.37 PN00 (Net Price)
635
A.38 PR01 (Price Incl. Sales Tax)
636
A.39 PR02 (Price Increased)
636
A.40 PTVO (Voucher)
638
A.41 R100 (100% Discount)
638
A.42 RL00 (Factoring Discount)
639
A.43 SKTO (Cash Discount After Tax)
640
A.44 SKTV (Cash Discount Before Tax)
640
A.45 VA00 (Variants)
641
A.46 VPRS (Cost)
643
A.47 Z902 (Data Determination Material)
644
A.48 Z905 (Material Group Discount)
644
A.49 ZBUP (Price Book, Gross Price)
645
A.50 ZDB1 (Minimum Profit Margin)
646
A.51 ZM00 (Delta to the Order Value)
646
A.52 ZPBP (Data Determination Customer)
647
A.53 ZPRA (Price (General))
647
A.54 ZPRB (Price Cust. Specific)
648
A.55 ZPRC (Price Increased)
649
A.56 ZPRD (Contract Price)
650
A.57 ZH01 (Budget Approved)
650
A.58 ZH02 (Budget Requested)
652
B The Authors
653
Index
655