STORAGEFSDB - Additional Information

KGS Store will create a directory tree which depends on the parameter FolderDepth. In the lowest subfolder the document data file will be saved.

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	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