FCLMCSHBKHSBK2_D

Transparent Table Application Table
9 Fields 1 CDS Views

Draft table for entity R_CASHBANKHOUSEBANKTP

FCLMCSHBKHSBK2_D is an SAP database table in S/4HANA. Draft table for entity R_CASHBANKHOUSEBANKTP. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CashBankHouseBankDraft view_entity from BASIC House Bank

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY companycode bukrs Company Code
KEY housebank hbkid House Bank
KEY bankcountry banks Bank Ctry/Reg.
KEY bankinternalid bankk Bank Key
phonenumber1 telf1 Telephone 1
taxid1 stcd1 Tax Number 1
contactpersonname name1_a Contact Person
housebankfordisplaytext abap.char House bank description for title

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.

-- Draft table for entity R_CASHBANKHOUSEBANKTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLMCSHBKHSBK2_D (
    MANDT,                    -- Client [mandt]
    COMPANYCODE,              -- Company Code [bukrs]
    HOUSEBANK,                -- House Bank [hbkid]
    BANKCOUNTRY,              -- Bank Ctry/Reg. [banks]
    BANKINTERNALID,           -- Bank Key [bankk]
    PHONENUMBER1,             -- Telephone 1 [telf1]
    TAXID1,                   -- Tax Number 1 [stcd1]
    CONTACTPERSONNAME,        -- Contact Person [name1_a]
    HOUSEBANKFORDISPLAYTEXT,  -- House bank description for title [abap.char]
    PRIMARY KEY (MANDT, COMPANYCODE, HOUSEBANK, BANKCOUNTRY, BANKINTERNALID)
);

Learn More