Key and Non-Key Fields

[Former Member]

Can someone bring out the difference between key and non-key fields in relation to adding the fields to a condition table in pricing? SAP documentation says that "The key fields of a condition table must appear at the start of the table, in other words, non-key fields must not appear between any two key fields."

Thanks,

[Former Member · Accepted solution]

hi,

hope you got confused, Key field is the unique field in the table (eg: Employee ID )

Non-key field may not required to be unique.

so while declaring key field it shld be beginning of the table .

siva

[former_member1374255]

mandt is not unique then why it is key field?

[Former Member]

In SAP, as concerned for Condition Table, it is recommended & a practise that all Key fields should come before the non-key fields. Hence the relevance is that Key fields are fields, whch are required & play an important role as compared to no-key fields.

Regards,

Rajesh Banka

Reward suitable points.