I_AssetAgreementLinkData

Asset Agreement Link Details | view: IASTCAGLINKDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_CHGCMS_AST
Column Name Description
AssetAgreementUUID GUID for Table CMS_CHG
Column Name Description
💲 Currency of the Final Asset Value (ObjectAssetFinalCurrency):
AssetAgreementAmount Amount of Asset used as Charge
💲 CMS_DTE_CHG_ASMT_CURR (AssetAgreementAssessmentCrcy):
AssetAgreementAssessmentAmount Assessment amount of a charge
Column Name Description
📏 Unit of Measure of Quantity (ObjectAssetUnitOfMeasure):
AssetAgreementQuantity Size of the Asset used as Charge
Column Name Description
AssetAgreementRegisterDate Date on which the Land Charge was Registered
AssetAgreementAssessmentDate Date of assessment
AssetAgreementValidFromDate Date
AssetAgreementValidToDate Date
Column Name Description
Column Name Description Domain name
ObjectAssetUUID GUID for Table CMS_AST SYSUUID
CollateralAgreementUUID GUID for Table CMS_CAG SYSUUID
AssetAgreementDescription Description for Charges CMS_DSC
AssetAgreementRankingOrderVal Ranking of a Collateral Agreement in an Asset CMS_PRIORITY
AssetAgreementSequence Sequence of an Asset in a Collateral agreement CMS_PRIORITY
AssetAgreementRegisterNumber Register Number CMS_INTFID
AssetAgreementBPShareNumerator Numerator in Business Partner Share of Asset CMS_RATIO
AssetAgreementBPShareDnmntr Denominator in the Business Partner Share of Asset CMS_RATIO
ObjectAssetReferenceSystem Object System Reference ID CMS_SYS
Master Data Relations Join Conditions
Currency of the Final Asset Value
  • Currency of the Final Asset Value
  • Client
  • I_ASSETAGREEMENTLINKDATA.OBJECTASSETFINALCURRENCY == TCURC.WAERS
  • I_ASSETAGREEMENTLINKDATA.MANDT == TCURC.MANDT
Foreign key for unit of measure
  • Client
  • Unit of Measure of Quantity
  • I_ASSETAGREEMENTLINKDATA.MANDT == T006.MANDT
  • I_ASSETAGREEMENTLINKDATA.OBJECTASSETUNITOFMEASURE == T006.MSEHI