Pricing in SD Condition tables on Zfields

36 Views

Hi

I have a requirement as follows.

A new table has been created which has got a field with 20character length. The field can take any value but the first 4 characters can follow only15 allowed lists. For example there will be as many transactions with ABCD********* value in this field where * can represent any character. But I want to control the value of a condition type based on teh first four characters of this field.

Ex : If ABCD, i want to maintain a condition record of 100 Dollars, if ZYCD then 200 Dollars and so on.

Is it possible to add only the first four characters as a field in my condition table.

Another case :

I have a field which is a check box. So it can have a value of X or empty. Now I want to use this field in teh condition table and want to maintain some value for the empty field. Is this possible.

Thanks in Advance for the help.

Regards

S.Navaneetha krishnan