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
- On Data Product app.
- Click to Add Local Tables (File).
- 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
SAP Knowledge Base Article - Public