ODS 0SD_O02 content

[Former Member]

Hi Gurus,

I'm trying to use the BC ODSs for Order Items (0SD_O01) e and Return Items (0SD_O02) and i'm getting something strange in the load of the second.

There is a start routine that deletes all the records with doc. type different than H or O, so in the ODS i should just have documents with these document types, what doesn't happen! I've debugged the update rules and the start routine works fine, i mean it deleates all the rows from the data package where the doc. types are different from these ones. But at the end i got in the ODS other types of docs!!

Does anyone have a suggestion on what is happening here?

Thaks in advance,

Nuno

[Former Member]

Check your Start routine should have something like this.

Delete Data_package where DOC_TYPE NE 'H'

and DOC_TYPE NE 'O'.

If it is there try to reactivate the update rules & Reload the data.

Regards, Siva

[Former Member]

Hi Siva,

That's what i've said! But it's not working.... Regarding this routine i should have on ODS just Doc. type H and O and that's not what is happening. Althought, when i go throught degub in the update rules e can see that de rows a deleted!!

Any suggestions?

Regards,

Nuno

[Former Member]

Hi!

There is anyone who have worked with this ODS's? There were not problems?

Thank you.

Regrds,

N.