(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

Technical Documentation - Procurement - SPRINT report 

Please update the new doc there and no longer here.

(warning)    (warning)     (warning)     (warning)

Description

SPRINT - PUR: Data Detailed Analysis (Core Query)

Technical NameBW_QRY_MV_SPD01_0008

Application

SPRINT

Info-provider

MV_SPD01

Usage type

Direct execution in analyser

Expected users


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

TabScreenshotComment
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. ZoneC_ORIGCTY__C_PZONEAuthorization / Selection OptionNo
Vendor Zone (PUR)C_VENDID__C_PZONEAuthorization / Selection OptionNo
Creditor Attribut Purch. ZoneC_CREDID__C_PZONEAuthorization / Selection OptionNo
Source system0LOGSYSCustomer Exit / Several Single ValuesNo
Calendar Month/Year0CALMONTHIntervalYes
CompanyC_COMPCDEAuthorization / Selection OptionNo
PRS Company codeC_COMPPRSSelection OptionNo
Company Zone (Pur)C_COMPCDE__C_PZONESelection OptionNo
Company Zone (FC)C_COMPCDE__C_ZONEAuthorization / Selection OptionNo
Company CountryC_ORIGCTYSelection OptionNo
Company ScopeC_COMPCDE__C_PSCOPESelection OptionNo
Company Consolidation MethodC_COMPCDE__C_CSMETHSelection OptionNo
PlantC_PLANTAuthorization / Selection OptionNo
Plant CountryC_PLANT__0COUNTRYSelection OptionNo
Plant SiteC_PLANT__C_PSITESelection OptionNo
Global Business Unit C_SUBACT2__C_PFCTR1_2Authorization / Selection OptionNo
FunctionC_FUNCT_2Selection OptionNo
CreditorC_CREDIDSeveral Single ValuesNo
Creditor Account GroupC_CREDID__0ACCNT_GRPVSelection OptionNo
Creditor CountryC_CREDID__0COUNTRYSelection OptionNo
Creditor ClassC_CREDID__C_VENCLSSelection OptionNo
Creditor Group (PUR) CodeC_CREDID__C_GRPPURSelection OptionNo
Creditor PRSC_CREDID__C_VENDPRSSelection OptionNo
Creditor SegmentC_CREDID__C_SEGTSelection OptionNo
VendorC_VENDIDSeveral Single ValuesNo
Vendor PRS C_VENDID__C_VENDPRSSelection OptionNo
Vendor Account GroupC_VENDID__0ACCNT_GRPVSelection OptionNo
Vendor CountryC_VENDID__0COUNTRYSelection OptionNo
Vendor Group (PUR) CodeC_VENDID__C_GRPPURSemection OptionNo
Vendor ClassC_VENDID__C_VENCLSSemection OptionNo
Vendor from PO DomainC_VENDID__C_DOMAINSelection OptionNo
Vendor Segment C_VENDID__C_SEGTSelection OptionNo
MaterialC_MATNR2Selection OptionNo
Material Product (PUR)C_MATNR2__C_PURPRODSelection OptionNo
Material Material GroupC_MATNR2__C_MAT_GRPSelection OptionNo
Material TypeC_MATNR2__C_MAT_TYPSelection OptionNo
Value ChainC_MATNR2__C_PRODGRPSelection OptionNo
Material First Use DateC_MATNR2__C_FUDTSelection OptionNo
Document TypeC_DOCTYPCustomer ExitNo
WC Account type0GL_ACCOUNT__C_GL_TYPESelection OptionNo

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider

= CR_PUAP1

= CR_PUAP2

= CR_PUAP3

Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

Total Invoiced Value (FI)

Description

Total Invoiced Value (FI) (&CRCY01&) (A)

Calculation rule detail

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith 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

Ratiois composed by KF, CKF or RKFWith restriction
V

BW_CKF_MV_SPD01_0053 (W)

Nb Material


W



Currency Conversion

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
Free0LOGSYSSource System
Free0CALDAYCalendar Day
Free0CALMONTHCalendar Month/Year
FreeC_COMPCDECompany
FreeC_ORIGCTYCompany Country
FreeC_CREDID__0COUNTRYCreditor Country
FreeC_PLANT__C_PSITEPlant Site
FreeC_PLANTPlant
FreeC_PUR_GRPPurchasing Group
FreeC_PUR_ORGPurchasing Organization
FreeC_DOMAINDomain
FreeC_SEGTSegment
FreeC_CREDIDCreditor
FreeC_CREDID__C_DOMAINCreditor Domain
FreeC_CREDID__C_SEGTCreditor Segment
FreeC_CREDID__C_VENDPRSCreditor PRS
FreeC_CREDID__0ACCNT_GRPVCreditor Account Group
FreeC_CREDID__C_VENCLSCreditor Class
FreeC_CREDID__C_VENDVIPCreditor VIP
FreeC_MATNR2Material
FreeC_MATNR2__C_MAT_TYPMaterial Type
FreeC_AGRNBRSAP Contract
Free0DOC_NUMPO Number
FreeC_COSTCTRCost Center
FreeC_COSTCTR__C_FUNCT_2Function
FreeC_VENDIDVendor
FreeC_WBS_EL2WBS Element
FreeC_PMNTTRMInvoice Payment Terms
FreeC_CREDID__C_FLGINTInternal Partner Flag
FreeC_MATNR2__C_PRODGRPMaterial Value Chain (PUR)
FreeC_SUBACT2__CPFCTR1_2Global Business Unit
FreeC_COMPCDE__C_ZONECompany Zone (FC)
FreeC_MATNR2__C_MAT_GRPMaterial Material Group
FreeC_PO_ITM__C_ORICDEPO Origin Need
FreeC_COMPCDE__C_PZONECompany Zone (Pur)
FreeC_WBS_EL2__C_WBSE_TPCapex flag
Free0PROFIT_CTRProfit Center
FreeC_COMPCDE__C_CSMETHCompany Consolidation Method
FreeC_VENDID__C_VENDPRSVendor PRS
Free0CALYEARCalendar Year
FreeC_PO_ITM__C_TYPCTSAP Contract SWAP Type
Free0CALQUARTERCalendar Quarter/Year
Free0AC_DOC_NOAccounting Document
FreeC_COMPCDE__C_PSCOPECompany Scope
FreeC_VENDID__0ACCNT_GRPVVendor Account Group
FreeC_VENDID__C_VENCLSVendor Class
FreeC_VENDID__C_DOMAINVendor Domain
FreeC_VENDID__C_SEGTVendor Segment
FreeC_PLANT__0COUNTRYPlant Country
FreeC_MATNR2__C_FUDTMaterial First Used Date
FreeC_MATNR2__C_PURPRODMaterial Product (PUR)
FreeC_CREDID__C_GRPPURCreditor Group (PUR) Code
FreeC_VENDID__C_GRPPURVendor Group (PUR) Code
FreeC_COMPCDE__C_COMPPRSPRS Company
Free0DOC_CURRCYInternal Currency
Free0LOC_CURRCYOriginal Currency
FreeC_MAT_GRP__C_MATPUR2Realigned Material Group
Free0GL_ACCOUNTG/L Account
FreeC_DOCTYPAccnt. document type
FreeC_SUBACT2Sub-Activity 2
Free0GL_ACCOUNT__C_GL_STYPGL Account Sub Type
Free0GL_ACCOUNT__C_GLFAMILGL Acc. BFC Family
Free0GL_ACCOUNT__C_GL_TYPEGL Acc WC Type
FreeC_MAT_GRPPO Material Group
FreeC_MAT_GRP__C_SEGTPO Material Group Segment
FreeC_MATNR2__C_MAT_AT1Material Att 1 (PUR)
FreeC_MATNR2__C_MAT_AT2Material Att 2 (PUR)
FreeC_VENDID__C_VND_AT1Vendor Att 1 (PUR)
FreeC_VENDID__C_VND_AT2Vendor Att 2 (PUR)
FreeC_CREDID__C_VND_AT1Creditor Att 1 (PUR)
FreeC_CREDID__C_VND_AT2Creditor Att 2 (PUR)

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)

OperatorValueCharacteristic 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

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10