on 05-13-2008 2:03 PM
Hello Gurus,
what is key fields and non-key field of condition table?
thanks very much!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.