Master Data Check setting in ADSO

[former_member440418]

Hi,

We have an ADSO with setting "Active /Compress data " and write "Change log option" enabled (i.e Std DSO) . And in this ADSO we have an Info object for which "With master Data " option is disabled.

And for this Info Object whenever we set the Master Check Option to either "Master Data Check During Load/Activation" or "Master Data Check During Load/Activation and persists SID in Datastore" and do the data load and activate .The data activation always fails with an error :

"Value '1' of characteristic ZTOTFYRS is not a number with 000003 spaces "

"Error when assigning SID: Action VAL_SID_CONVERT InfoObject <Object name> "

but when we set Master Check Option to "Master Data Check During reporting" everything works fine (i.e) all operations data Load, Activation, Reporting works fine. The SID are also getting generated during reporting for this infoobject without any issues.

This behavior looks strange for me, planning to raise Ticket to SAP .If someone already has solution please let me know. This is not my question to this forum 🙂

My question to this forum is I would like to understand more about the master Data check Option in ADSO.What I can understand from documents is

when we set Master Check Option to "Master Data Check During reporting" Referential Integrity is checked during reporting, that means when we run a query the transaction data is cross verified with master data if the transaction data doesn't exists in master data then system will throw error . Is that right?

But in my example the Info object is not enabled to store master data in that case what does the system does with respect to referential integrity check . And these ADSO setting descriptions are totally misleading. In traditional BW in DTP we have settings for referential Integrity checks based on the setting the data integrity is checked and at DSO level user mention only when to generate SIDS.

Now in ADSO the integrity check settings at DSO level for individual InfoObject level is totally confusing and misleading. Can anyone explain me in detail about this settings.

Thanks & Regard's

A.Dinesh

[siva123hana]

Hi,

Similar issue is resolved by activating the ADSO by using Program: RSDG_ADSO_ACTIVATE.

Thanks

Regards

Siva

[yi]

Hi guys, here is my late reply for future reference

I've found this post that explains everything about the master data check flag: https://blogs.sap.com/2021/03/29/demystifying-sap-bw-adso-master-data-check/

In short, the flag is not really for "Referential Integrity" as was suggested here, but to check if the values are good for reporting and, optionally store internal reporting IDs (SIDs).

Hope that helps,

Andrew

[former_member449387]

Hello Dinesh,

You have any update on above query ? I face this issue for time characteristics .For those characteristics like 0DATE or any characteristics which use 0DATE as reference we get an error some thing like no sid for found value '20100710'.When I choose the option Master Data Check during reporting it s working fine and all the sid getting generated.

Did you implement this note 2582961.

Thanks,

Dharma