CMS_OMS_DOC_LNK SAP table for – Documents Link

Here we would like to draw your attention to CMS_OMS_DOC_LNK table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_OMS_DOC_LNK is a SAP standard transp table used for storing Documents Link related data in SAP. It comes under the package CMS_OMS_COMMON.

SAP CMS_OMS_DOC_LNK table

Table CMS_OMS_DOC_LNK technical data

TableCMS_OMS_DOC_LNK
Data storingDocuments Link
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_OMS_COMMON
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_OMS_DOC_LNK Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_OMS_DOC_LNK table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for CMS_OMS_DOC_LNK
    Its a key field.
  • DOC_GUID : GUID for CMS_OMS_DOC_LNK
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link Key for OMS Links -Documents
  • DOC_LINK_GUID : GUID for OMS Links – Documents
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Struture with Document Details
  • DOC_REFERENCEID : Reference Document ID
    Its data type is CHAR (Character String) with field length 64
  • DOC_TYPE : Document Type
    Its data type is CHAR (Character String) with field length 6
  • DOC_DATE : Document Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PHYSICAL_LOCN : Physical Location of Document
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Validity Data for Documents (DB Format)
  • VALID_FROM : Date on which the Document came into effect
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • VALID_TO : Date until which the Document stands valid
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32