1. SAP Tutorial
  2. Financial Services

CMS_OMS_VAL_LNK SAP table for – Value Link

Here we would like to draw your attention to CMS_OMS_VAL_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_VAL_LNK is a SAP standard transp table used for storing Value Link related data in SAP. It comes under the package CMS_OMS_COMMON.

SAP CMS_OMS_VAL_LNK table

Table CMS_OMS_VAL_LNK technical data

TableCMS_OMS_VAL_LNK
Data storingValue 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_VAL_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_VAL_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 Value link
    Its a key field.
  • VAL_GUID : GUID for Value service
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link Key for OMS Links -Value
  • VAL_LINK_GUID : GUID for OMS Links – Values
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Value details
  • VAL_TYPE : Value Type
    Its data type is CHAR (Character String) with field length 6
  • CALC_AMOUNT : Calculated Value
    Its data type is CURR (Currency Field) with field length 17
  • CALC_AMT_CURR : Currency for Calculated Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ENTERED_AMOUNT : Entered Value
    Its data type is CURR (Currency Field) with field length 17
  • ENT_AMT_CURR : Currency for Entered Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VAL_VALID_FROM : Date from which Value Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_VALID_TO : Date until which Value Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_DATE : Date of First Valuation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_ORIGIN : Origin of Value
    Its data type is CHAR (Character String) with field length 6
  • .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

    • CMS_OMS_VAL_LNK related tables

    • TCMS_OMS_VALTY_T : Value type texts
    • TCMS_OMS_VALST : Value set
    • TCMS_OMS_CAT_T : Object Category – Text Table
    • TCMS_OMS_VL_VLST : Value sets
    • TCMS_OMS_FLDS_T : Text Table for Object field names
    • CMS_OMS_VAL_LNK : Value Link
    • TCMS_OMS_FEAT_T : Object Classification – Text
    • TCMS_OMS_FEAT : Object Classification
    • TCMS_INS_SET : Insurance Set
    • CMS_OMS_DOC_LNK : Documents Link
    • TCMS_OMS_VALST_T : Value set texts
    • TCMS_OMS_FLDS : Table for Object field names
    • TCMS_INS_SET_T : Insurance Set- Text Table
    • TCMS_OMS_CAT : Object Categories
    • CMS_OMS_BP_LNK : Business Partner Link
    • TCMS_OMS_VALTY : Value type (customizing)
    • TCMS_INS_TYP_SET : Insurance Types-> Insurance Sets
    • CMS_OMS_INS_LNK : Object – Insurance Link Data

    CMS_OMS_VAL_LNK related transaction codes under SAP package CMS_OMS_COMMON

    • CMS_CUS_COM_NR : Number range maintenance: CMS_MOV

    Related References

    Related Tutorials

    CMS_OMS_INS_LNK SAP table for – Object – Insurance Link Data

    CMS_OMS_INS_LNK table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Object...

    CMS_OMS_DOC_LNK SAP table for – Documents Link

    CMS_OMS_DOC_LNK table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Documents...

    CMS_OMS_BP_LNK SAP table for – Business Partner Link

    CMS_OMS_BP_LNK table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Business...

    VDINSURE_PARTNE0 SAP table for – Do Not Use: Link Partner <-> Insurance

    VDINSURE_PARTNE0 table in SAP FS (Loans Management in FS) module. This table is used for storing data of Do Not...

    /FSIH/LINK SAP table for – Table of Links Between Loan and Insurance Policy

    /FSIH/LINK table in SAP FS (Loans Management in FS) module. This table is used for storing data of Table of...

    CMS_CAG_RBL SAP table for – Collateral Agreement – Receivable Link Details

    CMS_CAG_RBL table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Collateral...

    CMS_SEC_ACC_DOC SAP table for – Link between securities account and Documents is stored here

    CMS_SEC_ACC_DOC table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Link...

    «
    »