Skip to Content

Personalize Export filter in Data Workbench

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2016 at 08:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2016 at 10:21 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.