Versions Compared

Old Version 2

changes.mady.by.user Karen Oppong

Saved on Sept 28, 2023

compared with

New Version Current

changes.mady.by.user NATTATH-ext, Jayaram

Saved on Sept 06, 2024

Key

This line was added.
This line was removed.
Formatting was changed.

Table of Contents

outline	true

1.0

Access Management

Role menu for all project costs queries

Panel

borderColor	#ffffff
titleColor	#ffffff
titleBGColor	#009EE0
title	Roles & Access

List of application role + menu role and explanation if we have several applications role with specials rules.

Role Code	Role Description	Explanation
ZR_RCS_CA_

M09

M072

PS - Project Costs

TR - Transportation costs New	role menu
ZBI_RCS_

TR_

A02Project Costs and Structures Analysis

A08	New Transport Costs Analysis - End User

roleApplication

Role

End User rights

role menu for TIERS, gives access to

infoproviders of Infoarea "AREA_PSCO"

BI Analysis Authorization "ZBI_PS" ("*" for authorization objects not relevant for the application)

ZBI_RCS_CO_A21

CBS Project costs Reporting Analysis - End User role

Application Role:

End User rights

gives access to infoproviders of Infoarea "AREA_F_CO_CBS_PS"

Gives access to multiprovider:MPR_PS014

BI Analysis Authorization "ZBI_CBS_PC"

all cubes under infoarea IA_SD_TR*

Authorization Object ZBI_TR2 / Authorization on Company Code

This role has to be used with the role menu transportation costs

ZP2_RCS_TR_A08

Transportation Costs Analysis TIERS - End User Role

Linked to authorization role ZP2_TR2

NB: The role menu ZR_RCS_ALL_MENU "Role composite with all role Menu and perimeters" gives access to all role menu. When asking for a new role menu, do not forget it is added to that one.

NB: ZBI_RCS_TR_A02 & ZR_RCS_TR_A02 are obsolete

Image Added

Panel

borderColor	#ffffff
titleColor	#ffffff
titleBGColor	#009EE0
title	Authorization Objects

List of authorization objects mandatory for the application.

Authorization object	Explanation

0COMP_CODE;

C_COMPCDE

;

PMORDER

SHCSTI2__

0COMP_CODECompany, role:

C_COMPCDE

ZTOUTCAP01 => All Companies "Solvay"

ZR_*_CA_P01

0PROFIT

ZR_

CTR

ZFR3_CA_P01 => Analysis company Rhodia Opérations ( ZFR3)

CPFCTR1_2

; 0PROFIT_CTR__C_PFCTR1;CPFCTR1_2;C_AGRITM__CPFCTR1_2;
C_ASSET2__C_PFCTR1;C_ASSET__C_PFCTR1;C_MATPLNT__CPFCTR1_2;
C_MATPLNT__C_PFCTR1;C_MATPNT2__CPFCTR1_2;C_PFCTR1;
C_PMORDER__C_PFCTR1;C_PMORDR__C_PFCTR1;C_PRDEQUI__CPFCTR1_2;
C_RECONTR__CPFCTR1_2;C_RESP_CC__CPFCTR1_2;C_SUBACT2__CPFCTR1_2
C_TECMAT__CPFCTR1_2;C_WBS_EL2__CPFCTR1_2;C_WBS_EL2__C_ZSECT;C_WBS_ELE__CPFCTR1_2;
C_WBS_ELE__C_ZSECT;C_ZSECT

GBU, role: ZR_*_CA_P05

C_FAMIL;C_WBS_EL2__C_FAMIL;C_WBS_ELE__C_FAMIL

Family, role: ZR_*_CA_P04

	GBU, role: ZR_*_CA_P05
C_COMPCDE__C_AUTHMA	Authorization scope role: ZR_*_CA_P00

See also file maintained by Authorization team :

BW Catalog of Roles: Authorization catalog
BW Authorization: BW Authorizations

DataFlow

Overview

Embedded Google Drive File

migrated	true
url	https://docs.google.com/presentation/d/1vGhaf14nZ4In_iudZ3OURh0uiuE-1cwk1V5Teebdpus/edit?usp=sharing
fullwidth	true
height	600

Embedded Google Drive File

migrated	true
url	https://docs.google.com/presentation/d/1RtpPCUE7RHx0ZNlRVhTxEcOfKgzg-l7uJQ6BzXXik3U/edit?usp=sharing
fullwidth	true
height	600

Technical Rules on Workbench

Rules & Explanations

Main documentation:

Preparation

Kickoff

Embedded Google Drive File

