SAP Knowledge Base Article - Public

2801872 - Validation Checks not Performed on Mandatory Fields While Uploading Materials Using Microsoft Excel® Approach

Symptom

When uploading the Materials using Microsoft Excel®, even if the mandatory fields like Material Description, Product Category ID and Base UoM are not filled in the upload file, the Materials can be still imported without any validation checks for the mandatory fields.

Environment

SAP Business ByDesign

Reproducing the Issue

To upload Materials:

  1. Go to Product Data workcenter
  2. Go to Materials view
  3. Go to Material subview
  4. Select the button New and choose Material from Microsoft Excel®
  5. Fill only the field Material ID
  6. In the Microsoft Excel, go to the tab SAP Business ByDesign
  7. Select Logon
  8. A dialog box opens where you can enter the logon details
  9. Provide the system URL and enter your user ID and your password, and click Logon
  10. In the ribbon, select Save Data to
  11. Material gets successfully uploaded to system


To check if Materials are uploaded in system:

  1. Go to Product Data work center
  2. Go to Materials view
  3. Find the Material ID
  4. Material is imported even if the mandatory fields like Material Description, Product Category ID and Base UoM were not part of the upload file.

Cause

The validation checks raised on the UI are raised specifically for the Quick Activity Floorplan (QAF) and the Object Instance Floorplan (OIF). When we create a Material from the backend on the Business Object, no such checks are raised. Moreover, the creation of Material only triggers a create on the Root node of the Business Object where the Description field is not present, neither is the Product Category ID present. Therefore, no validations arise for them and the creation of Material is successful. When you create Material via Microsoft Excel®, it is the same behavior and therefore, no checks are raised from the Business Object itself and create is successful.

Resolution

This is a designed behavior on the Business Object. The mandatory fields are marked with an asterisk character * on the Microsoft Excel® to ensure that you fill these fields everytime you create a Material.

Fill the mandatory fields in the Microsoft Excel® file and proceed with Materials import.

Keywords

Microsoft Excel®, Upload Materials, Excel approach, Material Description, Mandatory fields , KBA , SRD-MD-PRD-PRD , Product , Problem

Product

SAP Business ByDesign all versions