C_Cn_RecnclnBankStatementItem

DDL: C_CN_RECNCLNBANKSTATEMENTITEM SQL: CCNRECBKSTMNTITM Type: view CONSUMPTION Package: GLO_FIN_EPIC_CN
29 Fields 1 Data Sources 4 Associations

Bank Statement Items for BkRecnclnStmnt

C_Cn_RecnclnBankStatementItem is a Consumption CDS View that provides data about "Bank Statement Items for BkRecnclnStmnt" in SAP S/4HANA. It reads from 1 data source (I_CN_RecnclnBankStatementItem) and exposes 29 fields with key fields CompanyCode, HouseBank, HouseBankAccount, BankReconciliationDate, BankStatementShortID. It has 4 associations to related views. Part of development package GLO_FIN_EPIC_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_RecnclnBankStatementItem BankStatementItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Arbankstatementitem _BankStatementItem BankStatementItem.BankStatementItem = _BankStatementItem.BankStatementItem and BankStatementItem.BankStatement = _BankStatementItem.BankStatementShortID
[0..1] I_Arbsitmemolinewithorig _MemoLine $projection.BankStatementShortID = _MemoLine.BankStatementShortID and $projection.BankStatementItem = _MemoLine.BankStatementItem
[1] C_CN_BankRecnclnStatement _BankReconciliationStatement BankStatementItem.CompanyCode = _BankReconciliationStatement.CompanyCode and BankStatementItem.HouseBank = _BankReconciliationStatement.HouseBank and BankStatementItem.HouseBankAccount = _BankReconciliationStatement.HouseBankAccount and BankStatementItem.BankReconciliationDate = _BankReconciliationStatement.BankReconciliationDate
[0..1] C_CN_BankReconciliationItem _BankReconciliation BankStatementItem.CompanyCode = _BankReconciliation.CompanyCode and BankStatementItem.HouseBank = _BankReconciliation.HouseBank and BankStatementItem.HouseBankAccount = _BankReconciliation.HouseBankAccount and BankStatementItem.BankReconciliationDate = _BankReconciliation.BankReconciliationDate

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCNRECBKSTMNTITM view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Bank Statement Items for BkRecnclnStmnt view
UI.headerInfo.typeName Bank Statement Item view
UI.headerInfo.typeNamePlural Bank Statement Item view
UI.headerInfo.title.value BankStatement view
UI.headerInfo.description.value BankStatementItem view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CN_RecnclnBankStatementItem CompanyCode Receiver Company Code
KEY HouseBank I_CN_RecnclnBankStatementItem HouseBank House Bank
KEY HouseBankAccount I_CN_RecnclnBankStatementItem HouseBankAccount House Bank Account
KEY BankReconciliationDate I_CN_RecnclnBankStatementItem BankReconciliationDate Reconciliation Date
KEY BankStatementShortID I_CN_RecnclnBankStatementItem BankStatement Bank Statement No.
KEY BankStatementItem I_CN_RecnclnBankStatementItem BankStatementItem Memo Record No.
Note I_CN_RecnclnBankStatementItem Note TradeRequest Comment
BankStatement _BankStatementItem BankStatement Bank Statement No.
BankReconciliationMatchType I_CN_RecnclnBankStatementItem BankReconciliationMatchType Matched indicator
ValueDate _BankStatementItem ValueDate Value Date
TransactionCurrency _BankStatementItem TransactionCurrency Transaction Currency
MemoLine _MemoLine MemoLine Memo Line
AssignmentReference _BankStatementItem AssignmentReference Assignment Reference
BankLedgerDocument _BankStatementItem BankLedgerDocument
FiscalYear _BankStatementItem FiscalYear G/L Fiscal Year
PostingDate _BankStatementItem PostingDate Posting Date for GR
PaymentTransaction _BankStatementItem PaymentTransaction Bus Trans Code
PaymentExternalTransacType _BankStatementItem PaymentExternalTransacType
OriginalCurrency _BankStatementItem OriginalCurrency
AmountInOriginalCurrency _BankStatementItem AmountInOriginalCurrency
DocumentItemText _BankStatementItem DocumentItemText Text
AmountInTransactionCurrency _BankStatementItem AmountInTransactionCurrency Pt Crcy Amt
PaymentManualTransacType _BankStatementItem PaymentManualTransacType
PartnerBank
PartnerBankAccount _BankStatementItem PartnerBankAccount
BusinessPartnerName _BankStatementItem BusinessPartnerName Extracted Customer Name
_BankStatementItem _BankStatementItem
_BankReconciliation _BankReconciliation
_BankReconciliationStatement _BankReconciliationStatement

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_Cn_RecnclnBankStatementItem.
-- 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: CCNRECBKSTMNTITM

