cancel
Showing results for 
Search instead for 
Did you mean: 

What tables will be updated by creating a new condition Type : urgent plea

Former Member
0 Kudos

Dear All,

I am creating a new condition type, by coping a exisiting Condition type,

I am using the same access sequence and updating my pricing procedure, Please let me know what object will be modified by doing this. I mean to know what tables will be updated, Also let me know how do I know that information.

Thanks in Advance.

Regards

Venkat

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Venkat,

KONAIND Index: Groups of Conditions/Header Record Conditions

KOND Conditions (Data)

KOND3 Conditions: Campaign Determination - Data Part

KONDD Material Substitution - Data Division

KONDDP Conditions: Additional Materials for Material Determination

KONDH Conditions: Batch Strategy - Data Division

KONDI Conditions: Data part for certificates

KONDIND General Document Index for Conditions

KONDN Conditions: Free goods - Data section

KONDNS Conditions: Free goods determination - scales

KONDP Conditions: Packing Object Data Section

KONDR Conditions: Derivation strategy - data part

KONDRPR Conditions: Derivation strategy - recipient item data

KONDRPS Conditions: Derivation strategy - sender item data

KONDV Conditions: Data part for certificates

KONH Conditions (Header)

KONM Conditions (1-Dimensional Quantity Scale)

KONP Conditions (Item)

KONV Conditions (Transaction Data)

KONW Conditions (1-Dimensional Value Scale)

KOTN900 LSI Free Goods Condition Table

Hope this will help.

Regards,

Naveen.

Former Member
0 Kudos

Hi Naveen / Vijay,

Once gain thanks for your efforts,

I also realized that tables t685, t685t and t685a have not mentioned by you guys, I am sure that these tables are updated, as these for condition tables and I am talking about tables updated on creation of condition type. also wanted to know what are other tables effected ..when we create a condition record and assigne these condition type in pricing procedure.

please let me know.

Thanks & regards.

Alloting points for your efforts.

Venkat

Former Member
0 Kudos

Please advice me futher ..

Regards

Venkat

rajesh_potdar2
Explorer
0 Kudos

Venkat, you are right tables T685* are updated when you create a new condition type. When you assign this condition type to a pricing procedure table T683 definitely gets updated and additionally depending on configuration/ requirements associated tables like T683C(Batch search procedure: determination in sales doc.) , T683S, T683T, T683U, T683V, T683V_CMP (Campaign determination) may get updated. Also, if you are using condition exclusion for the new condition type then tables T684, T684G, T684S, T684T are also updated. Hope this helps. Pl award points if helpful.

Rajesh

Former Member
0 Kudos

Hi Rajesh,

Thanks for your reply.

Also let me know if tables like KNOV, KNOD, KNOP will have effect.

Regards

Venkat

rajesh_potdar2
Explorer
0 Kudos

Venkat,

i could not find the tables you mentioned (KNOV, KNOD, KNOP) to be active in the system that I use. However there is a table KNOB is related to Cost Accounting. You are better off taking CO consultant's view on it.

Rajesh

Former Member
0 Kudos

Hi Rajesh and others ,

once again thanks for your quick reply.

I made a mistake with table name but I was refering to KONH, KONP, KONM, KONW,KONV and KOND these tables.

Please confirm me that these tables will also effect by changing the pricing procedure.

Thanks ...

Thanks & Regards

Venkat

rajesh_potdar2
Explorer
0 Kudos

Tables KONH , KONP, KONM, KONW, KOND will be affected ONLY when you create condition records for the new condition type.

KONV will be affected only when a sales document which uses the pricing procedure that uses the new condition type is created and saved by a user.

Hope that clarifies.

- Rajesh

Former Member
0 Kudos

Hi Rajesh,

Thank you very much !!!

Your answers were very helpful. Thanking you once again.

Closing thread. alloting points.

Regards

Venkat

Former Member
0 Kudos

Hi All,

Thanks for your replies, I am done with config.. I am have closed this thread earlier but has one more doubt.

I came to know that t685, T685A, T685A have been changed due to creation of new condition type.

Tabke t683 will be updated on assigning this condition type to pricing procedure. Please let me know,

How do I confirm that. Will SAP show this information some where, Will this be like a pop up for something.

Please let me know, urgent please

Regards

Venkat

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Venkat,

When u create a Condition record, values are stored in A++

When u create a sales order values are picked up from A++, and the pricing structure is stored in KONV and KONP. For retrieving this key field is Condition record number.

We have another Table - KOND - Conditions (Data).which was missing in the list.

this was the flow of storing and retrieving the data in pricing tables A++,

KONH, KONP, KONM, KONW,KONV and KOND.

Hope this Clarifies your Doubt and Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula

Former Member
0 Kudos

Dear Vijay / Naveen,

Thanks for your quick response.

Vijay, You mentioned about creating a condition record and A+. I did not understand by A+, Moreover I am interested in knowing about tables or any other object updated while creating a <b>new condition type</b> not <b>condition record</b>, please let me know. I am new to pricing procedures ..

Also Naveen, you have given me a big list of tables, I did not understand properly, also I dont have any free goods, so How do I know which tables will be modified. I know that if you created a new condition type, after saving, the system will let you know what tables have been updated but here I am creating a functional spec in which I have to mention about that, even before copying a condition type,

Please help me.

Regards

venkat

Thanks

venkat

Former Member
0 Kudos

Hi Vijay,

Please advice further..

Regards

Venkat