Delta Changes – Master Data Integration with Files
S&OP HANA is new product of SAP for Business Process Sales and Operations Planning. Start of year 2014 we have started using S&OP HANA version 2.0 and Mid of 2014 New version of S&OP HANA introduced as 3.0 SP1 and after 2-3 months version 3.0 SP2.
is based on Version 2.0; the data integration with files process has changed.
In this document I have explained the delta changes and how to integrate master data with files in version 3.0 SP02,
2. Understanding of Master Data of S&OP HANA
SAP S&OP has provided standard contents – Templates, models. Master data, Key figures which can be used as a reference or use it as it is. In case business requires any additional objects then Implementation cunsltant can create new one.
Most commonly used Master Data Types (MDT) are Product, Customer Location, resources and BoM .
High level catagarisation of the Master data types are
a) Simple Master Data
- E.g. Product, Customer Location
- Similar to APO Demanand Planning’s Characteristics
b) Compound Master data
- Composed of Simple Master Data
- E.g. CustomerProduct is composed of 2 simple master data such as customer and Product
- It is similar to the APO demand Planning’s Carasteristic Value Combination (CVC) e.g. Product, Customer, Location
c) Reference master data
- It is created using refrence of another existing simple master data
- E.g. MDT Component uses refrence of simple master data MDT Product.
- Not required to maintain it separely. It is refered from the part of Simple master data
To view the available functionality in the Web UI, Log on to the Web UI of S&OP HANA URL with valid user ID, Password and Authorizations.
Now select the tab master data types to see the details of it as shown in Fig 2
Please note that PRDID is key and Required field , which is mandatory during Product maintenance.
Master data available in S&OP HANA is listed in the Table 1.
Note: In the Mastedata types/Object’s first letters S2, SM1 etc stands for the SAP Standard Model’s objects. E.g. S2 for SAP Model 2, SM1 for SAPMODEL1. While creating the Master data Objects you can create it for the Model as per the requirements.
Structure of the Master Data divided into 2 parts as Header and Attributes.
Table 1 has details of the header. Master data is a group of attributes.
Now we will see details of the Master data attributes to understand it better.
Let us take first an example of master data attributes for Product as shown in Table 2 and next for the Component as shown in Table 3
Now we have a good understanding of the Master Data Types, It’s Structure and Terminology used in S&OP HANA.
Understanding of master data structure helps a lot to maintain the data in the templates and minimize the number of errors.
3. Maintain Master Data Attributes – Objects (MDO)
We understood the structure of the Master Data Types. MDT is a set of Master Data Attributes/Objects (MDO). In this section we will see the details of the MDO.
a) Log On to the valid S&OP HANA Web UI for your company with valid user ID and Authorization.
b) After successful log on select the Configuration Icon from the left panel of the screen , System will take you to the configuration screen from it select the Attributes from the Master Data section as shown in Fig 3
c) We have following options to create new attributes, Save , Refresh and Delete as shown in Table 4
Maintain details for the Add Attributes as shown in Fig 4
After adding it now attribute is appeared in the attributes list with status Inactive and the save button now shown as active to save . See Fig 5
Status of the MDO will get changed once it is used in any MTD and MTD is having Status as “Active” We will see more details of it in next Section 4
4. Maintain Master data using Web UI
S&OP HANA has 3 types of Master Data Type (MDT) – Simple, Compound and Reference. We are having options as shown Table 5
A) Simple Master Data
b) Maintain ID ‘T01PRD’ and Press OK
c) Maintain Details of ID fields value as per Fig 7
‘*’ represent against any field is mandetory field and we have to maintain value for it.
d) As required maintain value for other fileds.
e) From attribute list slect appropriate requred attribute and select Key field for attribute. In Our example I have selected SPRDID for Key and automatically Required also got selected.
Now it will appear in list of MDT with Status “Inactive” as shown in fig 8
h) After activation check the status of ID as shown in Fig 10
If any attributes shows status inactive in the attribute list, after using it in the MDT and status of MDT is active then automatically inactive status of the attribute of it will change status as “Active”.
B) Compound Master Data
b) Maintain ID Value and Press OK. System will take you next screen to maintain further details as shown in Fig 12
c) Select check box for Compound MDT and then system will show new area Composed
of as shown in Fig 13
After activation status changed it as a active as shown in Fig 16
Log displayed shown in Fig 17
5. Master data Load using Web UI
In S&OP HANA Version 3.0 SP1,SP2 lots of improvements has been done for the Data Integration by SAP after receiving feedback from Customers, Partners.
For example selecting object for Product as shown in Fig 20
Template will get downloaded for Product as shown in Fig 21
Fill data in template and save it to load as shown in Fig 22 below, Y1 Cell marked in red
for PRDID value is mandetory to fill as shown in Fig 22
Now since, the file is ready to load data, for Loading master data create new import job as shown in Fig 23.
After Pressing Upload Data Icon job will get scheduled in the background and it will show one of the status as Success, Processing, Processed with Error(s) and Fatal Error(s).
In Fig 25 see status of the Job completed as Successful.
We will download Full Report.
Downloaded Reports shown in Fig 26
If job fails then download Reject report to see the reason of rejection and take action to reload it with correction.
6. Maintain Master Data Types value from Excel Add-IN
SAP has provided option to maintain master data value using S&OP Excel Add-IN for less number of data.
In this section we will see step by step maintain master data Disply and Add
a) Logon to S&OP HANA Excel Add-IN. After successful Log On, See Ribbon on which see the section Master Data shown in Fig 27
c) After selecting Maintain option select Master Data Type from list as shown in Fig 28
There are Options to maintain master data to create New, Edit, Delete Display, copy as shown in Table 6
d) Select master data types Location to disply with Location ID 101 as shown in Fig 29
f) Add Master Data Type Customer Data Value
g) Display Customer as added recently as shown in Fig 31
Similarly you can maintain data for all the Master Data Types (MDT).
7. Delta Changes
- S&OP HANA version 2.0 was having 2 Web UI Old and New; In the New UI Configuration of Master Data was available. Where as in S&OP HANA version 3.0 SP1, SP2 In SP 02 only one WEB UI is present. This change in Version 3.0 SP01, SP02 is very good and made simple for user. Single Web UI has all the S&OP HANA functionality
- It has Data Upload Templates available for Download to user for Master Data, Key Figure and Time Profile
- Interactive Reporting of data loads and filter support
- Enhanced error type e.g. bad File, Now user can read the error and able to understood the error
- No manifest file required for WEB UI
8. Tips and Tricks
Every SAP Product’s has it’s own terminology. Master Data is very commonly used and when System Product’s are integrated with each other in implementation project then it is very important to understand each product’s terminology.
SAP S&OP HANA is new product and now a day’s most of the customer is looking for Product assessment, Implementation experiences to implement it.
In this section I will cover Learning Points:
1) Understanding of Master Data Types available in S&OP HANA along with it’s Attributes are very important
2) Understanding of attributes which are mandatory/Required to maintain it’s value is very important. While maintaining data in Templates it helps to reduce error/s While Creating New MDT and any available selected attribute is having status as “Inactive” then after activating the MDT change it’s status at header level for MDT as “Active” as well as for attributes status also changed as “Active”. Details of it explained in Fig 32
3) Master Data Configuration is done from Web UI and not for S&OP Excel Add-IN.
4) If any number of MDT combination requires to maintain then create /use the MDT “Compound” e.g. customer Product then use maser data types S2CUSTOMERPRODUCT. It has Compound Master Data Type which is composed of Product and Customer as shown in Fig 33 . In APO Demand Planning it is called as a Characteristic Value Combination( CVC).
5) Master Data Type which are having Refrence master data then not require to maintain it e.g. Component is a Master Data Type as a reference master data and it’s reference master data name is S2PRODUCT. When system looks for component data with reference of Prodcuct’s attributes as shown in Fig 34.
6) While uploading data for Compound master data then Composed of Simple master data has to be loaded first as a Simple master data and the Compond master data type.
7) Understanding of template to maintain template. Understanding of the MDT is prerequiste to maintain template. Required Attributes is mandatory to maintain data value in the template.
8) MDO and MDT should have status as “Active” before usage of it.
9) Master Data value can be Character, Numeric or Alpha Numeric as per the MDO’s Data Type of attributes. While maintaining the data in templates follow the MDO’s data type and it’s length, Decimal details.
e.g. Product ID’s Data type of attributes are shown in Fig 35
10) In S&OP HANA Version 3.0 Data load is simple than the Version 2.0. Now no need to create manifest file, Zip it and then load. Templates are available to download as .CSV file from Web UI – Data Integration section for available MDO.
11) From Web UI you can not see all Master data list as a report. You have to check it in S&OP HANA Excel Add-IN under master data tab.
12) In S&OP HANA Version 3.0 SP1, Multi-Level Bill Of Material is maintained /Modeled using Production Sources as s combination of MDT are SOURCEPRODUCTION, PRODUCTIONSOURCEITEM, PRODUCTIONRESOURCE. There is no limit for Levels. We can go for aby number of Levels.
13) Capacity consumption rates is maintained /Modeled using PRODUCTIONRESOURCE.
14) Capacity consumption can be defined as a Time-independent or Time-dependent. Time series flag to be used . ‘Capacity Consumption Rate key figure is used for time-dependent capacity consumption rates.
15) Deletion of master data has to be done very carefully as it affects Master data objects and related time series data. Check the usage of master data object in any Compund master data .eg. Want to delete Product which has value P1. System will delete the Product value P1 from Product . and Compund master Data CustomerProduct also. Take extra efforts to check the MDO value to be deleted.
16) Always check the attribute date format is set to YYYY-MM-DD hh:mm:ss.000. In Excel you have to change the Cell Property via Date custom .
17) You can use custom Downloaded Template as per business requirement. Key Attributes are required in the Template and rest of the attributes if not required can be removed from the custom template.