Preface

21

History of the Pricing and Condition Technique

21

How Will This Book Help You?

22

Structure of the Book

22

Target Audience

23

Naming Conventions

24

Note on the Examples in This Book

24

1 Application Areas and Elements of the Condition Technique

27

1.1 Condition Records

27

1.2 Application Areas (Using Condition Tables)

29

1.3 Selected Application Areas (Usages)

30

1.3.1 Usage A: Pricing

30

1.3.2 Usage B: Output

30

1.3.3 Usage C: Account Determination

31

1.3.4 Usage D: Material Determination

31

1.3.5 Usage G: Material Listing and Exclusion

32

1.3.6 Usage N: Free Goods

32

1.3.7 Usage 3: Campaign Determination

32

1.3.8 Usage T: Data Collection

32

1.4 Applications of the Condition Technique

33

1.5 Elements of the Condition Technique

36

1.6 Field Catalog and Communication Structures

37

1.6.1 Field Catalog

37

1.6.2 Communication Structures

38

1.7 Condition Tables

39

1.8 Access Sequences

41

1.8.1 Access Sequence with Different Condition Tables

41

1.8.2 Access Sequence with a Single Condition Table (Access with Partial Key)

44

1.8.3 Access Sequence with Fields in Free Key

47

1.8.4 Exclusive or Additive Access

50

1.8.5 Direct Values

50

1.8.6 Data Determination During Access

50

1.9 Condition Types

51

1.10 Condition Master Data

51

1.10.1 Data Model

52

1.10.2 Maintenance Dialog for Simple Usages (Application Areas)

53

1.10.3 Maintenance Dialog for Complex Usages

54

1.10.4 Validity Periods

55

1.10.5 Release Status and Processing Status

56

1.11 Determination Procedures

56

1.12 Determination Analysis

57

1.13 Requirements

58

1.14 The Complete Process at a Glance

59

1.15 Summary

60

2 Pricing Condition Master Data

61

2.1 Condition Maintenance via Condition Type

61

2.1.1 Details Functionality

63

2.1.2 Additional Data Functionality

64

2.1.3 Scales Functionality

65

2.1.4 Condition Supplement Functionality

65

2.1.5 Validity Periods Functionality

66

2.1.6 Free Goods Functionality

66

2.1.7 Status Information Functionality

66

2.1.8 Cumulative Values Functionality

66

2.1.9 Other Condition Type Functionality

66

2.2 Condition Maintenance via the Area Menu

66

2.3 Condition Maintenance via Index

70

2.4 Agreements

71

2.4.1 Sales Deals

71

2.4.2 Rebates

74

2.5 Price Agreements

74

2.6 Summary

74

3 Pricing Reports and Price Lists

75

3.1 Pricing Reports

75

3.1.1 Execution of Pricing Reports

75

3.1.2 Configuration of a Pricing Report

77

3.1.3 Pricing Report for Condition Maintenance via the Area Menu

81

3.2 Condition Information

81

3.3 Net Price List

84

3.4 Sales Price – Retrieve API

85

3.5 Price List

86

3.5.1 Creation of Price Lists

87

3.5.2 Customizing and Customer Enhancements

92

3.5.3 Registration of Fields

92

3.5.4 Define the Data Determination

94

3.5.5 Enhancements of the Selection Screen

101

3.5.6 Enhancements of the Price List Result

105

3.5.7 Customizing Overview

108

3.5.8 Important Programs and Function Modules

110

3.6 Summary

111

4 Pricing Configuration

115

4.1 Implementation of an Initial Customer-Specific Scenario

115

4.1.1 Creating a Condition Table

116

4.1.2 Creating an Access Sequence

120

4.1.3 Customizing a Condition Type

122

4.1.4 Creating a Condition Type

125

4.1.5 Inserting a Condition Type into a Pricing Procedure

127

4.1.6 Defining the Pricing Procedure Determination

128

4.1.7 Testing the Pricing Scenario

129

4.2 Elements of Pricing in Detail

129

4.2.1 Condition Table

130

4.2.2 Access Sequence

131

4.2.3 Condition Type

132

4.2.4 Pricing Procedure

