,CJ20

[Former Member]

Hi all,

Can anyone tell me which field corresponds to STATUS field in CJ20 transaction.

Thanks in advance

Regards

Neha Kapoor

[schneidertho · Accepted solution]

hi,

do you mean where the data for that field comes from?

db table is JEST

rgds.

thorsten

[Former Member]

Hi

Kindly check the following code to get the Status for a project.

SELECT SINGLE * FROM proj
WHERE pspid = projectnr.
  IF sy-subrc = 0.
    SELECT * FROM jest
    WHERE objnr = proj-objnr
    AND   not inact = 'X'.
  ENDIF. 
ENDSELECT.

Kindly reward points for useful answers!

best regards,

Thangesh