Skip to Content
0
Jun 10, 2020 at 05:29 PM

Missing SID's for InfoObjects based on HANA Views

1007 Views

Hello,

I'm facing an issue with InfoObjects based on HANA views. These InfoObjects are actually created using content of various transparent tables in ERP.

The problem is that if a record is added to the underlying transparent table, somehow a SID need to be generated for corresponding record. For some InfoObjects this works just fine. For other, it does not. So, when a new record appears in the InfoObject, no SID is generated in /BIC/S<infoobject_name>, and I face errors saving planning buffer that contains ID for this new record, as described in note 2471784.

This note in turn refers to note 2189861. This note wisely suggests that "The corresponding SID values to the master data values of the HANA views must be guaranteed". This looks fair and square, but further information as to HOW to do so is quite vague.

For the start, it says that "In this case the provider specific properties of all HANA view based info object in the virtual provider is not flagged as referential integer (flag 'Ref. Integrity (HANA) is empty)". This is quite confusing, as I have no single 'virtual provider' in my BW configuration. Furthermore, is suggests that "If the reference data is read from a HANA view in the composite provider to on the output tab and make sure that the flag 'Referential Integrity' is not set for each InfoObject". This is more clear, and I made sure that no such flags are set for any InfoObject in my composite provider.

However, the problem with planning on newly created records for some HANA-view-based infoobjects is still there, and I have no idea how to fix it.

The note offers an option to run RSPLS_CREATE_MISSING_SIDS report every time the problem occurs, but that does not seem as valid solution for infoobjects where new records in underlying transparent tables are added by dozens or even hundreds during the day.

What disturbs me most is that I cannot understand why for certain HANA-view-based InfoObjects this SID-related issue does not occur at all, and for other it happens every time. The settings for 'problem' and 'non-problem' InfoObjects look pretty much the same.

Please advise.

Thank you,

Valeriy