144

4.2.5 Modular Pricing Procedures

148

4.3 Customer-Specific Adaptations and Customer Namespaces

158

4.3.1 Creative Use of the Standard Configuration

158

4.3.2 New Fields for Pricing

159

4.3.3 Requirements and Formulas (Routines)

159

4.3.4 User Exits for Pricing

160

4.4 Example of the Implementation of Complex Pricing Scenarios

161

4.5 Configurable Parameters and Formulas

163

4.5.1 Implementing an Initial Scenario with Configurable Parameters and Formulas

164

4.5.2 Elements of CPF in Detail

175

4.5.3 Customer-Specific Adaptations in CPF

180

4.6 Interface to Profitability Analysis

186

4.7 Summary

187

5 Working with Condition Records

189

5.1 Release Status

189

5.1.1 Available Release Statuses

190

5.1.2 Release Status in Condition Records

190

5.1.3 Release Status in Conjunction with Agreements

191

5.2 Mass Change/Mass Creation with Template

192

5.3 Price Master Data Maintenance Apps

196

5.3.1 Mass Maintenance

198

5.3.2 Excel Export and Import

202

5.4 Copying Condition Records

207

5.4.1 Prerequisites

207

5.4.2 Application Example

210

5.5 Condition Maintenance via Area Menus

212

5.6 Condition Record Maintenance with OData Service

213

5.7 Other Functionalities in Condition Maintenance

215

5.7.1 Approval Workflow

216

5.7.2 Change Documents

221

5.7.3 Texts

222

5.7.4 Rename Condition Type Description

224

5.7.5 Condition Supplements

226

5.7.6 Deleting of a Condition Record

226

5.8 Summary

228

6 Pricing in the Sales Document

229

6.1 The Item Conditions Screen

229

6.1.1 Condition Detail

232

6.1.2 Insert Row

234

6.1.3 Delete Row

235

6.1.4 Hide Price Element for Specific Users

235

6.1.5 Condition Record (Master Data)

235

6.1.6 Analysis (Pricing Log)

235

6.1.7 Update (Prices)

236

6.1.8 Configurable User Interface for Pricing

236

6.2 Header Conditions Screen

238

6.3 Predefined Price Elements in the Item Overview Screen

241

6.4 Price Agreements

242

6.4.1 Creating Price Agreements

243

6.4.2 Searching and Displaying Price Agreements Using the Condition Index

245

6.5 Pricing During Creation of Documents with Reference

246

6.6 Pricing for Special Billing Scenarios

247

6.6.1 Pricing in Rental and Maintenance Contracts (Periodic Billing Plan)

247

6.6.2 Pricing in Fixed Price Contracts (Milestone Billing)

251

6.7 Summary

256

7 Special Functions in Pricing

257

7.1 Group Conditions

257

7.1.1 Header Conditions with a Fixed Amount

258

7.1.2 Percentage-Based Header Conditions

258

7.1.3 Scale-Based Conditions Without Group Key

258

7.1.4 Scale-Based Conditions with Group Key

258

7.1.5 Percentage-Based and Fixed-Amount Group Conditions with Condition Records

259

7.2 Condition Exclusion

259

7.2.1 Simple Condition Exclusion Using Requirements

259

7.2.2 Condition Exclusion Using Exclusion Groups

260

7.2.3 Condition Exclusion Using Formulas

262

7.3 Condition Update

264

7.4 Tax Determination in Sales

267

7.4.1 Simple Tax Determination

268

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)

277

7.6.3 Cross-Company Stock Sale

278

7.6.4 Make-to-Order With/Without Production Order

279

7.6.5 Actual-Cost Accounting

279

7.6.6 Condition Type VPRS (Cost)

280

7.7 Currency Conversion in Sales

280

7.7.1 Local Currency

281

7.7.2 Document Currency and Exchange Rates

281

7.7.3 Exchange Rate for Accounting

282

7.7.4 Condition Currency and Exchange Rates

284

7.7.5 Currency Customizing and Exchange Rates

284

7.7.6 Currency Conversion

285

7.8 Print Formatting of the Pricing Result

287

