I_CN_BankRecnclnItem

DDL: I_CN_BANKRECNCLNITEM SQL: ICNBKRECNCLNITEM Type: view CONSUMPTION
44 Fields 3 Data Sources 1 Associations

Bank Reconciliation Item for China

I_CN_BankRecnclnItem is a Consumption CDS View that provides data about "Bank Reconciliation Item for China" in SAP S/4HANA. It reads from 3 data sources (I_CN_BankRecnclnStatement, P_CN_BankStatementBalance, P_CN_HouseBankwithGLBalance) and exposes 44 fields with key fields CompanyCode, HouseBank, HouseBankAccount, BankReconciliationDate, HouseBank. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_CN_BankRecnclnStatement I_CN_BankRecnclnStatement from
P_CN_BankStatementBalance P_CN_BankStatementBalance left_outer
P_CN_HouseBankwithGLBalance P_CN_HouseBankwithGLBalance union_all

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.HouseBankCurrency = _Currency.Currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICNBKRECNCLNITEM view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Bank Reconciliation Item for China view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode BRS CompanyCode Receiver Company Code
KEY HouseBank BRS HouseBank House Bank
KEY HouseBankAccount BRS HouseBankAccount House Bank Account
KEY BankReconciliationDate BRS BankReconciliationDate Reconciliation Date
Ledger BRS Ledger Ledger
HouseBankCurrency BRS HouseBankCurrency Transaction Currency
BankAccount BRS BankAccount Bank acct
BankAccountReferenceText BRS BankAccountReferenceText Reference
BankName Bank Name
GLAccount BRS GLAccount General Ledger
AdjustedGLAcctBalanceAmt BRS AdjustedGLAcctBalanceAmt Adj.Closing Balance
AdjustedBkAcctBalanceAmt BRS AdjustedBkAcctBalanceAmt Adj.Closing Balance
BankAcctBalanceAmt BankAcctBalanceAmt
GLAcctBalanceAmt BRS GLAcctBalanceAmt Closing Balance
UnmatchedIncgBkStmntPayt BRS UnmatchedIncgBkStmntPayt Umtchd Incing. In BK
UnmatchedOutgBkStmntPayt BRS UnmatchedOutgBkStmntPayt Umtchd Otcing. In BK
UnmatchedIncgJrnlEntrPayt BRS UnmatchedIncgJrnlEntrPayt Umtchd Incing. In JE
UnmatchedOutgJrnlEntrPayt BRS UnmatchedOutgJrnlEntrPayt Umtchd Otcing. In JE
CreationUserName BRS CreationUserName User Name
LastChangeDateTime BRS LastChangeDateTime Timestamp
LastBankReconciliationDate BRS LastBankReconciliationDate Last Reco. Date
BankReconciliationStatus BRS BankReconciliationStatus Bank Recon. Status
CompanyCode Receiver Company Code
KEY HouseBank GLBalance HouseBank House Bank
KEY HouseBankAccount GLBalance HouseBankAccount House Bank Account
KEY BankReconciliationDate Reconciliation Date
Ledger GLBalance Ledger Ledger
HouseBankCurrency GLBalance HouseBankCurrency Transaction Currency
BankAccount GLBalance BankAccount Bank acct
BankAccountReferenceText GLBalance BankAccountReferenceText Reference
BankName GLBalance BankName Bank Name
GLAccount GLBalance GLAccount General Ledger
AdjustedGLAcctBalanceAmt GLBalance AdjustedGLAcctBalanceAmt Adj.Closing Balance
AdjustedBkAcctBalanceAmt GLBalance AdjustedBkAcctBalanceAmt Adj.Closing Balance
BankAcctBalanceAmt BankBalance Finalbalance
GLAcctBalanceAmt GLBalance GLAcctBalanceAmt Closing Balance
UnmatchedIncgBkStmntPayt GLBalance UnmatchedIncgBkStmntPayt Umtchd Incing. In BK
UnmatchedOutgBkStmntPayt GLBalance UnmatchedOutgBkStmntPayt Umtchd Otcing. In BK
UnmatchedIncgJrnlEntrPayt GLBalance UnmatchedIncgJrnlEntrPayt Umtchd Incing. In JE
UnmatchedOutgJrnlEntrPayt GLBalance UnmatchedOutgJrnlEntrPayt Umtchd Otcing. In JE
CreationUserName GLBalance CreationUserName User Name
LastChangeDateTime Timestamp
LastBankReconciliationDate GLBalance LastBankReconciliationDate Last Reco. Date
_Currency _Currency

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 I_CN_BankRecnclnItem.
-- 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: ICNBKRECNCLNITEM
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_CN_BankRecnclnItem AS
SELECT
  BRS.CompanyCode AS CompanyCode,
  BRS.HouseBank AS HouseBank,
  BRS.HouseBankAccount AS HouseBankAccount,
  BRS.BankReconciliationDate AS BankReconciliationDate,
  BRS.Ledger AS Ledger,
  BRS.HouseBankCurrency AS HouseBankCurrency,
  BRS.BankAccount AS BankAccount,
  BRS.BankAccountReferenceText AS BankAccountReferenceText,
  BRS._HouseBank._Bank.BankName AS BankName,
  BRS.GLAccount AS GLAccount,
  BRS.AdjustedGLAcctBalanceAmt AS AdjustedGLAcctBalanceAmt,
  BRS.AdjustedBkAcctBalanceAmt AS AdjustedBkAcctBalanceAmt,
  BankAcctBalanceAmt,
  BRS.GLAcctBalanceAmt AS GLAcctBalanceAmt,
  BRS.UnmatchedIncgBkStmntPayt AS UnmatchedIncgBkStmntPayt,
  BRS.UnmatchedOutgBkStmntPayt AS UnmatchedOutgBkStmntPayt,
  BRS.UnmatchedIncgJrnlEntrPayt AS UnmatchedIncgJrnlEntrPayt,
  BRS.UnmatchedOutgJrnlEntrPayt AS UnmatchedOutgJrnlEntrPayt,
  BRS.CreationUserName AS CreationUserName,
  BRS.LastChangeDateTime AS LastChangeDateTime,
  BRS.LastBankReconciliationDate AS LastBankReconciliationDate,
  BRS.BankReconciliationStatus AS BankReconciliationStatus
FROM I_CN_BankRecnclnStatement
LEFT OUTER JOIN P_CN_BankStatementBalance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON HouseBankCurrency = _Currency.Currency  -- association [0..1]
-- UNION ALL with additional select branch(es): P_CN_HouseBankwithGLBalance
;

Learn More