Symptom
- During extraction from a SAP table, the presence of special characters (specifically tabulations, "tabs") in a description/address field causes a column shift in the record.
- In the source table (for example, field STRAS), two characters appear as “#” but show as tabs when exported.
- CI-DS logs report an error due to an attempt to send a CHAR value into a numeric field.
- The two tabs move subsequent fields to the right, causing content (for example, KATR10) to be read into a decimal field (for example, UMSA1).
- In some cases, no error is raised, but the output file is produced with misaligned columns and wrong data.
Read more...
Environment
- SAP Cloud Integration for data services (CI-DS)
- Dataflow source is an SAP table
Keywords
ci-ds, data flow, table reader, special characters, tab characters, embedded delimiter, column shift, char to numeric, parsing, misaligned columns, extraction error, delimiter settings, SAP table, stras, katr10 , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , 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