7.8.1 Functional Scope of Output Processing

287

7.8.2 Print Formatting of Order Item Values and Document Footer

289

7.9 Summary

291

8 Pricing Procedures and Condition Types in Sales

293

8.1 Selected Pricing Procedures

295

8.1.1 Pricing Procedure RVAA01 (Standard B2B)

295

8.1.2 Pricing Procedure RVAA02 (Standard with Price Book)

301

8.1.3 Pricing Procedure RVAB01 (Tax Included in Price)

303

8.1.4 Pricing Procedure PSER01 (Periodic Billing)

305

8.1.5 Pricing Procedure ICAA01 (Intercompany Billing)

306

8.1.6 Pricing Procedure WK0001 (Value Contract Procedure)

307

8.1.7 Pricing Procedure RVWIA1 (Plants Abroad/Tax Handling)

308

8.1.8 Pricing Procedure RVACRN (Contract Billing)

308

8.2 Selected Condition Types of the Standard Pricing Procedures

311

8.2.1 Condition Types EDI1/EDI2 (Customer Expected Price)

311

8.2.2 Condition Types RL00/MW15 (Invoice List Conditions)

311

8.2.3 Condition Types SKTV/SKTO (Cash Discount))

312

8.2.4 Condition Type HM00 (Order Value)

312

8.2.5 Condition Types AMIW/AMIZ (Minimum Sales Order Value/Minimum Value Surcharge)

314

8.2.6 Condition Type AZWR (Down Payment/Settlement)

314

8.2.7 Condition Type GRWR (Statistical Value (Cross-Border))

314

8.3 Summary

315

9 Condition Contract Management

317

9.1 Overview of Condition Contract Management

317

9.1.1 Condition Contract Agreement

317

9.1.2 Invoice Accompanying Conditions

320

9.1.3 Conditions Requiring Subsequent Settlements

324

9.1.4 Embedding in Line of Business Processes

331

9.1.5 Settlement Processes

334

9.2 Elements of Condition Contract Processing in Detail

345

9.2.1 Customizing for Condition Contract Processing

345

9.2.2 Integration into the Condition Technique

352

9.2.3 Integration into Pricing

362

9.2.4 Status Management

368

9.3 Condition Contract Settlement

369

9.3.1 Business Volume Determination

370

9.3.2 Split Criteria

374

9.3.3 Settlement and Accrual Processing

376

9.3.4 Interaction of Pricing and Settlement Amounts

382

9.3.5 Preconfigured End-to-End Processes

384

9.4 Tips and Tricks

386

9.4.1 Business Volume

387

9.4.2 Condition Contract Enhancements

389

9.4.3 Important Reports and SAP Fiori Apps

391

9.4.4 Settlement Material and Tax Handling

393

9.4.5 External Control of Condition Contract Processing

394

9.5 Summary

396

10 Special Features of the Condition Technique in Pricing

399

10.1 Interfaces, Tables, and Interrelationships

400

10.1.1 Interfaces to Condition Tables and Master Data Maintenance

400

10.1.2 Interfaces to the Pricing Modules

400

10.1.3 Internal Structures and Tables of the Pricing Programs

401

10.1.4 Field Sequence in the Condition Table

404

10.2 Data Determination via the Condition Technique

404

10.2.1 Variant 1: Data Determination Within the Access: Use in Subsequent Access

405

10.2.2 Variant 2: Data Determination in the Access: Transfer to Document Item via Requirement

410

10.2.3 Transfer from Condition Record via Formula or Requirement

417

10.2.4 Variant 3: Transfer from Document Condition Record to Document Condition via Formula (Manipulation of the Calculation)

420

10.2.5 Variant 4: Transfer from Condition Record to KOMK via Requirement

420

10.2.6 Variant 5: Use of Data from Other Document Conditions in Formulas

421

10.3 Fields with Multiple Values

422

10.3.1 The KOMPLOOP Variant for Multiple Value Fields

422

10.3.2 The Repeating Field Variant for Multiple Value Fields

424

10.3.3 Variant Using BAdI SD_COND_LOAD_MVA

425

10.4 Summary

425

11 Important Programs for Pricing

