| KPI | Source System | BI System | Comment | Core Query | Qlikview Query |
|---|
Order Book | WP1 |
& PF1 | BW SD (Global Sales) |
BI4 PPS | All GBUs using WP1 or PF1 (except |
NovecarePepol) | Sales Orders:BW_QRY_MVSDSO41_SD004PO Orders:BW_QRY_MVSDSO47_001 | Sales Orders:QVSD_BW_QRY_MVSDSO41_SD004PO Orders (WP1 only):QVSD_BW_QRY_MVSDSO47_001 |
ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 | ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 |
Order Book | WP1 (Pepol) | BI4 PPS |
Only Novecare (to deal with extrapolation)Pepol | ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 |
QV_NOVECARE__BOOK_WW_NOVPPS_PPE_R001Order Book | PF1 | BW SD (OBAS) | | BW_QRY_MVSDSO01_SD004 | QVSD_BW_QRY_MVSDSO01_SD004 (Sales Orders)BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 |
Sales | WP1 & PF1 | BW P&L COPA | Except |
Chemlogic and Pepol | BW_QRY_MVCOPA01_0004 | QVSBS_BW_QRY_MVCOPA01_0004 |
Sales |
Non-SAPFor , Chemlogic and Bangpoo | SALES TREND & MANAGEMENT REPORT with CONTRIB-MARGIN (period) CWWPPE_R001 | QV_SALES RESULTS_CWWPPE_R002 |
Sales | Manual xls | XLS | Non-ERP Company: |
Solvay & CPC Barium Strontium MonterreyGBU Special ChemComposite Materials | | |
Budget & BFR |
SAFIR | SAFIRQuickload Uploads | BW SD (Global Sales) | Available to GBUs that load budget and BFR |
into BW | BW_QRY_MVSDSO61_0001 | QV_BW_ |
OBJECTIVESCWWSAFIR0010001 |
Overdue & DSO | PRS (WP1 & PF1) | BW FIAR | Overdue & DSO | BW_QRY_MVFIAR01_0001 | QVSBS_BW_QRY_MVFIAR01_0001 |
Overdue & DSO | PRS (WP1 & PF1) | BW FIAR | Aged Overdue | BW_QRY_MVFIAR01_0006 | QVSBS_BW_QRY_MVFIAR01_0006 |
Sold & Pending Orders | WP1 & PF1 |
BO PPSGlobal Sales | All Open Orders ( |
no time limitation)M, M+1, M+2 only, to be enhanced soon) | BW_QRY_MVSDSO41_SD011 |
| QV_LIST_OF_OPEN_ORDERS_CWWPPS |
|
Sold & Pending Orders | WP1 & PF1 |
BO PPSGlobal Sales | All Invoiced Orders during the current month |
LIST OF INVOICESCWWPPSR001QV_LIST OF INVOICES_CWWPPS_R001MVSDSO41_SD011 |
|
CCR | WP1 | BO PPS | Order Lines | | QV Complaint CRM by GBU CWWPPS 001 |
CCR | PF1 | BW SD (OBAS) | Order Lines | BW_QRY_DBSDSO14_0001 | QVSD_BW_QRY_DBSDSO14_0001 |