Delete entry in KONH table

[former_member623826]

Hello,

I have a requirement wherein I have to delete entries (condition records) from KONH table. The ABAP team is currently going into debug mode and deleting required condition records. But this is not the feasible solution. Please help.

Thanks in advance,

Abhinav

[Former Member]

Dear Abhinavavi

Can you please let us know the requirement please so that we can help you better.

Thanks&Regards

Raghu.k

[former_member623826]

Hello,

A program is supposed to report a material from a contract. But the program checks if any condition record exists in KONH for the master contract-material key (valid or not valid anymore). If a condition record exists, the program will not report the material. In my case, the condition record in master contract is no longer valid. Still entry is there in KONH. So program is finding this entry in KONH and thus not reporting the material (we want materail to be reported by program). So we want the condition record to be deleted from KONH.

Thanks,

Abhinav

[eduardo_hinojosa]

Hi

Usually archiving objects can do it. For instance, conditions for pricing, you do the customizing with V/06 and you set if the records are deleted or marked for deletion (ie: archiving). Use tcode DB15 to check the proper archiving object (pricing, acc.determination, and so on).

I hope this helps you

Regards

Eduardo

[Former Member]

Hi,

You said, "A program is supposed to report a material from a contract....". What is this program and how do you run it?

Regards,

[former_member623826]

@eduardo

Can you please tell me in detail how to archive condition records? Is it done through transaction db15? how to do it?

@himanshu

We have a customised program which runs and gives a report of all live contracts and its materials. One material is not coming in the report due to functionality built in program (if a condition record exists in table KONH with the key as master contract-material, then the program will not report that material; even if the condition record has expired). Now, we want to get the material in display of report, so the entry of condition record in KONH has to be deleted.

[Former Member]

Hi,

If you have a customised program then why can't you ignore the condition records which are not valid. To get the condition record number you must be quering some condition tables. You can add the date condition in the program as well.

Regards,

[former_member623826]

The current situation and requieremnt is an exception requirement. In egrenral this does not happen. So asking the ABAP team to change the program will require a lot of effort. So, for this time, if somehow condition records can be deleted from KONH, we can solve the case.

[Former Member]

Can you delete through the standard way? MEk2, Vk12 ?

[former_member623826]

If we use VK12/Mek2, still the entry of the condition record from table KONH will not be deleted.

[Former Member]

Did your program check for deletion flag at KONP table?

[jpfriends079]

Hello

Just a thought.

Why don't you considering logic to be introduced to your program where it considers validity date of master contract compared with the pricing condition type?

Regards

JP

[Former Member]

Hello,

Not recommended but can try and test in development system.

01. Go to condition type thru v/06

02. Go to master data tab of your condition type

03.Here you get delete fr. DB three options

04. Choose option B ( delete without pop up )

05 Save

06 Now go to VK12 , enter your condition type , key combination etc.

07 Select records and delete from Delete Row button located at bottom left hand side.

08. This will delete condition record from Database PERMANENTLY .

Thanks /Rajesh