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 | SPRINT - PUR: Data Detailed Analysis (Core Query) |
|---|---|
| Technical Name | BW_QRY_MV_SPD01_0008 |
Application | SPRINT |
Info-provider | MV_SPD01 |
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 |
|---|---|---|---|---|
Country Attribut Purch. Zone | 0CPUNTRY__C_PZONE | Authorization / Selection Option | No | |
| Country Attribut Purch. Zone | C_ORIGCTY__C_PZONE | Authorization / Selection Option | No | |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider | = CR_PUAP1 = CR_PUAP2 = CR_PUAP3 |
Key figures
Total Invoiced Value (FI)
Description
Total Invoiced Value (FI) (&CRCY01&) (A)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| A | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency | |
| B | BW_CKF_MV_SPD01_0001 (C) FI Amount without Tax in Internal Currency | |
| C | ( - BW_RKF_MV_SPD01_0001 (D) + BW_RKF_MV_SPD01_0002 (E) ) * BW_CKF_MV_SPD01_0058 (F) + ( - BW_RKF_MV_SPD01_0050 (G) + BW_RKF_MV_SPD01_0052 (H) ) * BW_CKF_MV_SPD01_0060 (I) + ( - BW_RKF_MV_SPD01_0051 (J) + BW_RKF_MV_SPD01_0054 (K) ) * BW_CKF_MV_SPD01_0059 (L)
| |
| D | 0DEB_CRE_LC Debit/Credit Amount |
|
| E | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| F | - BW_RKF_MV_SPD01_0001 (D) <> 0
| |
| G | 0DEB_CRE_LC Debit/Credit Amount |
|
| H | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| I | ( - BW_RKF_MV_SPD01_0050 ) (G) <> 0 | |
| J | 0DEB_CRE_LC Debit/Credit Amount |
|
| K | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| L | ( - BW_RKF_MV_SPD01_0051 ) (J) <> 0 |
Total Invoiced Value with PO (FI)
Description
Total Invoiced Value with PO (FI) (&CRCY01&) (M)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| M | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency |
|
Total Invoiced Value without PO (FI)
Description
Total Invoiced Value without PO (FI) (&CRCY01&) (N)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| N | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency |
 |
