SAP ABAP Table TBCO_SE_ACC (Sec. Acct Master Data + Address of Dep. Bank for Correspond.)
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_SE_ACC | Table Relationship Diagram |
Short Description | Sec. Acct Master Data + Address of Dep. Bank for Correspond. |
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 | Treasury: Securities Account Master Data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | RLDEPO | VRLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
5 | VERKONTO | VERKONTO | ABNKR | CHAR | 15 | 0 | No. of bank giro acct, security acct no. in US secur.accts | ||
6 | RDEPOTNR | ABNKR | ABNKR | CHAR | 15 | 0 | Securities account no. | ||
7 | XLDEPO | XLDEPO | XLDEPO | CHAR | 30 | 0 | Securities account ID | ||
8 | RERTRK | RERTRK | SAKNR | CHAR | 10 | 0 | Internal bank account | SKB1 | |
9 | RDPBANK | RDEPOTBANK | BU_PARTNER | CHAR | 10 | 0 | Depository Bank | * | |
10 | RBGUE | RBGUENST | BU_PARTNER | CHAR | 10 | 0 | Beneficiary | * | |
11 | SSPERRV | CHAR | 2 | 0 | |||||
12 | DSPERR | DSPERR | DATUM | DATS | 8 | 0 | Block flag until | ||
13 | RGSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
14 | SSKZB | SSKZB | SSKZB | NUMC | 1 | 0 | BAV stock indicator | TZ11 | |
15 | JVERMST | JVERMST | JANEI | CHAR | 1 | 0 | Net worth tax indicator | ||
16 | SUDEC | SUDEC | SUDEC | NUMC | 2 | 0 | Insurance Line of Business Indicator | TW05 | |
17 | DEDEC | DEDEC | DATUM | DATS | 8 | 0 | Date of entry in premium reserve fund | ||
18 | RFGEB | RFGEB_NEW | BU_PARTNER | CHAR | 10 | 0 | Releaser of master record (person) | * | |
19 | DFREI | DFREI | DATUM | DATS | 8 | 0 | Date of release | ||
20 | TFREI | TFREI | TIMES | TIMS | 6 | 0 | Time of release | ||
21 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
22 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
23 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
24 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
25 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
26 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
27 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
28 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
29 | RPORTB | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
30 | SOBJEKT | VVKEYOBJ | VVKEY | CHAR | 10 | 0 | Internal key for object | ||
31 | SROLEXTDEP | DUMMY_3 | CHAR3 | CHAR | 3 | 0 | Dummy function | ||
32 | SROLEXTBEG | DUMMY_3 | CHAR3 | CHAR | 3 | 0 | Dummy function | ||
33 | VVSLOEKZ | VVSLOEKZ | VVSLOEKZ | NUMC | 1 | 0 | Deletion indicator | ||
34 | SSPERR | SSPERR | SSPERR | CHAR | 3 | 0 | Block type for restraint on disposal | TW17 | |
35 | RAHABKI | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | T012 | |
36 | RAHKTID | TB_RHKTID | HKTID | CHAR | 5 | 0 | Short key for house bank account | T012K | |
37 | SEC_ACC_GRP | TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | TRGT_SECACCGRP | |
38 | STATUS | TPM_SEC_ACC_STATUS | TPM_SEC_ACC_STATUS | NUMC | 1 | 0 | Status of a Security Account | ||
39 | STATUS_RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
40 | STATUS_DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
41 | STATUS_TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
42 | SECACC_TYPE | TPM_SECACC_TYPE | TPM_SECACC_TYPE | CHAR | 3 | 0 | Securities Account Type | TRSC_SECACC_TYPE | |
43 | .INCLU--AP | 0 | 0 | ISSR: Erweiterung für Meldewesendaten bei Depotanlage | |||||
44 | .INCLUDE | 0 | 0 | ISSR: Append-Struktur für Meldewesendaten bei Depotanlage | |||||
45 | BUDAT | ISSR_BUDAT | DATUM | DATS | 8 | 0 | Gueltig Ab-Datum Meldewesen -Stamm | ||
46 | COUNTRY_VAR | ISSR_REP_COUNTRY | ISSR_REP_COUNTRY | CHAR | 4 | 0 | TISSR_MARECO | ||
47 | SPARTE | ISSR_VERS_SPARTE | ISSR_VERS_SPARTE | CHAR | 2 | 0 | Insurance Line of Business Indicator | TISSR_SPARTE | |
48 | STOCKBAV | ISSR_STOCKBAV | ISSR_STOCKBAV | CHAR | 1 | 0 | BAV Stock Indicator | TISSR_STOCKBAV | |
49 | ADDRNUMBER | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
50 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
51 | NAME1 | NAME1_ADRS | TEXT40 | CHAR | 40 | 0 | Name 1 of an address | ||
52 | NAME2 | NAME2_ADRS | TEXT40 | CHAR | 40 | 0 | Name 2 of an address | ||
53 | NAME3 | NAME3_ADRS | TEXT40 | CHAR | 40 | 0 | Name 3 of an address | ||
54 | NAME4 | NAME4_ADRS | TEXT40 | CHAR | 40 | 0 | Name 4 of an address | ||
55 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
56 | PFACH | PFACH_BAS | PFACH | CHAR | 10 | 0 | PO box | ||
57 | PSTL2 | PSTL2_BAS | PSTLZ | CHAR | 10 | 0 | PO Box postal code | ||
58 | PFORT | PFORT_ADRS | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
59 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
60 | PSTLZ | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
61 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
62 | ORT02 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
63 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
64 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
65 | INLND | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
66 | ANZZL | ANZEI | ANZEI | DEC | 2 | 0 | Number of lines in address | ||
67 | PRIOR | PRITY_ADRS | CHAR9 | CHAR | 9 | 0 | Address lines priority | ||
68 | WAREN | WAREN | WAREN | CHAR | 1 | 0 | Delivery address ID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TBCO_SE_ACC | BUKRS | T001 | BUKRS | KEY | 1 | 1 |
2 | TBCO_SE_ACC | COUNTRY_VAR | TISSR_MARECO | COUNTRY_VAR | KEY | 1 | CN |
3 | TBCO_SE_ACC | MANDT | T000 | MANDT | KEY | 1 | 1 |
4 | TBCO_SE_ACC | RAHABKI | T012 | HBKID | REF | C | CN |
5 | TBCO_SE_ACC | RAHKTID | T012K | HKTID | REF | C | CN |
6 | TBCO_SE_ACC | RERTRK | SKB1 | SAKNR | KEY | 1 | 1 |
7 | TBCO_SE_ACC | RGSBER | TGSB | GSBER | KEY | 1 | 1 |
8 | TBCO_SE_ACC | RPORTB | TWPOB | RPORTB | |||
9 | TBCO_SE_ACC | SECACC_TYPE | TRSC_SECACC_TYPE | SECACC_TYPE | |||
10 | TBCO_SE_ACC | SEC_ACC_GRP | TRGT_SECACCGRP | SEC_ACCT_GRP | KEY | 1 | CN |
11 | TBCO_SE_ACC | SPARTE | TISSR_SPARTE | SPARTE | KEY | 1 | CN |
12 | TBCO_SE_ACC | SSKZB | TZ11 | SSKZB | KEY | 1 | CN |
13 | TBCO_SE_ACC | SSPERR | TW17 | SSPERR | KEY | 1 | CN |
14 | TBCO_SE_ACC | STOCKBAV | TISSR_STOCKBAV | STOCKBAV | KEY | 1 | CN |
15 | TBCO_SE_ACC | SUDEC | TW05 | SUDEC | KEY | 1 | 1 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |