SAP ABAP Table TBCO_BANK (Output Structure for Bank Data (New with CFM 1.0))
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM-TR (Application Component) Transaction Management
⤷ FTTR (Package) Treasury: Financial Transaction
⤷ FIN-FSCM-TRM-TM-TR (Application Component) Transaction Management
⤷ FTTR (Package) Treasury: Financial Transaction
Basic Data
Table Category | INTTAB | Structure |
Structure | TBCO_BANK | Table Relationship Diagram |
Short Description | Output Structure for Bank Data (New with CFM 1.0) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Payment Details for Transaction | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | RFHA | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | VTBFHA | |
5 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
6 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
7 | DZVERB | TB_DZVERB | DATUM | DATS | 8 | 0 | Payment details effective from | ||
8 | SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | TZB0A | |
9 | CRUSER | TB_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
10 | DCRDAT | TB_CRDAT | DATUM | DATS | 8 | 0 | Entered On | ||
11 | TCRTIM | TB_TCRTIM | UZEIT | TIMS | 6 | 0 | Entry Time | ||
12 | UPUSER | TB_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
13 | DUPDAT | TB_DUPDAT | DATUM | DATS | 8 | 0 | Changed on | ||
14 | TUPTIM | TB_TUPTIM | UZEIT | TIMS | 6 | 0 | Time changed | ||
15 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
16 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | T012K | |
17 | RPZAHL | TB_RPZAHL_NEW | BU_PARTNER | CHAR | 10 | 0 | Payer/payee | * | |
18 | RPBANK | TB_RPBANK | BVTYP | CHAR | 4 | 0 | Partner bank details | ||
19 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
20 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
21 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
22 | SPAYRQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
23 | SPRSNG | TB_SPRSNGK | XFELD | CHAR | 1 | 0 | Individual payment | ||
24 | SPRGRD | TB_SPRGRD | T_SPRGRD | CHAR | 1 | 0 | Determine grouping definition | ||
25 | SCSPAY | TB_SCSPAY | XFELD | CHAR | 1 | 0 | Same direction necessary for joint payment? | ||
26 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
27 | RPCODE | RPCODE | RPCODE | CHAR | 20 | 0 | Repetitive Code | FIBL_RPCODE | |
28 | RP_TEXT | RPCODE_TEXT | XTEXT50 | CHAR | 50 | 0 | Reference Text for Repetitive Code | ||
29 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
30 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
31 | .INCLU-SND | 0 | 0 | all data for a bank in bank chain | |||||
32 | CHAINNOSND | CHAINNO | CHAINNO | NUMC | 2 | 0 | Current number of a bank in bank chain | ||
33 | BANKSSND | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
34 | BANKLSND | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
35 | ERDATSND | ERDAT_BF | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
36 | ERNAMSND | ERNAM_BF | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
37 | BANKASND | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
38 | PROVZSND | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
39 | STRASSND | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
40 | ORT01SND | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
41 | SWIFTSND | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
42 | BGRUPSND | BGRUP | BGRUP | CHAR | 2 | 0 | Bank group (bank network) | ||
43 | XPGROSND | XPGRO | XFELD | CHAR | 1 | 0 | Post Office Bank Current Account | ||
44 | LOEVMSND | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
45 | BNKLZSND | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
46 | PSKTOSND | PSKTO_CH | PSKTO | CHAR | 16 | 0 | Post office bank current account number | ||
47 | ADRNRSND | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
48 | BRNCHSND | BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
49 | CHKMESND | CHECKMETH | CHECKMETH | CHAR | 4 | 0 | Check digit calculation method | ||
50 | BANKNSND | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
51 | BNTYPSND | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
52 | BKONTSND | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
53 | BKREFSND | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
54 | IBANSND | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
55 | IBAN_SENDER | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
56 | .INCLU-IM1 | 0 | 0 | all data for a bank in bank chain | |||||
57 | CHAINNOIM1 | CHAINNO | CHAINNO | NUMC | 2 | 0 | Current number of a bank in bank chain | ||
58 | BANKSIM1 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
59 | BANKLIM1 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
60 | ERDATIM1 | ERDAT_BF | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
61 | ERNAMIM1 | ERNAM_BF | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
62 | BANKAIM1 | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
63 | PROVZIM1 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
64 | STRASIM1 | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
65 | ORT01IM1 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
66 | SWIFTIM1 | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
67 | BGRUPIM1 | BGRUP | BGRUP | CHAR | 2 | 0 | Bank group (bank network) | ||
68 | XPGROIM1 | XPGRO | XFELD | CHAR | 1 | 0 | Post Office Bank Current Account | ||
69 | LOEVMIM1 | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
70 | BNKLZIM1 | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
71 | PSKTOIM1 | PSKTO_CH | PSKTO | CHAR | 16 | 0 | Post office bank current account number | ||
72 | ADRNRIM1 | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
73 | BRNCHIM1 | BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
74 | CHKMEIM1 | CHECKMETH | CHECKMETH | CHAR | 4 | 0 | Check digit calculation method | ||
75 | BANKNIM1 | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
76 | BNTYPIM1 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
77 | BKONTIM1 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
78 | BKREFIM1 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
79 | IBANIM1 | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
80 | .INCLU-IM2 | 0 | 0 | all data for a bank in bank chain | |||||
81 | CHAINNOIM2 | CHAINNO | CHAINNO | NUMC | 2 | 0 | Current number of a bank in bank chain | ||
82 | BANKSIM2 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
83 | BANKLIM2 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
84 | ERDATIM2 | ERDAT_BF | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
85 | ERNAMIM2 | ERNAM_BF | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
86 | BANKAIM2 | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
87 | PROVZIM2 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
88 | STRASIM2 | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
89 | ORT01IM2 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
90 | SWIFTIM2 | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
91 | BGRUPIM2 | BGRUP | BGRUP | CHAR | 2 | 0 | Bank group (bank network) | ||
92 | XPGROIM2 | XPGRO | XFELD | CHAR | 1 | 0 | Post Office Bank Current Account | ||
93 | LOEVMIM2 | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
94 | BNKLZIM2 | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
95 | PSKTOIM2 | PSKTO_CH | PSKTO | CHAR | 16 | 0 | Post office bank current account number | ||
96 | ADRNRIM2 | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
97 | BRNCHIM2 | BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
98 | CHKMEIM2 | CHECKMETH | CHECKMETH | CHAR | 4 | 0 | Check digit calculation method | ||
99 | BANKNIM2 | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
100 | BNTYPIM2 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
101 | BKONTIM2 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
102 | BKREFIM2 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
103 | IBANIM2 | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
104 | .INCLU-IM3 | 0 | 0 | all data for a bank in bank chain | |||||
105 | CHAINNOIM3 | CHAINNO | CHAINNO | NUMC | 2 | 0 | Current number of a bank in bank chain | ||
106 | BANKSIM3 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
107 | BANKLIM3 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
108 | ERDATIM3 | ERDAT_BF | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
109 | ERNAMIM3 | ERNAM_BF | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
110 | BANKAIM3 | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
111 | PROVZIM3 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
112 | STRASIM3 | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
113 | ORT01IM3 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
114 | SWIFTIM3 | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
115 | BGRUPIM3 | BGRUP | BGRUP | CHAR | 2 | 0 | Bank group (bank network) | ||
116 | XPGROIM3 | XPGRO | XFELD | CHAR | 1 | 0 | Post Office Bank Current Account | ||
117 | LOEVMIM3 | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
118 | BNKLZIM3 | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
119 | PSKTOIM3 | PSKTO_CH | PSKTO | CHAR | 16 | 0 | Post office bank current account number | ||
120 | ADRNRIM3 | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
121 | BRNCHIM3 | BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
122 | CHKMEIM3 | CHECKMETH | CHECKMETH | CHAR | 4 | 0 | Check digit calculation method | ||
123 | BANKNIM3 | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
124 | BNTYPIM3 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
125 | BKONTIM3 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
126 | BKREFIM3 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
127 | IBANIM3 | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
128 | .INCLU-REC | 0 | 0 | all data for a bank in bank chain | |||||
129 | CHAINNOREC | CHAINNO | CHAINNO | NUMC | 2 | 0 | Current number of a bank in bank chain | ||
130 | BANKSREC | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
131 | BANKLREC | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
132 | ERDATREC | ERDAT_BF | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
133 | ERNAMREC | ERNAM_BF | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
134 | BANKAREC | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
135 | PROVZREC | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
136 | STRASREC | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
137 | ORT01REC | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
138 | SWIFTREC | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
139 | BGRUPREC | BGRUP | BGRUP | CHAR | 2 | 0 | Bank group (bank network) | ||
140 | XPGROREC | XPGRO | XFELD | CHAR | 1 | 0 | Post Office Bank Current Account | ||
141 | LOEVMREC | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
142 | BNKLZREC | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
143 | PSKTOREC | PSKTO_CH | PSKTO | CHAR | 16 | 0 | Post office bank current account number | ||
144 | ADRNRREC | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
145 | BRNCHREC | BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
146 | CHKMEREC | CHECKMETH | CHECKMETH | CHAR | 4 | 0 | Check digit calculation method | ||
147 | BANKNREC | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
148 | BNTYPREC | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
149 | BKONTREC | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
150 | BKREFREC | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
151 | IBANREC | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
152 | IBAN_RECEIVER | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
153 | XBEWART | XBEWART | TEXT30 | CHAR | 30 | 0 | Name of flow type | ||
154 | S_PASSIVE_PAY | TB_S_PASSIVE_PAY | BOOLE | CHAR | 1 | 0 | Liab. Outgoing Payment? |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TBCO_BANK | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | TBCO_BANK | HBKID | T012 | HBKID | KEY | 1 | CN |
3 | TBCO_BANK | HKTID | T012K | HKTID | KEY | 1 | CN |
4 | TBCO_BANK | LANDL | T005 | LAND1 | REF | C | CN |
5 | TBCO_BANK | LZBKZ | T015L | LZBKZ | REF | C | CN |
6 | TBCO_BANK | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | TBCO_BANK | RFHA | VTBFHA | RFHA | KEY | 1 | CN |
8 | TBCO_BANK | RPCODE | FIBL_RPCODE | RPCODE | |||
9 | TBCO_BANK | SBEWART | TZB0A | SBEWART | REF | 1 | CN |
10 | TBCO_BANK | UZAWE | T042F | UZAWE | KEY | 1 | CN |
11 | TBCO_BANK | WAERS | TCURC | WAERS | KEY | 1 | CN |
12 | TBCO_BANK | ZLSCH | T042Z | ZLSCH | KEY | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |