P_HOUSEBANKACCOUNT

CDS View
8 Fields 5 CDS Views

P_HOUSEBANKACCOUNT is a CDS View in S/4HANA. It contains 8 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BankAccountSituation view inner COMPOSITE Bank Account Situation
I_CN_BankRecnclnStatement view left_outer BASIC Bank Reconciliation Statement for China
I_HouseBankAccount view from BASIC House Bank Account
I_HouseBankAccountLinkage view from COMPOSITE House Bank Account Linkage
P_CN_HouseBankwithoutRecncln view from COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
KEY bukrs CompanyCode 2
KEY hbkid HouseBank 1
KEY hktid HouseBankAccount 1
acc_id BankAccountInternalID 1
bankn BankAccount 2
hkont GLAccount 2
refzl BankAccountReferenceText 2
waers HouseBankCurrency 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_HOUSEBANKACCOUNT (
    BUKRS,
    HBKID,
    HKTID,
    ACC_ID,
    BANKN,
    HKONT,
    REFZL,
    WAERS,
    PRIMARY KEY (BUKRS, HBKID, HKTID)
);

Learn More