SAP Knowledge Base Article - Public

3525027 - Updating condition validity dates via excel in Mass Changes to Purchasing Info Records

Symptom

  • Using the excel template in APP Mass Changes to Purchasing Info Records users would like to update the validity period of purchasing info record conditions. When new validity dates are added to the excel template and uploaded, the info record is updated but the validity period of the price and/or supplementary conditions are not changed  

Environment

SAP S/4Hana Cloud Public Edition 

Reproducing the Issue

  1. Open the APP Mass Changes to Purchasing Info Records.
  2. Enter in filter criteria and select the PiR or range of PiR's to be changed
  3. Download the data to Excel. 
  4. Edit the start and validity end dates and save. 
  5. Upload the Excel in the APP Mass Changes to Purchasing Info Records
  6. Check the log and check the info records processed - the validity periods are not changed. 

Cause

The condition validity end date is a key field used by the system to locate and update conditions.
If the validity end date in the excel does not match the one in the database the condition will not be updated. 


Resolution

If it is required to change the validity end date of conditions, it requires firstly deleting the condition record then creating a new condition with the new validity period.

  1. Download the info records to be changed into the excel template.
  2. If it concerns changing the validity start date only, upload the template with the changed start date.
  3. If it concerns changing the validity period including the validity end date.
    Step 1 - Mark these conditions with the delete indicator in the Excel template and upload it.
    Step 2 - Update the same template with the new validity period start and end date, use a new group ID eg: 01 for the conditions and set the 'is new' flag on the conditions and upload it.
  4. The validity period of the Info record condition(s) will be updated with the new dates. 

See Also

Refer to this blog post

Keywords

SAP S/4HANA Cloud Public Edition, Purchase Info record, update price, update discount, new date interval, condition validity end date, excel template, condition record. , KBA , MM-FIO-PUR-IR , Fiori UI for Manage Info Records , MM-PUR-VM-CON-2CL , Conditions (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions