topic Re: reset flag in Application Development and Automation Discussions

reset flag

Former Member — Wed, 10 Jun 2009 09:46:13 GMT

Hi Experts I need an advice for the below case.

A flag which is set in the EBAN must be reseted. This

is the programm. It doesn't do that. What can be reason for that.

This is the Function Module Call from SAP SRM System with destination command.

CALL FUNCTION 'ZBM_RESET_FLAG'
 DESTINATION 'RV3CLNT888'
  EXPORTING
    BANFNUMBER        = ls_ITEM-EXT_DEMID
 EXCEPTIONS
   NOT_RESETED       = 1
   OTHERS            = 2.

The Function Module is in the the backendsystem (R/3).

FUNCTION ZBM_RESET_FLAG.
*"----------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"  IMPORTING
*"     VALUE(BANFNUMBER) TYPE  BANFN
*"  EXCEPTIONS
*"      NOT_RESETED
*"----------------------------------------------------------------------

  data lt_eban type table of eban.
  data ls_eban type eban.

  data:  l_r_banfn type table of ZBANFEN.

 SELECT * FROM eban into table lt_eban where BANFN EQ BANFNUMBER AND LOCKFLAG EQ 'X'.

  IF SY-SUBRC IS INITIAL.
    LOOP AT lt_eban INTO ls_eban .
      clear: ls_eban-LOCKFLAG .
      modify eban from ls_eban.
    ENDLOOP.
    ELSE.
    raise NOT_RESETED.
  ENDIF.

ENDFUNCTION.

Re: reset flag

Sandeep_Panghal — Wed, 10 Jun 2009 09:51:34 GMT

You may check in the backend system by debugging the system .

There can be an issue with the "modify eban from ls_eban."

Re: reset flag

Former Member — Wed, 10 Jun 2009 09:54:27 GMT

Hi,

The field BANFN has a conversion routine associated with it.

Just check whether the Purchase requisition number which you are passing to the FM via the variable

ls_ITEM-EXT_DEMID has padded 0's. If not then use FM CONVERSION_EXIT_ALPHA_INPUT in your RFC FM before the select statement.

Possibly the select statement is failing and hence the update is not happening.

Regards,

Ankur Parab

Re: reset flag

former_member609120 — Wed, 10 Jun 2009 09:55:21 GMT

Hi ertas,

Could you debug and check whether the select is successful.

Whether it is clearing the same entry for that particular record.

Best Regards,

Vanessa Noronha

Edited by: Vanessa Noronha on Jun 10, 2009 11:55 AM

Re: reset flag

rainer_hbenthal — Wed, 10 Jun 2009 10:04:49 GMT

i'm just wondering about that. Do you know how the UPDATE is working?


update eban
set lockflag = ' '
where banfn = banfnumber.
  and lockflag = 'X'.

no select, no loop, no modify. Add checking of sy-subrc and sy-dbcnt and give that back to the caller.

Edited by: Rainer Hübenthal on Jun 10, 2009 12:04 PM

Re: reset flag

kesavadas_thekkillath — Wed, 10 Jun 2009 10:07:58 GMT

looping at lt_eban

Modifying eban ..

Not possible


 LOOP AT lt_eban INTO ls_eban .   <--------
      clear: ls_eban-LOCKFLAG .
      modify eban from ls_eban.       <-----------
 ENDLOOP.

Re: reset flag

Former Member — Wed, 10 Jun 2009 10:09:06 GMT

when I call the Function Module within R/3 then it works

Re: reset flag

rainer_hbenthal — Wed, 10 Jun 2009 10:11:24 GMT

then your rfc connection is not working. But ... i would really change the coding.

Re: reset flag

Former Member — Wed, 10 Jun 2009 10:12:27 GMT

how ?

How else can you write this coding ?

Regards

ertas

Edited by: Ilhan Ertas on Jun 10, 2009 12:12 PM

Re: reset flag

rainer_hbenthal — Wed, 10 Jun 2009 10:14:10 GMT

Just read the answers.

Re: reset flag

Former Member — Wed, 10 Jun 2009 10:16:49 GMT

is that the answer ?

looping at lt_eban

Modifying eban ..

This is not a valid abap code

Re: reset flag

rainer_hbenthal — Wed, 10 Jun 2009 10:18:59 GMT

If you cant read i cant help you.

Re: reset flag

Former Member — Wed, 10 Jun 2009 10:20:55 GMT

TRANSPORTING addition in MODIFY statement may do the trick for you.


*MODIFY eban FROM ls_eban.
MODIFY eban FROM ls_eban TRANSPORTING lockflag.

Re: reset flag

rainer_hbenthal — Wed, 10 Jun 2009 10:23:08 GMT

if its not working without transporting, it will not work with transporting. But still silly coding.

Re: reset flag

kesavadas_thekkillath — Wed, 10 Jun 2009 10:27:05 GMT

Hi IIhan,

check the Prv post from Rainer .. Thatz it

and manish "MODIFY eban" is that possible

Re: reset flag

Former Member — Wed, 10 Jun 2009 10:28:44 GMT

Even i think so now..

My apologies..

Re: reset flag

Former Member — Wed, 10 Jun 2009 15:04:34 GMT

hi is there a commit work needed or not ?

Regards

ertas

Re: reset flag

Former Member — Thu, 11 Jun 2009 11:15:52 GMT

Dear Colleques,

the problem is still existing.

I have inserted a infinite loop and have called t-code sm50 and debugged this coding.

There is no sy-subrc <> 0 and any error message.

Is it not possible to update a dictionary table via remote call like in my case ?

What is worng here ?

Regards

ertas

data lzahl1 type i .
data lzahl2 type i .

lzahl1 = 0.
lzahl2 = 2.

while lzahl1 < lzahl2.
clear sy-subrc.
endwhile.


  data lt_eban type table of eban.
  data ls_eban type eban.

  data:  l_r_banfn type table of ZBANFEN.

  CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
    EXPORTING
      INPUT  = BANFNUMBER
    IMPORTING
      OUTPUT = BANFNUMBER.


  SELECT * FROM eban into table lt_eban where BANFN EQ BANFNUMBER AND LOCKFLAG EQ 'X'.

  IF SY-SUBRC IS INITIAL.
    LOOP AT lt_eban INTO ls_eban .
      UPDATe eban set lockflag = ' ' where banfn = ls_eban-BANFN.
     commit work and wait.
    ENDLOOP.
  ELSE.
    raise NOT_RESETED.
  ENDIF.

Re: reset flag

Former Member — Thu, 11 Jun 2009 11:20:18 GMT

Hi,

what is the type of teh field BANFNUMBER?

Is your select statement returning anything?

Regards,

Ankur Parab

Re: reset flag

Former Member — Thu, 11 Jun 2009 11:35:11 GMT

hi parab

the type of the field BANFNUMBER is BANFN

and the select statement is returning 0

Regards

ertas