how to find from EBAN, the purchase requisition which are to be released???

[Former Member]

Hi,

How will we find from table EBAN, the purchase requisition which are to be released? I am developing a report and i need the Indicator field in the table and the value..

Thanks

[karun_prabhu]

Hello Johann.

Refer this thread http://scn.sap.com/thread/3328815

Regards.

[former_member217176]

HI Johann,

Check fileds FRGGR (Release group) and FRGSX(Release Strategy). and got to table T16FS and find the status. Below link may help u.

http://www.saptechnical.com/Tutorials/Workflow/POReleaseStrategy/Details.htm

Regards,

Jayaraj

[gouravkumar64]

Hi Gabriel,

You can try to build a link between EBAN & CDHDR/CDPOS,

write query for EBAN ,then check in CDPOS then CDHDR like this.

You will get PR number and date.

READ TABLE it_cdpos INTO wa_cdpos WITH KEY objectid = p_pdoc( po/pr number)

                                                tabkey+13 = p_item

                                                 value_new = wa_cdpos-value_old.

IF sy-subrc = 0.

     READ TABLE it_cdhdr INTO wa_cdhdr WITH KEY objectclas = wa_cdpos-objectclas

                   objectid =  wa_cdpos-objectid

                   changenr = wa_cdpos-changenr.

     lv_len_new  = strlen( wa_cdpos-value_new ).

     lv_len_old = strlen( wa_cdpos-value_old ).

     IF lv_len_new = 3 AND lv_len_old = 0.

       wa_out-reldr01 = wa_cdhdr-udate.

       wa_out-relnr01 = wa_cdhdr-username." reldr01 = sy-datum.

       wa_out-reldr02 = wa_cdhdr-udate.

       wa_out-relnr02 = wa_cdhdr-username.

       wa_out-reldr03 = wa_cdhdr-udate.

       wa_out-relnr03 = wa_cdhdr-username.

     ENDIF.

Thanks

Gourav.

[former_member209120]

Hi Johann,

if field  frgzu in table eban is empty then PR was not released 

  frgzu type eban-frgzu,              "Purchase req release

and  loekz should not 'X'

  loekz type eban-loekz,              "PR Deletion indicator

try like that..