I_ObjectValuationLinkData

Object Value Link Data | view: IOBJVALLNKDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_OMS_VAL_LNK, CMS_SHP
Column Name Description
ObjectValuationUUID GUID for Value service
Column Name Description
💲 Currency for Calculated Value (ObjectValuationCalculatedCrcy):
ObjectValuationCalculatedAmt Calculated Value
💲 Currency for Entered Value (ObjectValuationEnteredCurrency):
ObjectValuationEnteredAmount Entered Value
Column Name Description
Column Name Description
ObjectValuationValidFromDate Date from which Value Stands Valid
ObjectValuationValidToDate Date until which Value Stands Valid
ObjectFirstValuationDate Date of First Valuation
Column Name Description
Column Name Description Domain name
ObjectValuationLinkUUID GUID for OMS Links - Values SYSUUID
ObjectValuationEnteredDateTime Creation Timestamp TZNTSTMPS
ObjectValuationLastChgdDteTme Change Timestamp TZNTSTMPS
MovableObjectUUID GUID for CMS_MOVABLES SYSUUID
ShipObjectUUID Globally Unique Identifier SYSUUID
RightsObjectUUID Rights GUID SYSUUID
InsuranceObjectCategory Object Category CMS_OBJ_CAT
Master Data Relations Join Conditions
Foreign key for Currency
  • Currency for Calculated Value
  • Client
  • I_OBJECTVALUATIONLINKDATA.OBJECTVALUATIONCALCULATEDCRCY == TCURC.WAERS
  • I_OBJECTVALUATIONLINKDATA.MANDT == TCURC.MANDT
Currency for Entered Value
  • Client
  • Currency for Entered Value
  • I_OBJECTVALUATIONLINKDATA.MANDT == TCURC.MANDT
  • I_OBJECTVALUATIONLINKDATA.OBJECTVALUATIONENTEREDCURRENCY == TCURC.WAERS
Origin of Value
  • Client
  • Origin of Value
  • ?
  • I_OBJECTVALUATIONLINKDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_OBJECTVALUATIONLINKDATA.OBJECTVALUATIONORIGIN == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_OBJECTVALUATIONLINKDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Value Type I_OBJECTVALUATIONLINKDATA.MANDT == TCMS_OMS_VALTY.MANDT