Purpose
This page is created to clarify the behavior behind Net and Total Value calculation in POWL.
Overview
For Shopping Cart and Purchase Order POWL Queries column Net Value and Total Value are available in the result list. The value that is displayed under this column is determined by different logic based on Business Object type (SC, PO) and item type (Material, Service and Limit).
Material and Service
| Column Name | Value in SC and PO POWL (Feeder SAPSRM_FEEDER_SC/PO) |
|---|---|
| Net Value (NET_VALUE) | Field VALUE in table BBP_PDIGP |
| Total Value (TOTAL_VALUE) | Field TOTAL_VALUE in table BBP_PDHGP |
Limit
| Column Name | Value in SC POWL (Feeder SAPSRM_FEEDER_SC) |
|---|---|
| Net Value (NET_VALUE) | Field LIMIT in table BBP_PDLIM (LIM_TYPE = G) |
| Total Value (TOTAL_VALUE) | Field TOTAL_VALUE in table BBP_PDHGP |
Debugging Guide
Set a breakpoint in the following Methods:
- Shopping Cart - EXECUTE_SEARCH_INTERNAL_ITEM of class /SAPSRM/CL_SRC_SRV_DB_SC
- Purchase Order - EXECUTE_SEARCH_INTERNAL_ITEM of class /SAPSRM/CL_SRC_SRV_DB_PO
If you perform a search in POWL, the relevant breakpoint will stop. At the end of this Method, system loops at the found GUIDs and enriches the data of the result.
In Method GET_RESULT, system populates the relevant value for column Net Value. The field Total Value is already populated here from the header data during search.
In case of Material or Service lines, system populates field Net Value using the following logic.
In case of Limit line, a different logic is called to populate the data from field LIMIT (Value Limit).
In case of PO and HANA search, Method GET_RESULT is not called. In this case those values will be populated that are stored in table /SAPSRM/PO_POWL.
Related Content
Related SAP Notes/KBAs
SAP KBA: 2421729 Total Value column shows the sum of the item values in POWL