C_CashFlowRcnlnBndl

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_CashFlowRcnlnBndl.
-- 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_CashFlowRcnlnBndl AS
SELECT
  CashFlowReconciliationBundle,
  BankAccountInternalID,
  BankAccountCurrency,
  RcnldBkStmntCshFlwAmount,
  RcnldFcstCshFlwAmount,
  RsdlMemoRecordAmount,
  CashFlowReconciliationProfile,
  CashFlowReconciliationStrategy,
  CashFlowReconciliationChannel,
  CreatedByUser,
  CreationDateTime,
  MemoRecord,
  PlanningLevel,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  AmountInTransactionCurrency,
  TransactionCurrency,
  MemoRecordStatus_2,
  MemoRecordStatus,
  CshFlwRcnlnBndlValDte,
  _MemoRecordText[1:Language = $session.system_language].MemoRecordStatusText AS MemoRecordStatusText,
  _RecnclnStrgyTxt[1:Language = $session.system_language].CshFlwRecnclnStrgyTxt AS CshFlwRecnclnStrgyTxt,
  _RecnclnChnlTxt[1:Language = $session.system_language].CshFlwRecnclnChnlTxt AS CshFlwRecnclnChnlTxt,
  _PlanningLevelText[1:Language = $session.system_language].PlanningLevelDescription AS PlanningLevelDescription
FROM R_CshFlwRcnlnBndlWthRcnldAmt AS Bundle
LEFT OUTER JOIN C_CshFlwRcnlnBndlBkStmntFlw AS _BkStmntFlow ON _BkStmntFlow.BankAccountInternalID = Bundle.BankAccountInternalID AND _BkStmntFlow.CashFlowReconciliationBundle = Bundle.CashFlowReconciliationBundle  -- association [0..*]
LEFT OUTER JOIN C_CshFlwRcnlnBndlFcstCshFlw AS _ForecastFlow ON _ForecastFlow.BankAccountInternalID = Bundle.BankAccountInternalID AND _ForecastFlow.CashFlowReconciliationBundle = Bundle.CashFlowReconciliationBundle  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = Bundle.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON _PlanningLevelText.PlanningLevel = Bundle.PlanningLevel  -- association [0..*]
LEFT OUTER JOIN I_MemoRecordStatusText_2 AS _MemoRecordText ON _MemoRecordText.MemoRecordStatus_2 = Bundle.MemoRecordStatus_2  -- association [0..*]
LEFT OUTER JOIN I_CshFlwRecnclnStrgyTxt AS _RecnclnStrgyTxt ON CashFlowReconciliationStrategy = _RecnclnStrgyTxt.CashFlowReconciliationStrategy  -- association [0..*]
LEFT OUTER JOIN I_CshFlwRecnclnChnlTxt AS _RecnclnChnlTxt ON CashFlowReconciliationChannel = _RecnclnChnlTxt.CashFlowReconciliationChannel  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
;