The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work. Remove the sections that are not relevant. |
Description | CAPEX Lease B/S by Flows - AA RoU (Core Query) |
|---|---|
| Technical Name | BW_QRY_MVFICX01_0021 |
Application | Financial Accounting |
Info-provider | MVFICX01 |
Usage type | Direct execution in Analyser |
Expected users |
Workbook/Query General Description
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 |
|---|---|---|---|---|
V_0FIAA_SIM_0001 | 0FIAA_SIM | Single Value | Yes | |
V_C_COMPCDE__C_AUTHMA_0001 | C_COMPCDE__C_AUTHMA | Selection Option | Yes | |
| V_COMPPRS_0008 | C_COMPPRS | Selection Option | Yes | |
| V_C_COMPCLG__C_COMPPRS_0002 | C_COMPCLG__C_COMPPRS | Selection Option | Yes | |
| V_C_MNGAREA_0003 | C_COMPPRS__C_MNGAREA | Selection Option | Yes | |
| V_C_COMPCLG__C_FLGINT_0001 | C_COMPCLG__C_FLGINT | Single Value | Yes | |
| V_0DATE_0015 | C_COMPPRS__C_MERGDAT | Single Value | Yes | |
| V_CPFCTR1_2_0024 | CPFCTR1_2 | Selection Option | Yes | |
| V_0RTYPE_0001 | 0RTYPE | Single Value | Optional |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| C_MGN_ACC | [*] A23* | |
| C_COMPPRS__C_MERGDAT | = # | |
| 0INFOPROV | CRFIAA01 CRFIAA02 CRFIAA03 CRFIAA04 |
Add screenshot if relevant
Key figures
Calculation rule detail
NA
Text Replacement Variable
NA
Currency Conversion
Exchange Rate Type : V_0RTYPE_0001
Currency : V_CURVAR_0003
Time Reference : V_0DATE_0015
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Row | 0LOGSYS | Source Syst. | |
| Row | 0CO_AREA | CO Area | |
| Row | C_COMPCDE | Company Code (Aff.) | |
| Row | C_RECONTR__C_ASSCLAS | Asset Class | |
| Row | C_RECONTR | Contract | |
| Row | C_VENDID | Vendor | |
| Row | C_RECONTR__C_ZZVENDI | Vendor Contract ID | |
| Row | C_RECONTR__C_ZZCONV | Convergence ID | |
| Row | C_RECONTR__C_COSTCTR | Cost Center | |
| Row | C_RECONTR__C_ASSET2 | Asset | |
| Row | CPFCTR3_2 | 3 - BFC Activity 2 | |
| Row | CPFCTR1_2 | 1 - BFC GBU | |
| Free | 0FIAA_SIM | AA Posted/Sim. | |
| Free | C_TRATYP | AA Trans. Type | |
| Free | C_RECONTR__C_AT_MAN2 | Asset Main Nb | |
| Free | C_MGN_ACC | BFC Account | |
| Free | C_COMPCLG__C_BFCCOMP | BFC Comp. Code | |
| Free | C_COMPCLG | Company code (Leg.) | |
| Free | C_RECONTR__C_CONTRTY | Contract Type | |
| Free | C_DEPAREA | Deprec. Area | |
| Free | 0INFOPROV | InfoProvider | |
| Free | 0LOC_CURRCY | Local curr. | |
| Free | 0CALYEAR | Posting year | |
| Free | 0FISCPER | Posting year/Period | |
| Free | C_COMPCLG__C_COMPPRS | PRS Comp. code (Leg.) | |
| Free | C_COMPCLG__C_MNGCTRY | PRS Comp. BFC Mgt Country (Leg.) | |
| Free | C_COMPPRS__C_MNGAREA | PRS Comp. BFC Mgt Area (Leg.) | |
| Free | C_COMPCLG__0COUNTRY | PRS Comp. Country (Leg.) | |
| Free | C_COMPCLG__C_FLGINT | PRS Comp. Interco flag (Leg.) | |
| Free | C_COMPCLG__C_MERGDAT | PRS Comp. Merging date (Leg.) | |
| Free | C_WBS_EL2 | WBS Element | |
| Free | C_RECONTR__C_WBSE_TP | WBSE Type | |
| Free | CPFCTR2_2 | 2 - BFC Group of activ. |
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 | |