VFCLMBAMSHBANKL

9 Fields 1 CDS Views

Generated Table for View

VFCLMBAMSHBANKL is an SAP database table in S/4HANA. Generated Table for View. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_VFCLMBAMSHBANKL view from CDS View replacing VFCLMBAMSHBANKL in F4

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
banks FCLM_BAM_BANK_COUNTRY_KEY Bank Ctry/Rgn. Key
bankl FCLM_BAM_BANK_KEY Bank Key
banka BANKA Bank Name
ort01 ORT01_GP City
bnklz BANKL Bank Number
swift SWIFT SWIFT/BIC
brnch BRNCH Bank Branch
stras STRAS_GP Street

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VFCLMBAMSHBANKL (
    MANDT,  -- Client [MANDT]
    BANKS,  -- Bank Ctry/Rgn. Key [FCLM_BAM_BANK_COUNTRY_KEY]
    BANKL,  -- Bank Key [FCLM_BAM_BANK_KEY]
    BANKA,  -- Bank Name [BANKA]
    ORT01,  -- City [ORT01_GP]
    BNKLZ,  -- Bank Number [BANKL]
    SWIFT,  -- SWIFT/BIC [SWIFT]
    BRNCH,  -- Bank Branch [BRNCH]
    STRAS,  -- Street [STRAS_GP]
    PRIMARY KEY (MANDT)
);

Learn More