cancel
Showing results for 
Search instead for 
Did you mean: 

condition table

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (4)

Answers (4)

Lakshmipathi
Active Contributor
0 Kudos

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

Lakshmipathi
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Dear

Could you please explain in detrails with example ?

Regards

venu gopal

Lakshmipathi
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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