migrated	true
url	https://docs.google.com/presentation/d/1EcBnprCcrjUyFV1L4KDWq-QoeQmvY4hrPvYL2EJPgO4/edit#slide=id.p4
fullwidth	true
height	600

Project Quality Plan

Embedded Google Drive File

migrated	true
url	https://drive.google.com/file/d/0B46EYtJzPsZ-YTRHRlhTWEtWQW8/view?resourcekey=0-_MW23kVWMZOTSPCXYM4u4Q
fullwidth	true
height	600

Design Validation

Embedded Google Drive File

migrated	true
url	https://docs.google.com/presentation/d/1buvi6M5KrDk5Ll3917sEr-52ujLgT5ZY5R0_Ws94gpM/edit#slide=id.p4
fullwidth	true
height	600

Design

Functional Specification

Embedded Google Drive File

migrated	true
url	https://docs.google.com/document/d/1EByARR5UOqBQ9ZOP6Xwf_Ol7ylPXrcpVo0P1iK6287c/edit
fullwidth	true
height	600

Map of Datasources

Embedded Google Drive File

migrated	true
url	https://docs.google.com/spreadsheets/d/1JNOj5lzgzK9U3AGYjxwxdNH_vtgRG3KM3ZsEoEWkVQU/edit
fullwidth	true
height	600

Profiles Management

Embedded Google Drive File

migrated	true
url	https://docs.google.com/presentation/d/1UAsa0rCdnEabItHTulE6VKo95-txq46zpiLj_xBYU2Y/edit#slide=id.gc3efd81a5_0_0
fullwidth	true
height	600

Queries Definition

Embedded Google Drive File

migrated	true
url	https://docs.google.com/spreadsheets/d/1cSJqjkLnZ-OX5pOLV8UxfZDIUuUW8EH2D8TLUjTjzas/edit#gid=0
fullwidth	true
height	600

Technical documentation

Embedded Google Drive File

migrated	true
url	https://docs.google.com/document/d/1E9_Z1BWfKZcLS9d_l6kSHGs84LhLORv2Dqt61xAqcu8/edit
fullwidth	true
height	600

Deployment

E Learning

Embedded Google Drive File

migrated	true
url	https://drive.google.com/file/d/0B46EYtJzPsZ-MGpzQjFmRnB0c0k/view?resourcekey=0-jc-PGiMleMqlk7oOGgemkQ
fullwidth	true
height	600

Rule to take the GBU code

Read the field C_SUBACT2 (profit center) from master data C_MATPNT3 using plant and material as key.

  SELECT  logsys
              /bic/c_plant
              /bic/c_matpnt3
              /bic/c_pfctr1
              /bic/c_subact2
              co_area
          INTO  TABLE itb_matpnt2
          FROM  /bic/pc_matpnt3
         FOR ALL ENTRIES IN itb_dpsdtr02
          WHERE /bic/c_plant   = itb_dpsdtr02-c_plant
            AND /bic/c_matpnt3 = itb_dpsdtr02-c_matpnt2
            AND logsys         = itb_dpsdtr02-logsys
            AND objvers        = 'A'.

  READ TABLE itb_matpnt2 INTO itb_matpnt2_w
          WITH TABLE KEY logsys    = <result_fields>-logsys
                         c_plant   = <result_fields>-/bic/c_plant
                         c_matpnt2 = itb_dpsdtr02_w-c_matpnt2.
        IF sy-subrc = 0.
          <result_fields>-/bic/c_pfctr1 = itb_matpnt2_w-c_pfctr1.
          <result_fields>-/bic/c_subact2 = itb_matpnt2_w-c_subact2.
          <result_fields>-co_area   = itb_matpnt2_w-co_area.

Rule to determine the partner code

  IF itb_dpsdtr02_w-c_vendid  IS NOT INITIAL.
          <result_fields>-/bic/c_pnty3py     = 'VEND'.
          <result_fields>-/bic/c_3rparty  = itb_dpsdtr02_w-c_vendid.
          SHIFT <result_fields>-/bic/c_3rparty LEFT DELETING LEADING '0'   .
        ENDIF.
        IF itb_dpsdtr02_w-c_shiptid   IS NOT INITIAL.
          <result_fields>-/bic/c_pnty3py     = 'CUST'.
          <result_fields>-/bic/c_3rparty  = itb_dpsdtr02_w-c_shiptid.
          SHIFT <result_fields>-/bic/c_3rparty LEFT DELETING LEADING '0'   .
        ENDIF.

Rule to determine the departure and destination code

