Aurelie Mazerot
Process Expert
Miriam Luttrin
General Description
This KPI display a chart with WC Receivables split by Trade Receivables, Advances received from customers and Trade Receivables by BFC Account and WC Account Sub-Type. This measures values by month which helps for future projection.  Besides another chart where it's possible to explore WC Receivables split by GBU.
 Indicator details results can be analyzed by :
BFC Account
WCAccount Sub-Type
 Date Reference:
 
  Refresh Frequency: 
Monthly (during closure on 1st to 6th 3 times per day)
KPI Name
Calculation
Account Receivables
 
Advances Received Customers
 
Trade Receivables Wd
 
WC Receivables
Total WC
Clearing year/month = Not assigned
Merging Date = #
Source Information:
Core Query:
BW_QRY_MVFIWC01_0013
BW_QRY_MVFIWC01_0015
QV Query:
QVWCAP_BW_QRY_MVFIWC01_0013
QVWCAP_BW_QRY_MVFIWC01_0015
(Non SAP - manual - conditional if absent from 13)
BW Filters:

 

Flag Obsolete Object <> 1
  Info Provider <> FISCA: Magnitude account data (cube)
PRS Comp. Interco Flag = YES

 

Flag Obsolete Object <> 1
Info Provider <> FISCA: Magnitude account data (cube)
PRS Comp. Interco Flag = YES
WC Acct Type = INVENTORY
PAYABLES
RECEIVABLES
Specific Dimensions
WC Account Sub Type
 
Customer Country
Country of the PRS Customer