Skip to Content
avatar image
Former Member

Data Source Key Field error for DXC

Hi All,

While trying to activate the data source 2LIS_11_VAHDR and 0MATERIAL_TEXT in the BW System for DXC consumption I get the following error -

Error in HANA DB system: Unable to modify DSO table '2LIS_11_VAHDR': no key field defined (at least one of the defined columns must be a key column)

How can the data source keys be maintained.

Pl assist. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 03, 2013 at 12:35 PM

    Hi Saurabh,

    These notes need to be applied in the Netweaver server where you're trying to implement DXC. BASIS team will be able to help you with these notes.

    1701750 DataSource: Secondary Index on the PSA

    If your DataSource is missing a key, apply this note to any BW systems connected to the SAP

    Business Suite system you are using with DXC.

    1677278 DataSource: Changing the Key Definition (A version)

    Provides a report where you can define a semantic key for any DataSources that are missing

    keys. DataSources without keys will cause an error when you try to generate the In-Memory

    DataStore Object in SAP HANA.

    Before applying this not to your SAP Business Suite system, first apply SAP note 1701750 to

    any BW systems connected to the SAP Business Suite system you are using with DXC.

    1710236 SAP HANA DXC: DataSource Restrictions

    Lists specific DataSources not supported by DXC.

    Hope it helps.😊

    --

    Shreepad

    Add comment
    10|10000 characters needed characters exceeded