General presentation

Objective of the application

Describe in a few words the content of application + link with functional or technical specifications (google links) done with during the project or linked with PPMO

Tool Leader + IT leader of the application: Name of project or main leader for the application + reporting coodinator

Usage information

How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site

History

Provide some history of the application : When was it created ? What was the initial project ? Who was the original requestor ? If possible provide link to the project information

Roles & Access

Roles and 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_M04	SPRINT - Purchasing	role menu
ZR_RCS_CA_M31	SPRINT - SBS - PTP	role menu
ZR_RCS_CA_M54	SPRINT - Supplier Credit	role menu
ZR_RCS_SPRINT2_A01	SPRINT 2 - End User role	role menu for Sprint, gives access to all cubes under infoarea IA_PUR_* Authorization Object ZBI_SPRINT2 / Authorization on zone, GBU, Plant, Company Code This role has to be used with the role menu Purchasing or PtP
ZBI_RCS_SC_A01	SPRINT - Supplier Credit	role menu for Supplier credt, gives access to all cubes under infoarea IA_SC_* Object ZBI_SPRNT_SC / Authorization only on Company Code This role has to be used with the role menu ZR_RCS_CA_M54 / SPRINT - Supplier Credit

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: ZR_RCS_SPRINT_A01 & ZR_RCS_SPRINT_A02 are obsolete

Authorization objects

List of autorisation objects mandatory for the application.

Authorization object	Explanation
Zone (C_PZONE)	ZR_*_CA_P11 Authorizations exist on this object, but all users have access to all (role ZR_TOUT2_CA_P11), this authorization on Zone is abandoned. NB: ZR_TOUT_CA_P11 is obsolete
GBU (C_SUBACT2__CPFCTR1_2)	ZR_*_CA_P05
Plant (C_PLANT)	ZR_*_CA_P02 ZR_7866_CA_P02 => Plant 7866 - Chalampé (ex 7027) - (Cie ZFR9) ZR_TOUT_CA_P02 => All Plants "Solvay"
Company Code (C_COMPCDE)	ZR_*_CA_P01 ZR_ZFR9_CA_P01 => BUTACHIMIE - ( ZFR9) (ex 0560) ZR_TOUT_CA_P01 => All Companies "Solvay"

See also file maintained by Authorization team : BW Catalog of Roles / link: https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

Dataflow 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 :

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Masterdata RULE1 on Vendors (C_VENDID) / Class attribut (C_VENCLS)

This rule concerns only Solvay vendors (from PF1) P*, which are employees not existing in PRS. It is then not possible to set Class = 'X' in ERP.

For those vendors, the class has to be set to 'X' in BW.

The intervall of vendor is managed in Global Filter (C_GLBFILT). Currently P000000000 to PZZZZZZZZZ

$TECHNO - BI TEAM > BW PTP - SPRINT (including SRM7, PUNCH, Purchasing VBF) (WBP) /!\ Obsolete /!\ > image2016-6-3 13:56:43.png$

Detail of main topics with explanations of the rules and only the main + special rules about queries to run and use in the correct way

Dependencies with other applications

Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...

Data loadings

Info providers and objects loaded

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

Loading frequency

Detail of frequency : monthly; weekly or else

Average performance

if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application

Key Figure	Estimation
~ Average Process Chain Runtime
~ Average nb of rows loaded per load
~ Total nb of rows loaded (if full)
~ Average Runtime for 10k lines

Record Keeping

Give details if any historisation is done, example: keep only data greater than beginning of Y-3

Reporting

Queries End User Documentation

Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.

Main queries

List the most important and complex queries only with a link to the documentation

Main functionalities

Terms of Payment

	SPRINT	DPO
Vendor / Company Code view (LFB1)	C_VENDCOM__0PMNTTRMS	C_VENDCOM__C_PMNTTRM
Vendor / Purchasing view 1 (LFM1)	C_VENDPRG__C_PMNTTRM	C_VENDPRG__C_PMNTTRM
Vendor / Purchasing view 2 (LFM2)	C_PO_ITM__C_PMNTRM2	C_VENPRG2__C_PMNTTRM
In Purchase Order (PO)	C_PO_ITM__C_PMNTTRM	C_PO_ITM__C_PMNTTRM
In Accounting Document (DOCT)	C_PMNTTRM	C_PMNTTRM

Broadcast

Indicate if there are broadcasts and give some details on the broadcast settings.

Maintenance

Known bugs

Give the list and explanation on the known, not-solved, bugs.

Recurring procedure

Variable (TVARVC)

Variable	Explanation
LOGSYS_A , LOGSYS_R, LOGSYS_S A= Acetow, R=Rhodia, S=Solvay	Bex variable V_LOGSYS_0007 used to fill query prompt => SE24 ZCL_BIU001_V_0LOGSYS_0007

Global Filters (C_GLBFILT)

Stream

Rule

Explanation

SPRINT

DB_FIAP1

DB_FIAP2

Variable used in transformation (start routine) between DBFIAP01/2 => DB_FIAP1/2.

Aim : skip the DSO DB_FIAP1/2 lookup.

In case of a reloading of FIAP, this look-up in not usefull. To optimize loading time, set the filter to Y. Do not forget to put it back to N afterwards.

SPRINT

SEGMENTAT

Variable used in DTP filter to define the number of year to consider for segmentation redetermination

DSOs : DB_FIAP1/2/3 + DB_PUHD1/2/3 + DB_PUSL1/2/3

SPRINT

CLASS_X

Variable used in transformation to load Vendor number from DataSource 0VENDOR_ATTR / Solvay

currently : interval P000000000 and PZZZZZZZZZ

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016

Useful transaction / programs

Transaction	Description	Corresponding table
XK03	Display Vendor (Central)	LFA1
MK03	Display Vendor (Purchasing)	LFB1
FK03	Display Vendor (Company Code)	LFM1/LFM2
ME23N	Display Purchase Order	EKKO/EKPO
ME53N	Display Purchase Request	EBAN
FB03	Display Accounting Document	MKPF/BSEG BSIK/BSAK