Skip to Content
0

Master Data Check setting in ADSO

Aug 16, 2017 at 11:06 PM

541

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dharmateja Nandipati Apr 03 at 02:17 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded