General presentation
List of contacts
- Sandrine Micollet (SBS Information Services) : Reporting Coordinator
- Guillaume Thevenet (SBS Information Services) : BW Coordinator
Objective of the application
The objective of application is to allow users loading data from excel files with validation of content.
Usage information
Around 4 users worldwide.
History
The project was started in May/2016 and was in go-live in June/2016. It was requested by CBS project manager Nathalie Delahousse and approved bt Sandrine Micollet,
Link about the specifications :
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_M433 | Upload Data - Non-ERP ZCYTEC_FILE | Role to allow uploading file |
| ZR_NERPCYT_CA_P12 | Analysis SYSTEMS - NERPCYT - Non ERP - CYTEC | Role to allow running process chain |
| ZCYTECCAP12 | Area Source System - Non ERP - CYTEC | End user role |
And check also on the DSO DPAUTH01, this DSO is updated on WBP and WBQ every day with process chain PC_AUTHORIZ_001 at 00:30am.
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| C_SRSYST | External source system |
Link to the BW Catalog of role
Dataflow overview
Main flows
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
We needed a solution for Solvay or other companies not working on ERP SAP. We have created a specific transaction : ZBW_CBS
The transaction is based on program : ZBW_CYTEC_CBS
With this transaction, user can load excel file for
- Customer master data
- Cost Element master data
- Non-ERP Function costs data
The transaction is available in SOLIA portal. For information, it's better to use IE and not Chrome
We have created a new authorization object (C_SRSYST) to be sure that users can only load data for companies they have access to.
The program checks user’s authorizations with DPAUTH01 DSO
For master data, we can display content of master data in the screen and also save it in an excel file
For master data and transactional data, user is available to load excel files using lay-out already defined.
We control the content of the file to be sure that there is no error (missing field or incorrect values).
Once data is loaded:
- The file is saved as csv in /exploit/BW/Cytec
- The infopackages are executed to load flat file in PSAs.
- The process chains are executed
- By schedule (hourly with abap condition looking time in global filter).
- Manage “delta queue” is several loadings at the same time
- Another process chains to load from PSA to BW Info provider
- 2 for Master data
- 1 for DSO and cubes
- Process chain runs twice a day (managed in Global filter master data)
The abap program was developed to help user loading flat file in master data cost center & cost element and transactional data CBS function costs.
Below there is a list of entries in global filter used to support the program to do several activities, like: check authorizations, upload flat file, check company code, run process chain, etc.
Lay-out of files
Cost Center
| InfoObject | Description | Type | Size | Key | Business rules and Comment |
| CO_AREA | Controlling area | CHAR | 4 | Y | always ZCYT ; authorization object in the specific transaction in WBP |
| C_COSTCTR | Cost Center | CHAR | 10 | Y | cytec cost center codes |
| LOGSYS | Source System | CHAR | 10 | Y | NERP003 or NERPCYT |
| C_FUNCT_0 | 0 Hierarchy | CHAR | 32 | N | check : always ZCBS |
| C_FUNCT_1 | 1 Organisation | CHAR | 32 | N | check with existing values for C_COSTCTR-C_FUNCT_1 |
| C_FUNCT_2 | 2 Function | CHAR | 32 | N | check with existing values for C_COSTCTR-C_FUNCT_2 |
| C_FUNCT_3 | 3 Sub-function Grouping | CHAR | 32 | N | no check |
| C_FUNCT_4 | 4 Sub-function | CHAR | 32 | N | no check |
| C_COMPCDE | Company code | CHAR | 4 | N | check with C_COMPCDE |
| CREATEDON | Creation date | DATS | 8 | N | sy datum (not in the file but populated by the specific program) |
| USERNAME | User Name | CHAR | 12 | N | sy uname (not in the file but populated by the specific program) |
| DATETO | Valid to | DATS | 8 | Y | YYYYMMDD |
| DATEFROM | Valid from | DATS | 8 | N | YYYYMMDD |
| PROFIT_CTR | Profit Center | CHAR | 10 | N | It is not filled in Cytec case |
| LANGU | Language Key | LANG | 1 | Y | always 'E' for English |
| TXTSH | Short description | CHAR | 20 | N | free text |
| TXTMD | Medium description | CHAR | 40 | N | free text |
Template of flat file for Cost center
Cost Element
| InfoObject | Description | Type | Size | Key | Business rules and Comment |
| CO_AREA | Controlling area | CHAR | 4 | Y | always ZCYT ; authorization object in the specific transaction in WBP |
| COSTELMNT | Cost Element | CHAR | 10 | Y | cytec specific cost elements |
| CSTELMNTYP | Cost element category | CHAR | 2 | N | always '01' |
| LOGSYS | Source System | CHAR | 10 | N | NERP003 or NERPCYT, check against global filter |
| C_CELTHF1 | Fixed cost Group 1 | CHAR | 32 | N | |
| C_CELTHF2 | Fixed cost Group 2 | CHAR | 32 | N | |
| C_CELTHF3 | Fixed cost Group 3 | CHAR | 32 | N | |
| C_CELTHF4 | Fixed cost Group 4 | CHAR | 32 | N | |
| DATETO | Valid to | DATS | 8 | Y | YYYYMMDD |
| DATEFROM | Valid from | DATS | 8 | N | YYYYMMDD |
| LANGU | Language Key | LANG | 1 | Y | always 'E' for English |
| TXTSH | Short description | CHAR | 20 | N | free text |
| TXTMD | Medium description | CHAR | 40 | N | free text |
Template of flat file for Cost element
CBS Function Costs
| InfoObject | Description | Type | Size | Key | Business rules and Comment |
| 0CO_AREA | Controlling area | CHAR | 4 | Y | always ZCYT |
| 0FISCVARNT | Fiscal year variant | CHAR | 2 | Y | Always K4 |
| 0FISCPER | Fiscal year / period | NUMC | 7 | Y | yyyymmm |
| 0CURTYPE | Currency Type | CHAR | 2 | Y | always 10 meaning company code currency |
| 10 | Y | counter defined by cytec not fill by the interface => still empty | |||
| 3 | Y | always 1 not fill by the interface => still empty | |||
| C_COSTCTR | Cost Center | CHAR | 10 | Y | check with master data C_COSTCTR with controlling area ZCYT and company code |
| 0COSTELMNT | Cost Element | CHAR | 10 | Y | check with master data C_COSTELMNT with controlling ares ZCYT |
| 0LOGSYS | Source System | CHAR | 10 | N | NERP003 or NERPCYT |
| 0FISCYEAR | Fiscal year | NUMC | 4 | N | YYYY |
| C_COMPCDE | Company code | CHAR | 4 | N | check with master data C_COMPCDE (PRS code) |
| 0DB_CR_IND | Sender/Receiver indicator | CHAR | 1 | N | S = debit, H = credit |
| 0VTYPE | Value type | NUMC | 3 | N | always 10 |
| 0CURRENCY | Currency key | CUKY | 5 | N | USD |
| 0AMOUNT | Amount | CURR | 9 | N | decimal is '.', sign is xxx |
| 0PSTNG_DATE | Posting date | DATS | 8 | N | format YYYYMMDD with no separator |
| 0DOC_DATE | Document date | DATS | 8 | N | format YYYYMMDD with no separator |
Template CBS Function Costs flat file
Dependencies with other applications
There is no dependencies with other applications, all data is loaded using flat files by users.
Data loadings
Info providers and objects loaded
Main Process Chain: PC_FC_CYTEC
There is an abap condition ZBW_UPDATE_GLB_FILTER used to define the hours that the process should be executed based on global filter rule CYNE_STIME, nowdays twice a day.
In WBP : 5 times 11:00am + 13:00am + 15:00am + 16:00am + 17:00am
In WBQ : from 8:00am to 09:00 pm each hour so 14 times
Cube CUB_FC007 - Fixed costs Analysis (External data)
DSO ODSBCCA9 - Cost Centers: Actual Costs (External data)
Transformation between flat file and ODSBCCA9
Loading frequency
Daily, twice a day.
Average performance
Depending on number of records loaded there is a variance between 30 seconds and 5 minutes.
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 2 minutes |
| ~ Average nb of rows loaded per load | 2K records |
| ~ Total nb of rows loaded (if full) | 20K |
| ~ Average Runtime for 10k lines | 2 minutes |
Record Keeping
This solution is in production since July/2016 loading data from June/2016, so there is no definition about retention, probably all historical data will be kept.
Reporting
Queries End User Documentation
Function Costs CBS User Guide.docx
Main queries
The queries are the same used for CBS Function costs users under multi provider MPR_FC001.
CBS Function end of month - result below
Main functionalities
The unique key figure loaded is the amount.
Broadcast
There is no broadcast defined.
Maintenance
Known bugs
All issues are identified during the validation of abap program, before to be loaded in BW and it can be fixed and validated by user again see the example below:
About Company code :
Need to check on the global filter if all companies codes are well actives or not.
Stream ZCYT and rule = COMPCDE
+ Need to create it on C_COMPCDE master data
+ don't forget to active the masters datas.
Recurring procedure
Sometimes users ask to delete not used cost centers and cost elements loaded wrongly.
Planned Evolution
The process should be replacement by RCS SAP Financial when it is implemented in Cytec around 2017/2018.