Basic Information

BW ServerEx : WBP
ApplicationEx : IM - Stocks
Query NameEx : BW - Physical inventory coverage rate (Core Query)
Query Technical Name Ex : BW_QRY_CUB_IC001_0028
Core/Specific ScopeCore or if the query is specific then the perimeter (Ex : Brazil Specific)
Specific ReasonIf the query is not core, explanation on why it's specific (Ex : Special Tax system in India...)
Provider Name Ex : Material Stock MPR_IC002
Usage type Direct execution in Analyzer / Workbook broadcast / QV / webtemplate...
Expected users Ex : Site controller

Purpose of this query

Explain the scope, purpose and history of the query. Explain if possible what is the typical use and users. 

Variables screen

 

Variable NameAuthorization ObjectDescription
Ex : Company Code Yes/No - Is this the object on which the authorization is based? Ex : Company Code that is receiving the goods
   

 

Filters

ObjectFilter ValueExplanation
Ex : Status of the trading partner Ex : <> 1 Ex : Exclude intercompanies
   

Characteristics

Characteristic NameCharacteristic codeExplanation
Country 0COUNTRY Country of the customer
   
   
   

Key Figures

Key Figure 1

Description

Text/name of the variable and explanation

Calculation rule detail

Quantity x Price

Dynamic naming of the key figure

If relevant, add the text replacement rule used for the key figure. Ex : <Fiscal Period> Quantity

Currency Conversion

  • Exchange Rate Type : Ex ZRH0   

The full description of each exchange rate type can be found in the Exchange rates page.

  • Currency : Variable, or fixed currency used
  • Time Reference : Current date / Based on infoobject X / Variable

Unit Conversion

Unit : Variable or fixed unit

The full explanation on how the quantity conversion works can be found in the Quantity Unit Conversion page.

Cells

If you have 2 structures and special cells calculations, explain here.

Conditional Formatting

See how to use in the Formatting page.

Condition NameRule
Ex: Bulk OnlyEx : Only show if Gross Qty = Net Qty
  

FAQ

Question : Ex : Quantity is seems incorrect when displaying the storage location in rows. 

Answer to the question