The IXOS component table contains all information necessary to access the components of an OT document in the archive table. The reference is created via the “sapdocid” and “docidstr” fields (1:n).
| Field Name | Type | Description (OT Field Name) |
|---|---|---|
| DOCIDNO | number(12) | (ds_doc.docidno) |
| DOCIDSTR | VARCHAR2(40) | (ds_doc.docidstr) Join field: sapdocid=docidstr |
| DIRS | VARCHAR2(40) | (ds_doc.dirs) |
| DIRNO | NUMBER(10) | (ds_doc.dirno) |
| DOCDATE | DATE | (ds_doc.docdate) Conversion is necessary |
| MODDATE | DATE | (ds_doc.moddate) Conversion is necessary |
| Archiveno | number(4) | (ds_doc.archiveno) |
| Archiveid | varchar2(40) | (ds_arch.name) |
| Retention | Date | (ds_doc.retention) |
| COMPSNAME | VARCHAR2(16) | (ds_comp.compsname) |
| COMPONENT | VARCHAR2(128) | (ds_comp.component) |
| Version | number(4) | (ds_comp.version) |
| COMPTYPE_NAME | VARCHAR2(129) | (ds_comptype.name) |
| COMPDATE | DATE | (ds_comp.compdate) Conversion is nec-essary |
| CLENGTH | NUMBER(10) | (ds_comp.clength) |
| BLOBIDNO | number(12) | (ds_comp.blobidno) |
| Volid1 | number(9) | (ds_comp.volid[1]) |
| Volid2 | number(9) | (ds_comp.volid[2]) |
| Volid3 | number(9) | (ds_comp.volid[3]) |
The component table can contain various versions of data objects. The version information is stored in the „VERSION“ column. The IXOS connector uses only the latest version and ignores previous versions. All com-ponent information of the OT system is preserved, even if it is not yet needed.
It is the customer’s responsibility to migrate the OT data into the IXOS connector component table, since with-out this information, no documents can be extracted from the Siemens archive. The number of columns in the archive table can be expanded as needed to accommodate future growth. This is done via the SAPERION DDC Designer.