You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Current »

 

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

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

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

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
      

Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No 
      

 

 

 

 

 

 

 

 

  • No labels