CMS_OMS_VAL_LNK

Value Link | #masterdata | Component: Master Data
Column Name Description
MANDT FK Client
VAL_GUID GUID for Value service
Column Name Description
💲 Currency for Calculated Value (CALC_AMT_CURR):
CALC_AMOUNT Calculated Value
💲 Currency for Entered Value (ENT_AMT_CURR):
ENTERED_AMOUNT Entered Value
Column Name Description
Column Name Description
VAL_VALID_FROM Date from which Value Stands Valid
VAL_VALID_TO Date until which Value Stands Valid
VAL_DATE Date of First Valuation
Column Name Description
Column Name Description Domain name
VAL_LINK_GUID GUID for OMS Links - Values SYSUUID
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
Master Data Relations Join Conditions
Foreign key for Currency
  • CMS_OMS_VAL_LNK.MANDT == TCURC.MANDT
  • CMS_OMS_VAL_LNK.CALC_AMT_CURR == TCURC.WAERS
Currency for Entered Value
  • CMS_OMS_VAL_LNK.MANDT == TCURC.MANDT
  • CMS_OMS_VAL_LNK.ENT_AMT_CURR == TCURC.WAERS
Foreign key for Mandt CMS_OMS_VAL_LNK.MANDT == T000.MANDT
Origin of Value
  • ?
  • Client
  • Origin of Value
Value Type CMS_OMS_VAL_LNK.MANDT == TCMS_OMS_VALTY.MANDT