IF itb_dpsdtr02_w-c_dpnode2 IS NOT INITIAL.

          <result_fields>-/bic/c_pntydp   = 'NODE'.
          <result_fields>-/bic/c_pntdp2    = itb_dpsdtr02_w-c_dpnode2.
        ENDIF.
        IF itb_dpsdtr02_w-c_dpshpn2  IS NOT INITIAL.
          <result_fields>-/bic/c_pntydp   = 'SHIPP'.
          w_shppnt   = itb_dpsdtr02_w-c_dpshpn2.
          <result_fields>-/bic/c_pntdp2    = w_shppnt.
        ENDIF.
        IF itb_dpsdtr02_w-c_dpplnt2  IS NOT INITIAL.
          <result_fields>-/bic/c_pntydp   = 'PLANT'.
          <result_fields>-/bic/c_pntdp2    = itb_dpsdtr02_w-c_dpplnt2.
        ENDIF.
        IF itb_dpsdtr02_w-c_dpvend2   IS NOT INITIAL.
          <result_fields>-/bic/c_pntydp   = 'VEND'.
          <result_fields>-/bic/c_pntdp2    = itb_dpsdtr02_w-c_dpvend2.
          SHIFT <result_fields>-/bic/c_pntdp2 LEFT DELETING LEADING '0'.
        ENDIF.
        IF itb_dpsdtr02_w-c_dpcust2   IS NOT INITIAL.
          <result_fields>-/bic/c_pntydp   = 'CUST'.
          <result_fields>-/bic/c_pntdp2    = itb_dpsdtr02_w-c_dpcust2.
          SHIFT <result_fields>-/bic/c_pntdp2 LEFT DELETING LEADING '0'.
        ENDIF.

Rule to determine the reference month

  IF itb_dpsdtr01_w-dtcomplact IS NOT INITIAL. " (shipment completion date)
          <result_fields>-rstt_rmnth = itb_dpsdtr01_w-dtcomplact(6).
        ELSE.
          IF itb_dpsdtr01_w-dtcompl_pl IS NOT INITIAL.
            <result_fields>-rstt_rmnth = itb_dpsdtr01_w-dtcompl_pl(6).   " (shipment planned completion date)
          ELSE.
            <result_fields>-rstt_rmnth = itb_dpsdtr01_w-erdat(6).   " (shipment creation date)
          ENDIF.
        ENDIF.

Unit conversions

The Unit conversion is done in the Bex queries (Quantity Conversion Type), after user chooses the unit conversion on reports

Transactionnal data are stored in sales unit

if base unit / po unit is managed in dimension MASS, conversion within table T006 works well
if base unit / po unit is not managed in dimension MASS, conversions for KG/LB/TO have to be managed on ERP side (MM03 / Alternative Conversion).

There are many "special" units on Solvay ERP, ie: 1KG, 1TN, VKG, KRE,

Important :

Quantities are not converted when loading data, and are not store into cubes (The conversion is done when running the report)

So, if a conversion is missing for a material ask the material referent to

1- manage the conversion on ERP Side by managed the material master (MM03) / unit of measure tab

2- the day after, when the DSO UOMCMAT2 is filled, the conversion is applied in the reports. It applies to whole data without any reloading.

The conversion type created by TIERS queries is QCT_MATNR4 (see below the setup for it).

Image Added

BW Quantity Conversion

BW Updated Qty Unit by Material

Currency conversion

The reports are all based on amounts in Local Currency Those amounts come directly from RCS/PF1. If user selects a currency in the prompt the query will convert, otherwise it will return the values in local currency.

The X rate considered is the Daily Month Average (M) rate (table managed by finance team, source ECB - European Central Bank) based on Document creation date.

See private documentation on BW Currency Conversion

The current available rates applied to ALL data (even past data) independently of the date.

We applied conversion type Curr Conv based on M shpcst creation - CTK_MTIERS (see setup below) :
Image Added

Image Added

BW Currency Conversion

Determination of manual price change of shipment cost

The manual price change (C_MPROK1) is from the Shipment cost sub-items as below:
VFSI - MPROK in PF1 and WP1

Image Added

Dependencies with other applications

It shares extractors (2LIS_08TRTK, 2LIS_08TRTLP, 2LIS_08TRFKZ) with the legacy TR application for WP1 and PF1.
It was created some master data in order to have the attributes shared with several applications: shipment doc, delivery doc and shipment cost item doc.
Data is consumed by Qlikview dashboard. The loadings in QV are daily. It runs a fixed scheduled, the loadings must be finished when the next start.
There is an integration with SPRINT (purchase schedule lines) to store there the service purchases (freight)
There are links between TIERS and Value Stream and Industrial dashboard (both for Rhodia legacy)

There is an integration with SPRINT to store the profit center (C_SUBACT2) for purchase services

Rhodia PO schedule lines (DB_PUSL1)Image Added

