Personalize Export filter in Data Workbench

[Former Member]

Hello everyone,

I have tried working with the new function "Data Workbench" in C4C. This goes quite well, but we are facing a crucial problem.

In our context, we have different types of customer, and this is an important information. So we have created an extension field "Type" for Account object, and it is mandatory. Everything is basic customizing process.

When we want to export Account using Data Workbench, and select data according to the "Type", the field is not available in the filter. The same for all other extension fields.

Is it possible to personalize the export filter in Data Workbench? Or at least add some extension fields?

Thank you very much for your answers!

BR

Alicia

[former_member145507 · Accepted solution]

Hi Alicia,

Yes, this is possible and for this you need to extend the C4C Odata service itself.

Please follow the below steps for the same.

• Hover the mouse on this newly created extension attribute and tool bar will appear. Click on tool icon button.

• It should open up a new dialog box. Click on Field Definition link

• It opens up a new view. This view is used to set the usage and behavior of the extension field.

• Since you are interested in extending OData service, you should navigate directly to "ODATA SERVICES" tab.

• Click on edit button at the bottom of the screen. And now you can extend the odata services using the + button available in the “action” column.

• You can choose any service available here. You will extend c4codata service by clicking + button on c4codata row.

• Click “save” button, a confirmation window will popup. Close the confirmation window. Also close the Edit Field screen window to move to opportunity window.

• So now we are done with change which wanted to do. Let’s now end the editing of master page layout by clicking on the menu option “End Layout Change” under Adapt menu.

• With this activity we have extended the c4codata service with the extension field.

Note: You can cross check in c4codata metadata if it is really added. The link is https://<c4c tenant base URL>/sap/byd/odata/v1/c4codata/$metadata. In the metadata search for the extension field attribute using browser search. And you should find the added attribute in entity definition.

Hope this helps.

Regards,

Pavithran

[Former Member · Accepted solution]

Hi

I've tried and it seems working.

Thank you very much!

BR,

Alicia

[chandansb]

Thanks Pavithran for such valuable information. Surely not many would know this. However would also like to suggest using the another option available to extract the required data.

You can also use Mass Data Maintenance to achieve this.

Regards,

Chandan