C_CndnContrSettlmtCal_F5989

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 C_CndnContrSettlmtCal_F5989.
-- 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 C_CndnContrSettlmtCal_F5989 AS
SELECT
  ConditionContract,
  SettlmtDate,
  SettlmtDateCat,
  SettlmtDateSequentialID,
  CndnContrCalItemUUID,
  RefSettlmtDate,
  RefSettlmtDateSequentialID,
  SettlmtExecutionDate,
  SettlementFixedValueDate,
  BusVolDateFrom,
  BusVolDateTo,
  SettlmtDateUsage,
  CndnContrSourceCalItemUUID,
  R_CndnContrSettlmtCalTP._ConditionContract.CndnContrUUID AS CndnContrUUID,
  R_CndnContrSettlmtCalTP._ConditionContract.CndnContrType AS CndnContrType,
  R_CndnContrSettlmtCalTP._ConditionContract.CndnContrSuplrSettlmtCat AS CndnContrSuplrSettlmtCat,
  R_CndnContrSettlmtCalTP._SettlmtDateCat._Text.SettlmtDateCatName : localized AS SettlmtDateCatNamelocalized,
  _ConditionContract._CndnContrType.CndnContrPrtlSettlmtCat AS CndnContrPrtlSettlmtCat,
  virtual SettlmtMgmtSchedgWl : wlf_swl_id AS virtualSettlmtMgmtSchedgWlwlf_swl_id,
  virtual UICT_Hdr_Settlement_Status : boolean AS virtualUICT_Hdr_Settlement_Statusboolean,
  virtual UICT_Coll_Gen_Info : boolean AS virtualUICT_Coll_Gen_Infoboolean,
  virtual UICT_Fldgrp_Date_Details : boolean AS virtualUICT_Fldgrp_Date_Detailsboolean,
  virtual UICT_Fldgrp_BusVol_Dates : boolean AS virtualUICT_Fldgrp_BusVol_Datesboolean,
  virtual UICT_Fldgrp_SWL : boolean AS virtualUICT_Fldgrp_SWLboolean,
  virtual UICT_PrtlSettlmtCat : boolean AS virtualUICT_PrtlSettlmtCatboolean
FROM R_CndnContrSettlmtCalTP
LEFT OUTER JOIN C_SettlmtDoc_F5989 AS _SettlementDocuments ON ConditionContract = _SettlementDocuments.SettlmtReltdCndnContr AND SettlmtDate = _SettlementDocuments.SettlmtDate AND SettlmtDateCat = _SettlementDocuments.SettlmtDateCat  -- association [0..*]
;