T012

Transparent Table Application Table
9 Fields 17 CDS Views

Hausbanken

T012 is an SAP database table in S/4HANA. Hausbanken. It contains 9 fields. 17 CDS views read from this table.

CDS Views using this table (17)

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_BankGroupCompanyCount view_entity inner BASIC Count of company code per bank group
P_HouseBankCompanyCount view from BASIC Count of house bank related company code
SHSM_IDKR_BNKACCSHLP view left_outer Value Help for Bank Account
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 House Bank Account

Fields (9)

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

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.

-- Hausbanken
-- 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]
    PRIMARY KEY (MANDT, BUKRS, HBKID)
);

Learn More