Solvay PO schedule lines (DB_PUSL2)Image Added

There is an integration with Value Stream to store there the cost of transports

Rhodia CUB_VS (value stream)
Image Added

There is an integration with Industrial dashboard to store there the cost of transports

Rhodia CUB_DIPL (industrial dashboard)

Image Added

Info areas

Image Added

Master Data

Image Added

Propagation Layer

Image Added

Business Layer

Image Added

Reporting Layer

Image Added

Virtual Layer

Image Added

Multi provider

1 - MVSDTR01 - Shipm & Delivery & Cost & Cond & PO/Inv (Sol&Rho)

Image Added

Data Flow

Image Added

Dimensions

Image Added

Key figures

Image Added

2 - MVSDTR02 - TR Vir: Shipment Events (Solvay & Rhodia)

Data Flow

Image Added

Dimensions

Image Added

Key figures

Image Added

Main KPI calculations

Image Added

Main functionalities

Main datasources based on SAP tables

2lis_08TRTK – Shipment Header
2lis_08TRTLP – Shipment & Deliveries
2lis_08TRFKZ – Shipment Costs
DTS_TRKONV – Shipment Conditions
DTS_TRFI_ESSR – Invoices & Purchases History
DTS_TRFI_VFKP – Invoices & Purchases Issues

Main dimensions for the data

C_POINT2 – Connection Point (it can be a customer, vendor, plant, node point or shipping point)
C_3RPARTY – 3rd Party (Cust / Vend) - it cab be a vendor or a customer
C_ROUTE – Route
C_SHIPNU2 – Shipment Number
C_SHCSTI2 – Shipment Cost item
C_DELITM2 – Delivery Item
C_CNDTYP2 – Condition Type
C_SHPTP_2 – Shipping Type
C_SHPMTP2 – Shipment Type
C_SHCITTY – Item category shipment costs
C_VTADD01 – Ship. Shipping Line
C_SHIPCD2 – Shipping conditions
0TRZONE – Transportation Zone
C_TRPPNT2 – Transportation planning point
C_VSTGA – Event Reason f.deviation
C_EVTTYP – Event Type

Reporting

