To: Carolyn Fuller

A p.req. approval can be identified as a change of the release status (field
EBAN-FRGZU). This is initially blank, then it may become 'X' (after first
approval), and then 'XX'. A refusal may change an 'X' to a blank, or an 'XX'
to 'X'.

P.Req. release status changes are logged as document changes. Hence, you can
find the "approved by" in the change log for the P.Req. (tables CDHDR,CDPOS).
For this purpose, you may query table CDPOS directly:
Select * from CDPOS into table I_CDPOS
  where  OBJECCLAS = 'BANF'
    and  OBJECTID = (p.req.#).
The whole approvals history is there. Relevant fields are:
FRGST - release strategy
FRGKZ - release indicator
FRGZU - release status

From: "Kyriakos P. Zavoleas" zavoleas@MIT.EDU

.................... CAO Home Page