Data fileds and key fields in DSO

[Former Member]

Can any one explain what exactly difference between data fileds and keyfields in DSO or the concept of these two

And how to know which fields should be assigned to data filed or key field

with regards,

musai

[Former Member · Accepted solution]

Hi Musai,

A DSO stores data in a flat structure; same as data is stored in a table. To identify unique records, key fields are required.

The system defines key fields to identify records. This key is known as technical key and consists of fields; request no, data package id and record no.

The user defines a key while creating the DSO(which is a mandatory). This key is known as Semantic Key. The key can be created with minimum of one field and maximum of a combination of 16 fields.

While creating a DSO, the user has to decide which fields can uniquely identify a record in the DSO and assign the fields as key fields.

The rest of the fields are added as data fields. As a simple example, a customer details table will have fields as Customer no, Customer location, category, etc. Customer no. here can uniquely identify all rows. Its defined as key field, rest qualify as data field.

Hope this clarifies your doubt.

[former_member1310099]

HI Musai7,

KEY FIELDS : We can take all the primary keys from the source as key fields. Only characteristics( Primary keys) can be taken into Key fields. You can create a maximum of 16 key fields

DATA Fields: We can take both characteristics as well as key figure in data fields. You can create a maximum of 749 fields.

Hope it helps.

Regards,

Sravan.

[Former Member]

Hi Musai,

Let me take an ex. Say you have 3 fields A, B & C. Let us assume 'A' is keyfield, 'B' & 'C' are Datafields.

Lets assume the PSA data is :

A B C

001 Musai 89.9

002 Musai 89.9

003 Pavan 75.00

So when you load the data to DSO, since all the keyfield values are unique (001,002,003), all the records will get loaded to DSO.

But If PSA data is :

A B C

001 Musai 89.9

001 Musai 85.7

003 Pavan 75.00

Only 2nd & 3rd rows will be loaded to DSO since 1st & 2nd row have same value for keyfield (001). So 1st row gets overwritten(or summation depending on what is the setting in Transformation rule for C considering C is Keyfigure) by 2nd when you load to DSO. 3rd row doesn't have any problem. So that will go as it is.

Also please note that we cannot use Keyfigures as keyfield.

Hope it is clear now!

Regards,

Pavan

[former_member186445]

key and data field for dso is exactly the same as when you create a table in se11. the key fields will define the unique records. two records with the same key cannot be updated

you need to put in the key those fields that you need to identify one signle record. put less fields in the key and lines will be overwritten. put to much fields in the key and same lines will be added although they needed to be overwritten.

a lot of info about this can be found on the net.

M.

[Former Member]

HI M,

Can you explain in brief as i am not satisfied with the answers from net or other sources.I hope you got my point.

If you can elaborate more then it will be helpful for me.

with regards,

musai

[former_member186445]

suggestion : follow a course at SAP.

[Former Member]

Key fields are same as primary key in a database table. Data fields are same as fields, other than those in primary key, in a database table.

Hope now you understood.

[Former Member]

Hi,

ODS is nothing but 2D table.

If you define some fields as key fields, they will identify unique records in table.

E.g. if you want to create ODS for Employee data, you will define Employee no. as key fields while employee name and all other information as a data fields. so with employee no, you can uniquely identify that particular employee. 2 employee can have same name.

Hope this helps.