Changing condition table fields from left side to right side in change mode

[Former Member]

Friends:

I am changing existing condition table. I have fields that I want to add is in the field catalog. When I double click on the field I am getting message Function can not be selected. Every thing is grayed out in change mode. How can I add field from left side to the right side of the existing table?

Full points will be given

Van bills

[Former Member · Accepted solution]

It is not possible to modify exiting / already created tables. A new table requires to be created and assigned as and where required.

Regards,

Rajesh Banka

[Former Member · Accepted solution]

Rajesh:

Thank you for your answer. I have solved the problem. Actually you can not delete the field in the condition table. You can replace it. You can replace it by clicking field catalog.

Edited by: van bills on Nov 3, 2008 4:47 AM

[Former Member · Accepted solution]

Please share your experience of replacing a field in the Price Catalog for a condition table.

Thanks,

[Former Member · Accepted solution]

Hi Van,

Can you please explain how you did that.

My understanding is you cannot change / Replace any field from an existing pricing condition table.

Regards

Sai

[Manoj_Mahajan78]

Hi..

See below example of condition table field maintainance-

Add a Field To New Condition Table in Pricing

Add a field to a new condition table in Pricing (Condition Technique):-

I will explain you the process with below example...Please follow steps in below sequence-

Try to add the filed from the field catalog. In case the required combination field is not there, you can add the field through the following process to filed catalog and create the condition table. It is most common that one or other time we need to use this function while configuring multi tasking & complex Pricing Architecture.

Here I'm giving a simple guide to add fields to the Pricing Field Catalogues:

For example you want to use field PSTYV ('Sales document item category') that is included in structure KOMP ('Pricing Communication Item') as a key for a condition table.

When you create a condition table (Transaction V/03), however, the system does not propose the field in the field catalog.

Condition access, field catalog, allowed fields, KOMG, KOMK, KOMP, KOMPAZ, KOMKAZ, PSTYV are the other terms which we need to know about, to add Fields.

Reason and Prerequisites:

For technical reasons, field PSTYV was included in structure KOMP, however, not in structure KOMG ('Allowed Fields for Condition Structures').

Proceed as follows:

1. Call up the ABAP Dictionary (Transaction SE11) and create data type ZZPSTYV. Choose PSTYV as a domain.As a short text, you can use, for example, 'ZZ - sales document item category' and as a field label, you can use the field labels of PSTYV.Save, check and activate your entries.

2. Call up structure KOMPAZ in the ABAP Dictionary (Transaction SE11) in the change mode and make the following entry:

Component Component type:

ZZPSTYV ZZPSTYV

Save, check and activate the change you made.

3. Note:Because of the change in structure KOMPAZ, field ZZPSTYV is now known in structures KOMG and KOMP because structure KOMPAZ is included in both structures.

4. Call up Transaction SPRO. Navigate to 'Sales and Distribution -> Basic Functions -> Pricing -> Pricing Control' and execute 'Define Condition Tables'.

Choose 'Conditions: Allowed fields' and include ZZPSTYV as a new entry.

5. Note:Now you can use field ZZPSTYV as a key field when you create a condition table Axxx.

6. Supply the new field you defined by including the following source code line in USEREXIT_PRICING_PREPARE_TKOMP:

MOVE xxxx-PSTYV TO TKOMP-ZZPSTYV.

In order processing you find the user exit in Include MV45AFZZ, and in billing document processing you find it in Include RV60AFZZ.

Consider that you can also use this note as a help if you want to use other customer-specific fields as key fields in a condition table.

For header fields, use structure KOMKAZ instead of structure KOMPAZ and

USEREXIT_PRICING_PREPARE_TKOMK instead of

USEREXIT_PRICING_PREPARE_TKOMP.

For more information, see Transaction SPRO via the path 'Sales and Distribution -> System Modifications -> Create New Fields (Using Condition Technique) -> New Fields for Pricing' and OSS Note 21

Regds

MM

[Former Member]

In the existing table u cant add new fields, you can create a new table with old and new fields and then add this table to Access sequence.

Sam