427

11.1 The PRICING Function Module

427

11.1.1 Routine PREISFINDUNG_VORBEREITEN (Pricing Prepare)

430

11.1.2 Routine KONDITIONSVORSTEP (Condition Prestep)

431

11.1.3 Routine KONV_EINLESEN (Read KONV)

436

11.1.4 Routine XKOMV_AUFBAUEN_AUS_KOMT1 (Set Up XKOMV from KOMT1)

436

11.1.5 Routine XKOMV_AUFBAUEN_AUS_TKOMV (Set Up XKOMV from TKOMV)

438

11.1.6 Routine XKOMV_BEWERTEN (Evaluate XKOMV)

439

11.1.7 Routine XKOMV_AUSSCHLUSS (XKOMV Exclusion)

440

11.1.8 Routine XKOMV_UEBERTRAGEN_NACH_TKOMV (Transfer XKOMV to TKOMV)

440

11.2 The PRICING_COMPLETE Function Module

440

11.2.1 Types of Group Conditions

440

11.2.2 Execution of Function Module PRICING_COMPLETE During Order Processing

442

11.2.3 Program Flow of the PRICING_COMPLETE Function Module

444

11.3 The PRICING_COPY Function Module

449

11.4 Data Storage of the Pricing Result in Table PRCD_ELEMENTS

451

11.5 The PRICING_REFRESH Function Module

452

11.6 Dialog Connection/Other Function Modules

453

11.6.1 Function Module PRICING_LOAD_CONDITION_TYPS

453

11.6.2 Dialog Connection

453

11.6.3 The PRICING_DETERMINE_DATES Function Module

454

11.7 Relationship of Tables and Structures

455

11.8 Summary

456

12 System Adaptation Using Requirements, Formulas, and User Exits

457

12.1 Pricing Types

458

12.1.1 Control via Field KOMP-KAEND_TYP

459

12.1.2 Control via KOMP-KONAU_TYP

459

12.2 Requirements

459

12.2.1 Manipulation of KOMK Fields and KOMP Fields via Requirements

460

12.2.2 Overriding Pricing Types via Requirements

460

12.2.3 Example 1: Using Table TKSCHLEXCL

460

12.2.4 Example 2: Using Tables TKSCHL and TKSCHLEXCL

461

12.2.5 Processing Time of the Prestep Requirement (KOBEV Part)

462

12.2.6 Processing Time of the Definite Requirement

462

12.2.7 Behavior for Copied Conditions

463

12.3 An Example Using Formulas

463

12.4 Formulas for Pricing Conditions

468

12.4.1 Condition Base Value Formulas

469

12.4.2 Scale Base Formulas

470

12.4.3 Condition Value Formulas

472

12.4.4 Formulas for the Structure of Group Keys (Group Key Routines)

474

12.5 Special Logic for Pricing Type F in Routine XKOM_BEWERTEN

478

12.5.1 Point in Time A

479

12.5.2 Point in Time B

479

12.5.3 Point in Time C

479

12.5.4 Point in Time D

479

12.6 Pricing Result in KOMP

480

12.6.1 KOMP-FXMSG (Message Number)

481

12.6.2 KOMP-PRSOK (Pricing Is OK)

482

12.6.3 KOMP-CEPOK (Status Expected Price)

482

12.6.4 KOMP-MPROK (Status Manual Price Change)

482

12.6.5 KOMP-KOUPD (Condition Update)

483

12.6.6 KOMP-NETPR (Net Price)

483

12.6.7 KOMP-NETWR (Net Value of the Item)

483

12.6.8 KOMP-MWSBP (Tax Amount of the Item)

483

12.6.9 KOMP-WAVWR (Cost of the Item)

483

12.6.10 KOMP–BRTWR, KZWI1–KZWI6, and Others (Subtotals)

484

12.7 Control Flag XKOMV-KSTEU

485

12.8 User Exits

487

12.8.1 User Exits of Function Group V61A

487

12.8.2 User Exits of Function Group V69A

492

12.9 Enhancement of PRCD_ELEMENTS

494

12.10 Performance Aspects

494

12.11 Error Messages/Error Handling

