How to Delete the condition record in CRM

[Former Member]

HI,

Can you please help me how to delete the condition record from condition table in CRM.

Please explain the usage of FM CRMXIF_CONDITION_SEL_DELETE with examples.

I have also read the documention of the function module. How to use this FM for custom defined condition table.

(this is the code given in Documentation)

DATA-OBJECT_REPRESENTATION = 'E'

DATA-SEL_OPT-CT_APPLICATION = 'CRM'

DATA-SEL_OPT-OBJECT_TASK = 'D'

DATA-SEL_OPT-RANGE-FIELDNAME = 'PRODUCT_ID'

DATA-SEL_OPT-RANGE-R_SIGN = 'I' (Including)

DATA-SEL_OPT-RANGE-R_OPTION = 'EQ'

DATA-SEL_OPT-RANGE-R_VALUE_LOW = 'PROD_1'

Thanks

Shankar

[Former Member]

Hi,

This deletion of condition record solved by own. Its working fine.

[Former Member]

Hi Shankar,

I am using the same CRMXIF_CONDITION_SEL_DELETE function module to delete condition record present in CRM.

But it is giving me below error in the return table of the FM after i run the program. Can you please correct me if I am doing any thing wrong?

Error in lt_return: SMW3 CND_MAST_SEL_DEL_EXT_VALIDATE CND_M_SD

code:

ls_range-fieldname = 'PRODUCT_ID''.

ls_range-R_SIGN = 'I'.

ls_range-R_OPTION = 'EQ'.

ls_range-R_VALUE_LOW = '123456'.

APPEND ls_range TO lt_range.

MOVE lt_range TO ls_entry-SEL_OPT-range.

ls_data-SEL_OPT-object_task = 'D'.

ls_data-SEL_OPT-ct_application = 'CRM'.

ls_data-object_representation = 'E'.

CALL FUNCTION 'CRMXIF_CONDITION_SEL_DELETE'

EXPORTING

DATA = ls_date

IMPORTING

RETURN = lt_return

.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

IMPORTING

return = lt_ret.

Edited by: Saravanaprasad Nadar on Jul 7, 2010 1:27 AM

[Former Member]

Hi

The above code works for the deletion of the condition records

[Former Member]

Hello!

Can anybody delete only one particular condition record using CRMXIF_CONDITION_SEL_DELETE?

Can you show some examples?

Thank you!

Edited by: cat0100 on Sep 8, 2010 1:32 PM

[Former Member]

Go to Easy access Master data Prices and conditions-choose the application and maintanence group -in that select your condition type,and access the condition table for which you want to delete the record ,and then select that particular record and hit the delete button which is on the top.

hope this helps

[Former Member]

Hi,

Thanks for your reply.

I want to do it through the Program.

Thanks

Shankar