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

Compare with Current View Page History

« Previous Version 4 Next »

 

Description

SPRINT - PtP: Payables Analysis (Core Query)

Technical NameBW_QRY_MV_APRS1_0003

Application

SPRINT - PtP

Info-provider

MV_APRS1

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

Vendor Zone (PUR)C_VENDID__C_PZONEAuthorization / Selection OptionNo 
Zone (PUR)C_COMPCDE__C_PZONEAuthorization / Selection OptionNo 
Creditor Attribut Purch. ZoneC_CREDID__C_PZONEAuthorization / Selection OptionNo 
Source System0LOGSYSSeveral Single ValuesNo 
Global Business UnitC_SUBACT2__CPFCTR1_2Authorization / SelectionNo 
Company codeC_COMPCDEAuthorization / SelectionNo 
SiteC_PLANT__C_PPSITESelection OptionNo 
PlantC_PLANTAuthorization / Selection OptionNo 
DomainC_DOMAINSelection OptionNo 
SegmentC_SEGTSelection OptionNo 
Purchase OrganisationC_PUR_ORGSelection OptionNo 
Purchasing GroupC_PUR_GRPSelection OptionNo 
Invoice Payment TermsC_PMNTTRMSelection OptionNo 
Creditor ClassC_VENCLSSeveral Single ValuesNo 
Vendor Class C_VENDID__C_VENCLSSeveral Single ValuesNo 
Posting Date0CALDAYIntervalNo 
Clearing Date0CLEAR_DATEIntervalNo 
Account Document Number0AC_DOC_NOSelection OptionNo 

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider

= CR_PUAP1

= CR_PUAP2

= CR_PUAP3

= CR_RDSF1

= CR_RDSF2

 
Creditor<> [P000000000 - PZZZZZZZZZ] 
Creditor Class<> S 
Creditor Account Group

<> KRED

<> PERS

<> Z012

<> Z013

<> ZSET

<> ZZCP

<> ZZPE

 
Vendor Class<> S 

Key figures

 

2.06 Nb Invoices Posted

Description

2.06 Nb Invoices Posted = Sum of posted doc FI

Calculation rule detail

Ratio
is composed by KF or CKF or RKF
With Restriction
A

BW_RBK_MV_APRS1_0012 (A1)

Posted Document FI - RHO

A1

BW_CKF_MV_APRS1_0007 (D)

Nb of Accounting Doc. by Company

B

BW_RBK_MV_APRS1_0005 (B1)

Posted Document (FI - RCS)

B1

BW_CKF_MV_APRS1_0007 (D)

Nb of Accounting Doc. by Company

C

BW_RBK_MV_APRS1_0011 (C1)

Posted Document (FI - PF1)

C1

BW_CKF_MV_APRS1_0007 (D)

Nb of Accounting Doc. by Company

 

D

BW_CKF_MV_APRS1_0006 (D1)

Nb of Accounting Document

Aggregation → Summation on C_COMPCDE

 
D1

 

 

2.07 % Paperless Invoices

Description

2.07 % Paperless Invoices = Reverse the percentage of documents scanned automatically to the total number of documents posted

Calculation rule detail

Ratio
is composed by KF or CKF or RKF
With Restriction
   
   
   
   
   
   

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
    

Conditions

 

Condition Name

Active

By default

Key Figure

(Structure)

Operator
Value
Characteristic Assignement
      



  • No labels