495

12.12 Summary

496

13 Typical Practice Demands on Pricing and Their Solutions

497

13.1 Budgeting Requirements

498

13.1.1 Statistics Table S060

498

13.1.2 Statistics Table S071

499

13.1.3 Budgeting Requirements

500

13.2 Why Is the Condition Not Found?

507

13.3 Rounding

509

13.4 Prices with More Than Two Decimal Places

511

13.5 Handling Freight Surcharges

511

13.5.1 Complete Billing of Freight Surcharges with the First Delivery

511

13.5.2 No Freight Surcharges for Free Goods and Returns

512

13.5.3 Exclude Freight Surcharges When Certain Materials Are Sold Together

513

13.6 Authorizations for the Pricing Screen

515

13.7 Adding Subtotal Fields

517

13.8 Date-Dependent Maintenance of Master Data Fields

517

13.8.1 Data Determination for the Sales Document Item VBAP

518

13.8.2 Data Determination for the Sales Document Header VBAK/Business Data VBKD

520

13.8.3 Example: Substitution of a Customer Group (VBKD-KDGRP)

520

13.8.4 Pros and Cons of Data Determination

521

13.8.5 Data Determination for the Billing Documents

521

13.9 Copied Conditions and Subsequent Quantity Changes

522

13.9.1 Simple Solution for Fixed Amount Condition Types

523

13.9.2 Complex Solution for Any Condition Type

524

13.10 Increased Prices in Returns and Credit Notes

527

13.11 Key Figures for Reporting and Analysis

529

13.11.1 Implementation of a Consolidated Pricing Procedure

530

13.11.2 Key Figure 1: The Initial Value (KZWI1)

537

13.11.3 Key Figure 2: The Standard Condition Types (KZWI2)

538

13.11.4 Key Figure 3: The Customer-Specific Condition Types (KZWI3)

538

13.11.5 Key Figure 4: Manual Condition Types (KZWI4)

540

13.11.6 Key Figure 6: The Net Value (NETWR)

541

13.11.7 Key Figure 7: The Cost (WAVWR)

541

13.12 Calling External Services from Within Pricing in SAP S/4HANA

544

13.13 Condition Record Depending Requirements

545

13.13.1 Creation of a New Usage Task

546

13.13.2 Exclusion of Particular Material Groups in a Condition Record

552

13.14 Summary

559

14 Pricing in Selected Applications

561

14.1 Pricing in Sales Orders

562

14.1.1 Routine USEREXIT_PRICING_PREPARE_TKOMK

564

14.1.2 Routine USEREXIT_PRICING_PREPARE_TKOMP

565

14.1.3 Reacting to the Changes of Document Contents

565

14.1.4 Manual Triggering of New Pricing in the Sales Order

567

14.2 Pricing in Billing Documents

567

14.3 Pricing in Service Documents

569

14.4 Pricing in Purchase Orders

569

14.5 Pricing in Accounting

572

14.6 Tax Determination in Accounting

573

14.7 Pricing in Transport Management (Shipment Cost Calculation)

579

14.8 Summary

580

15 Performance and Testing

581

15.1 SAP Table Buffering

581

15.2 Prestep Conditions and Access Optimization

582

15.3 Field Sequence in the Condition Tables

585

15.4 Usage of Requirements

585

15.5 Group Conditions and Formulas

586

15.6 Peculiarities in Sales Orders and Billing Documents

587

15.6.1 Peculiarities in the Sales Order

587

15.6.2 Peculiarities in the Billing Document

587

15.6.3 Filling the Communication Structure KOMK

590

15.7 Analytical Tools

593

15.8 Testing

595

15.9 Summary

597

16 Migrating from SAP ERP to SAP S/4HANA

599

16.1 Overview of SAP S/4HANA

599

16.1.1 Database: SAP HANA

599

16.1.2 User Interface: SAP Fiori

600

16.1.3 Deployment Options

600

16.2 Differences and Similarities Between SAP ERP and SAP S/4HANA

600

16.2.1 Data Model

601

16.2.2 Configuration

606

16.2.3 System Adjustment

607

16.2.4 Master Data Maintenance

