New condition price depending on bill-to-party counrty

[Former Member]

Hi everybody,

We are trying to create a new sales condition price that depends on the bill-to-party country. But we can't get it. The only country we can use is the Ship-to party country. Every country we select in the table for the condition refers to the Ship-to party country, not to the Bill-to party country.

Who can help me?

Thanks in advance

[Former Member · Accepted solution]

Hi

<b>You can add new field to field catalog with u r required field , Then create condition table using that new field as follows..</b>

<b>To add field into Field catalogue:</b>

For example if 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.

Prerequisites:

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

To solve the problem, 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 Note 21040.

<b>

To creating a condition Table:</b>

1) There are almost all the regularly used Conditon Table predefined in the system from 001 to 500.

See what best you can use the Standard Tables to avoid further errors.

2) In case you should define the new condtion Table,

a) Goto TCode: V/03

b) Give a Table any number from 501-999

Press execute and reach to next screen.

c) Check up whether the field you are looking is already added in Field catalogue.

d) Double click on the fields you want to make a Table..one by one. Note that the sequence here is important in higher hierarchical to lower..

Eample : Sales Org, DC, Division, Customer and then Material etc..,

e) After selecting, click on the Techincal View buttin (redone) and reach to next screen.

7) Check which key should be in header and which key should be footer. Use check and uncheck functionalities there..

😎 Once you are through with all the above steps ..click on generate button.

Check the Table is generated or not.

You can check it at V/04 or V/05 or in SE11.

[Former Member]

Hi ,

For this you will have to first find out the allowed fields for pricing . You can do that by going to SPRO > S& D > system modification and Create new fields for pricing.

Once this is done you will be able to find the field while creating condition table.

Basically this should be their in KOMK & KOMP you will need to include their also.

Reward Points!!!!!!!!!!!!!!

Thanks,

Kamal

[Former Member]

Thanks for your reply. As far as I know, the field bill-to-party country doesn't exist in that tables. So, we should create a ZZ field and fill it with the value LAND1 that we have in table VBPA for that sales order, pert.function RE (Bill-to-party).

Is that right? Is there a standard functionality to get it or we shoul create a ZZ field?

Thanks

Iné

[Former Member]

Hi Ines.,

This is very good quostion,But can you please be little bit more clear

Thanks & Regards

Narayana

[Former Member]

Yes, of course. The problem we have is that we have a price condition Z, with a access sequence. The table we created for this condition has the following fields: Destination country, Incoterms, Material Type.

We want to modify this condition and create a new table with the following fields: Bill-to-party country, Incoterms, Material Type. But the problem is that we can't find that "Bill-to-party country" field. The Country fields that exist now, are all refering to the destination country.

Thanks,

Iné

[Former Member]

Hi,

for this by taking ABAPer help u can add a field 'Bill-to-party country' in the field catelogue, then u r able 2 create the cond table asper ur reqt.

Cheers Chitty