cancel
Showing results for 
Search instead for 
Did you mean: 

Table where the document status is stored

Former Member
0 Kudos

Hi,

I'm looking for the document status (In Process, Invalid, Released) in cProjects.

Where can I find the status in the DB or which method exist to read it?

Thanks in advance.

Best regards,

Axel

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi, Axel!

Try this:

Table DPR_DOCUMENT --> get the EDMS_GUID

Use the EDMS_GUID as the OBJECT in table CRM_JEST.

Let me know if it worked! I've tried a quick test now and it seemed to work.

Regards,

Ivanna

mariano_sabiche
Active Participant
0 Kudos

Axel;

You have to check the DB if you want to find the documents.

In SAP R/3 in any kind of DB, you have this tables:

DMS_DOC2LOIO (relation with Logic ID to DMS Doc.)

PHIO_ID (physical identification)

DMS_PH_CD1 (if you have DMS configuration in CFolder)

Best regards,

Mariano

Former Member
0 Kudos

The table DPR_PROJECT didn't help. In cProjects documents can be assigned to various kind of objects (projects header, tasks, checklists,...). I'm interessted to the status of the assigned documents and not to the status of a project.

Former Member
0 Kudos

Table DPR_PROJECT contains the status column... Does that not help?