Description | BW COPA Netback query (Core Query) |
|---|---|
| Technical Name | BW_QRY_MVCOPA01_NETBACK_0001 |
Application | FMCO_COPA - Profitability Analysis |
Info-provider | MVCOPA01 |
Usage type | Extraction from Analysis Microsoft Excel |
Expected users | Controllers |
Workbook/Query General Description
Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display |
| |
| Rows/Columns |
| |
| Value Display |
| |
| Planning |
| |
Extended |
|
|
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| 0I_FPER | 0FISCPER | Interval / Mandatory / Manual entry | Yes | |
| Constant | 0FISCVARNT | Defaul value K4 | No | |
| Constant | 0VTYPE | Defaul value 10 | No | |
| Constant | 0CURTYPE | Defaul value 10 | No | |
| Constant | 0INFOPROV | Defaul value CRCOPA22 | No | |
| V_CPFCTR1_2_0007 | C_TECMAT__CPFCTR1_2 | Authorization / Mandatory | No | |
| V_COMPPRS_0006 | C_COMPCDE__C_COMPPRS | Authorization / Mandatory | No | |
| V_DIVISION | C_DIVISN | Optional / Selection option | No | |
| V_CUSTID_0001 | C_PAYER | Optional / Selection option | No | |
| V_C_CUSTID_0001 | C_CUSTID | Optional / Selection option | No | |
| V_SHIPID_0001 | C_SHIPID | Optional / Selection option | No | |
| V_SALEMPL | C_CUSTSA2__C_SALEMP | Optional / Selection option | No | |
| VPROD_HIER | C_MATNR2__0PROD_HIER | Optional / Selection option | No | |
| V_C_MATNR2_0001 | C_MATNR2 | Optional / Selection option | No | |
| V_C_PLANT_0010 | C_PLANT | Optional / Selection option | No | |
| V_INDOR | C_MATGR1 | Optional / Selection option | No |
Variable Sequence
Add screenshot
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Ex : Status of the trading partner | Ex : <> 1 | Ex : Exclude intercompanies |
Add screenshot if relevant
Key figures
Key Figure 1
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Text Replacement Variable
If relevant, add the text replacement rule used for the key figure
Currency Conversion
Exchange Rate Type : Ex ZRH0
Currency : Variable, or fixed currency used
Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Free/Row/Column | 0COUNTRY | Country | Country of the customer |
Cells
If you have 2 structures and special cells calculations, explain here.
Conditions
If you have conditions, explain here.
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
| Ex : Excl if <=10 | Yes/No | Sales Value | Greater Than | 10 | Ex : All Independently |
Exceptions
If you have conditions, explain here.
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ex : Red if <=10 | Yes/No | Bad 3 | Lesser Than | 10 | |