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