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

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

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

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

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