S4 Attachment Service with DMS: SAP Object Link Tables

[benoit-schmid]

Good Morning,

We have migrated from ECC 6.07 to S4 a few months ago.

I have noticed that users start to download documents (mostly PDF Files)
using the DMS/Attachment Services.

As I have never used DMS in the past, I am trying to understand
how these documents are linked to SAP Objects.

I have understood the following link.

1. The table DRAD links the SAP Document to a Document Number
---
DOKOB: Document Type = BUT000 for Business Partner
OBJKY: 1008729 = Document Partner Identifier
DOKNR: 10000000000 = Document Number
---

2. The table DMS_DOC2LOIO links the Document Number to a Logical Document
---
DOKNR : 10000000000 = Document Number
LO_OBJID: 005056AEE37B1EDEB2CE8AE0A4800DDD = Logical Document
---

3. The table DMS_PH_CD1 links the logical document to relative document information.
--
LOIO_ID : 005056AEE37B1EDEB2CE8AE0A4800DDD
PHIO_ID : Same as LOIO_ID
PH_CLASS: DMS_PCD1
LO_CLASS: DMS_LCD1
STOR CAT: DMS_C1_ST
---

4. The table DMS_PHF_CD1 also provides document informations for a Logical Document.

There is something that is not clear, for me.
There are Documents stored in the CMS and that exist in in the components tables (eg DMS_PH_CD1 and DMS_PHF_CD1) but do not exist in the DMS_DOC2LOIO & DRAD tables.

Basicaly, I find entries with the following select:
select LOIO_ID from dms_ph_cd1 where LOIO_ID not in ( select LO_OBJID from DMS_DOC2LOIO)

How can I find out the linked SAP Objects for these documents?

Have a nice day.

[Nico1966]

Table DRAD is the table linking a DIR (DMS Document Info Record) with a SAP Business object/document (BO type is stored in DRAD-DKOB, The BO document number in  DRAD-OBJKY)

BR, Nico Kuijper

[Nico1966]

And other tables that contain the object link between the BO object key and the DIR DMS document are: table DRAD_PORDER (DMS links for Production Orders), DMUD, /KPC/MM_APDO, etc.

[Nico1966]

Please go to SE11, enter data type OBJKY and search for SAP tables where the DMS DIR object key is used. That gives some insight in SAP tables that refer to DMS DIR BO object keys

[benoit-schmid]

Good Afternoon,

There are 38 tables with this Table Field:
I will perform the select and come back 🙂

Have a nice day.

[benoit-schmid]

Good Afternoon,

I have check the found tables, by checking which ones contains entries:

select 'CRMS4D_REC_MAP' from dummy where 0!=(select count(*) from "CRMS4D_REC_MAP");
select 'CRMS4M_ICM_DOC' from dummy where 0!=(select count(*) from "CRMS4M_ICM_DOC");
select 'CVSE_GUID' from dummy where 0!=(select count(*) from "CVSE_GUID");
select 'DMS_DOC_FOLDER3' from dummy where 0!=(select count(*) from "DMS_DOC_FOLDER3");
select 'DMUD' from dummy where 0!=(select count(*) from "DMUD");
select 'DRAD_DRAFT' from dummy where 0!=(select count(*) from "DRAD_DRAFT");
select 'DRAD' from dummy where 0!=(select count(*) from "DRAD");
select 'DRAD_LAST_CHANGE' from dummy where 0!=(select count(*) from "DRAD_LAST_CHANGE");
select 'DRAD_PORDER' from dummy where 0!=(select count(*) from "DRAD_PORDER");
select 'JVA_FILE_LOG' from dummy where 0!=(select count(*) from "JVA_FILE_LOG");
select 'KNA1_DRAD_DQ_RES' from dummy where 0!=(select count(*) from "KNA1_DRAD_DQ_RES");
select 'KNA1_DRAD_PRC' from dummy where 0!=(select count(*) from "KNA1_DRAD_PRC");
select 'KNA1_DRAD_SRC' from dummy where 0!=(select count(*) from "KNA1_DRAD_SRC");
select 'LFA1_DRAD_DQ_RES' from dummy where 0!=(select count(*) from "LFA1_DRAD_DQ_RES");
select 'LFA1_DRAD_PRC' from dummy where 0!=(select count(*) from "LFA1_DRAD_PRC");
select 'LFA1_DRAD_SRC' from dummy where 0!=(select count(*) from "LFA1_DRAD_SRC");
select 'MAINTNOTIF_D' from dummy where 0!=(select count(*) from "MAINTNOTIF_D");
select 'MAINTNTF_D' from dummy where 0!=(select count(*) from "MAINTNTF_D");
select 'MAINTWORKREQ_D' from dummy where 0!=(select count(*) from "MAINTWORKREQ_D");
select 'MARA_DRAD_DQ_RES' from dummy where 0!=(select count(*) from "MARA_DRAD_DQ_RES");
select 'MARA_DRAD' from dummy where 0!=(select count(*) from "MARA_DRAD");
select 'MARA_DRAD_PRC' from dummy where 0!=(select count(*) from "MARA_DRAD_PRC");
select 'MARA_DRAD_SRC' from dummy where 0!=(select count(*) from "MARA_DRAD_SRC");
select 'MARA_DRAD_STXH' from dummy where 0!=(select count(*) from "MARA_DRAD_STXH");
select 'MARA_DRAD_STXH_P' from dummy where 0!=(select count(*) from "MARA_DRAD_STXH_P");
select 'MARA_DRAD_STXH_S' from dummy where 0!=(select count(*) from "MARA_DRAD_STXH_S");
select 'MARA_DRAD_STXL' from dummy where 0!=(select count(*) from "MARA_DRAD_STXL");
select 'MARA_DRAD_STXL_P' from dummy where 0!=(select count(*) from "MARA_DRAD_STXL_P");
select 'MARA_DRAD_STXL_S' from dummy where 0!=(select count(*) from "MARA_DRAD_STXL_S");
select 'ODATA_CV_ATTACH' from dummy where 0!=(select count(*) from "ODATA_CV_ATTACH");
select '/PLMI/CR_DYNTHN' from dummy where 0!=(select count(*) from "/PLMI/CR_DYNTHN");
select 'RDSV_OUT_COPY' from dummy where 0!=(select count(*) from "RDSV_OUT_COPY");
select 'SIPT_PRINT_CHK' from dummy where 0!=(select count(*) from "SIPT_PRINT_CHK");
select '/SMERP/STG_PM005' from dummy where 0!=(select count(*) from "/SMERP/STG_PM005");
select '/SMERP/STG_PM010' from dummy where 0!=(select count(*) from "/SMERP/STG_PM010");
select 'STKO_DRAFT_V2' from dummy where 0!=(select count(*) from "STKO_DRAFT_V2");
select 'STPO_DRAFT_V2' from dummy where 0!=(select count(*) from "STPO_DRAFT_V2");
select 'VEERP_LINKS' from dummy where 0!=(select count(*) from "VEERP_LINKS");

By the way, in my S4 system there is no /KPC/MM_APDO table.

Only 4 tables contain entries:
 - DRAD and DRAD_LAST_CHANGE contains information for the same LOIO.
 - /PLMI/CR_DYNTHN does not contain relevant information
 - ODATA_CV_ATTACH contains a single entry

Therefore there is one entry that is considered temporary, which I do not know the exact meaning.
Would you know what is the meaning of an "attachment serviced" in temporary status?

Would you know how I could investigate for the other documents that are not in these tables?

Have a nice day.