I_AssetAgreementLinkData

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_AssetAgreementLinkData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_AssetAgreementLinkData AS
SELECT
  chg_guid AS AssetAgreementUUID,
  ast_guid AS ObjectAssetUUID,
  cag_guid AS CollateralAgreementUUID,
  description AS AssetAgreementDescription,
  ranking_order AS AssetAgreementRankingOrderVal,
  sequence AS AssetAgreementSequence,
  reg_entry_no AS AssetAgreementRegisterNumber,
  reg_date AS AssetAgreementRegisterDate,
  ast_part_nr AS AssetAgreementBPShareNumerator,
  ast_part_dn AS AssetAgreementBPShareDnmntr,
  ast_qty AS AssetAgreementQuantity,
  ast_value AS AssetAgreementAmount,
  asmt_amt AS AssetAgreementAssessmentAmount,
  asmt_curr AS AssetAgreementAssessmentCrcy,
  asmt_date AS AssetAgreementAssessmentDate,
  cast( substring(valid_from, 2, 8 ) as cms_dte_date ) AS AssetAgreementValidFromDate,
  cast( substring(valid_to, 2, 8 ) as cms_dte_date ) AS AssetAgreementValidToDate,
  _ObjectAssetData.ObjectAssetReferenceSystem AS ObjectAssetReferenceSystem,
  _ObjectAssetData.ObjectAssetUnitOfMeasure AS ObjectAssetUnitOfMeasure,
  _ObjectAssetData.ObjectAssetFinalCurrency AS ObjectAssetFinalCurrency
FROM cms_chg
LEFT OUTER JOIN I_CollateralAgreementData AS _CollateralAgreementData ON CollateralAgreementUUID = _CollateralAgreementData.CollateralAgreementUUID  -- association [0..1]
LEFT OUTER JOIN I_AgreementPartner AS _AgreementPartner ON CollateralAgreementUUID = _AgreementPartner.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortion AS _AgreementPortion ON CollateralAgreementUUID = _AgreementPortion.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementSpecialArrangement AS _AgreementSpecialArrangement ON CollateralAgreementUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementTerminationAndCost AS _AgreementTerminationAndCost ON CollateralAgreementUUID = _AgreementTerminationAndCost.AgreementTermnAndCostLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAgreementRelshp AS _CollateralAgreementRelshp ON CollateralAgreementUUID = _CollateralAgreementRelshp.AgreementRelationshipSrceUUID OR CollateralAgreementUUID = _CollateralAgreementRelshp.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _ObjectAssetData ON ObjectAssetUUID = _ObjectAssetData.ObjectAssetUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetPartner AS _ObjectAssetPartner ON ObjectAssetUUID = _ObjectAssetPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _ObjectAssetDocument ON ObjectAssetUUID = _ObjectAssetDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON ( CollateralAgreementUUID = _CollateralObjectCalcData.CollateralObjectUUID AND _CollateralObjectCalcData.CollateralObjectType = 'CAG' ) OR ( ObjectAssetUUID = _CollateralObjectCalcData.CollateralObjectUUID AND _CollateralObjectCalcData.CollateralObjectType = 'AST' )  -- association [0..*]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON CollateralAgreementUUID = _AgreementAssetCalcData.CollateralAgreementUUID AND ObjectAssetUUID = _AgreementAssetCalcData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementRelshpCalcData AS _AgreementRelshpCalcData ON CollateralAgreementUUID = _AgreementRelshpCalcData.AgreementRelationshipSrceUUID OR CollateralAgreementUUID = _AgreementRelshpCalcData.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortionCalcData AS _AgreementPortionCalcData ON CollateralAgreementUUID = _AgreementPortionCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON CollateralAgreementUUID = _AgreementReceivableCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _AssetAgreementAssessmentCrcy ON AssetAgreementAssessmentCrcy = _AssetAgreementAssessmentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectAssetFinalCurrency ON ObjectAssetFinalCurrency = _ObjectAssetFinalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ObjectAssetUnitOfMeasure ON ObjectAssetUnitOfMeasure = _ObjectAssetUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;