I_CollateralCharge

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_CollateralCharge.
-- 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_CollateralCharge AS
SELECT
  chg_guid AS CollateralChargeUUID,
  ast_guid AS CollateralAssetUUID,
  cag_guid AS CollateralAgreementUUID,
  description AS CollateralChargeDescription,
  ranking_order AS ColltrlChargeRankingOrderValue,
  sequence AS CollateralChargeSequenceValue,
  reg_entry_no AS CollateralChargeRegisterNumber,
  reg_date AS CollateralChargeRegisterDate,
  ast_part_nr AS ColltrlAstPrtnShareNumerator,
  ast_part_dn AS ColltrlAstPrtnShareDenominator,
  asmt_amt AS ColltrlChargeAssessmentAmount,
  asmt_curr AS ColltrlChrgAssessmentCurrency,
  asmt_date AS CollateralChargeAssessmentDate,
  created_by AS CollateralChargeEnteredBy,
  created_at AS ColltrlChargeEnteredDateTime,
  changed_by AS CollateralChargeLastChangedBy,
  changed_at AS ColltrlChrgLastChgdDateTime,
  sourceofentry AS CollateralChargeEnteredSource,
  cast( substring( valid_from, 2, 8 ) as cms_dte_date ) AS CollateralChargeValidFromDate,
  cast( substring( valid_to, 2, 8 ) as cms_dte_date ) AS CollateralChargeValidToDate
FROM cms_chg
LEFT OUTER JOIN I_CollateralAgreementData AS _CollateralAgreementData ON CollateralAgreementUUID = _CollateralAgreementData.CollateralAgreementUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralAssetData AS _CollateralAssetData ON CollateralAssetUUID = _CollateralAssetData.CollateralAssetUUID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlChrgAssessmentCurrency ON ColltrlChrgAssessmentCurrency = _ColltrlChrgAssessmentCurrency.Currency  -- association [0..1]
;