SAP Knowledge Base Article - Public

3748144 - Cannot add custom fields to mass change excel for purchase contracts (SAP S/4HANA Cloud Public Edition)

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

  1. Open Manage Your Solution.
  2. Go to SSCUI 103528 Settings for Excel-based Data Exchange.
  3. Select the Business Object for purchase contracts.
  4. Select the Worksheet and Worksheet description, then choose Edit.
  5. Add a custom field (for example, YY1_MASTERID_PDH) to the worksheet mapping and save.
  6. Open the app Mass Changes to Purchase Contracts.
  7. 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

  1. In SSCUI 103528, remove any custom fields you added to the purchase contract worksheet configuration.
  2. Ensure only fields provided by the view C_PURCHASECONTRACTMASSUPDT (and its item equivalent) are included in the worksheet.
  3. Save the configuration and retry the Excel download from the Mass Changes to Purchase Contracts app to confirm it works without custom fields.
  4. 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

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

Product

SAP S/4HANA Cloud Public Edition all versions