Condition Values deletion

[Former Member]

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

[Former Member]

HI,

Refer to this link..

[Former Member]

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

[Former Member]

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

[Former Member]

dear ajay,

what do u mean by configuration of archiving ?

[Former Member]

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

[former_member632458]

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

[Former Member]

Hi Sekhar,

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

-Thanks,

Ajay