607

16.2.5 Analytics

607

16.2.6 Enhanced Access Sequence

607

16.3 Migration to SAP S/4HANA

607

16.3.1 Enhancement of Table KONV

608

16.3.2 Enhancement of Draft Tables

608

16.3.3 Enhancements of Data Elements

608

16.3.4 Interfaces

609

16.3.5 Access to Table KONV

609

16.3.6 VOFM Routines

610

16.3.7 Fields in Table PRCD_ELEMENTS That Are No Longer Supported

610

16.3.8 Access Sequences with More Than 99 Accesses

610

16.3.9 Fields VAKEY and VADAT

611

16.3.10 Currency of Sales Documents in Table PRCD_ELEMENTS

611

16.4 Summary

612

17 Pricing in SAP S/4HANA Cloud Public Edition

613

17.1 Configuration

613

17.2 New Product Hierarchy

619

17.2.1 Predelivered Content

619

17.2.2 Configuration

621

17.3 In-App Extensibility

622

17.4 Summary

624

Appendix A Condition Type Profiles

625

A.1 AMIW (Minimum Sales Order Value)

625

A.2 AMIZ (Minimum Value Surcharge)

626

A.3 AZWR (Down Payment/Down Payment Settlement)

627

A.4 DIFF (Rounding of the Total)

627

A.5 DUPL (Condition to Be Duplicated)

628

A.6 EDI1 (Customer Expected Price)

629

A.7 EDI2 (Customer Expected Value)

630

A.8 EK01 (Actual Cost)

630

A.9 EK02/EK03 (Calculated Costs)

631

A.10 GRWR (Statistical Value)

631

A.11 HA00 (Percentage Discount)

632

A.12 HB00 (Discount (Value))

633

A.13 HD00 (Freight)

634

A.14 HI02 (Hierarchy/Material Discount)

635

A.15 HM00 (Order Value)

635

A.16 IV01 (Intercompany Price)

636

A.17 KP00 (Pallet Discount)

637

A.18 KP01 (Incomplete Pallet Surcharge)

638

A.19 KP02 (Mixed Pallet Discount)

639

A.20 KP03 (Mixed Pallet Surcharge)

640

A.21 KUMU (Cumulative Condition)

642

A.22 KW00 (Group Valuation, Transfer Price)

643

A.23 MW01 (Tax Trigger)

643

A.24 MW15 (Factoring Discount Tax) (Full Tax)

644

A.25 MWSI (Output Tax, Percentage Included)

645

A.26 NETP (Rounding Difference)

646

A.27 NETW (Value of Goods)

647

A.28 NRAB (Free Goods)

647

A.29 PBBS (Base Price)

648

A.30 PBU (Price Book Determination)

648

A.31 PBUD (Price Book, Basis)

650

A.32 PBUP (Price Book, Gross Price)

650

A.33 PC00 (Profit Center Valuation Transfer Price)

651

A.34 PI01 (Intercompany Price)

652

A.35 PMIN (Minimum Price)

653

A.36 PN00 (Net Price)

654

A.37 PR01 (Price Incl. Sales Tax)

654

A.38 PR02 (Price Increased)

655

A.39 PTVO (Voucher)

656

A.40 R100 (100% Discount)

657

A.41 RL00 (Factoring Discount)

657

A.42 SKTO (Cash Discount After Tax)

658

A.43 SKTV (Cash Discount Before Tax)

659

A.44 VA00 (Variants)

659

A.45 VPRS (Cost)

661

A.46 Z902 (Data Determination Material)

662

A.47 Z905 (Material Group Discount)

663

A.48 ZBUP (Price Book, Gross Price)

663

A.49 ZDB1 (Minimum Profit Margin)

664

A.50 ZM00 (Delta to the Order Value)

665

A.51 ZPBP (Data Determination Customer)

665

A.52 ZPRA (Price (General))

666

A.53 ZPRB (Price Cust. Specific)

666

A.54 ZPRC (Price Increased)

667

A.55 ZPRD (Contract Price)

668

A.56 ZH01 (Budget Approved)

668

A.57 ZH02 (Budget Requested)

670