condition table field order

[Former Member]

Hello folks,

Is it important to list the fields in a condition table in the proper order ?

I do not think so and like to clarify with you pls.

regards

Ravi

[Former Member · Accepted solution]

Hi

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

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.

AS per SAP Help

regards

Prashanth