3332010 - Error "The column definition(s) for remote table may have change" when deploying hierarchy remote table

When deploying remote table based on BW Hierarchy, error occurs:

The deployment of <HIER_REMOTE_TABLE> was unsuccessful. Error(s): The column definition(s) for remote table <HIER_REMOTE_TABLE> may have changed. Please refresh the remote table definition.

SAP Datasphere

Limited visibility exposure of the key field HEADERID from BW Source system.

This can be checked using Program RODPS_REPL_ODP_GET_DETAIL with parameters

I_SUBSCRIBER_TYPE = HANA_SDI
I_CONTEXT = BW
I_ODPNAME = <HIER_REMOTE_TABLE>$H

Fields in ET_FIELDS marked as SELONLY=X indicate fields can only be used as selection filter, but not transferrable.
HEADERID can be this case, which is not exposed as extraction fields.
However HEADERID could be marked as KEYFLAG=X.

Therefore, this can not be consumed in SAP Datasphere.

If you want to use BW Hierarchies, use /BI*/H<IOBJNM> (/H Tables)

3331989 - Error "Could not insert into table due to a unique constraint violation" when replicating Hierarchy data using CDS view in Datasphere

SAP SCN Wiki BW Hierarchy Tables

SAP SCN Wiki Operational Data Provisioning - Troubleshooting

dwc, data warehouse cloud, hierarchies, business warehouse, HIER, HEADERID, $H  , KBA , DS-DI-RT , Remote Tables , Problem