Key Fields and Data Fields in ODS

[Former Member]

Hi Guru's ,

Can u Explain what are Key Field's and Data Field's in ODS,and How they work.

Thanx in Advance.

[Former Member · Accepted solution]

Hi Pradeep,

An ODS’ key fields forms a unique combination of chars according to which data in the ODS will be summed up. Data fields are additional fields, chars or key figures.

For example, you have the following key fields:

Doc No, Doc line item (item no in the doc) and you load the following data:

Doc# Item# Amount CALDAY

1234 1 100 26.09.2005

1234 1 150 27.09.2005

1234 2 300 27.09.2005

1235 1 400 27.09.2005

The first two rows with the same key fields (1234-1) will be aggregated and into ODS will go amount of 250.

What I said is true if for Amount key figure the ‘Add’ option is set.

But if you set an ‘Overwrite’ option, then the second record will overwrite the first one and only amount of 150 will go to ODS!

But if CALDAY is also a key field, then into ODS will go all records without any aggregation, because key fields combination is different for all records.

So, ODS’ key fields choice and KFs settings are very important for data aggregation in the ODS.

Best regards,

Eugene

[Former Member · Accepted solution]

Thanx Eugene.

My doubt was clarified.

[Former Member]

Hi,

U can check the URL which will be much helpful to u.

The characteristics will be referred as the key fields in the ODS. So u wil place all the charateristic info objects in the Key fields section. and the Key figures in the data fields section.

Here in ODS u can maintain--

You can create a maximum of 16 key fields

You can create a maximum of 749 fields

You can use 1962 bytes (minus 44 bytes for the change log)

You cannot include key figures as key fields

Regards-

MM

Assign points if it helps..

[Former Member]

Hi,

The key fields and data fields in the ODS plays a significant roles.

As these fields contains the characteristics and key figure information respectively.

When u design the ODS then u have to place ur Char info objects in the Key fields and the Key figure Info objects in the data fields.

for more info refer..

http://help.sap.com/saphelp_bw31/helpdata/en/4a/e71f39488fee0ce10000000a114084/content.htm

Hope it helps-

MM

Assign poins if it helps.

Message was edited by: vishnuC

[Former Member]

just to add one more when u assign key fields in an ods the max u can have is 16 keyfields. u can't go more than that.

[Former Member]

Hi,

Can u Elobarate the concept plz.