topic Re: Reservation in Application Development and Automation Discussions

Reservation

Former Member — Wed, 06 Jun 2007 17:24:09 GMT

Hi,

In my program, I have to check whether a material has any open reservation. Could anyone please tell me how should I check that in a program?

Thanks..

Uma.

Re: Reservation

RichHeilman — Wed, 06 Jun 2007 17:28:33 GMT

Maybe you could look at the reservation table RESB.

Regards,

Rich Heilman

Re: Reservation

Former Member — Wed, 06 Jun 2007 17:35:19 GMT

How should I get the open reservations from that table?

how will i check whether it is open or closed? I can only see the Deleted field in that table, which says whether the reservation is deleted or not.

Please let me know..

Thanks

Uma

Re: Reservation

Former Member — Wed, 06 Jun 2007 17:38:07 GMT

Main table is : RESB

FM : HRCA_MAT_RESITEM_GET

Re: Reservation

Former Member — Wed, 06 Jun 2007 17:42:03 GMT

KZEAR = space

Re: Reservation

Former Member — Thu, 14 Jun 2007 14:44:56 GMT

If I just check in RESB table for KZEAR = space, it is giving a list of open reservation. But if check for that reservation in MB23, for few reservations it says "Reservation 0000000522 does not exist".

Is there any other way to check for open reservations? I tried using "BAPI_RESERVATION_GETITEMS" to get any open reservations, but even this is giving similar result as looking for in table RESB for KZEAR = space

Please let me know if there are any other way to find open reservations.

Thanks..

Uma.

Re: Reservation

Former Member — Thu, 14 Jun 2007 14:48:33 GMT

Check like this,


  SELECT *
         FROM  RESB
         APPENDING TABLE PET_RESB
         WHERE MATNR IN S_MATNR
         AND   WERKS IN S_WERKS
         AND   BDTER IN S_BDTER
         AND   SCHGT =  SP_SCHGT         "OPL993 nur/kein Schüttgut
         AND   XLOEK = SPACE.
* Filtern lt. Selektion

* Filtern lt. Selektion
  PERFORM FILTER_BEDARFE CHANGING IT_RESB[].
FORM FILTER_BEDARFE CHANGING PIET_RESB TYPE RESB_TAB.

  CHECK ALLES IS INITIAL.

  LOOP AT PIET_RESB INTO WA_RESB.
    IF WA_RESB-RESB-ENMNG >= WA_RESB-RESB-BDMNG
    OR WA_RESB-RESB-KZEAR <> SPACE.
      DELETE PIET_RESB.
    ENDIF.
  ENDLOOP.

ENDFORM.                    " filter_bedarfe

Vasanth