SAP Knowledge Base Article - Public

2414455 - How to Enable Custom Business Objects and Extension Fields in OData and Data Workbench

Symptom

You are not able to find a custom business object (BO) created from PDI on Data Workbench or an extension field created on a standard business object is missing in the Data Workbench template.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign
  • SAP Cloud Applications Studio

Reproducing the Issue

  1. Go to Data Workbench work center.
  2. Click on Import view.
  3. Select Custom BO.
  4. The custom BO is not available.
  5. Now select Standard BO.
  6. Select the related entity and download the excel workbook.
  7. You notice the extension field is missing in the template.

Resolution

  • To add PDI extension fields created from SAP Cloud Applications Studio (PDI) to standard OData services, which will then be reflected to Data Workbench (if availabe), please follow the below link:

https://community.sap.com/t5/application-development-blog-posts/new-feature-odata-service-extension-with-extension-fields-in-sdk/ba-p/13348038 

  • To add a custom BO and its respective fields to Data Workbench, you can create a custom OData service following the steps below:
  1. Go to the Administrator work center.
  2. Select the OData Service Explorer view.
  3. Change the Show filter to Custom Odata Services.
  4. Click on New, to create a new custom OData service. 
  5. Check the option: Data Workbench enabled (if you want to use this service with Data Workbench).
  6. Edit the Custom OData service.
  7. Select the required Custom BO under the "Select Business Object" button.
  8. Expand and select the required Entities (fields).
  9. Now all the fields related to the selected entities will be available in the right hand side window of the OData Service.
  10. Save your custom OData service.
  11. Click on Activate.

Now the selected custom BO along with its fields will be available in the Data Workbench work center, under the Custom Object option.

Keywords

custom, odata, service, custom, business, object, data, workbench, extension, field, PDI, SDK, template, excel, migration , KBA , extension fields , standard odata service , enable custom business object , customer bo , AP-RC-ODF , OData framework (C4C Only) , AP-RC-BDS-EXT , ByDesign Studio Extensibility , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions