SAP Knowledge Base Article - Preview

2666128 - Target table template <VIEW_NAME> does not contain any key field - SAP Landscape Transformation Replication Server

Symptom

  • There is a MSSQL table which contains column names that are longer than 30 characters and column names are truncated after 30 characters.
  • If 2 column names share the first 30 characters, after truncation, these 2 columns have the same name, in SLT, duplicated column names are removed so SLT cannot handle these table structures.
  • In order to be able to replicate such a table it is prescribed to create a view with shorter names and use in LTRS.
  • Adding a view in LTRS fails with "Target table template <VIEW_NAME> does not contain any key field."


Read more...

Environment

  • SAP Landscape Transformation Replication Server
  • Microsoft SQL Server

Product

SAP Landscape Transformation replication server 2.0 ; SAP NetWeaver 7.5

Keywords

KBA , HAN-DP-LTR , Use CA-LT-SLT instead , 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.