Purchase Requisition Integration with External Catalog
Challenges/Requirement
The user needs to check the price / inventory from the external vendor’s online catalog based on the material number (in this case CAS Number). This process typically involves manually checking the external website for price / stock details, which requires a lot of effort.
To simplify this procedure, we propose integrating the vendor catalog with the SAP S/4HANA cloud system to update price / stock details automatically. This can be achieved by an SAP UI5 application which establishes a connection with the external portal.
Once this integration is in place, users will be able to easily configure purchase requisition item details and input the CAS number to retrieve stock and price information. Additionally, we have embedded the UI5 application within the SAP S/4HANA cloud system, enabling users to conveniently validate inventory details directly from the purchase requisition screen.
Technical Solutions
Develop an SAP UI5 application that can retrieve and display stock information from an external portal.
In the SAP UI5 application, show a list of purchase requisition items created in the S/4HANA cloud system using the purchase requisition item details API. Users can view the corresponding purchase requisition item details and click on the assign button.
The pop-up option for users to select the currency. They can retrieve available stock based on the CAS number and supplier details from the external portal (Bld Pharm in this case) API by clicking the “Go” button.
Users can select and update stock/price availability based on their location. For the update action, we have configured the OData API to update purchase requisition item details with information (location, price, size, and quantity).
We have added new fields (location, price, size, and quantity) to store vendor stock and price details and have extended these fields to the purchase requisition item OData API and the purchase order item screen. This allows users to view the current stock and corresponding pricing details before finalizing an order.
During purchase order creation, users have the ability to verify the inventory details directly from the external portal.
Business Benefits
- Eliminate Manual Data Entry
Automating the update of vendor stock information between S/4HANA and external portals eliminating the need of manual data entry, overcoming the risk of human errors.
- Enhanced Planning and Coordination
Real-time visibility into vendor stock improves planning and facilitates better coordination with suppliers, leading to more efficient operations.
nice
good
Test 2