BNKA

Transparent Table Application Table
37 Fields 34 CDS Views

Bank master record

BNKA is an SAP database table in S/4HANA. Bank master record. It contains 37 fields. 34 CDS views read from this table.

CDS Views using this table (34)

ViewTypeJoinVDMDescription
/BSNAGT/P_BNKA view from BNKA P View
/PF1/P_BNKA view from P View for BNKA
A_BankDetail view from BASIC Bank Details
E_Bank view_entity from EXTENSION Bank
ESH_N_BANK_BANK view from Bank master record
FAR_DP_MERCHANT view inner Merchant Account for SAP Digital Payments add-on
FARPVD_HOUSEBANK_VH view left_outer Value Help on House Banks
FCLM_BAM_ACCOUNT_VH view left_outer Bank Account Value Help
FCLM_BAM_DOC_DM_BK_ATTR view left_outer Active Company Code List of FI
Fclm_Bam_Sh_Bankl view left_outer Search help for Bank
fclm_bam_shlp_acctid view left_outer Search help for ACC ID
Fclm_Bm_Address view left_outer Address data for bank master and business partner
Fclm_Bm_Bank view from Bank master data for management
Fclm_Bm_Company_Used view inner Bank data of company used
Fclm_Bm_Related_Branches view left_outer Bank data for related branches
Fclm_V_House_Bank view left_outer CDS view for House Bank
I_Bank view from BASIC Bank
I_Bank_2 view_entity from BASIC Bank
I_BankAcctIdVH view left_outer BASIC Bank Account ID value help
I_BankAcctNumberVH view left_outer BASIC Account Number
I_BankForBusinessPartner view from BASIC Bank Master for Business Partner
I_BPBankLinkage view left_outer BASIC Linkage between BP and Bank
P_ARBSITMCUSTBANKDATA view left_outer BASIC
P_Arbsitmonacc view left_outer COMPOSITE
SHSM_BNKA view from CDS View replacing BNKA in search help
SHSM_BNKA_BOEHBANK view from CDS VIEW search help for BOE bank
SHSM_FCLM_BAM_EXPORT_ACCOUNT view left_outer Bank Account Value Help
SHSM_FMCA_TRM_BANKL view from Replacing BNKA in search help FMCA_TRM_BANKL
SHSM_IDKR_BNKACCSHLP view left_outer Value Help for Bank Account (Obsoleted)
VFCLM_BAM_DDL_ACCOUNTPREQUEST view left_outer
VFCLM_BAM_DDL_BPBNKALINK view left_outer Linkage between BP and Bank
VFCLM_BAM_DDL_FBAR01 view left_outer Account Result for FBAR
VFCLM_BAM_DDL_HIERNODECORE view left_outer Hierarchy Node Core Attributes
VFCLM_BAM_DDL_REQHIST view left_outer

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY banks BANKS Bank Ctry/Reg.
KEY bankl BANKK Bank Key
erdat ERDAT_BF Created On
ernam ERNAM_BF Created By
banka BANKA Bank Name
provz REGIO Region
stras STRAS_GP Street
ort01 ORT01_GP City
swift SWIFT SWIFT/BIC
bgrup BGRUP Bank group
xpgro XPGRO Postbank Acct
loevm LOEVM Delete
bnklz BANKL Bank Number
pskto PSKTO_CH Postal chk acct
adrnr AD_ADDRNUM Address Number
brnch BRNCH Bank Branch
chkme CHECKMETH Method
vers VERS_BF File Format
iban_rule IBAN_RULE IBAN Rule
sdd_b2b SDD_B2B SDD B2B
sdd_cor1 SDD_COR1 SDD COR1
sdd_rtrans SDD_RTRANS R Transactions
znocheck /ATL/LNOCHECK Don't Check
zacc_len /ATL/LACC_LEN Account length
zres1 /ATL/LRESIDUE Residue
zres2 /ATL/LRESIDUE Residue
zres3 /ATL/LRESIDUE Residue
zres4 /ATL/LRESIDUE Residue
zres5 /ATL/LRESIDUE Residue
zres6 /ATL/LRESIDUE Residue
zres7 /ATL/LRESIDUE Residue
zres8 /ATL/LRESIDUE Residue
zres9 /ATL/LRESIDUE Residue
zres10 /ATL/LRESIDUE Residue
bicky PRQ_BICKY BIC+ number
rccode PRQ_RCC Rout.ctrl code

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 master record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BNKA (
    MANDT,       -- Client [MANDT]
    BANKS,       -- Bank Ctry/Reg. [BANKS]
    BANKL,       -- Bank Key [BANKK]
    ERDAT,       -- Created On [ERDAT_BF]
    ERNAM,       -- Created By [ERNAM_BF]
    BANKA,       -- Bank Name [BANKA]
    PROVZ,       -- Region [REGIO]
    STRAS,       -- Street [STRAS_GP]
    ORT01,       -- City [ORT01_GP]
    SWIFT,       -- SWIFT/BIC [SWIFT]
    BGRUP,       -- Bank group [BGRUP]
    XPGRO,       -- Postbank Acct [XPGRO]
    LOEVM,       -- Delete [LOEVM]
    BNKLZ,       -- Bank Number [BANKL]
    PSKTO,       -- Postal chk acct [PSKTO_CH]
    ADRNR,       -- Address Number [AD_ADDRNUM]
    BRNCH,       -- Bank Branch [BRNCH]
    CHKME,       -- Method [CHECKMETH]
    VERS,        -- File Format [VERS_BF]
    IBAN_RULE,   -- IBAN Rule [IBAN_RULE]
    SDD_B2B,     -- SDD B2B [SDD_B2B]
    SDD_COR1,    -- SDD COR1 [SDD_COR1]
    SDD_RTRANS,  -- R Transactions [SDD_RTRANS]
    ZNOCHECK,    -- Don't Check [/ATL/LNOCHECK]
    ZACC_LEN,    -- Account length [/ATL/LACC_LEN]
    ZRES1,       -- Residue [/ATL/LRESIDUE]
    ZRES2,       -- Residue [/ATL/LRESIDUE]
    ZRES3,       -- Residue [/ATL/LRESIDUE]
    ZRES4,       -- Residue [/ATL/LRESIDUE]
    ZRES5,       -- Residue [/ATL/LRESIDUE]
    ZRES6,       -- Residue [/ATL/LRESIDUE]
    ZRES7,       -- Residue [/ATL/LRESIDUE]
    ZRES8,       -- Residue [/ATL/LRESIDUE]
    ZRES9,       -- Residue [/ATL/LRESIDUE]
    ZRES10,      -- Residue [/ATL/LRESIDUE]
    BICKY,       -- BIC+ number [PRQ_BICKY]
    RCCODE,      -- Rout.ctrl code [PRQ_RCC]
    PRIMARY KEY (MANDT, BANKS, BANKL)
);

Learn More