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:

archive_F6.png

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
To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. M. Rabe

    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

    (0) 
    1. Mathieu GRAVIL Post author

      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.

      Archive2.png

      ARCHIVE_F6.png

      (0) 
      1. M. Rabe

        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?

        (0) 
        1. Kolusu Suresh Kumar

          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

          (0) 

Leave a Reply