SAP Knowledge Base Article - Public

3746292 - List to add table (file) to custom data product doesn't contain expected local table

Symptom

When attempting to add local table to custom data product the same is missing from list.

Environment

SAP BDC
SAP Datasphere

Reproducing the Issue

  1. On Data Product app.
  2. Click to Add Local Tables (File).
  3. Search for desired table and only get "no data".

Cause

This can be related to tables containing not supported data types.

Resolution

Check for the types of data involved on related documentation: Data Types Supported By Local Tables (File)


As a workaround check if the type can't be converted to a supported one.
Example:
int1 (tiny int) can be predefined in the local table with data type converted from hana.tinyint to integer.

In case not supported data type is desirable and not supported please consider submitting enhancement request for product using the following:
KBA - 0003332382 - How to create an enhancement request for SAP Datasphere?

See Also

KBA - 0003332382 - How to create an enhancement request for SAP Datasphere?

Keywords

KBA , BDC-DSP , SAP Datasphere features specifically related to BDC. , DS-SM , Space Management , How To

Product

SAP Datasphere all versions