VFCLM_BAM_DDL_BANK
VFCLM_BAM_DDL_BANK is a CDS View in S/4HANA. It contains 23 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| VFCLM_BAM_DDL_BANK_WITHDESP | view | from |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BankCountry | BankCountry | 1 |
| KEY | BankKey | BankKey | 1 |
| AddressCity | AddressCity | 1 | |
| AddressCountry | AddressCountry | 1 | |
| AddressMailbox | AddressMailbox | 1 | |
| AddressPOBoxPostalCode | AddressPOBoxPostalCode | 1 | |
| AddressRegion | AddressRegion | 1 | |
| AddressStreet | AddressStreet | 1 | |
| AddressStreetPostalCode | AddressStreetPostalCode | 1 | |
| BankDataFormat | BankDataFormat | 1 | |
| BankName | BankName | 1 | |
| BankNetworkGrouping | BankNetworkGrouping | 1 | |
| BankNumber | BankNumber | 1 | |
| Branch | Branch | 1 | |
| CheckDigitMethod | CheckDigitMethod | 1 | |
| City | City | 1 | |
| CreatedAt | CreatedAt | 1 | |
| CreatedBy | CreatedBy | 1 | |
| HouseStreet | HouseStreet | 1 | |
| PostalCheckAccount | PostalCheckAccount | 1 | |
| PostbankAccount | PostbankAccount | 1 | |
| Region | Region | 1 | |
| SWIFT | SWIFT | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VFCLM_BAM_DDL_BANK (
BANKCOUNTRY,
BANKKEY,
ADDRESSCITY,
ADDRESSCOUNTRY,
ADDRESSMAILBOX,
ADDRESSPOBOXPOSTALCODE,
ADDRESSREGION,
ADDRESSSTREET,
ADDRESSSTREETPOSTALCODE,
BANKDATAFORMAT,
BANKNAME,
BANKNETWORKGROUPING,
BANKNUMBER,
BRANCH,
CHECKDIGITMETHOD,
CITY,
CREATEDAT,
CREATEDBY,
HOUSESTREET,
POSTALCHECKACCOUNT,
POSTBANKACCOUNT,
REGION,
SWIFT,
PRIMARY KEY (BANKCOUNTRY, BANKKEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA