cancel
Showing results for 
Search instead for 
Did you mean: 

Table field for PO releaser in R/3 (4.7 Enterprise)

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

see my last posting

Former Member
0 Kudos

Hi

Based on the Release code you would have identified & given authorization to a user for his user id then there is no question of not knowing who has released it, you can check in authorization for release code for which user it has been assigned.

Regards

Former Member
0 Kudos

Hi Ranganath,

many thanks for your response.

What is a <b>release code</b> and in what DB tables is it stored?

Best regards

/hw

Former Member
0 Kudos

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.