I_AgreementTerminationAndCost

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_AgreementTerminationAndCost.
-- 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_AgreementTerminationAndCost AS
SELECT
  trmcst_guid AS AgrmtTerminationAndCostUUID,
  link_guid AS AgreementTermnAndCostLinkUUID,
  cost_typ AS AgreementCostType,
  cost_due_date AS AgreementCostDueDate,
  term_right_typ AS AgreementTermnRightType,
  term_reason AS AgreementTerminationReason,
  first_term_date AS AgrmtTerminationPossibleDate,
  term_notice_date AS AgreementTerminationNoticeDate,
  amount AS AgrmtTermnAndCostAmt,
  currency AS AgrmtTermnAndCostCrcy,
  unit_freq AS AgrmtTermnAndCostFrqcyUnit,
  period_freq AS AgrmtTermnAndCostFrqcyPeriod
FROM cms_cag_trmcst
LEFT OUTER JOIN I_CollateralAgreementData AS _CollateralAgreementData ON AgreementTermnAndCostLinkUUID = _CollateralAgreementData.CollateralAgreementUUID  -- association [0..1]
LEFT OUTER JOIN I_AgreementPortion AS _AgreementPortion ON AgreementTermnAndCostLinkUUID = _AgreementPortion.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPartner AS _AgreementPartner ON AgreementTermnAndCostLinkUUID = _AgreementPartner.AgreementPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_AgreementSpecialArrangement AS _AgreementSpecialArrangement ON AgreementTermnAndCostLinkUUID = _AgreementSpecialArrangement.AgrmtSpecialArrangementRefUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON AgreementTermnAndCostLinkUUID = _AssetAgreementLinkData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAgreementRelshp AS _CollateralAgreementRelshp ON AgreementTermnAndCostLinkUUID = _CollateralAgreementRelshp.AgreementRelationshipSrceUUID OR AgreementTermnAndCostLinkUUID = _CollateralAgreementRelshp.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON AgreementTermnAndCostLinkUUID = _CollateralObjectCalcData.CollateralObjectUUID AND _CollateralObjectCalcData.CollateralObjectType = 'CAG'  -- association [0..1]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON AgreementTermnAndCostLinkUUID = _AgreementAssetCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementRelshpCalcData AS _AgreementRelshpCalcData ON AgreementTermnAndCostLinkUUID = _AgreementRelshpCalcData.AgreementRelationshipSrceUUID OR AgreementTermnAndCostLinkUUID = _AgreementRelshpCalcData.AgreementRelationshipDestUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementPortionCalcData AS _AgreementPortionCalcData ON AgreementTermnAndCostLinkUUID = _AgreementPortionCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementReceivableCalcData AS _AgreementReceivableCalcData ON AgreementTermnAndCostLinkUUID = _AgreementReceivableCalcData.CollateralAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_AgreementCostType AS _AgreementCostType ON AgreementCostType = _AgreementCostType.AgreementCostType  -- association [0..1]
LEFT OUTER JOIN I_AgreementTermnRightType AS _AgreementTermnRightType ON AgreementTermnRightType = _AgreementTermnRightType.AgreementTermnRightType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _AgreementTerminationReason ON AgreementTerminationReason = _AgreementTerminationReason.CollateralAttributeIndType AND _AgreementTerminationReason.CollateralAttributeIndCat = 'CAG002'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AgrmtTermnAndCostCrcy ON AgrmtTermnAndCostCrcy = _AgrmtTermnAndCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_AgreementFrequencyUnit AS _AgrmtTermnAndCostFrqcyUnit ON AgrmtTermnAndCostFrqcyUnit = _AgrmtTermnAndCostFrqcyUnit.AgreementFrequencyUnit  -- association [0..1]
;