Link between SAP and Archive server opentext
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 | |
| 100 | KNB1 | 00001925250100 | F6 | 52A442C4B5D23110E10080000A7E7B6E | ZCS_ATTCHT | 09.12.2013 | 09.12.2023 | |
| 100 | KNB1 | 00001925250100 | F6 | 52A517D4E96C1D70E10080000A7E7B6E | ZCS_ATTCHT | 10.12.2013 | 10.12.2023 | |
| 100 | KNB1 | 00001925250100 | F6 | 52A60E47DFFD3110E10080000A7E7B6E | ZCS_ATTCHT | 10.12.2013 | 10.12.2023 |
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
|
Hi Mathieu,
thank you for this useful blog. Since you seem to know your stuff I hope you can answer two questions for me:
1. where can I find the relation between the ArchiveLink repository ID and the document ID in the ArchiveServer tables? So far we can see the RepID in the DS_ARCH, DS_AUDIT and JDS_STATISTIC but I don't see the correlation.
2. Is the data itself (digital documents) stored as a blob somewhere?
Much obliged
Marcel Rabe
University of Amsterdam
Hi Marcel,
Thank you for your comment. I wish you an Happy new year.
I will try to answer your questions.
For Point 2, the answer is no. Data are not store in the archiver server database. In the database, we will have only links between SAP document and archive doc id and the location where the document is archive.
For point 1,
Doc id is linked to VOLID/VOLNAME in table DS_VOLID (Buffer_TEST_001),
VOLNAME (Buffer_TEST_001 ) is linked to a POOLNAME (DiskBuffer_TEST) in TABLE DS_POOL,
DS_POOL.POOLNAME = DS_POOLTAB.HDSKPOOL(DiskBuffer_TEST) is linked to DS_POOLTAB.POOLNAME (F6_POOL_F6).
This DS_POOLTAB.POOLNAME = ADM_ARCHIVE.DSPOOLNAME (F6_POOL_F6) is linked to Archivename (Cont Rep ID) in ADM_ARCHIVE (F6).
I hope it helps you.
Excellent! Thanks for the response. The point about the data storage is very intriging: even if you install the software with the specific instruction to store the data in the database, it is still not stored in the DB but in the <RepID>Volume directory?
Hello Rabe ,
There is NO option available during installation to make the content store in the DB tables. You should be confused some way 😉
The whole point of having a external content(archive) server is to store it on repository. So that content can be managed in well organised way using separate resources other than SAP for pooling, buffering, squeezing, rententions, redemtions, untampered…etc…etc.
Thanks,
Kolusu
I just read this article..thanks for writing this
I am an amateur in this area. We are migrating our SAP landscape ECC7 toPrivate cloud. We are using Open text.. please can you guide how to migrate OPEN TEXT and documents in systematic manner so as user finds them in respective Trnsactions?
Please advise