C_CN_BankReconciliationItem

DDL: C_CN_BANKRECONCILIATIONITEM SQL: CCNBKRECNCLNITEM Type: view CONSUMPTION
26 Fields 1 Data Sources 4 Associations

Bank Reconciliation Item for China

C_CN_BankReconciliationItem is a Consumption CDS View that provides data about "Bank Reconciliation Item for China" in SAP S/4HANA. It reads from 1 data source (I_CN_BankRecnclnItem) and exposes 26 fields with key fields CompanyCode, HouseBank, HouseBankAccount, BankReconciliationDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CN_BankRecnclnItem I_CN_BankRecnclnItem from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Associations (4)

CardinalityTargetAliasCondition
[0..*] C_Cn_RecnclnBankStatementItem _BankStatementItem BR.CompanyCode = _BankStatementItem.CompanyCode and BR.HouseBank = _BankStatementItem.HouseBank and BR.HouseBankAccount = _BankStatementItem.HouseBankAccount and BR.BankReconciliationDate = _BankStatementItem.BankReconciliationDate
[0..*] C_CN_RecnclnJournalEntryItem _JournalEntryItem BR.CompanyCode = _JournalEntryItem.CompanyCode and BR.HouseBank = _JournalEntryItem.HouseBank and BR.HouseBankAccount = _JournalEntryItem.HouseBankAccount and BR.BankReconciliationDate = _JournalEntryItem.BankReconciliationDate
[1] I_CompanyCodeVH _CompanyCodeVH BR.CompanyCode = _CompanyCodeVH.CompanyCode
[1] I_HouseBankAccountVH _HouseBankAccountVH BR.CompanyCode = _HouseBankAccountVH.CompanyCode and BR.HouseBank = _HouseBankAccountVH.HouseBank and BR.HouseBankAccount = _HouseBankAccountVH.HouseBankAccount

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCNBKRECNCLNITEM 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 #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
EndUserText.label Bank Reconciliation Item for China view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode BR CompanyCode Receiver Company Code
KEY HouseBank BR HouseBank House Bank
KEY HouseBankAccount BR HouseBankAccount House Bank Account
KEY BankReconciliationDate BR BankReconciliationDate
Ledger BR Ledger Ledger
HouseBankCurrency BR HouseBankCurrency
BankAccount BR BankAccount Bank acct
BankAccountReferenceText BR BankAccountReferenceText Reference
BankName BR BankName Bank Name
GLAccount BR GLAccount General Ledger
AdjustedGLAcctBalanceAmt BR AdjustedGLAcctBalanceAmt
AdjustedBkAcctBalanceAmt BR AdjustedBkAcctBalanceAmt
BankAcctBalanceAmt BR BankAcctBalanceAmt
GLAcctBalanceAmt BR GLAcctBalanceAmt
UnmatchedIncgBkStmntPayt BR UnmatchedIncgBkStmntPayt
UnmatchedOutgBkStmntPayt BR UnmatchedOutgBkStmntPayt
UnmatchedIncgJrnlEntrPayt BR UnmatchedIncgJrnlEntrPayt
UnmatchedOutgJrnlEntrPayt BR UnmatchedOutgJrnlEntrPayt
CreationUserName BR CreationUserName User Name
LastChangeDateTime BR LastChangeDateTime Timestamp
BankReconciliationStatus BR BankReconciliationStatus
LastBankReconciliationDate BR LastBankReconciliationDate
_BankStatementItem _BankStatementItem
_JournalEntryItem _JournalEntryItem
CompanyCodeName _CompanyCodeVH CompanyCodeName Company Name
HouseBankAccountDescription _HouseBankAccountVH HouseBankAccountDescription

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_BankReconciliationItem.
-- 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: CCNBKRECNCLNITEM
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW C_CN_BankReconciliationItem AS
SELECT
  BR.CompanyCode AS CompanyCode,
  BR.HouseBank AS HouseBank,
  BR.HouseBankAccount AS HouseBankAccount,
  BR.BankReconciliationDate AS BankReconciliationDate,
  BR.Ledger AS Ledger,
  BR.HouseBankCurrency AS HouseBankCurrency,
  BR.BankAccount AS BankAccount,
  BR.BankAccountReferenceText AS BankAccountReferenceText,
  BR.BankName AS BankName,
  BR.GLAccount AS GLAccount,
  BR.AdjustedGLAcctBalanceAmt AS AdjustedGLAcctBalanceAmt,
  BR.AdjustedBkAcctBalanceAmt AS AdjustedBkAcctBalanceAmt,
  BR.BankAcctBalanceAmt AS BankAcctBalanceAmt,
  BR.GLAcctBalanceAmt AS GLAcctBalanceAmt,
  BR.UnmatchedIncgBkStmntPayt AS UnmatchedIncgBkStmntPayt,
  BR.UnmatchedOutgBkStmntPayt AS UnmatchedOutgBkStmntPayt,
  BR.UnmatchedIncgJrnlEntrPayt AS UnmatchedIncgJrnlEntrPayt,
  BR.UnmatchedOutgJrnlEntrPayt AS UnmatchedOutgJrnlEntrPayt,
  BR.CreationUserName AS CreationUserName,
  BR.LastChangeDateTime AS LastChangeDateTime,
  BR.BankReconciliationStatus AS BankReconciliationStatus,
  BR.LastBankReconciliationDate AS LastBankReconciliationDate,
  _CompanyCodeVH.CompanyCodeName AS CompanyCodeName,
  _HouseBankAccountVH.HouseBankAccountDescription AS HouseBankAccountDescription
FROM I_CN_BankRecnclnItem
LEFT OUTER JOIN C_Cn_RecnclnBankStatementItem AS _BankStatementItem ON BR.CompanyCode = _BankStatementItem.CompanyCode AND BR.HouseBank = _BankStatementItem.HouseBank AND BR.HouseBankAccount = _BankStatementItem.HouseBankAccount AND BR.BankReconciliationDate = _BankStatementItem.BankReconciliationDate  -- association [0..*]
LEFT OUTER JOIN C_CN_RecnclnJournalEntryItem AS _JournalEntryItem ON BR.CompanyCode = _JournalEntryItem.CompanyCode AND BR.HouseBank = _JournalEntryItem.HouseBank AND BR.HouseBankAccount = _JournalEntryItem.HouseBankAccount AND BR.BankReconciliationDate = _JournalEntryItem.BankReconciliationDate  -- association [0..*]
LEFT OUTER JOIN I_CompanyCodeVH AS _CompanyCodeVH ON BR.CompanyCode = _CompanyCodeVH.CompanyCode  -- association [1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _HouseBankAccountVH ON BR.CompanyCode = _HouseBankAccountVH.CompanyCode AND BR.HouseBank = _HouseBankAccountVH.HouseBank AND BR.HouseBankAccount = _HouseBankAccountVH.HouseBankAccount  -- association [1]
;

Learn More