SAP Knowledge Base Article - Public

2809997 - How to get the data of product quantity characteristics from DWB

Symptom

You have a requirement to fetch values of product UoM Characteristics, but you found it's not possible to export UoM Characteristics using DWB

Environment

SAP Cloud for Customer 1905, 1908

Reproducing the Issue

  1. Go to Data Workbench workcenter
  2. Select Export view
  3. Select Standard Object ProductQuantityCharacteristics

Then you can find Total Export Records show as 0

Cause

Direct export of the QuantityCharacteristics from the DWB is unfortunately not yet possible. Development team have taken the request in development plan for the release 1911 and will deliver the feature with 1911.

Resolution

To get the data of product quantity characteristics from the DWB, you need to use  Export Complete Business OBJECT (Product). The quantity characteristics data will be added in the export zip file in the file ProductQuantityCharacteristics.csv.

Generally the quantity characteristics data can be retrieved like the following ( examples):

GET https://tenant URL/sap/c4c/odata/v1/product/ProductCollection('ObjectID')/ProductQuantityCharacteristics

GET https://tenant URL/sap/c4c/odata/v1/product/ProductCollection('ObjectID')?$expand=ProductQuantityConversion,ProductQuantityCharacteristics

GET https://tenant URL/sap/c4c/odata/v1/product/ProductCollection?$filter=ProductID eq 'XXX'&$expand=ProductQuantityConversion,ProductQuantityCharacteristics

Keywords

UoM Characteristics; Data Workbench; Product , KBA , LOD-LE-PRD , Product + Product Category , Product Enhancement

Product

SAP Cloud for Customer core applications 1902 ; SAP Cloud for Customer core applications 1905