Symptom
You imported customer adresses via data workbench incl. external keys.
But in an export the external keys are not shown for the main address in the file.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench
- Go to Export view
- Export Customer Addresses
- In the export file, search for the related account
- Find for most records Object ID with External_Key and Corporate_Account_ExternalKey
- But for the Main Address, find Object ID with Corporate_Account_ExternalKey only, without External_Key
Cause
The main address was created via the customer header because at least one address field of the header is filled. For example, there is a value in the column CountryRegion.
If at least one address field of the header is filled, this will become the main address and you cannot specify an external key for the address implicitly created via the header.
Thus all the main-addresses implicitly created via the header do not have external keys.
Resolution
To avoid this, kindly leave all the address-fields of the header empty and maintain all your addresses via tab Account_Addresses.
Caution: If you have several addresses per customer in tab Account_Addresses you must set one of them as main address via column Main_Address.
Keywords
missing, not available , KBA , LOD-LE-BP-BP , Business Partner , Problem