How To Fix IMPORT_SALES_DOC018 - Row "&1": Only product will be imported (customer material/GTIN ignored).

SAP Error Message - Details

• Message type: E = Error

• Message class: IMPORT_SALES_DOC - Messages for Import Sales Docement from Excel

• Message number: 018

• Message text: Row "&1": Only product will be imported (customer material/GTIN ignored).

In row &V1& for order &v2& item &v3&, only the entered product will be
imported. When a product has been entered, the system ignores the
customer material or GTIN field.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message IMPORT_SALES_DOC018 - Row "&1": Only product will be imported (customer material/GTIN ignored). ?

  The SAP error message IMPORT_SALES_DOC018 Row "&1": Only product will be imported (customer material/GTIN ignored) typically occurs during the import of sales documents, such as sales orders or quotations, when there is an issue with the customer material number or GTIN (Global Trade Item Number) associated with the product.
  Cause:
  
  Missing or Incorrect Customer Material Number: The customer material number provided in the import does not exist in the system or is not correctly mapped to the product.
  GTIN Issues: The GTIN provided may not be valid or may not be linked to the product in the SAP system.
  Configuration Settings: The system may be configured to ignore customer-specific material numbers or GTINs for certain products or sales documents.
  Data Format Issues: The format of the customer material number or GTIN may not meet the expected criteria (e.g., length, character set).
  
  Solution:
  
  Verify Customer Material Number: Check if the customer material number exists in the system and is correctly assigned to the product. You can do this by navigating to the material master data in SAP.
  Check GTIN: Ensure that the GTIN is valid and correctly linked to the product. You can verify this in the material master data as well.
  Review Configuration: Check the configuration settings in the SAP system to see if there are any rules that dictate how customer material numbers and GTINs are handled during imports. This may involve consulting with your SAP configuration team.
  Data Validation: Ensure that the data being imported is in the correct format and adheres to the expected standards. This may involve cleaning or transforming the data before import.
  Consult Documentation: Review SAP documentation or help resources for any specific requirements related to the import of sales documents.
  
  Related Information:
  
  Transaction Codes: You may use transaction codes like MM03 (Display Material), VA03 (Display Sales Order), or SE11 (Data Dictionary) to check material and sales document details.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance.
  Support: If the issue persists, consider reaching out to your SAP support team or consulting with an SAP expert for further assistance.
  
  By addressing the underlying causes and following the suggested solutions, you should be able to resolve the error and successfully import the sales documents.