How To Fix RSDS101 - &1: External length specification will be ignored

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDS - New DataSource

• Message number: 101

• Message text: &1: External length specification will be ignored

What causes this issue?

The value &V2& is specified as <LS>output length</> in &V1&. It is also
specified that the data is shipped in internal format.

System Response

The length specification for <LS>output length</> is ignored. If the
data in the source actually have the specified lengths, this results in
conversion errors.

How to fix this error?

Select the external <LS>format</> if required.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDS101 - &1: External length specification will be ignored ?

  The SAP error message RSDS101 with the text "External length specification will be ignored" typically occurs in the context of DataSource definitions in SAP BW (Business Warehouse) or when working with DataSources in SAP ERP systems. This message indicates that there is a mismatch or an issue with the external length specification of a field in a DataSource.
  Cause:
  The error is usually caused by one of the following reasons:
  
  Inconsistent Field Lengths: The external length specified for a field in the DataSource does not match the actual length of the field in the underlying database table or structure.
  DataSource Configuration: The DataSource may have been configured incorrectly, leading to discrepancies in field definitions.
  Data Type Mismatch: The data type of the field in the DataSource may not align with the data type in the source system, causing the external length to be ignored.
  
  Solution:
  To resolve the RSDS101 error, you can take the following steps:
  
  
  Check DataSource Definition:
  
  Go to the DataSource in the SAP BW system and check the field definitions.
  Ensure that the external length specified for each field matches the actual length of the corresponding field in the source system.
  
  
  
  Adjust Field Lengths:
  
  If you find discrepancies, adjust the external length in the DataSource definition to match the source field's length.
  You can do this in the DataSource maintenance transaction (e.g., RSA1 for BW).
  
  
  
  Review Data Types:
  
  Verify that the data types of the fields in the DataSource match those in the source system. If there are mismatches, correct them accordingly.
  
  
  
  Re-activate DataSource:
  
  After making changes, re-activate the DataSource to ensure that the changes take effect.
  
  
  
  Test Data Extraction:
  
  Perform a test extraction to ensure that the error no longer occurs and that data is being extracted correctly.
  
  
  
  Related Information:
  
  Transaction Codes: You may use transaction codes like RSA1 (Data Warehousing Workbench) or RSA3 (DataSource Test) to manage and test DataSources.
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or fixes related to this error.
  Documentation: Refer to SAP documentation for DataSource configuration and field mapping to ensure best practices are followed.
  
  By following these steps, you should be able to resolve the RSDS101 error and ensure that your DataSource is correctly configured for data extraction.