TBCHAIN21
Bank chains per business partner account (allocation)
TBCHAIN21 is an SAP database table in S/4HANA. Bank chains per business partner account (allocation). It contains 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BankChainItem | view_entity | from | BASIC | Intermediary bank for Bank Chain |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | banksrec | BANKSREC | Ctry/R Rec. | |||
| KEY | bankkrec | BANKKREC | Bank Key | |||
| KEY | banknrec | BANKNREC | Bank Acct/IBAN | |||
| KEY | waers | WAERS | Currency | |||
| KEY | bankssnd | BANKSSND | Ctry/R Sender | |||
| KEY | bankksnd | BANKKSND | Bank Key | |||
| KEY | uzawe | UZAWE | Pmnt Meth. Sup. | |||
| KEY | chainno | CHAINNO | Number | |||
| chainbankt | CHAINBANKT | Bank Type in Chain | ||||
| chainbanks | CHAINBANKS | Ctry/R Corr. | ||||
| chainbankk | CHAINBANKK | Corr.Bank Key | ||||
| chainbankn | CHAINBANKN | Bank Acct | ||||
| iban | IBAN | IBAN |
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.
-- Bank chains per business partner account (allocation)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBCHAIN21 (
MANDT, -- Client [MANDT]
BANKSREC, -- Ctry/R Rec. [BANKSREC]
BANKKREC, -- Bank Key [BANKKREC]
BANKNREC, -- Bank Acct/IBAN [BANKNREC]
WAERS, -- Currency [WAERS]
BANKSSND, -- Ctry/R Sender [BANKSSND]
BANKKSND, -- Bank Key [BANKKSND]
UZAWE, -- Pmnt Meth. Sup. [UZAWE]
CHAINNO, -- Number [CHAINNO]
CHAINBANKT, -- Bank Type in Chain [CHAINBANKT]
CHAINBANKS, -- Ctry/R Corr. [CHAINBANKS]
CHAINBANKK, -- Corr.Bank Key [CHAINBANKK]
CHAINBANKN, -- Bank Acct [CHAINBANKN]
IBAN, -- IBAN [IBAN]
PRIMARY KEY (MANDT, BANKSREC, BANKKREC, BANKNREC, WAERS, BANKSSND, BANKKSND, UZAWE, CHAINNO)
);
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