Highlights
Data Extracted from fire frames to SAP system through RPA: Profit Centers are created in SAP with information captured in 3 different tabs – Basic data, Indicators, Company Code Assignment, and address. Apart from this, Controlling Area and validity dates are the pre-requisite for creating Profit Centers in SAP. The tool facilitates the creation of a Profit Center based on data provided in the template by the users.
Business Need
Search Request: A requester should be able to Search a Profit Center in DMX using any of the following fields:
- Profit Center ID
- Short Text
- Company Codes
Upon searching, creating change, block & unblocking DMX, the app must return the valid search results back from SAP.
Multiple records will be displayed on the results table, and there will be the ability to download the result set to Excel.
The user shall be able to open any search result and see the details associated with that Profit Center.
The Site Search results much have the following fields in them:
- Profit Center ID
- Profit Center Name / Description
- Valid From Date
- Valid To Date
- Company Codes
- Profit Center Group
- Segment
- User Responsible
- Person Responsible
- Business Area
Using the search results, the requestor should be able to Change, Block, or Unblock any one of the Master with the SAP data pre-filled in it.
7.1.1.5 A requester should be able to Create a new Profit Center with the fields and validation rules as described in the mapping document.
About the Customer
Customer is one of the leading multinational luxury fashion holding companies based in New York City and operates multiple fashion brands across the globe.
Solution
Business solutions required before solution:
1. An excel based manual workflow process for SAP master data and transactional data creation, which lacked automation
2. This manual process takes a lot of time, is error-prone, and requires a large team to operate
After solution implementation
1. The UI Path RPA integration ensured the seamless and cyclic creation of master and transactional data in SAP using DMX inputs without any manual interventions
2. Enabled the Bulk upload of pricing condition forms in SAP with increased efficiency and reduced time. This is a great value addition to the business in terms of Sales and Supply chain processes
3. The real-time dropdowns values from SAP are retrieved to the DMX application through manual and weekly dropdown refresh functionality
4. Efficient Master data management with fool-proof approval workflow in place
5. Application is designed in such a way that exception flows are handled through SAP API and UI validation checks.
6. The negative flows are handled as business exceptions and go back to the user corrections
Technical Benefits
- UI & RPA is used to automate Manual entry in SAP for the request created in the DMX
- Angular basically used to enter the data by the user
- MongoDB- No sequel DB is used to store request data
- NodeJS: Writing APIs between MongoDB and User-interface
Project Challenges
- Business analysis is a Bottleneck
- Trusted data
- Connected, intelligent data
- Architecture flexibility that embraces the cloud
- Real-time data is the central component of the Intelligent Enterprise
- They require flexibility when it comes to their cloud infrastructure and the architecture of their solutions
Business Benefits
- Get guidance to support features through a conversation with the chatbot in natural language
- Fill in a form to add an issue title and describe your situation or question. Based on your input, you will receive solution proposals and component suggestions. The more precise you describe your situation, the better might be the proposed solutions
- Search for and trigger functions
- Reducing the Manpower & time saving
- Easily access fire frames and do the changes
