T012

Transparent Table Application Table
11 Fields 18 CDS Views

House Banks

T012 is an SAP database table in S/4HANA. House Banks. It contains 11 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
/BSNAGT/P_T012 view from T012 P View
ESH_N_HOUSEBANK_T012 view from House Banks
FAC_AD_CDS_HOUSEBANK view from CDS View for House Bank and BNKA
Fac_Ad_Cds_T042i view left_outer CDS View for T042I with Text
FARPVD_HOUSEBANK_VH view from Value Help on House Banks
Fclm_Bm_Company_Used view inner Bank data of company used
Fclm_Bm_Housebankwithau view from House bank data with authorization
Fclm_V_House_Bank view from CDS view for House Bank
I_Housebank view from BASIC Master data for House Bank
I_HouseBankMaster view from BASIC House Bank Master
P_Arbanktransactiondocitem_07 view left_outer COMPOSITE
P_BankGroupCompanyCount view inner BASIC
P_HouseBankCompanyCount view from BASIC
SHSM_IDKR_BNKACCSHLP view left_outer Value Help for Bank Account (Obsoleted)
SHSM_T012 view from CDS View Replacing T012 in search help
shsm_t012_1 view from CDS View Replacing T012 in search help
V_GRC_BANK_ACCT_DDL view from /GRC/V_BANK_ACCT Compatibility View
VFCLM_BAM_DDL_HOUSEBANKACCOUNT view left_outer

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY hbkid HBKID House Bank
banks BANKS Bank Ctry/Reg.
bankl BANKK Bank Key
telf1 TELF1 Telephone 1
stcd1 STCD1 Tax Number 1
name1 NAME1_A Contact Person
spras SPRAS Language
bupla BUPLA_T012 Business Place
vpast VPAST Past val.dte

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.

-- House Banks
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T012 (
    MANDT,  -- Client [MANDT]
    BUKRS,  -- Company Code [BUKRS]
    HBKID,  -- House Bank [HBKID]
    BANKS,  -- Bank Ctry/Reg. [BANKS]
    BANKL,  -- Bank Key [BANKK]
    TELF1,  -- Telephone 1 [TELF1]
    STCD1,  -- Tax Number 1 [STCD1]
    NAME1,  -- Contact Person [NAME1_A]
    SPRAS,  -- Language [SPRAS]
    BUPLA,  -- Business Place [BUPLA_T012]
    VPAST,  -- Past val.dte [VPAST]
    PRIMARY KEY (MANDT, BUKRS, HBKID)
);

Learn More