SAP ABAP Table VTBDEALACT (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | VTBDEALACT | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | RFHA | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | * | |
4 | CRUSER | TB_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
5 | DCRDAT_D | TB_DCRDAT | DATUM | DATS | 8 | 0 | Entered On | ||
6 | TCRTIM_D | TB_TCRTIM | UZEIT | TIMS | 6 | 0 | Entry Time | ||
7 | UPUSER | TB_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
8 | DUPDAT | TB_DUPDAT | DATUM | DATS | 8 | 0 | Changed on | ||
9 | TUPTIM | TB_TUPTIM | UZEIT | TIMS | 6 | 0 | Time changed | ||
10 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
11 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
12 | SFGTYP | TB_SFGTYP | T_SFGTYP | NUMC | 3 | 0 | Transaction Category | AT01 | |
13 | SGSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
14 | SFHAART | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | AT10 | |
15 | RGATT | TI_RGATT | T_RGATT | CHAR | 13 | 0 | Class | ||
16 | RFHAZUNR | TB_RFHAZUN | T_RFHAZU | NUMC | 5 | 0 | Number status of activity | ||
17 | RFHAZUL | TB_RFHAZUL | T_RFHAZU | NUMC | 5 | 0 | Last Active Transaction Activity | ||
18 | SAKTIV | TB_SAKTIV | T_SAKTIV | NUMC | 1 | 0 | Active Status of Transaction or Activity | ||
19 | KONTRH | TB_KUNNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
20 | RREFKONT | RREFKONT_OBSOLETE | USTRU | CHAR | 8 | 0 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | T037S | |
21 | RREFKONT2 | RREFKONT_OBSOLETE | USTRU | CHAR | 8 | 0 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | T037S | |
22 | RPORTB | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
23 | WGSCHFT | TB_WGSCHFT | WAERS | CUKY | 5 | 0 | Currency of transaction | TCURC | |
24 | WGSCHFT1 | TB_WGSCHF1 | WAERS | CUKY | 5 | 0 | Currency of Outgoing Side | * | |
25 | WGSCHFT2 | TB_WGSCHF2 | WAERS | CUKY | 5 | 0 | Currency of Incoming Side | * | |
26 | SKALID | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | TFACD | |
27 | SKALID2 | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | TFACD | |
28 | JLIMIT | TB_JLIMIT | XFELD | CHAR | 1 | 0 | Limit indicator | ||
29 | AKUEND | TB_AKUEND | T_AKUEND | NUMC | 2 | 0 | Period of Notice | ||
30 | SKUEND | TB_SKUEND | T_SKUEND | NUMC | 1 | 0 | Unit of Period of Notice | ||
31 | RLDEPO | VRLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
32 | ZUONR | TB_TFPROJ | T_TFPROJ | CHAR | 13 | 0 | Finance Project | ||
33 | ABWTYP | TB_ABWTYP | T_ABWTYP | CHAR | 5 | 0 | Processing Category | AT05 | |
34 | RMAID | TB_RMAID | T_RMAID | CHAR | 10 | 0 | Master Agreement | VTBMA | |
35 | RGARANT | TB_RGARANT_NEW | BU_PARTNER | CHAR | 10 | 0 | Guarantor of Financial Transaction | * | |
36 | ZUOND | TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
37 | REFER | TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
38 | MERKM | TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics | ||
39 | RANL | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
40 | SSTOGRD | SSTOGRD | SSTOGRD | CHAR | 2 | 0 | Reason for Reversal | TZST | |
41 | RDEALER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | TZDEA | |
42 | DVTRAB | TB_DVTRAB | DATUM | DATS | 8 | 0 | Contract Conclusion Date | ||
43 | GSPPART | TB_GSPPART | TEXT19 | CHAR | 19 | 0 | Contact Person | ||
44 | XAKT | XAKT | CHAR32 | CHAR | 32 | 0 | File Number | ||
45 | NORDEXT | TB_NORDEXT | FTI_CHAR16LOW | CHAR | 16 | 0 | External Reference | ||
46 | LIMITART | TB_LIMITAR | T_LIMITAR | CHAR | 2 | 0 | Limit type | ATOR | |
47 | RFHAZU | TB_RFHAZU | T_RFHAZU | NUMC | 5 | 0 | Transaction activity | ||
48 | SFGZUSTT | TB_SFGZUTY | T_SFGZUTY | NUMC | 2 | 0 | Transaction Activity Category | AT02 | |
49 | SAKTIV_HAZU | TB_SAKTIV | T_SAKTIV | NUMC | 1 | 0 | Active Status of Transaction or Activity |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VTBDEALACT | ABWTYP | AT05 | ABWTYP | KEY | 1 | CN |
2 | VTBDEALACT | BUKRS | T001 | BUKRS | KEY | 1 | CN |
3 | VTBDEALACT | LIMITART | ATOR | LIMITART | REF | C | CN |
4 | VTBDEALACT | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | VTBDEALACT | RDEALER | TZDEA | RDEALER | KEY | 1 | CN |
6 | VTBDEALACT | RLDEPO | TWD01 | RLDEPO | C | CN | |
7 | VTBDEALACT | RMAID | VTBMA | RMAID | C | CN | |
8 | VTBDEALACT | RPORTB | TWPOB | RPORTB | |||
9 | VTBDEALACT | RREFKONT | T037S | RREFKONT | KEY | C | CN |
10 | VTBDEALACT | RREFKONT2 | T037S | RREFKONT | KEY | C | CN |
11 | VTBDEALACT | SANLF | TZAF | SANLF | KEY | 1 | CN |
12 | VTBDEALACT | SFGTYP | AT01 | SFGTYP | KEY | 1 | CN |
13 | VTBDEALACT | SFGZUSTT | AT02 | SFGZUSTT | KEY | 1 | CN |
14 | VTBDEALACT | SFHAART | AT10 | SFHAART | KEY | 1 | CN |
15 | VTBDEALACT | SGSART | TZPA | GSART | KEY | 1 | CN |
16 | VTBDEALACT | SKALID | TFACD | IDENT | KEY | 1 | CN |
17 | VTBDEALACT | SKALID2 | TFACD | IDENT | KEY | 1 | CN |
18 | VTBDEALACT | SSTOGRD | TZST | SSTOGRD | KEY | 1 | CN |
19 | VTBDEALACT | WGSCHFT | TCURC | WAERS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |