The new wiki link for this data flow is here:

Please update the new doc there and no longer here.

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 - SAP vs BFC RoU (Core Query)
Technical Name	BW_QRY_MVFICX01_0025
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	$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-7-46.png$
Rows/Columns	$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-8-12.png$
Value Display	$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-8-40.png$
Planning	$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-9-5.png$
Extended	$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-9-27.png$

Variables

Definitions

Variable Name	Info-object	Selection Type	Required
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

Variable Sequence

$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-10-46.png$

Filters

Object	Filter Value	Explanation
C_COMPPRS__C_MERGDAT	= #	Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

Key Figure 1

$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-14-4.png$

$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-14-31.png$

$TECHNO - BI TEAM > BW_QRY_MVFICX01_0025 /!\ Obsolete /!\ > image2021-1-26_0-14-51.png$

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 : 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)
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