| Table of Contents | ||
|---|---|---|
|
1- Requirement
EHS users need to have sales information with EHS characteristics.
...
BW_PPS_EHS_SUBSTCAS.TXT
BW_PPS_EHS_COMPO_STD.TXT
2- Files location
Files are placed in the folder: /exploit/BW/CIS.
3- Files description
3-1 BW_PPS_EHS_LIBSUBST.TXT
3-1-1 Brief description
This file contains all the specifications that have a long description and a substance nature.
3-1-2 Logical file name
Z_EHS_FILENAME
3-1-3 Source
Specification InfoObject (0EHS_SPEC)
3-1-4 Fields
:
Field | Technical name | Type |
Specification | /BI0/PEHS_SPEC-EHS_SPEC | char 12 |
Substance Nature of the specification | /BI0/PEHS_SPEC-EHS_SUCH | char 10 |
Specification long description | /BI0/TEHS_SPEC-TXTLG | char 60 |
3-1-5 Conditions for the loading
The specification has a substance nature,
...
Only English descriptions are loaded.
3-1-6 Example
100000000019;Z_SUB_MONO;Ultramarine blue
...
100000000054;Z_SUB_MONO;ethylbenzene
3-2 BW_PPS_EHS_SUBSTCAS.TXT
3-2-1 Brief description
This file contains all the specifications that have a short description.
3-2-2 Logical file name
Z_EHS_FILENAME2
3-2-3 Source
Specification InfoObject (0EHS_SPEC)
3-2-4 Fields
:
Field | Technical name | Type |
Specification | /BI0/PEHS_SPEC-EHS_SPEC | char 12 |
Substance Nature of the specification | /BI0/PEHS_SPEC-EHS_SUCH | char 10 |
Specification short description | /BI0/TEHS_SPEC-TXTSH | char 20 |
3-2-5 Conditions for the loading
The specification has a short description,
...
Only English descriptions are loaded.
3-2-6 Example
100000000019;Z_SUB_MONO;57455-37-5
...
100000000054;Z_SUB_MONO;100-41-4
3-3 BW_PPS_EHS_COMPO_STD.TXT
3-3-1 Brief description
This file contains the percentage of specifications in the commercial products for a selected month.
3-3-2 Logical file name
Z_EHS_FILENAME3
3-3-3 Source
Material-Specification Mapping Datastore Object (DSO_EHS1),
...
Commercial Product InfoObject (C_PROD)
3-3-4 Fields
:
Field | Technical name | Type |
Commercial Product | /BIC/ADSO_EHS100-/BIC/C_PROD | char 18 |
Specification | /BIC/ADSO_EHS100-EHS_SPEC | char 12 |
Authorization Group | /BIC/ADSO_EHS100-EHS_AUTH | char 10 |
Substance Nature of the Commercial Product | /BIC/PC_PROD-EHS_SUCH | char 10 |
Percentage Specification in Material | /BIC/ADSO_EHS100-EHS_SPMA |
Number
8 decimals
3-3-5 Conditions for the loading
The specification is not like ‘PRCO*’ or the percentage specification in material <> 100%,
Data are limited to the specified month (input criteria)
3-3-6 Particular handling
‘0‘s on the left of the commercial product code are deleted,
...
Before the loading a screen allows the user to choose a specific month for the extraction
3-3-7 Example
90000317;100000000000;ZZ_BU_00;;100.00000000;%
...
90001679;100000001974;ZZ_BU_10;;11.00000000;%
4- Program description
Name: Z_DOWNLOAD_FILE_EHS
...
- Closing the dataset (physical file)
5- Data Flow modifications
Some adjustments have been done on BW:
...
The DTP which load C_PROD was added in “Performance RCS EHS KPI” process chain.
6- Frequency
Before running Z_DOWNLOAD_FILE_EHS program, the loadings of 0EHS_SPEC (texts an attributes), C_PROD and DSO_EHS1 have to be completed. So it was decided to trigger an event (PC_GENERATE_EHS_FILES event) at the end of “Performance RCS EHS KPI” process chain which runs monthly on the 1^st^ month day. “GENERATE EHS FILES” process chain was created and it starts on this event.
7- In case of loading error
The program could be executed manually by choosing a month in the user screen.