Offline Mass Update of Purchasing Info Records through Microsoft Excel
In this blog we will discuss about the offline mass update capabilities of fiori app Mass Changes to Purchasing Info Records, you can perform mass create, update, or delete for multiple purchasing info records simultaneously. You can change the purchasing info records general, purchasing organization, and pricing condition data for multiple purchasing info records. Additionally, you can view the change logs to verify the status of the changes made.
This feature is supported from release SAP S/4HANA Cloud 2202 onwards.
Methods Used for Mass Update
Mass update on purchasing info records can be done using the following two methods:
- Online: Using the list view of the app
Search and view purchasing info records using filter criteria such as supplier, material, purchasing organization, and info record category. Apply mass changes on the search results as required.
- Offline: Using Microsoft Excel
Search and filter purchasing info records and download them in Microsoft Excel format. Make relevant changes in the downloaded excel file and save it. Upload the updated excel in the app view. The edits will be saved and updated for the purchasing info records.
Note:Variable Order unit Info record not supported for offline upload scenarios.
What are the capabilities of offline mass update?
Offline mass update feature helps purchasers to create new purchasing info records via Microsoft Excel or update, or delete the existing purchasing info record by maintaining the required data in Microsoft Excel and later uploading it to the SAP system. User also have an option to download the existing info records to the Microsoft Excel and later users are allowed to do the required update in the excel based on the business need. Configuration, and steps to perform offline upload listed below.
- Configuration steps for Microsoft Excel download or upload.
- Steps to perform offline download or upload.
Configuration Steps for Microsoft Excel Download or Upload:
In general, all the configurations are delivered with standard content, however user have provision to modify some configurations based on the business need.
Step 1:Login to the S/4 HANA system with user having access to the role SAP_BR_BPC_EXPERT,
Step 2:Navigate to the tile Manage Your Solution.
Step 3:Click on “Configure Your Solution” and filter application area sourcing and procurement – General settings
Step 4:Click on configure in the configuration step – Define Setting for Excel-Based Data Exchange.
Step 5:Select the Business object EXL_OPS_PIR for Purchasing Info Record and navigate in the worksheet menu.
Step 6:Select the worksheet ID and navigate into the worksheet description which would contain the list of worksheet language supported and fields exposed for each sheet. Info record facet info would be segregated in three different sheets General Info, Purchase Organization and Pricing Info for download and upload. Each sheet would be mapped to the respective worksheet id and only the relevant fields would be exposed within each sheet.
Step 7: Worksheet Description
View the worksheet description, it contains the supported language info.
Step 8:Worksheet columns
Each worksheet id and relevant fields exposed would be listed in this configuration and user has provision to update the configuration like defining the sequence number, downloading the fields in Microsoft Excel and the editability of the fields with different configuration options.
This helps to download the fields in particular order within each sheet. User has the provision to select the sequence based on business need.
Business user could decide to download only the relevant fields which is required for business. Only fields which are checked in this configuration would be downloaded to excel.
It is not recommended for the user to modify the configuration for the key fields delivered in standard content.
If a particular field is marked as read only, any updates done to this field in the excel during upload would not be considered for update.
Mandatory fields value to be passed required for Info Record creation or update.
Info Record Excel Download and Upload via Microsoft Excel:
Business user shall apply filters and select the info records based on the business need, and click on Download to download all the existing info records to the Microsoft Excel.
Steps to download:
Step 1:Login to SAP S/4HANA system with user having the role assigned SAP_BR_PURCHASER.
Step 2: Open the App “Mass Changes to Purchasing Info Record”.
Step 3:Apply filters and select the info records based on the business need and click on Download.
Downloaded excel would have content segregated in three different sheets as per the configuration defined.
Sheet 1:General info for info record
Sheet 2: Pur org data for info records
Sheet 3: Pricing for info record based
Business user shall upload the excel content via the Mass Changes to Purchasing Info Record app.
Operations supported in Microsoft Excel Upload:
Info record creation
Modify the existing info record
Info record deletion
Info Record Creation:
In general, business users can create info records by maintaining data in all the sheet in one go or business user could also decide to create only general data first for a particular supplier and material combination, and later extend to purchase organization and plant data.
Note: Creation of general data for supplier and material can be done first and later extending with purchase organization and pricing conditions data should be done with “Is New” flag set in purchase org and pricing condition sheet.
Steps to create Info records using Microsoft Excel upload:
Step 1: In the downloaded excel template, maintain dummy values(for Ex #111 or any value) in the Info record column which would be common in all the sheets that would help to link all the general data, purchasing org and pricing condition info in all the sheet.
Step 2: Enter all the mandatory field values and other fields based on the business requirement.
Step 3: Set “Is New” Flag to X in all the sheets for all new records.
Step 4: Save the excel locally.
Step 5: Open the App “Mass Changes to Purchasing Info Records”.
Steps 6: Click on Upload.
Step 7:Browse the file from the local system and upload the excel (Only one excel can be uploaded at a time.
Step 8:Enter the upload job description and schedule upload.
Step 9: After the upload job is scheduled you can navigate to Application jobs to analyse the status log of the offline upload.
Step 10:Click on job log icon to see the details of the jobs executed.
Modify Info records via Microsoft Excel
Download existing info records to the Microsoft Excel and makes updates like quantity, price etc. based on the configuration defined and upload the excel to the SAP system.
Setting deletion flag for Info record via Microsoft excel
Info record can be marked for deletion at General data or Purchase organization data. Set (X-Flag) in the records against the column. Info Record Flagged for Deletion at on all the sheet or only at general data or purchase organization level based on the business need.
Prepare the excel and upload the excel in the system.
Application jobs helps to monitor all the background job triggered for mass upload.
All views expressed in this blogs are my own, it may also subject to change.