CREATE VIEW C_Cn_RecnclnBankStatementItem AS
SELECT
  BankStatementItem.CompanyCode AS CompanyCode,
  BankStatementItem.HouseBank AS HouseBank,
  BankStatementItem.HouseBankAccount AS HouseBankAccount,
  BankStatementItem.BankReconciliationDate AS BankReconciliationDate,
  BankStatementItem.BankStatement AS BankStatementShortID,
  BankStatementItem.BankStatementItem AS BankStatementItem,
  BankStatementItem.Note AS Note,
  _BankStatementItem.BankStatement AS BankStatement,
  BankStatementItem.BankReconciliationMatchType AS BankReconciliationMatchType,
  _BankStatementItem.ValueDate AS ValueDate,
  _BankStatementItem.TransactionCurrency AS TransactionCurrency,
  _MemoLine.MemoLine AS MemoLine,
  _BankStatementItem.AssignmentReference AS AssignmentReference,
  _BankStatementItem.BankLedgerDocument AS BankLedgerDocument,
  _BankStatementItem.FiscalYear AS FiscalYear,
  _BankStatementItem.PostingDate AS PostingDate,
  _BankStatementItem.PaymentTransaction AS PaymentTransaction,
  _BankStatementItem.PaymentExternalTransacType AS PaymentExternalTransacType,
  _BankStatementItem.OriginalCurrency AS OriginalCurrency,
  _BankStatementItem.AmountInOriginalCurrency AS AmountInOriginalCurrency,
  _BankStatementItem.DocumentItemText AS DocumentItemText,
  _BankStatementItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _BankStatementItem.PaymentManualTransacType AS PaymentManualTransacType,
  cast(_BankStatementItem.PartnerBank as farp_pablz ) AS PartnerBank,
  _BankStatementItem.PartnerBankAccount AS PartnerBankAccount,
  _BankStatementItem.BusinessPartnerName AS BusinessPartnerName
FROM I_CN_RecnclnBankStatementItem AS BankStatementItem
LEFT OUTER JOIN I_Arbankstatementitem AS _BankStatementItem ON BankStatementItem.BankStatementItem = _BankStatementItem.BankStatementItem AND BankStatementItem.BankStatement = _BankStatementItem.BankStatementShortID  -- association [0..1]
LEFT OUTER JOIN I_Arbsitmemolinewithorig AS _MemoLine ON BankStatementShortID = _MemoLine.BankStatementShortID AND BankStatementItem = _MemoLine.BankStatementItem  -- association [0..1]
LEFT OUTER JOIN C_CN_BankRecnclnStatement AS _BankReconciliationStatement ON BankStatementItem.CompanyCode = _BankReconciliationStatement.CompanyCode AND BankStatementItem.HouseBank = _BankReconciliationStatement.HouseBank AND BankStatementItem.HouseBankAccount = _BankReconciliationStatement.HouseBankAccount AND BankStatementItem.BankReconciliationDate = _BankReconciliationStatement.BankReconciliationDate  -- association [1]
LEFT OUTER JOIN C_CN_BankReconciliationItem AS _BankReconciliation ON BankStatementItem.CompanyCode = _BankReconciliation.CompanyCode AND BankStatementItem.HouseBank = _BankReconciliation.HouseBank AND BankStatementItem.HouseBankAccount = _BankReconciliation.HouseBankAccount AND BankStatementItem.BankReconciliationDate = _BankReconciliation.BankReconciliationDate  -- association [0..1]
;

Learn More