cancel
Showing results for 
Search instead for 
Did you mean: 

key fields and non-key field of condition table

Former Member
0 Kudos

Hello Gurus,

what is key fields and non-key field of condition table?

thanks very much!

Accepted Solutions (1)

Accepted Solutions (1)

claudia_neudeck
Active Contributor

Hello,

if you goto transaction V/07. Here you can maintain the access sequence for a condition.

Please have a look at the fields of a table. This are all keyfields if you create a conditon record.

For example:

V/07

> standard access sequence PR00

> Click 'Accesses

> Please sign the first access 10

> Click 'fields' (on the left side)

This fields which are displayed are all keyfield.

I hope this will help you.

If you are satisfied with the anser, please don't forget to give Reward Points.

Regards

Claudia

Answers (2)

Answers (2)

Former Member
0 Kudos

Key field

Each condition table contains keys that can be used for creating dependent condition records.

for example let take condition type PR00.

PR00 uses access sequence PR02 .

Access sequence PR02 has following tables associated with it namely 304, 305 & 306

When you create a conditon record for PR00 with transaction VK11 or VK31, you have a button 'key combination' which is nothing but fields associated with tables 304, 305 & 306.

In brief, Condition records are always created using specific keys. Condition tables are used to define the structure of the keys of a condition record.

Non key field

For example take condition table 144 - sales deal basic data.

Table 144 is associated with access sequence PBUD.

If you check the fields associated with this table (click technical view button), there are three fields at bottom which do not have 'key' check mark -KDATU, PLTYP, KSTAF

So, when you create a condition record for PBUD, system does not propose these 3 fields in 'key combination' and hence are non key fields.

  • Please reward points for good answers as this would help increase the total donation that SAP will make to the United Nations World Food Programme.

former_member217082
Active Contributor
0 Kudos

Hi zhang

when you go to access sequence and go to accesses and select the condition table(you created or already created ) and double click on the feilds tab , you can view the key feilds.

Regards

Srinath