Page tree
Skip to end of metadata
Go to start of metadata

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 NameValue 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 NameValue 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