Link between SAP and Archive server opentext

[Former Member]

In this document, i would like to show link between sap document and opentext archive server.

Let take an example :

I would like to have information of SAP object ID 00001925250100 which is a Doc Type ZCS_ATTCHT of object type KNB1.

With transaction OAC3 (table  TOAOM_C), we get the cont Rep on which document is stored (F6) and we can see the table which is use to make link between SAP doc and opentext doc (TOA03):

ObjectType	Doc. Type	L	Cont.Rep.ID	Link	Retent.Period
KNB1	ZCS_ATTCHT	X	F6	TOA03	120

table which use to link SAP doc and arch doc for doc type ZCS_ATTCHT is TOA03. We can see the name of content repository F6. This content repository must exist in archvie server:

In TOA03, we get number of archive doc (ARC_DOC_ID):

MANDT	SAP_OBJECT	OBJECT_ID	ARCHIV_ID	ARC_DOC_ID	AR_OBJECT	AR_DAT	DEL_DATE	RESERVE
100	KNB1	00001925250100	F6	529CB3EFA7ED0FE0E10080000A7E7B6E	ZCS_ATTCHT	03.12.2013	03.12.2023	PDF
100	KNB1	00001925250100	F6	52A442C4B5D23110E10080000A7E7B6E	ZCS_ATTCHT	09.12.2013	09.12.2023	PDF
100	KNB1	00001925250100	F6	52A517D4E96C1D70E10080000A7E7B6E	ZCS_ATTCHT	10.12.2013	10.12.2023	PDF
100	KNB1	00001925250100	F6	52A60E47DFFD3110E10080000A7E7B6E	ZCS_ATTCHT	10.12.2013	10.12.2023	PDF

In order to know information in archive server, we can use SQL statement on Archive server database (need TOA03.ARC_DOC_ID= DS_DOC.DOCIDSTR)

select * from IXDS.DS_DOC WHERE DOCIDSTR

IN (

'529CB3EFA7ED0FE0E10080000A7E7B6E',

'52A442C4B5D23110E10080000A7E7B6E',

'52A517D4E96C1D70E10080000A7E7B6E',

'52A60E47DFFD3110E10080000A7E7B6E',

'52F7D186C46139C0E10080000A7E7B6E');

DOCIDNO	DOCIDSTR	DIRS	DIRNO	DOCDATE	MODDATE	OLDVOL	DOCTYPE	ARCHIVENO	RETENTION
54317061	529CB3EFA7ED0FE0E10080000A7E7B6E	747400	54317061	1386049475	1386049475		1	88	0
54463738	52A442C4B5D23110E10080000A7E7B6E	748912	54463738	1386585410	1386585414		1	88	0
54493522	52A517D4E96C1D70E10080000A7E7B6E	749231	54493522	1386671133	1386671133		1	88	0
54493314	52A60E47DFFD3110E10080000A7E7B6E	749228	54493314	1386668259	1386668259		1	88	0
55840029	52F7D186C46139C0E10080000A7E7B6E	712662	55840029	1392045090	1392045092		1	88	0

select * from IXDS.DS_COMP WHERE DOCIDNO IN (SELECT DOCIDNO FROM IXDS.DS_DOC WHERE DOCIDSTR

IN (

'529CB3EFA7ED0FE0E10080000A7E7B6E',

'52A442C4B5D23110E10080000A7E7B6E',

'52A517D4E96C1D70E10080000A7E7B6E',

'52A60E47DFFD3110E10080000A7E7B6E',

'52F7D186C46139C0E10080000A7E7B6E'));

DOCIDNO	COMPSNAME	COMPONENT	VOLID1	VOLID2	VOLID3	NO	TYPE	VERSION	COMPDATE	CLENGTH	PROTVERS	FLAGS	BLOBIDNO	LOC1	LOC2	LOC3	PLENGTH
54317061	DATA.;1	data	8			0	10	1	1386049475	79593	2	0					79593
54463738	DATA.;1	data	8			0	10	1	1386585410	79593	2	0					79593
54493522	DATA.;1	data	8			0	10	1	1386671133	79593	2	0					79593
54493314	DATA.;1	data	8			0	10	1	1386668259	79593	2	0					79593
55840029	DATA.;1	data	8			0	10	1	1392045090	79593	2	0					79593

select * from IXDS.DS_ARCH  WHERE ARCHIVENO='88';

ARCHIVENO	ARCHIVEID	MAPPEDID
88	F6

select * from IXDS.DS_VOLID WHERE VOLID='8';

VOLID	VOLNAME	VOLTYPE	BASEDIR	CAPACITY	PERCENT1	STATUS
8	Buffer_TEST_001	HDSK	/EXTALPOOL/LEA/TEST	0	2	16