How To Fix LTR2_ES_CHECK064 - Incremental transformation will use preselection table settings 'SINGLE'

LTR2_ES_CHECK064 - Overview

• Message type: E = Error

• Message class: LTR2_ES_CHECK - LTR2 Checks on Embedded Specification

• Message number: 064

• Message text: Incremental transformation will use preselection table settings 'SINGLE'

What causes this issue?

The data model has been flagged to <LS>Use Incremental Transformation
</>. This requires that a single preselection table is used.
But in the <LS>Settings for Technical Selection</> for the data model,
the preselection table is not specified as <LS>Single preselection table
</>.

System Response

The system ignores the users settings and automatically uses the
settings <LS>Single preselection table</>.

How to fix this error?

To remove this warning from the check results, maintain <LS>Single
preselection table</> for the data model. Afterwards, run the checks
again.
You can also ignore this warning. But be aware that the system will
automatically use a single preselection table for the data model
regardless you specified.

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 LTR2_ES_CHECK064 - Incremental transformation will use preselection table settings 'SINGLE' ?

  The SAP error message LTR2_ES_CHECK064 indicates that during an incremental transformation process, the system is defaulting to use the preselection table settings as 'SINGLE'. This typically occurs in the context of SAP Data Warehousing or SAP BW (Business Warehouse) when dealing with data extraction and transformation processes.
  
  Cause:
  The error message is generally triggered due to the following reasons:
  
  
  Preselection Table Settings: The system is configured to use a preselection table that is set to 'SINGLE', which may not be optimal for the current transformation process. This can happen if the settings are not properly configured for the data source or if the transformation logic is not aligned with the expected data flow.
  
  
  Data Source Configuration: The data source from which the data is being extracted may not be set up correctly, leading to the system defaulting to a less efficient mode of operation.
  
  
  Transformation Logic: The transformation rules defined in the process may not