Why Are KNA1 NAME1–NAME4 Values Shorter Than the Values Shown in the SAP UI?

Question

Why are values in KNA1 fields, such as NAME1, NAME2, NAME3, and NAME4, shorter in the destination than the values shown in the SAP UI?

Environment

Connector: SAP ERP on HANA

Answer

Values in KNA1 fields may be shorter in the destination than the values shown in the SAP UI because the SAP UI can display customer name and address data from the related ADRC table instead of directly from KNA1.

In KNA1, the NAME1, NAME2, NAME3, and NAME4 fields have a maximum length of 35 characters. Fivetran replicates the values stored in KNA1, so the values in your destination may be shorter than those shown in the SAP UI. For example, the XD03 transaction may display longer name or address values from the related ADRC record. The KNA1.ADRNR field identifies the corresponding address record in ADRC.

To verify that Fivetran is replicating the source value correctly:

1. Use SE16 or SE16N to check the relevant NAME1–NAME4 value in KNA1.
2. Compare it with the corresponding value in your destination.
3. If the SAP UI shows a different or longer value, use KNA1.ADRNR to find the corresponding record in ADRC.
4. Compare the relevant ADRC with what the SAP UI displays.

If the replicated NAME1–NAME4 value matches KNA1, and the SAP UI matches the related ADRC value, SAP is displaying data from ADRC rather than KNA1.