on 11-02-2010 9:34 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Table DPR_PROJECT contains the status column... Does that not help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.