ODS

[Former Member]

Hi all,

I have a very basic question.

"ODS objects serve to store consildated and cleansed data on <u>document level</u>" -- SAP documentation

What does this document level exactly mean. Somebody please kindly let me know.

Rgds

Karthik krishna

[Former Member · Accepted solution]

Hi Karthik.

ODS stores Document level data.That's right.

http://help.sap.com/saphelp_nw04/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm.

I have a document on ODS ,give me your mail id,I will send you if you want.

Thanks,

Sudh

[Former Member · Accepted solution]

Can you please send me the copy

[Former Member]

Hi sudh,

can u send me that copy on ODS to my mailid as well.

neelkamal76@yahoo.com

with regards

neelkamal

[Ashwin]

Hi!

Document level is the atomic level of the data . AS ods is normally used to store 2 dimentional datastructure we can store the data to most normalized level exactly simmilar to that of in a RDBMS.

with regards

ashwin

[Former Member]

Hey Sudh,

Thanks for your reply

my email ckarthik_78@yahoo.com

Rgds

Karthik

[Former Member]

Karthik,

I send to your mail id,

Regards,

Sudh

[Former Member]

Hi,

Document level means, you can store the data in ODS at a detail level as it is in R/3. For example we can populate the records with the information of Billing Document.So almost the no of records in VBRK table is equal to the records in ODS.

It does not mean that we canot store such a detailness in Infocube. We have one point in using ODS i.e overwrite. If we maintain the such a Granularity in IC , The IC can have more no records than underlying table for a particular combination of key figures. And it also does not make sence. Because IC may holds multiple records even though the there in only one record in base table with this combination.

With rgds,

Anil Kumar Sharma .P

Kindly assign points ,If it really helps you.