on 06-18-2008 10:14 AM
Dear all
Wht is the purpose of the condition table, when we need to create new condition table, wht are the diffrent standard condition table available for our SD pricing procedure?
Regards
venu gopal
Edited by: venu kk on Jun 18, 2008 11:18 AM
Hi,
Condition table means group of fields which plays a crucial role in maintianing condition records for condition types..
When standard condition tables are not fulfilling your requirement then u can create your own condition table...
Regards
sankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear venu
If you are satisfied with the suggestions given, please close the thread with suitable points to the contributors to say thanks to them. If still you need any clarification, please come out with our further questions.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear venu gopal
A condition table defines the combination of fields (the key) that identifies an individual condition record. A condition record is how the system stores the specific condition data that you enter in the system as condition records. For example, when you enter the price for a product or a special discount for a good customer, you create individual condition records.
Example of a Condition Table
A sales department creates condition records for customer-specific material prices. The standard R/3 System includes condition table 005 for this purpose. The key of table 005 includes the following fields:
- Sales organization
- Distribution channel
- Customer
- Material
The first two fields identify important organizational data and the last two fields express the relationship between customers and specific materials. When the sales department creates a condition record for a material price or discount that is specific to one customer, the system automatically uses condition table 005 to define the key and store the record.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear venu gopal
Let us assume your pricing condition type is PR00. Go to V/07, select PR00 and double click on "Accesses" so that on your right side, you will see a screen.
There you can see various combinations assigned for your pricing condition which is possible only because of assigning the respective condition table.
That is if you maintain condition tables 4, 5 & 79, your pricing conditions would be based on either of the combinations mentioned below:-
- Material
- Customer / Material
- Sales Org / Dis.Chnl / Material group
Like the above, you can have your own choice of condition tables assigned here.
thanks
G. Lakshmipathi
Hi,
Take an example If you want to sell a product to a specific customer say XYZ in specific Sales Org. say 1000 and Distribution channel 10, then you want to charge him 1000 Rs.
and to the customer ABC, for Sales Org, 1000 and Distr. Channel 10, you want to charge 980 Rs,
So what you will Do.?
In your pricing procedures You will make one condition table with Following combination Customer/ Sales Org/ Distr. channel. and maintain the record like this
Cutomer Sales Org Distribution Channel Price
XYZ 1000 10 1000
ABC 1000 10 980
These are Condition records.
Hope this will help you.
Reard point if helpful.
Thanks,
Raja
Hi,
A condition table defines the combination of fields (the key) that identifies an individual condition record.
Example of a Condition Table
A sales department creates condition records for customer-specific material prices. The standard R/3 System includes condition table 005 for this purpose. The key of table 005 includes the following fields: Sales organization , Distribution channel, Customer, Material.
005 - Custmer / Material
004 - Material
006 - Pricelist/ Currency / Material
007 - Div / Material.
These are some of the standard condition tables.
PRase
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
A condition table defines the combination of fields (the key) that identifies an individual condition record.
When your requirement is for different fields and combinations which are not in the standard then you need to create Condition tables. e.g. If you want pricing procedure wrt Purchase group/sales organization wise, which may not be in standard condition table. so you can make your own condition table with this combination.
Hope this will help.
reward Point if helpful.
thanks,
raja
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.