What is the table field for PO releaser in R/3 (4.7 Enterprise)?

[Former Member]

Hi Gurus out there:

Do you know if there is a table field for PO releaser in R/3 (4.7 Enterprise)?

We use for e.g. the transaction ME29N to release a PO and I haven't been able to find a DB table where the PO releaser is stored.

In DB table EKKO I can find the fields FRGGR (Release group), FRGSX (Release strategy), FRGKE (Release Indicator), FRGZU (Release status) and FRGRL (Release Not Yet Completely Effected) but no information of the user who released the PO.

Many thanks in advance.

/hw

[Former Member]

Hi

You need to look in table <b>T16FG</b> (Release Groups) to find all the required field contents/values.

Do let me know.

Regards

- Atul

[Former Member]

Hi Atul,

many thanks for your response.

Table T16FG (Release Groups) doesn't contain the PO releaser (user who released a PO).

/hw

[Former Member]

Hi

<b>Have you tried reading the details of the PO Releaser using the BAPIs ?</b>

BAPI_PO_GETRELINFO

BAPI_PO_GETITEMSREL

 BAPI_PO_GETITEMSREL            List Purchase Orders for Release (Approval): New as of 4.0A      

 BAPI_PO_GETRELINFO             Display Detailed Release (Approval) Information on Purchase Order

BAPI_PO_RELEASE                Release Purchase Orders             

BAPI_PO_RESET_RELEASE          Cancel Release of Purchase Orders   

<u>Related link -></u>

Hope this will help.

Do let me know.

Regards

- Atul

[Former Member]

HI Atul,

many thanks again for your quick response. Unfortunately those BAPIs don't tell you any information about the user who released the PO.

Meanwhile I have found a solution to this problem:

CONCATENATE sy-mandt <ekko-ebeln> INTO tabkey.

SELECT SINGLE * FROM cdpos

WHERE objectclas = 'EINKBELEG'

AND objectid = <ekko-ebeln>

AND tabname = 'EKKO'

AND tabkey = tabkey

AND fname = 'FRGKE'

AND chngind = 'U'

AND value_new = '1'. " PO has been released

IF sy-subrc = 0.

SELECT SINGLE username

FROM cdhdr

INTO po_releaser

WHERE objectclas = 'EINKBELEG'

AND objectid = oitab-ebeln

AND changenr = cdpos-changenr.

ENDIF.