topic Re: BDC code - Delete Customer Fax number in Application Development and Automation Discussions

BDC code - Delete Customer Fax number

Former Member — Tue, 14 May 2013 09:45:12 GMT

Hello Experts,

I'm using BDC code to delete the Fax number of Customer (table KNA1 / ADRC) - Field TELFX.

But it is not deleting the Fax number.

The same code is working for 'Change / Add' operations but not 'Delete'.

Here's my code:

PERFORM bdc_dynpro      USING 'SAPMF02D' '0101'.
  PERFORM bdc_field       USING 'BDC_CURSOR'
                                'RF02D-D0110'.
  PERFORM bdc_field       USING 'BDC_OKCODE'
                                '/00'.
  PERFORM bdc_field       USING 'RF02D-KUNNR'
                                p_kunnr.
  PERFORM bdc_field       USING 'RF02D-D0110'
                                'X'.
  PERFORM bdc_dynpro      USING 'SAPMF02D' '0110'.
  PERFORM bdc_field       USING 'BDC_CURSOR'
                                'KNA1-TELFX'.
  PERFORM bdc_field       USING 'BDC_OKCODE'
                                '=UPDA'.
  PERFORM bdc_field       USING 'KNA1-TELFX'
                                ' '.
    test-dismode = 'N'.
  test-updmode = 'S'.
  
  CALL TRANSACTION 'XD02' USING g_t_bdcdata OPTIONS FROM test
  MESSAGES INTO tab_mess AND SKIP FIRST SCREEN .

Please do let me know why DELETE is not working.

Please help.

Thanks & Regards,
Sowmya

Re: BDC code - Delete Customer Fax number

Former Member — Tue, 14 May 2013 11:32:58 GMT

Hi,

Use this

PERFORM bdc_field USING 'KNA1-TELFX'

' '.

PERFORM bdc_field USING 'BDC_OKCODE'

'=UPDA'.

Instead of

PERFORM bdc_field USING 'BDC_OKCODE'

'=UPDA'.

PERFORM bdc_field USING 'KNA1-TELFX'

' '.

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 08:45:26 GMT

Hi Rahul,

I tried as per your suggestion.

It is still not working.

Thanks & Regards,
Sowmya

Re: BDC code - Delete Customer Fax number

marcin_cholewczuk — Wed, 15 May 2013 09:05:02 GMT

Hi,

Try to run this report in mode 'A' (instead of 'N') to see what's going on.

My first shot would be that transaction is calling commit work twice (when you run bdc after first commit transaction ends). If that's the case then use addition OPTIONS FROM and set in field RACOMMIT value 'X'.

Best Regards

Marcin Cholewczuk

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 09:20:54 GMT

Hi Marcin,

Thanks for the reply.

I checked by changing the mode to 'A'. It just saves by setting Fax number = ' '.

But when I go and see using XD03, it has not deleted the Fax number.

I also tried RACOMMIT = 'X' as per your suggestion. But still it's not working.

Thanks & Regards,
Sowmya

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 09:27:52 GMT

The best way is to do a small recording for the same via SHD and then compare the existing code with the new program and just replace the code sequence of deletion of tel number with new code.

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 09:34:35 GMT

Rahul,

This code is taken from SHDB recording itself.

-Sowmya

Re: BDC code - Delete Customer Fax number

former_member193464 — Wed, 15 May 2013 09:40:12 GMT

try giving default size in your options as blank.....
test-defsize = space.

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 09:40:51 GMT

Dear Sowmya,

What happen if you run the recording in test mode ? Does this delete this fax Number or not.

Regards,

Rahul

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 09:59:37 GMT

I tried giving test-defsize = space.

It's not deleting the fax number.

-Sowmya

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:02:15 GMT

Hi Rahul,

In test mode, it is deleting the fax.

-Sowmya

Re: BDC code - Delete Customer Fax number

former_member193464 — Wed, 15 May 2013 10:15:03 GMT

delete that line AND SKIP FIRST SCREEN.

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:22:48 GMT

I removed the line AND SKIP FIRST SCREEN. Still not working.

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:26:18 GMT

PERFORM bdc_dynpro USING 'SAPMF02D' '0401'.

PERFORM bdc_field USING 'BDC_CURSOR'

'KNA1-TELFX'.

PERFORM bdc_field USING 'KNA1-TELFX'

' '.

PERFORM bdc_field USING 'BDC_OKCODE'

'=UPDA'.

please try above code i think it will solve your query

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:28:07 GMT

This means the error is in your code. Try to debug the same and run the program in foreground i hope this could be the error where "Screen field KNA1-TELFX does not exist" .This is my assumption .

Better to debug the same.

Re: BDC code - Delete Customer Fax number

former_member193464 — Wed, 15 May 2013 10:35:06 GMT

try giving a value like 'test' in KNA1-TELFX....

see if it updates a value... looks like it is not updating a blank value....

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:42:08 GMT

Hi Gaurav,

The above code is not working.

-Sowmya

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:43:43 GMT

Hi Maverick,

If I give any test value like '12345', then it is updating. If I give ' ' (space), then it doesn't.

So, BDC doesn't work here?

Thanks & Regards,

Sowmya

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 10:59:20 GMT

try to use

PERFORM bdc_field USING 'KNA1-TELFX'

space.

PERFORM bdc_field USING 'KNA1-TELFX'

' '.

Re: BDC code - Delete Customer Fax number

Former Member — Wed, 15 May 2013 11:11:48 GMT

I tried both space and ' '. It's not deleting Fax number