C_CashFlowRcnlnBndl

DDL: C_CASHFLOWRCNLNBNDL SQL: CCSHFLWRB Type: view CONSUMPTION
23 Fields 1 Data Sources 5 Associations

Bundle Header

C_CashFlowRcnlnBndl is a Consumption CDS View that provides data about "Bundle Header" in SAP S/4HANA. It reads from 1 data source (R_CshFlwRcnlnBndlWthRcnldAmt) and exposes 23 fields with key fields CashFlowReconciliationBundle, BankAccountInternalID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CshFlwRcnlnBndlWthRcnldAmt Bundle from

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_CshFlwRcnlnBndlBkStmntFlw _BkStmntFlow _BkStmntFlow.BankAccountInternalID = Bundle.BankAccountInternalID and _BkStmntFlow.CashFlowReconciliationBundle = Bundle.CashFlowReconciliationBundle
[0..*] C_CshFlwRcnlnBndlFcstCshFlw _ForecastFlow _ForecastFlow.BankAccountInternalID = Bundle.BankAccountInternalID and _ForecastFlow.CashFlowReconciliationBundle = Bundle.CashFlowReconciliationBundle
[0..1] I_CompanyCode _CompanyCode _CompanyCode.CompanyCode = Bundle.CompanyCode
[0..*] I_PlanningLevelText _PlanningLevelText _PlanningLevelText.PlanningLevel = Bundle.PlanningLevel
[0..*] I_MemoRecordStatusText_2 _MemoRecordText _MemoRecordText.MemoRecordStatus_2 = Bundle.MemoRecordStatus_2

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CCSHFLWRB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private false view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Reconciliation Bundle view
UI.headerInfo.typeNamePlural Reconciliation Bundles view
UI.headerInfo.title.label Reconciliation Bundle view
UI.headerInfo.title.value CashFlowReconciliationBundle view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Bundle Header view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CashFlowReconciliationBundle CashFlowReconciliationBundle Reconciliation Bundle
KEY BankAccountInternalID BankAccountInternalID Technical ID
BankAccountCurrency BankAccountCurrency Currency
RcnldBkStmntCshFlwAmount RcnldBkStmntCshFlwAmount
RcnldFcstCshFlwAmount RcnldFcstCshFlwAmount
RsdlMemoRecordAmount RsdlMemoRecordAmount
CashFlowReconciliationStrategy CashFlowReconciliationStrategy
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
MemoRecord MemoRecord Memo Record
PlanningLevel PlanningLevel Planning Level
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
MemoRecordStatus_2 MemoRecordStatus_2 Memo Record Status
MemoRecordStatus MemoRecordStatus Memo Record Status
CshFlwRcnlnBndlValDte CshFlwRcnlnBndlValDte
MemoRecordStatusText
_BkStmntFlow _BkStmntFlow
_BankAccount _BankAccount
_PlanningLevelText _PlanningLevelText
_MemoRecordText _MemoRecordText

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.
-- SQL view name: CCSHFLWRB

CREATE VIEW C_CashFlowRcnlnBndl AS
SELECT
  CashFlowReconciliationBundle,
  BankAccountInternalID,
  BankAccountCurrency,
  RcnldBkStmntCshFlwAmount,
  RcnldFcstCshFlwAmount,
  RsdlMemoRecordAmount,
  CashFlowReconciliationStrategy,
  CreatedByUser,
  CreationDateTime,
  MemoRecord,
  PlanningLevel,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  AmountInTransactionCurrency,
  TransactionCurrency,
  MemoRecordStatus_2,
  MemoRecordStatus,
  CshFlwRcnlnBndlValDte,
  _MemoRecordText[1:Language = $session.system_language].MemoRecordStatusText AS MemoRecordStatusText
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..*]
;

Learn More