Ask the BW Expert: Extract Pricing Conditions from the R/3 Module into BW

  • by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software
  • July 1, 2004
Although SAP does not offer an extractor to transfer pricing conditions from R/3 to BW, there is a solution. The author describes how R/3 subtotals offer an approach that avoid the performance issues caused by many common workarounds. He describes the function of subtotals in R/3, and demonstrates how to use them to transfer sales pricing conditions into BW.

Dear BW Expert,

I cannot find an InfoSource for pricing conditions for sales documents in the standard business content. Can you point me to an InfoSource that extracts pricing conditions for sales documents from the KONV table in R/3?

Satish Hiranandani, Hewlett-Packard


Dear Reader,

Unfortunately, the current BW system lacks the extract structures you’re looking for to transfer sales document pricing conditions from R/3. The Logistics Extraction Cockpit (LO Cockpit) does not have an extractor for the sales orders or billing document condition values contained in R/3 table KONV.

It’s common for BW practitioners to attempt to make up for the missing extraction technology by writing customer enhancement RSAP0001 (EXIT_SAPLRSAP_001) for transferring pricing conditions. This is a mistake that can cause performance issues because the system reads conditions data in a loop. In addition, EXIT_SAPLRSAP_001 is called at the time of extraction and the conditions can change by the time the data is transferred, causing reporting inaccuracies and other problems.

However, there is an effective work-around based on subtotal fields in R/3 for transferring Sales and Distribution (SD) module pricing conditions into BW. Subtotal variables are used to calculate and temporarily store important condition values during pricing calculations in fields that are accessible for extraction.

Mitresh Kundalia

Mitresh Kundalia heads the SAP practice at Quality Systems & Software (, a consulting firm specializing in SAP S/4HANA, SAP General Ledger, and complex System Landscape Optimization (SLO)-type reorganizations. Mitresh is widely acknowledged as a leading SAP expert, with multiple publications and an SAP-PRESS book to his credit. He has published more than 50 peer-reviewed articles and white papers, and he has given presentations at various SAP conferences and events. Mitresh is the chief solutions architect of General Ledger Migration Optimizer (GLMO), a leading product to accelerate and jump-start the SAP S/4HANA and SAP General Ledger initiatives; SAP Data Reorganization Optimizer (SDRO), an SLO-type product for managing complex system landscape reorganizations; and Group Currency Activation and Conversion (GCAC), a product suite to manage introduction of parallel currencies and conversion of data in a live SAP system.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.