View Source

Overview

The PPS - Premier Pilotage Sales application deals with sales data extracted from SAP SD module at a very detailed level including sales orders, deliveries, shipments and invoices.

TECHNO - BI TEAM > PPS > image2016-5-31 14:23:36.png

Database Diagram

Main Fact Tables

TECHNO - BI TEAM > PPS > image2016-5-23 9:3:31.png

Main Master Data

TECHNO - BI TEAM > PPS > image2016-5-23 9:40:46.png

Universe Documentation

PP_F1_E (UNV) - Premier Pilotage Sales frozen universe in UNV version

This version of PPS universe has been kept for compatibility reasons in order to support Non-migrated WebI reports from BOXI in personal folders.

PP_F1_E (UNX) - Premier Pilotage Sales in UNX version

The UNX version of PPS universe is being updated regularly.

Data Foundation

Business Layer

Link to UpToDate documentation of universes (from 360 eyes)