In order to classify and identify the WBS Elements, we have created a new field, the Family
There are 5 Families :
ING : Engineering
IT
OTHERS
R&D : Research And Development
REGAFFAIRS : Regulatory Affairs
The Family has been created in RCS and it's filled by the users so it's very easy to load it in BW.
The family can be displayed in CJ20N transaction in the tab Cust. Enhancement in the field WBS family
The information can also be found in PRPS table in the field ZZ_FAMIL.
In BW, the family is loaded in the field ZZ_FAMIL from the data source.
The Family doesn't exist in Solvay's ERP so we have to calculate it in BW.
The family is determined in the end routine of the master data's transformation in the following order:
We read the Project master data for the WBS element and look at the Project profile.
If the project file contains _RD in the code, then the Family is R&D
If the Investment reason of the WBS element is A4 (Product Regulatory Affairs (REACH)), then the Family is REGAFFAIRS
If the Investment reason of the WBS element is H0 BUDGETS SIS (ITB), then the Family is IT
We read the Project master data for the WBS element and look at the Project profile.
If the project file contains _I in the code, then the Family is ING
For the other cases, Family is OTHERS.
Acetow has only one family to manage, the IT family.
The family is determined in the master data's transformation.
The rule is very simple: If the 2 first characters of the field USR03 are 'IT', then the family is IT. Else the family remains empty.