Total Value of Tax
Description
Total Value of Tax (&CRCY01&) (O)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| O | - BW_CKF_MV_SPD01_0032 (P)
| |
| P | BW_CKF_MV_SPD01_0031 (Q)
| |
| Q |
|
Consolidated Invoice Value Tax excl.
Description
Consolidated Invoice Value Tax excl. (&CRCY01&) (R)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| R | BW_CKF_MV_SPD01_0017 (B) * FV_C_COMPCDE_K_INTRA_0001 / 100
|
Consolidated Invoice Value Tax incl.
Description
Consolidated Invoice Value Tax incl. (&CRCY01&) (S)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| S | ( BW_CKF_MV_SPD01_0017 (B) + Total Value of Tax (O) ) * FV_C_COMPCDE_K_INTRA_0001 / 100
|
Count Creditor.
Description
Count Creditor (T)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| T | BW_CKF_MV_SPD01_0052 (U) Nb Creditor | |
| U |
Aggregation by: counter of all detailed value for C_CREDID |
Count Vendor.
Description
Count Vendor (V)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| V | BW_CKF_MV_SPD01_0069 (U) Nb Vendor | |
| U |
Aggregation by: counter of all detailed value for C_MATNR2 |
Count Material
Description
Count Material (V)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| V | BW_CKF_MV_SPD01_0053 (W) Nb Material | |
| W |
|
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Cells
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||
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 | SPRINT - PUR: Data Detailed Analysis (Core Query) |
|---|---|
| Technical Name | BW_QRY_MV_SPD01_0008 |
Application | SPRINT |
Info-provider | MV_SPD01 |
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 |
|---|---|---|---|---|
Country Attribut Purch. Zone | 0CPUNTRY__C_PZONE | Authorization / Selection Option | No | |
| Country Attribut Purch. Zone | C_ORIGCTY__C_PZONE | Authorization / Selection Option | No | |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider | = CR_PUAP1 = CR_PUAP2 = CR_PUAP3 |
Key figures
Total Invoiced Value (FI)
Description
Total Invoiced Value (FI) (&CRCY01&) (A)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| A | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency | |
| B | BW_CKF_MV_SPD01_0001 (C) FI Amount without Tax in Internal Currency | |
| C | ( - BW_RKF_MV_SPD01_0001 (D) + BW_RKF_MV_SPD01_0002 (E) ) * BW_CKF_MV_SPD01_0058 (F) + ( - BW_RKF_MV_SPD01_0050 (G) + BW_RKF_MV_SPD01_0052 (H) ) * BW_CKF_MV_SPD01_0060 (I) + ( - BW_RKF_MV_SPD01_0051 (J) + BW_RKF_MV_SPD01_0054 (K) ) * BW_CKF_MV_SPD01_0059 (L)
| |
| D | 0DEB_CRE_LC Debit/Credit Amount |
|
| E | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| F | - BW_RKF_MV_SPD01_0001 (D) <> 0
| |
| G | 0DEB_CRE_LC Debit/Credit Amount |
|
| H | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| I | ( - BW_RKF_MV_SPD01_0050 ) (G) <> 0 | |
| J | 0DEB_CRE_LC Debit/Credit Amount |
|
| K | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| L | ( - BW_RKF_MV_SPD01_0051 ) (J) <> 0 |
Total Invoiced Value with PO (FI)
Description
Total Invoiced Value with PO (FI) (&CRCY01&) (M)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| M | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency |
|
Total Invoiced Value without PO (FI)
Description
Total Invoiced Value without PO (FI) (&CRCY01&) (N)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| N | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency |
|
Total Value of Tax
Description
Total Value of Tax (&CRCY01&) (O)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| O | - BW_CKF_MV_SPD01_0032 (P)
| |
| P | BW_CKF_MV_SPD01_0031 (Q)
| |
| Q |
|
Consolidated Invoice Value Tax excl.
Description
Consolidated Invoice Value Tax excl. (&CRCY01&)
(O)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| O | - BW_CKF_MV_SPD01_0032 (P)
| |
| P | BW_CKF_MV_SPD01_0031 (Q)
| |
| Q |
|
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Cells
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||
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 | SPRINT - PUR: Data Detailed Analysis (Core Query) |
|---|---|
| Technical Name | BW_QRY_MV_SPD01_0008 |
Application | SPRINT |
Info-provider | MV_SPD01 |
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 |
|---|---|---|---|---|
Country Attribut Purch. Zone | 0CPUNTRY__C_PZONE | Authorization / Selection Option | No | |
| Country Attribut Purch. Zone | C_ORIGCTY__C_PZONE | Authorization / Selection Option | No | |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider | = CR_PUAP1 = CR_PUAP2 = CR_PUAP3 |
Key figures
Total Invoiced Value (FI)
Description
Total Invoiced Value (FI) (&CRCY01&) (A)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| A | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency | |
| B | BW_CKF_MV_SPD01_0001 (C) FI Amount without Tax in Internal Currency | |
| C | ( - BW_RKF_MV_SPD01_0001 (D) + BW_RKF_MV_SPD01_0002 (E) ) * BW_CKF_MV_SPD01_0058 (F) + ( - BW_RKF_MV_SPD01_0050 (G) + BW_RKF_MV_SPD01_0052 (H) ) * BW_CKF_MV_SPD01_0060 (I) + ( - BW_RKF_MV_SPD01_0051 (J) + BW_RKF_MV_SPD01_0054 (K) ) * BW_CKF_MV_SPD01_0059 (L)
| |
| D | 0DEB_CRE_LC Debit/Credit Amount |
|
| E | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| F | - BW_RKF_MV_SPD01_0001 (D) <> 0
| |
| G | 0DEB_CRE_LC Debit/Credit Amount |
|
| H | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| I | ( - BW_RKF_MV_SPD01_0050 ) (G) <> 0 | |
| J | 0DEB_CRE_LC Debit/Credit Amount |
|
| K | K_MWSTS VAT Amnt (Loc. Crcy) |
|
| L | ( - BW_RKF_MV_SPD01_0051 ) (J) <> 0 |
Total Invoiced Value with PO (FI)
Description
Total Invoiced Value with PO (FI) (&CRCY01&) (M)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| M | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency |
|
Total Invoiced Value without PO (FI)
Description
Total Invoiced Value without PO (FI) (&CRCY01&) (N)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| N | BW_CKF_MV_SPD01_0017 (B) FI Amount without Tax Internal Currency to Target Currency |
|
Total Value of Tax
Description
Total Value of Tax (&CRCY01&) (O)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| O | - BW_CKF_MV_SPD01_0032 (P)
| |
| P | BW_CKF_MV_SPD01_0031 (Q)
| |
| Q |
|
T
Consolidated Invoice Value
Tax excl. (&CRCY01&)
Description
Total Value of Tax (&CRCY01&) (O)
Calculation rule detail
| Ratio | is composed by KF, CKF or RKF | With restriction |
|---|---|---|
| O | - BW_CKF_MV_SPD01_0032 (P)
| |
| P | BW_CKF_MV_SPD01_0031 (Q)
| |
| Q |
|
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Cells
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||