I_CN_BANKRECNCLNSTATEMENT

CDS View
19 Fields 6 CDS Views

Bank Reconciliation Statement for China

I_CN_BANKRECNCLNSTATEMENT is a CDS View in S/4HANA. Bank Reconciliation Statement for China. It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CN_BankRecnclnStatement view from CONSUMPTION Bank Reconciliation Statement for China
C_CN_BkRecnclnMchnLrngApplyItm view from CONSUMPTION Apply Data for Bank Reconciliation ML
C_CN_BkRecnclnMchnLrngTrnItm view from CONSUMPTION Training Data for Bank Reconciliation ML
I_CN_BankRecnclnItem view from CONSUMPTION Bank Reconciliation Item for China
P_CN_HouseBankwithoutRecncln view left_outer COMPOSITE
P_CN_LastReconciliationDate view from COMPOSITE

Fields (19)

KeyField CDS FieldsUsed in Views
KEY BankReconciliationDate BankReconciliationDate 3
KEY CompanyCode CompanyCode 3
KEY HouseBank HouseBank 3
KEY HouseBankAccount HouseBankAccount 3
AdjustedBkAcctBalanceAmt AdjustedBkAcctBalanceAmt 2
AdjustedGLAcctBalanceAmt AdjustedGLAcctBalanceAmt 2
BankAccount BankAccount 1
BankAccountReferenceText BankAccountReferenceText 1
BankAcctBalanceAmt BankAcctBalanceAmt 1
CreationUserName CreationUserName 2
GLAccount GLAccount 1
GLAcctBalanceAmt GLAcctBalanceAmt 1
HouseBankCurrency HouseBankCurrency 1
LastChangeDateTime LastChangeDateTime 1
Ledger Ledger 1
UnmatchedIncgBkStmntPayt UnmatchedIncgBkStmntPayt 2
UnmatchedIncgJrnlEntrPayt UnmatchedIncgJrnlEntrPayt 2
UnmatchedOutgBkStmntPayt UnmatchedOutgBkStmntPayt 2
UnmatchedOutgJrnlEntrPayt UnmatchedOutgJrnlEntrPayt 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Bank Reconciliation Statement for China
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CN_BANKRECNCLNSTATEMENT (
    BANKRECONCILIATIONDATE,
    COMPANYCODE,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ADJUSTEDBKACCTBALANCEAMT,
    ADJUSTEDGLACCTBALANCEAMT,
    BANKACCOUNT,
    BANKACCOUNTREFERENCETEXT,
    BANKACCTBALANCEAMT,
    CREATIONUSERNAME,
    GLACCOUNT,
    GLACCTBALANCEAMT,
    HOUSEBANKCURRENCY,
    LASTCHANGEDATETIME,
    LEDGER,
    UNMATCHEDINCGBKSTMNTPAYT,
    UNMATCHEDINCGJRNLENTRPAYT,
    UNMATCHEDOUTGBKSTMNTPAYT,
    UNMATCHEDOUTGJRNLENTRPAYT,
    PRIMARY KEY (BANKRECONCILIATIONDATE, COMPANYCODE, HOUSEBANK, HOUSEBANKACCOUNT)
);

Learn More