topic Re: Condition Values deletion in Application Development and Automation Discussions

Condition Values deletion

Former Member — Thu, 19 Mar 2009 07:10:30 GMT

Hi Experts,

i had a sales document having condition some condition types with values.

ZRPA condition type for which the condition values are entered manually not from condition records.

How to delete these values or these rows from my sales order.

Where these values are stored?

is there any bapi / function module to delete condition values from Sales order...

Pls tell me.

Thanks in advance

Re: Condition Values deletion

Former Member — Thu, 19 Mar 2009 07:25:36 GMT

HI,

Refer to this link..

Re: Condition Values deletion

Former Member — Thu, 19 Mar 2009 07:28:29 GMT

Hi,

pls try the Following FM

Hope they will be of some help ..

SD_SALES_CONDITION_MAINTAIN

WB2_DETERMINE_SALES_CONDITION

SALES_CONDITIONS_TABLE_DISPLAY

SALES_CONDITIONS_DIRECTLY_READ

SALES_CONDITIONS_POSTE

SALES_CONDITIONS_READ

SALES_CONDITIONS_READ_KVEWE_A

SALES_CONDITIONS_READ_KVEWE_N

regards

ravi aswani

Re: Condition Values deletion

Former Member — Thu, 19 Mar 2009 13:22:07 GMT

Hi,

If you want to delete condition values permanently then you have to go with archiving process. This archive process will archive the data from the table and deletes it from the database.

For archiving this you have to use archiving object SD_COND and in the write variant specify selection values that are to be deleted.

Note: Before executing configuration of archiving is required.

-Thanks,

Ajay

Re: Condition Values deletion

Former Member — Fri, 20 Mar 2009 07:49:01 GMT

dear ajay,

what do u mean by configuration of archiving ?

Re: Condition Values deletion

former_member632458 — Fri, 20 Mar 2009 08:17:28 GMT

Hi Sekhar,

U can Check the table KONV, All Condition Values r available in this table.

every sales order will generate one Condition Number KNUMV .against this Condition Val number U will get all the condtion types and values respectively. IF u want to check all the conditons ,those will be avalable at pricing Procedure.

Regards,

rajesh S

Re: Condition Values deletion

Former Member — Fri, 20 Mar 2009 08:17:59 GMT

Hi,

Configuration means,

1. File system configuration - This by default it will be present

2. Archive file size - 100 MB size

3. Deletion setting - Mark it for automatic

4. Store - Delete before store select

Path for the above > SARA > Enter archiving object > Customizing > Archiving object specific customizing > check for above mentioned.

After that you archive it.

-Thanks,

Ajay

Edited by: Ajay Kumar on Mar 20, 2009 9:18 AM

Re: Condition Values deletion

Former Member — Fri, 20 Mar 2009 10:10:28 GMT

Hi Sekhar,

This archiving process helps in deleting the data from the database but not from your sales order. Apologise for this.

-Thanks,

Ajay