R_CshFlwRcnlnBndlWthRcnldAmt

DDL: R_CSHFLWRCNLNBNDLWTHRCNLDAMT SQL: RBNDLWTHAMT Type: view COMPOSITE
19 Fields 1 Data Sources 3 Associations

Bundle Header with Reconciled Amount

R_CshFlwRcnlnBndlWthRcnldAmt is a Composite CDS View that provides data about "Bundle Header with Reconciled Amount" in SAP S/4HANA. It reads from 1 data source (I_CshFlwRcnlnBndl) and exposes 19 fields with key fields CashFlowReconciliationBundle, BankAccountInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CshFlwRcnlnBndl bundle from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_CshFlwRcnlnBndlAmtByBkAcct _BundleAmont _BundleAmont.CashFlowReconciliationBundle = bundle.CashFlowReconciliationBundle and _BundleAmont.BankAccountInternalID = bundle.BankAccountInternalID
[0..1] I_BankAccount _BankAccount _BankAccount.BankAccountInternalID = bundle.BankAccountInternalID
[0..1] I_ResidualForecastedMemoRecord _ResidualMemoRecord _ResidualMemoRecord.MemoRecord = bundle.MemoRecord

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RBNDLWTHAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bundle Header with Reconciled Amount view
VDM.viewType #COMPOSITE view
VDM.private false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CashFlowReconciliationBundle I_CshFlwRcnlnBndl CashFlowReconciliationBundle Reconciliation Bundle
KEY BankAccountInternalID I_CshFlwRcnlnBndl BankAccountInternalID Technical ID
CreatedByUser I_CshFlwRcnlnBndl CreatedByUser User Name
CreationDateTime I_CshFlwRcnlnBndl CreationDateTime Timestamp
CashFlowReconciliationStrategy I_CshFlwRcnlnBndl CashFlowReconciliationStrategy Reconciliation Strategy
CshFlwRcnlnBndlValDte I_CshFlwRcnlnBndl CshFlwRcnlnBndlValDte Value date
BankAccountCurrency _BundleAmont BankAccountCurrency Currency
RcnldBkStmntCshFlwAmount _BundleAmont RcnldBkStmntCshFlwAmount
RcnldFcstCshFlwAmount _BundleAmont RcnldFcstCshFlwAmount
MemoRecord MemoRecord Memo Record
AmountInTransactionCurrency _ResidualMemoRecord AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency _ResidualMemoRecord TransactionCurrency Transaction Currency
PlanningLevel _ResidualMemoRecord PlanningLevel Planning Level
CompanyCode _ResidualMemoRecord CompanyCode Receiver Company Code
MemoRecordDescription _ResidualMemoRecord MemoRecordDescription Text
MemoRecordStatus_2 _ResidualMemoRecord MemoRecordStatus_2 Memo Record Status
MemoRecordStatus _ResidualMemoRecord MemoRecordStatus Memo Record Status
_BankAccount _BankAccount
_ResidualMemoRecord _ResidualMemoRecord

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 R_CshFlwRcnlnBndlWthRcnldAmt.
-- 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: RBNDLWTHAMT

CREATE VIEW R_CshFlwRcnlnBndlWthRcnldAmt AS
SELECT
  bundle.CashFlowReconciliationBundle AS CashFlowReconciliationBundle,
  bundle.BankAccountInternalID AS BankAccountInternalID,
  bundle.CreatedByUser AS CreatedByUser,
  bundle.CreationDateTime AS CreationDateTime,
  bundle.CashFlowReconciliationStrategy AS CashFlowReconciliationStrategy,
  bundle.CshFlwRcnlnBndlValDte AS CshFlwRcnlnBndlValDte,
  _BundleAmont.BankAccountCurrency AS BankAccountCurrency,
  _BundleAmont.RcnldBkStmntCshFlwAmount AS RcnldBkStmntCshFlwAmount,
  _BundleAmont.RcnldFcstCshFlwAmount AS RcnldFcstCshFlwAmount,
  MemoRecord,
  _ResidualMemoRecord.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _ResidualMemoRecord.TransactionCurrency AS TransactionCurrency,
  _ResidualMemoRecord.PlanningLevel AS PlanningLevel,
  _ResidualMemoRecord.CompanyCode AS CompanyCode,
  _ResidualMemoRecord.MemoRecordDescription AS MemoRecordDescription,
  _ResidualMemoRecord.MemoRecordStatus_2 AS MemoRecordStatus_2,
  _ResidualMemoRecord.MemoRecordStatus AS MemoRecordStatus
FROM I_CshFlwRcnlnBndl AS bundle
LEFT OUTER JOIN P_CshFlwRcnlnBndlAmtByBkAcct AS _BundleAmont ON _BundleAmont.CashFlowReconciliationBundle = bundle.CashFlowReconciliationBundle AND _BundleAmont.BankAccountInternalID = bundle.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON _BankAccount.BankAccountInternalID = bundle.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_ResidualForecastedMemoRecord AS _ResidualMemoRecord ON _ResidualMemoRecord.MemoRecord = bundle.MemoRecord  -- association [0..1]
;

Learn More