Symptom
You would like to understand how to delete an Organizational Unit via Data Import.
Environment
- SAP Sales Cloud Version 2
- SAP Sales and Service Cloud Version 2
Reproducing the Issue
- Navigate to Settings.
- Go to Data Import and Export view.
- Select Import → Delete.
- Search for Organizational Unit Entity.
- No results.
Cause
The Organizational Unit does not support a "hard" delete, as this could leave dangling references in associated documents. However, you can set the lifeCycleStatus to DELETED. When this is done, all sub-entities, like employee assignments, are removed, and the name and displayId will include the deletion timestamp along with the former displayId, allowing reuse of the same displayId.
This approach helps key users and support teams identify when a document reference points to a deleted Organizational Unit.
Resolution
In order to set the lifeCycleStatus to Deleted, please follow the steps below:
- Go to Data Import & Export screen.
- Click on Export button.
- Select Organizational Unit.
- Leave selected the Complete Entity checkbox.
- Select the file type.
- Filter by the Org unit ID that you want to delete.
- Click on Export data button.
- Open the main file Organizational_Unit that you exported.
- Enter the DELETED value for the Status field.
- Save the file. Make sure all files you exported are in a zip file.
- Click on Import → Update
- Select Organizational unit entity.
- Ignore blank values.
- Set type as the one you exported.
- Upload the zip file.
- Click on import data.
Keywords
Organizational Unit, Org Unit, Delete, Update, Status, Data Import, Export, Create, Add , KBA , CEC-CRM-ORG , Organizational Unit for SAP Sales/Service Cloud , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To