General presentation
Objective of the application
The objective is to load in a BW flow flat files resulting from an extraction of the Stock Margin Elimination query at defined moments. We want to keep a picture at a time T of the data.
Usage information
History
The decommissioning data flow structure (UPIS) was used for this project.
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 |
|---|---|---|
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Program ZBW_FI_1CP_STOCKMARGIN
- The program permit to load via a process chain the different files available in AL11
- The number of file loading is depending of file available by GBU and MONTH. The month loaded is depending of a parameter in Global Filter Master Data with default value the previous month. The file on the previous month are deposited on the BW server on the begin of the current month. After the file content check (view bellow) each file is load one by one in the propagation ODS DPCOPA04. One time all the available file are loaded, the BW data flow is started.
- For each file, if the file is already loaded in ODS DPCOPA04 (for example the previous day) and that the file has not be updated in BW AL11 then we will not process a new loading.
- In case on file is inconsistent, we continue to load the other file
- For each new file loading, we writing a log with some metadata in the ODS DPCOPA08
Email send in case of error
If there are any errors when checking the contents of each file, we will send an email with a quick description of the various inconsistencies. The file will be not loaded into BW and the old data will be kept if the file is already loaded, otherwise we will have no data for that month/gbu. The same email will be sent in the new loading phase (Day +1) if the file has not been corrected
Selective deletion
In case the file for the month and GBU is already load in the ODS and the update date on AL11 is higher than this loading then we remove by selective deletion the old file.
BW Providers
- Propagation Layer : DPCOPA04
- Business Layer : DBCOPA17
- Cube Provider : CRCOPA21
- Multi Provider : MVCOPA01
- Queries : BW_QRY_MVCOPA01_0030 & QV_BW_QRY_MVCOPA01_0002
- Flat file Log ODS : DBCOPA08
Master Data C_GLBFILT - Global Filter
| Global Filter Stream (Application) | "Global Filter Rule" | "Global Filter" | Global Filter Active | Global Filter Description | Global Filter Hight Value | Global Filter Low Value | Global Filter Option | Global Filter Sign |
| UPIS | FF_DATA | 1 | Y | Input filename for ZBW_FI_1CP_STOCKMARGIN program | INIT | EQ | I | |
| UPIS | FF_DATA | 2 | Y | EMAIL Recipient Receiver Name | To be define | EQ | I | |
| UPIS | FF_DATA | 3 | Y | Flat File Month (Empty = SY-DATUM-1) | EQ | I |
- UPIS/FF_DATA/001 : allows to manage the flat file path. This technical entry is update directly by program
- UPIS/FF_DATA/002 : allows to manage the user to send an email with the flat file content log error
- UPIS/FF_DATA/003 : allows to manage the recovery period to load. In the normal process the value have to be empty
Functional and Technical rules
Rules & Explanations
Flat Files upload rules
Flat files have to upload each month (Data of previous month) in BW AL11 via WebMethod application
- File name is proposed to be YYYYMM_XX_R15430_Stock_Margin_Elim.csv
- We have only one file uploaded by month and GBU
- BW directory : /exploit/BW/PandL/
In case the file of the month has to be corrected, the old file on the BW server has to be replaced by the corrected file. In BW Query, the old upload will be deleted and replaced by the new file content.
Example:
YYYYMM = YYYY Fiscal year (ex. 2022) MM = month (ex. 01)
XX = BFC GBU code (ex. CS) YYYY Fiscal year (ex. 2022) PP = month (ex. 01)
Flat Files content Rules
- The structure of the files will never be modified (same column, same order).
- No data column can be empty
- All information (GBU, BFC activity ...) must exist in the BW master data.
- The column 0CALMONTH must be equal to the month in flat file title
If any of the conditions below are not met, the file will not be uploaded to the BW data stream and an email will be sent with an error summary.
Dependencies with other applications
WebMethod application.
Data loadings
Info providers and objects loaded
Process Chain
PC_COPA_PL_20 / UPIS: TD : Main Process Chain
PC_COPA_PL_19 / UPIS: Upload UPIS Data : Process Chain called by program in PC PC_COPA_PL_20
Loading frequency
Daily
Average performance
Record Keeping
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recovery procedure
Load a specific month
It is possible to load files from previous months. To do this you just need to change the parameter UPIS/FF_DATA/003 in the Master Data C_GBLFILT.
For example if you want to load the file named "202201_SP_R15430_Stock_Margin_Elim.csv" you have to put the value "202201" in the Global Filter Low Value and run the process chain. All the flat file with name contain "202201" will be load.
Correct a specific file
In the case where a file in the past wants to be recovered or modified, it is necessary to apply the procedure above.
For each file uploaded (depending on the month), if the file has been modified on the AL11 directory (modification date) more recently than the last upload in the propagation ODS then
- The old load will be deleted from propagation ODS via selective suppression on month/gbu
- The new file will be load in propagation ODS
- The other provider (Business layer , cube) will be update in full mode.