Symptom
When downloading the Excel from the app, the error appears: "The database column 'YY1_MASTERID_PDH' is unknown. Please contact your business process configuration expert."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open Manage Your Solution.
- Go to SSCUI 103528 Settings for Excel-based Data Exchange.
- Select the Business Object for purchase contracts.
- Select the Worksheet and Worksheet description, then choose Edit.
- Add a custom field (for example, YY1_MASTERID_PDH) to the worksheet mapping and save.
- Open the app Mass Changes to Purchase Contracts.
- Start a download of the Excel template; the error is shown: "The database column 'YY1_MASTERID_PDH' is unknown. Please contact your business process configuration expert."
Cause
The mass change Excel only supports fields exposed by the view C_PURCHASECONTRACTMASSUPDT and its corresponding item view; custom fields are not supported.
Resolution
- In SSCUI 103528, remove any custom fields you added to the purchase contract worksheet configuration.
- Ensure only fields provided by the view C_PURCHASECONTRACTMASSUPDT (and its item equivalent) are included in the worksheet.
- Save the configuration and retry the Excel download from the Mass Changes to Purchase Contracts app to confirm it works without custom fields.
- If you require mass maintenance of custom fields for purchase contracts, submit a feature request in the Customer Influence Portal; refer to: How to Submit Feature Requests for SAP S/4HANA Cloud.
See Also
- Refer to: How to Submit Feature Requests for SAP S/4HANA Cloud
- Refer to: SAP Note 3662128 - Unable to download excel file for Purchase Contracts
- Refer to: SAP Note 3641594 - Unable to add custom field in "Mass Changes to Purchase Requisitions" app
- Refer to: Offline Mass Update of Purchase Contracts through Microsoft Excel
Keywords
mass changes to purchase contracts, excel-based data exchange, purchase contract, custom field, unknown database column, download error, C_PURCHASECONTRACTMASSUPDT, SSCUI 103528, excel template, extension fields, limitation, sscui, public cloud, fiori app, purchase contract mass update , KBA , MM-FIO-PUR-SQ-CON-CL , Fiori UI for Manage Purchase Contracts (Public Cloud) , Problem
SAP Knowledge Base Article - Public