Filesystem structure
KGS Store will create a directory tree which depends on the parameter FolderDepth. In the lowest subfolder the document data file will be saved.
Database structure
KGS Store uses three tables for storing all needed component and document information
Table: <Prefix_>DOCUMENT
| Field name | Field value | Type | Description |
|---|---|---|---|
| CSREPID (Index) | VARCHAR(40) | SAP ContentRepositoryID | |
| DOCID (Index) | VARCHAR(40) | SAP DocumentID | |
| ALVERS | 4500 | VARCHAR(4) | ArchiveLink-Version 0031 / 0045 |
| PROTECTION | VARCHAR(4) | SAP ProtectionFlag | |
| CREDATETIME | DATE | SAP creation timestamp | |
| MODDATETIME | DATE | SAP modification timestamp | |
| RETDATE | CHAR(8) | Retention Date | |
| BARCODE | CHAR(40) | SAP barcode (for future use) |
Table: <Prefix_>COMPONENT
| Field name | Field value | Type | Description |
|---|---|---|---|
| CSREPID (Index) | VARCHAR(40) | SAP ContentrepositoryID | |
| DOCID (Index) | VARCHAR(40) | SAP DocumentID | |
| COMPID (Index) | VARCHAR(512) | SAP CompID | |
| ALVERS | 4500 | VARCHAR(4) | ArchiveLink-Version 0031 / 0045 |
| CREDATETIME | DATE | SAP creation timestamp | |
| MODDATETIME | DATE | SAP modification timestamp | |
| RETDATE | DATE | Retentiondate | |
| APPVERS | VARCHAR(80) | SAP Application Version | |
| COMPTYPE | VARCHAR(80) | SAP Mimetype | |
| CHARSET | VARCHAR(80) | SAP Charset | |
| FILESIZE | NUMBER | ||
| FILEN | VARCHAR(512) | Filename in file system (if CONTAINERFILE is not empty, Filename of a ZIP Container) | |
| ORGFILEN | VARCHAR(512) | Original filename | |
| CONTAINERFILE | VARCHAR(255) | Filename in container (if container | |
| HASHALG | VARCHAR(10) | Hash algorithm | |
| HASKEY | VARCHAR(128) | Hash key | |
| HASHALGCONTFILE | VARCHAR(10) | Hash algorithm container file | |
| HASHKEYCONTFILE | VARCHAR(128) | Hash key container file |
Table: DOCUMENT_KEYS
| Field name | Field value | Type | Description |
|---|---|---|---|
| NAME (Index) | VARCHAR(40) | Key name | |
| VALUE (Index) | VARCHAR(255) | Key value | |
| CSREPID (Index) | VARCHAR(40) | SAP ContentrepositoryID | |
| DOCID (Index) | VARCHAR(40) | SAP DocumentID |
→ Configuration (Store) - STORAGEFSDB (3) | Configuration (Store) - StorageTypes - ArchiveLink