Symptom
- When a new column is introduced in the data flow, SAP Data Services does not automatically detect the structural difference and add the new column to an existing permanent target table.
- The new column may be available in the upstream schema or Query transform; however, Data Services does not automatically alter the physical target table structure to accommodate the new column.
- There is no option in Data Services Designer to enable automatic schema drift detection or automatic creation of new columns in an existing permanent target table.
Read more...
Environment
All Available SAP Data Services Versions
Product
SAP Data Services 2025 ; SAP Data Services 4.2 ; SAP Data Services 4.3
Keywords
KBA , EIM-DS-DES , User Interface/Designer , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview