SAP Knowledge Base Article - Public

2333379 - How to Delete Marketing Attributes Using Data Workbench Work Center

Symptom

This Document will guide you on how to delete Marketing Attribute assignment from Accounts using Data Workbench work center.

Disclaimer: "Images/data in this KBA are from SAP internal systems, sample data or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Hybris Cloud for Customer - all its versions.

Resolution

The complete deletion of the Marketing Attribute assignment of an Account has two steps:

First step:

  1. Go to Data Workbench work center;
  2. Select Export view;
  3. Select object as Attribute Assignment Item;
  4. Select Business Partner ID under filters and add the ID to Value;
  5. Click Next;
  6. Click Export Data;
  7. Then select object Attribute Assignment and perform the steps from 4 to 6.

Add column "ToBeDeleted" to the end of both extracted templates with value "TRUE", the files should look like these below,

BusinessAttributeAssignmentItem:

pic1.png

BusinessAttributeAssignment:

pic2.png

Note: Values filled for the fields ObjectID, AssignedObjectUUID, BusinessPartnerID, BusinessPartnerUUID, AttributeValue, BusinessAttributeID, BusinessAttributeSetID, HeaderObjectID, AssignedObjectUUID are dummy values

Second step:

  1. Go to Data Workbench work center;
  2. Select Update;
  3. Select first object as Attribute Assignment Item;
  4. Select Next;
  5. Upload the template for Attribute Assignment Item;
  6. Click Update;
  7. Then select the object Attribute Assignment and perform steps 4 to 6.

Keywords

marketing, attributes, assignment, data, workbench, business, delete, remove , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-CRM-MKT-CNT , Marketing Content , How To

Product

SAP Cloud for Customer 1802 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711