Query	Name
BW_QRY_MVSDTR01_0010	BW - Shipment costs detailed analysis TIERS (Core Query)
BW_QRY_MVSDTR01_0011	BW - Accrual Costs vs Invoice analysis TIERS (Core Query)
BW_QRY_MVSDTR01_0012	BW - Shipment status and events TIERS (Core query)
BW_QRY_MVSDTR01_0013	BW - CO² Emissions TIERS (core query)
BW_QRY_MVSDTR01_0014	BW - Shipment costs analysis by delivery ( for DYNASYS)
BW_QRY_MVSDTR01_0020	BW - Forward Reject Services Analysis (Core query)
BW_QRY_MVSDTR01_0021	BW-Overwiew of DG Shipment status and events-TIERS
BW_QRY_MVSDTR01_9000	BW - TR - ZV23 Vehicle Control at Production Plant
BW_QRY_MVSDTR01_9998	BW - Shipment costs detailed analysis Vendors TIERS
BW_QRY_MVSDTR01_9999	BW - Shipment costs detailed analysis TIERS
BW_QRY_MVSDTR01_BCST_0001	BW -Shipment costs detailed analysis TIERS Broadcast Query
BW_QRY_MVSDTR01_BCST_0002	BW- Shipment Status and Events Broadcast query
BW_QRY_MVSDTR02_0001	BW - Shipment Events TIERS (Core Query)
QVEPSC_BW_QRY_MVSDTR01_0001	BW - Shipment Costs Analysis for E&P TIERS - Qlikview (
QVNVSC_BW_QRY_MVSDTR01_0001	BW - Shipment Costs Analysis for Novecare TIERS - Qlikview (
QVPISC_BW_QRY_MVSDTR01_0001	BW - Shipment Costs Analysis for P&I TIERS - Qlikview (Core)
QVSBS_BW_QRY_MVSDTR01_0001	BW - SBS OTC Shipment Costs TIERS (QV SBS KPI)
QVSCE_BW_QRY_MVSDTR01_0010	BW - Economics part of activity SCE (Core Query)
QVSCE_BW_QRY_MVSDTR01_0011	BW - Acc. Costs vs Invoice Analysis TIERS (Core Qry for QV)
QVSCE_BW_QRY_MVSDTR01_0012	BW - Activity Haulier Evaluation SCE (core query)
QVSCE_BW_QRY_MVSDTR01_0013	BW - CO² Footprint SCE (QV Query)

Name	Description
BW_CKF_MVSDTR01_0001	No of Containers
BW_CKF_MVSDTR01_0002	Distance (SUM ship)
BW_CKF_MVSDTR01_0003	Gross W. dels. (SUM del item)
BW_CKF_MVSDTR01_0004	Net W, dels. (SUM del item)
BW_CKF_MVSDTR01_0005	Gross W, dels. (SUM delivery)
BW_CKF_MVSDTR01_0006	Net W, dels. (SUM delivery)
BW_CKF_MVSDTR01_0007	Gross W, dels. (SUM ship)
BW_CKF_MVSDTR01_0008	Net W, dels. (SUM ship)
BW_CKF_MVSDTR01_0010	No of handling units (MAX delitem)
BW_CKF_MVSDTR01_0011	No of handling units
BW_CKF_MVSDTR01_0014	Detailed Shpt. condition value
BW_CKF_MVSDTR01_0015	Invoiced Value
BW_CKF_MVSDTR01_0016	Accrual, Net value shipment
BW_CKF_MVSDTR01_0017	# Ship Relevant for SADH below 30 min
BW_CKF_MVSDTR01_0018	# Ship Relevant for SADH
BW_CKF_MVSDTR01_0020	Distance (SUM stage)
BW_CKF_MVSDTR01_0021	No of Shipments
BW_CKF_MVSDTR01_0023	No of handling units (MAX stage)
BW_CKF_MVSDTR01_0024	No of Stages (by detail)
BW_CKF_MVSDTR01_0025	No of Stages (by Stage)
BW_CKF_MVSDTR01_0026	No of Stages
BW_CKF_MVSDTR01_0027	No of Delivery Items
BW_CKF_MVSDTR01_0028	No of Deliveries
BW_CKF_MVSDTR01_0032	CO² Emission Factor
BW_CKF_MVSDTR01_0040	#Ship Relevant for Loading duration
BW_CKF_MVSDTR01_0041	#Ship Relevant for Queue time
BW_CKF_MVSDTR01_0042	#Ship Relevant for On Site duration
BW_CKF_MVSDTR01_0045	Number of HOTS
BW_CKF_MVSDTR01_0046	#Ship Relevant for booking leadtime
BW_CKF_MVSDTR01_0052	Net W. dels in VKG (SUM del item)
BW_CKF_MVSDTR01_0053	Net W. dels in VKG (SUM delivery)
BW_CKF_MVSDTR01_0054	Net W. dels in VKG (SUM ship)
BW_CKF_MVSDTR01_0055	Net W. dels in VTN (SUM del item)
BW_CKF_MVSDTR01_0056	Net W. dels in VTN (SUM delivery)
BW_CKF_MVSDTR01_0057	Net W. dels in VTN (SUM ship)
BW_CKF_MVSDTR01_0070	Gross W. dels. (MAX stage)
BW_CKF_MVSDTR01_0071	Net W. dels. (MAX stage)
BW_CKF_MVSDTR01_0072	Net W. dels in VKG (MAX stage)
BW_CKF_MVSDTR01_0073	Net W. dels in VTN (MAX stage)
BW_CKF_MVSDTR01_0081	Distance (max delivery)
BW_CKF_MVSDTR01_0082	Distance (max delitem)
BW_CKF_MVSDTR01_0090	Loading Duration (Days)
BW_CKF_MVSDTR01_0091	Transit time (Days)
BW_CKF_MVSDTR01_0092	Booking leadtime (Days)
BW_CKF_MVSDTR01_0093	HOTD delay (in days)
BW_CKF_MVSDTR01_0094	HOTS delay (in days)
BW_CKF_MVSDTR01_0095	On site duration (Days)
BW_CKF_MVSDTR01_0096	Queue time at plant (Days)
BW_CKF_MVSDTR01_0097	Planned Transp Time (Days)
BW_CKF_MVSDTR01_0098	SADH in min (by ship)

BW_RKF_MVSDTR01_0001	Number of Legs
BW_RKF_MVSDTR01_0002	Extra-costs accrual CP

Main queries

1 - Shipment cost details analysis

Technical Name: BW_QRY_MVSDTR01_0010
Propose a detailed analysis of shipment cost accruals, detailled by materials. Make shipment costs accruals understandable.
Allows benchmarking between materials, between customers.
Gives some possibilities of drill down to get details on a macro figure.
Public: sites log managers / GBU log process teams, base for Qlikview reportings

Configuration

Image AddedImage AddedImage AddedImage AddedImage Added

First Result

Image Added

2 - Shipment cost vs invoice analysis

Technical Name: BW_QRY_MVSDTR01_0011
Propose advanced cost analysis functionalities including invoice / accrual comparision and other ratios that can't be available at material level.
Detect / evaluate unbilled payables.
Audit tarif calculation
Public: finance / controlling, sites & GBU logistics managers, data log and support teams

Configuration

Image AddedImage AddedImage AddedImage AddedImage Added

First Result

Image Added

3 - Shipment status and events

Technical Name: BW_QRY_MVSDTR01_0012

Propose tracking of events on shipments. without cost considerations.
Propose a reporting on volumetry : number of files (delivery or shipment) per flow, average value on some indicators...
Load plan of shipping points

Public: LOG data and support teams, GBUs sites log managers and sites operations supervisors, Transport managers

Configuration

Image AddedImage AddedImage AddedImage Added Image Added

First Result

Image Added

4 - CO² Emissions

Technical Name: BW_QRY_MVSDTR01_0013
The propose is to show the calculations about quantity of carbonic gase that is released in atmosphere considering all the shipments by zone
Public: users that manage the environment effects and reports to governments

Configuration

Image AddedImage AddedImage AddedImage Added

First Result

Image Added

5 - Shipment Events

Technical Name : BW_QRY_MVSDTR02_0001

The propose is to show the events (problems) involving the hauliers that happened during the logistic process
Public: GBUs sites log managers and sites operations supervisors, transport managers

Configuration

Image Added Image AddedImage AddedImage Added

First Result

Image Added

Queries used to load QV applications

Image Added

Matrix between queries and info objects

Query description	Cost deatailed analysis	Accrual vs invoice	Statuses and events	Event reporting	CO2 Footprint
Technical name	MVSDTR01_0010	MVSDTR01_0011	MVSDTR01_0012	MVSDTR002_0001	MVSDTR01_0013
General "Core entry keys"	COMPANY	COMPANY	COMPANY	COMPANY	COMPANY
	PROMPT UNIT	PROMPT UNIT	PROMPT UNIT		PROMPT UNIT
	PROMPT CURRENCY	PROMPT CURRENCY
	System origin	System origin	System origin	System origin	System origin
	BFC GBU	BFC GBU	BFC GBU	BFC GBU	BFC GBU
	Site (PUSITE) - C-PSITE	Site (PUSITE)	Site (PUSITE)	Site (PUSITE)	Site (PUSITE)
	Actual completion Year / Month	Actual completion Year / Month	Actual completion Year / Month	Actual completion Year / Month	Actual completion Year / Month
	Shipment departure country	Shipment departure country	Shipment departure country	Shipment departure country	Shipment departure country
	Shipment destination country	Shipment destination country	Shipment destination country	Shipment destination country	Shipment destination country
	Forwd. Agent	Forwd. Agent	Forwd. Agent	Forwd. Agent
Query Specific axes	Product Hierarchy
	Material plant
	Bulk / Packed	PO number	Route	Event type	Zone
	3RD Party	Shpiment cost item category	DG class	Event reason for deviation
	Shpiment cost item category
	Transportation Mode	Transportation Mode	Transportation Mode	Transportation Mode	Transportation Mode
For those who want to detail	Plant	Plant	Plant	Plant	Plant
	Departure Geo Zone	Departure Geo Zone	Departure Geo Zone	Departure Geo Zone	Departure Geo Zone
	Transportation planning point	Transportation planning point	Transportation planning point	Transportation planning point	Transportation planning point
	Planed completion date	Planed completion date	Planed completion date	Planed completion date	Planed completion date
	Actual completion date	Actual completion date	Actual completion date	Actual completion date	Actual completion date
	Shipment number	Shipment number	Shipment number	Shipment number	Shipment number
	Shipping condition	Shipping condition	Shipping condition	Shipping condition	Shipping condition
	Shipment type	Shipment type	Shipment type	Shipment type	Shipment type
"By default" shown Measures (among those available)	Accrual Net value shipment (CP)	Accrual Net value shipment (CP)	Gross weight	Nb of event	Gross Weight
	Gross Weight (PU)	Invoiced value (CP)	Nb of shipments	Event duration	Distance
	Net Weight (PU)	Net weight (PU)	Nb of containers		CO2 Tons
	Cost per Unit (Net)	Gross Weight (PU)	Nb of deliveries
	Cost per unit (Gross)	Cost per unit (Net)	Nb of HU
		Cost per unit (Gross)	# ship relevant for loading duration
		Invoice - accrual Gap	# ship relevant for On site duration
		Provisionning accuracy	# ship relevant for Queue time
			# ship relevant for Trnasit time
			Average loading duration
	Keep all others as optional	Keep all others as optional	Average On site duration
			Average Queue time
			Average Transit duration
			% OTD
			% OTS
			Average distance
"By default" shown Rows (among those available)	Source sytem	Source System	Source sytem	Source System	Source system
	Site (CPLANT PSITE)	Site (CPLANT PSITE)	Site (CPLANT PSITE)	Site (CPLANT PSITE)	Site
	Shipment destination Country	Forward agent	Forward agent	Forward agent	Ship Shipping type
				Event type
				Event reason
All navigational attributes :
Organization	Source system	Source system	Source system	Source system	Source system
	BFC GBU	BFC GBU	BFC GBU	BFC GBU	BFC GBU
	Plant	Plant	Plant	Plant	Plant
	Site (Plant C-PSite)	Site (Plant C-PSite)	Site (Plant C-PSite)	Site (Plant C-PSite)	Site (Plant C-PSite)
	Company code	Company code	Company code	Company code	Company code
Shipment	Shipment number	Shipment number	Shipment number	Shipment number
	Departure country	Departure country	Departure country	Departure country
	Destination country	Destination country	Destination country	Destination country
	Forwarding agent	Forwarding agent	Forwarding agent	Forwarding agent
	Transportation planning point	Transportation planning point	Transportation planning point	Transportation planning point
	Actual Completion date	Actual Completion date	Actual Completion date	Actual Completion date
	Actual completion date (Month) YYYY/MM	Actual completion date (Month) YYYY/MM	Actual completion date (Month) YYYY/MM	Actual completion date (Month) YYYY/MM
	Actual completion date (Quarter) YYYY/Q	Actual completion date (Quarter) YYYY/Q	Actual completion date (Quarter) YYYY/Q	Actual completion date (Quarter) YYYY/Q
	Actual completion date Year (YYYY)	Actual completion date Year (YYYY)	Actual completion date Year (YYYY)	Actual completion date Year (YYYY)
	Actual date for Start of shipment	Actual date for Start of shipment	Actual date for Start of shipment	Actual date for Start of shipment
	Planned shipment completion date	Planned shipment completion date	Planned shipment completion date	Planned shipment completion date
	Planned shipment completion date (YYYY-MM)
	Shipment destination point	Shipment destination point	Shipment destination point	Shipment destination point
	Shipment destination point type	Shipment destination point type	Shipment destination point type	Shipment destination point type
	Shipment departure point	Shipment departure point	Shipment departure point	Shipment departure point
	Shipment departure point type	Shipment departure point type	Shipment departure point type	Shipment departure point type
	Route	Route	Route
	Shipment packaging material	Shipment packaging material	Shipment packaging material
	Shipment shipping type	Shipment shipping type	Shipment shipping type
	Transportation mode	Transportation mode	Transportation mode	Transportation mode	Transportation mode
			Departure point - TR zone
			Departure point - Zip code
			Destination point TR zone
			Destination point Zip code
		Shipment Shipping line	Shipment Shipping line
Shipment stage	Ship Stage sequence number	Ship Stage sequence number	Ship Stage sequence number
	Ship stage departure point	Ship stage departure point	Ship stage departure point
	Ship stage departure point type	Ship stage departure point type	Ship stage departure point type
	Ship stage destination point	Ship stage destination point	Ship stage destination point
	Shipment stage destination point type	Shipment stage destination point type	Shipment stage destination point type
	Leg indicator	Leg indicator	Leg indicator
Delivery	Delivery
	Delivery Item
	Delivery distribution channel
	Material
	Material plant
	DG class		DG class
	UN number		UN number
	3rd Party		3rd Party
	3rd Party type		3rd Party type
			3rd partry - TRzone
			3rd party - Location
			3rd party - Zip code
	Transportation group (Bulk / Packed)		Transportation group (Bulk / Packed)
	Transportation group detail		Transportation group detail
	Material hierarchy		Material hierarchy
Shipment x delivery	Shipping condition	Shipping condition	Shipping condition
Shipment cost item	Shipment cost number	Shipment cost number
	Item number	Item number
	Service agent	Service agent
	Shipment cost item category	Shipment cost item category
	Shipment cost posting date	Shipment cost posting date
	Shipment cost posting date - Month (YYYY/MM)	Shipment cost posting date - Month (YYYY/MM)
		PO Number
		Invoice Number
Cost condition	Condition type	Condition type
Event				Event actual start date (day)
				Event actual end date (day)

For more details about each query please click in following link: TIERS: Reporting Solution

2.0 DataFlow

2.1 Overview

Use the google presentation below as a template. This google presentation must be saved in the Reporting GDrive folder under the corresponding application. Then post the link to the document here.

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Exemple of dataflow overview :

Template Application name DataFlow

2.2 Technical Rules on Workbench

Explanation for the process on the technical side. Can be specific cases or general rules depending on the scope.

2.2

Dependencies with other applications

We should have the information where the application is sending or receiving information (e.g. APD open hub)

3.0

Data Loading

3.1

Info Providers and objects loaded

Detail of process chain, list + link between or special event done for the loading

Main Process ChainFinal Provider LoadingFrequencyTime startDuration

1 - Main Process Chain

This process chain is responsible to trigger and syncronize all TIERS processes chains for Solvay and Rhodia. It is scheduled to run every workday inside the Daily process chain (RSP_DAILY) after general master data PC, around 3AM (French time).

PC_SD_TIERS_001: SD TIERS Daily Main PC

Image Added

2 - Propagation Layer

This process chain is responsible to run the loads between source system and first layer in BW.

PC_SD_TIERS_020 à SD TIERS Daily Solvay Propagation PC
PC_SD_TIERS_010 à SD TIERS Daily Rhodia Propagation PC

3 - Business Layer

This process chain is responsible to load the second and third layers from propagation layer.

PC_SD_TIERS_021 à SD TIERS Daily Solvay Business Rule PC
PC_SD_TIERS_011 à SD TIERS Daily Rhodia Business Rule PC

4 - Master data

This process chain is responsible to load all the master data attributes in BW.

PC_SD_TIERS_MD_022 à SD TIERS Daily Solvay Master Data PC
PC_SD_TIERS_MD_002 à SD TIERS Daily Rhodia Master Data PC

5 - Text & maintenance

This process chain is responsible to load all the master data texts in BW.

PC_SD_TIERS_MD_TEXT022 à SD TIERS Daily Solvay Text PC
PC_SD_TIERS_MD_TEXT002 à SD TIERS Daily Rhodia Text PC
PC_SD_TIERS_DELETE à SD TIERS Daily Deletion PSA/Change Log

Loading frequency

Daily inside the daily process chain

Average performance & monitoring

Daily process chain is loaded in 2 hours with around 30k lines in DELTA mode for a total of 10M lines in cubes.

See below an extract of 1 month of monitoring

Image Added

Key Figure	Estimation
Key Figure	Estimation
~ Average Process Chain Runtime	90 to 120 minutes
~ Average nb of rows loaded per load	Shipment Header: Solvay 6K, Rhodia 2K Shipment&Deliveries: Solvay 40K, Rhodia 10K Shipment Costs: Solvay 9K, Rhodia 4K Shipment&Purchases: Solvay 110K, Rhodia 24K Shipment Conditions: Solvay 32K, Rhodia 152K 1.200K records (all providers)
~ Total nb of rows loaded (if full)	Data is stored since 2014 Propagation Layer - Solvay 20.000K, Rhodia 10.000K Business Layer - Solvay 15.000K, Rhodia 8.000K Reporting - Solvay 15.000K, Rhodia 8.000K Master data - Solvay 11.000K, Rhodia 5.000K
~ Average Runtime for 10k lines	30 minutes

For details about application load monitoring, click in following link: Application Monitoring

Record Keeping

User defined that 3 full years stored is enough to be maintained in BW.

There is no automatic process to remove historical data, so any request about historical deletion should be done by user using Freshdesk ticket.

Data Quality Control

Operational Documentation

Procedures

Scheduling

Monitoring

Error Handling

Known Bugs

Roadmap

Page tree

Products

Services

Ways of Working

Meet the Team

Technologies

Help

Life in DA&AI

Versions Compared

Old Version 2

New Version Current

Key

Access Management

DataFlow

Overview

Technical Rules on Workbench

Rules & Explanations

Rule to take the GBU code

Rule to determine the partner code

Rule to determine the departure and destination code

Rule to determine the reference month

Unit conversions

Currency conversion

Determination of manual price change of shipment cost

Dependencies with other applications

Info areas

Master Data

Propagation Layer

Business Layer

Reporting Layer

Virtual Layer

Multi provider

Main KPI calculations

Main functionalities

Main datasources based on SAP tables

Main dimensions for the data

Reporting

Main queries

1 - Shipment cost details analysis

2 - Shipment cost vs invoice analysis

3 - Shipment status and events

5 - Shipment Events

Queries used to load QV applications

Matrix between queries and info objects

2.0 DataFlow

2.1 Overview

2.2 Technical Rules on Workbench

Dependencies with other applications

Data Loading

Info Providers and objects loaded

1 - Main Process Chain

2 - Propagation Layer

3 - Business Layer

4 - Master data

5 - Text & maintenance

Loading frequency

Average performance & monitoring

Record Keeping

Data Quality Control

Operational Documentation

Procedures

Scheduling

Monitoring

Error Handling

Known Bugs

Roadmap