General presentation
Objective of the application
Tool Leader + IT leader of the application:
Usage information
History
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
See SPRINT Dataflow https://drive.google.com/open?id=1G0eplgqwvDwJjtYoziwdE2NPT5YtSjm72fUXXlPcEhM
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
Masterdata RULE2 on Realigned Material Group (C_MATPUR2)
All realigned material group are existing on Solvay, descriptions are then filled from PF1 only. Only english description are required.
Masterdata RULE3 on Terms of Payment (C_PMNTTRM)
Terms of Payment on SAP side are managed into 2 tables. TVZBT for sales (customers), T052U for purchasing (vendor).
Payment terms can be common. On BW there is only one object for Payment Terms. T052U has to be loaded first. The description of common terms will be then TVZBT's one.
Note that keys are differents, no matters, the last description is kept.
ReadSoft DataFlow
SPRINT - Data Mapping - Read Soft https://drive.google.com/open?id=1YV_8OtL4M16bszi1fqVE99O19fPk7EsEYhc9UK4DoP0
Dependencies with other applications
Data loadings
Info providers and objects loaded
Main Chains
| Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
| SPRINT: Daily Loading | PC_SPRINT_DAILY | MAIN | Daily | Not iso with WBD one. Avoid transport |
Slave Chains
| Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
| SPRINT : Propagation (Rhodia) | PC_SPRINT_TR_P1 | slave | Not iso with WBD one. Avoid transport | |
| SPRINT : Propagation (Solvay) | PC_SPRINT_TR_P2 | slave | Not iso with WBD one. Avoid transport | |
| SPRINT : Propagation (Acetow) | PC_SPRINT_TR_P3 | slave | Not iso with WBD one. Avoid transport |
Other Chains
| Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
Loading frequency
Average performance
| 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
Reporting
Queries End User Documentation
Main queries
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 |
MaintenanceBroadcast
No Broadcast implemented
Known bugs
Recurring procedure
Variables (TVARV/Global Filters)
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 |
FIAP Reloading
FIAP for SPRINT Dsos (CR_PUAP1/2/3), and Cubes (CR_PUAP1/2/3) have been reloaded several times since project golive.
At least is requested : current exercice + 3 previous ones.
Example 2016 => 2016 + 2013 to 2015
See ModOp SPRINT reloadings https://drive.google.com/open?id=1qSUGEl6v1Iftdc9N1CP7ytFxW2ew2lGO0eEmy4Gvwk0
It is important to check image Before/After. Only opened periods could be differents.
FIGL Reloading
Caution, take into account special periods 013 to 016, overwise December figures will be wrong.
Special periods 013 to 016 are at last stored on period 012.
See ModOp SPRINT reloadings https://drive.google.com/open?id=1qSUGEl6v1Iftdc9N1CP7ytFxW2ew2lGO0eEmy4Gvwk0
It is important to check image Before/After. Only opened periods could be differents.
ReadSoft Reloading
See ModOp SPRINT reloadings https://drive.google.com/open?id=1qSUGEl6v1Iftdc9N1CP7ytFxW2ew2lGO0eEmy4Gvwk0
Planned Evolution
Useful transactions / programs
| Transaction | Description | Corresponding table | Comments |
|---|---|---|---|
| XK03 | Display Vendor (Central) | LFA1 | |
| MK03 | Display Vendor (Purchasing) | LFM1/LFM2 | |
| FK03 | Display Vendor (Company Code) | LFB1 | |
| ME23N | Display Purchase Order | EKKO/EKPO | |
| ME53N | Display Purchase Request | EBAN | |
| FB03 | Display Accounting Document | MKPF/BSEG BSIK/BSAK | |
| ME13 | Display Purchase Info Record (PIR) Afficher Fiche Info Achat (FIA) | to display scale (barême) choose "conditions" then icon "steps (marches) example RCS : Info Record 53002260253 or 5300260253 | |
| ME03 | Display Source List | source d'approvisionnement example RCS : material 1050025 / plant 7822 | |




