SAP ABAP Table VTMWRK1 (Transaction view for collective processing)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
⤷ FTG (Package) R/3 application development for Treasury money market
⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
⤷ FTG (Package) R/3 application development for Treasury money market
Basic Data
Table Category | INTTAB | Structure |
Structure | VTMWRK1 | Table Relationship Diagram |
Short Description | Transaction view for collective processing |
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 | 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 | * | |
5 | CRUSER | TB_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
6 | DCRDAT | TB_DCRDAT | DATUM | DATS | 8 | 0 | Entered On | ||
7 | TCRTIM | TB_TCRTIM | UZEIT | TIMS | 6 | 0 | Entry Time | ||
8 | UPUSER | TB_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
9 | DUPDAT | TB_DUPDAT | DATUM | DATS | 8 | 0 | Changed on | ||
10 | TUPTIM | TB_TUPTIM | UZEIT | TIMS | 6 | 0 | Time changed | ||
11 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
12 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
13 | SFGTYP | TB_SFGTYP | T_SFGTYP | NUMC | 3 | 0 | Transaction Category | AT01 | |
14 | SGSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
15 | SFHAART | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | AT10 | |
16 | RGATT | TI_RGATT | T_RGATT | CHAR | 13 | 0 | Class | ||
17 | RMAID | TB_RMAID | T_RMAID | CHAR | 10 | 0 | Master Agreement | VTBMA | |
18 | RFHAZUNR | TB_RFHAZUN | T_RFHAZU | NUMC | 5 | 0 | Number status of activity | ||
19 | RFHAZUL | TB_RFHAZUL | T_RFHAZU | NUMC | 5 | 0 | Last Active Transaction Activity | ||
20 | SAKTIV | TB_SAKTIV | T_SAKTIV | NUMC | 1 | 0 | Active Status of Transaction or Activity | ||
21 | KONTRH | TB_KUNNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
22 | SROLEXT | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
23 | RGARANT | TB_RGARANT_NEW | BU_PARTNER | CHAR | 10 | 0 | Guarantor of Financial Transaction | * | |
24 | RREFKONT | RREFKONT_OBSOLETE | USTRU | CHAR | 8 | 0 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | T037S | |
25 | RREFKONT2 | RREFKONT_OBSOLETE | USTRU | CHAR | 8 | 0 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | T037S | |
26 | RPORTB | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
27 | WGSCHFT | TB_WGSCHFT | WAERS | CUKY | 5 | 0 | Currency of transaction | TCURC | |
28 | WGSCHFT1 | TB_WGSCHF1 | WAERS | CUKY | 5 | 0 | Currency of Outgoing Side | * | |
29 | WGSCHFT2 | TB_WGSCHF2 | WAERS | CUKY | 5 | 0 | Currency of Incoming Side | * | |
30 | AMTINPUT | TB_AMTIN | TX_AMTIN | CHAR | 1 | 0 | Note field for traded amount forex transactions | ||
31 | DBLFZ | TB_DBLFZ | DATUM | DATS | 8 | 0 | Term Start | ||
32 | SKALID | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | TFACD | |
33 | SKALID2 | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | TFACD | |
34 | JLIMIT | TB_JLIMIT | XFELD | CHAR | 1 | 0 | Limit indicator | ||
35 | AKUEND | TB_AKUEND | T_AKUEND | NUMC | 2 | 0 | Period of Notice | ||
36 | SKUEND | TB_SKUEND | T_SKUEND | NUMC | 1 | 0 | Unit of Period of Notice | ||
37 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
38 | RLDEPO | VRLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
39 | ZUONR | TB_TFPROJ | T_TFPROJ | CHAR | 13 | 0 | Finance Project | ||
40 | DELFZ | TB_DELFZ | DATUM | DATS | 8 | 0 | Term End | ||
41 | ABWTYP | TB_ABWTYP | T_ABWTYP | CHAR | 5 | 0 | Processing Category | AT05 | |
42 | TBEGRU | TBEGRU | TRBEGRU | CHAR | 4 | 0 | Authorization Group | TRBRG | |
43 | VRFHA | TB_VORFHA | T_RFHA | CHAR | 13 | 0 | Reference transaction (Rollover/premature settlement) | * | |
44 | SINCLBE | TB_SINCLBE | T_SINCLBE | CHAR | 1 | 0 | Calculation Period: Start Inclusive vs. End Inclusive | ||
45 | SNPVCAL | TB_SNPVCAL | T_SNPVCAL | CHAR | 1 | 0 | NPV Calculation | ||
46 | SRNDNG | TB_SRNDNG | TFM_SROUND | CHAR | 1 | 0 | Rounding of Amount from Generated Flows | ||
47 | ZUOND | TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
48 | REFER | TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
49 | MERKM | TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics | ||
50 | SFRGZUST | TB_FRGZUST | T_FRGZUST | CHAR | 1 | 0 | Transaction Release: Release Status | ||
51 | RANL | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
52 | RCOMVALCL | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | TRGC_COM_VALCL | |
53 | FACILITYNR | TB_FACILITYNR | T_RFHA | CHAR | 13 | 0 | Transaction Number of Facility | VTBFHA | |
54 | FACILITYBUKRS | TB_FACILITYBUKRS | BUKRS | CHAR | 4 | 0 | Company Code of Facility | T001 | |
55 | POSACC | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | TRFT_POS_ACCOUNT | |
56 | RCOMVALCL2 | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | TRGC_COM_VALCL | |
57 | TIMESTAMP_DEAL | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
58 | RPORTB2 | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
59 | SFGZUSTT | TB_SFGZUTY | T_SFGZUTY | NUMC | 2 | 0 | Transaction Activity Category | * | |
60 | DPROLOL | TB_DPROLOL | DATUM | DATS | 8 | 0 | Last rollover date | ||
61 | PEFFZINS | TB_PYIELD | DECV3_7 | DEC | 10 | 7 | Effective Interest Rate | ||
62 | SEFFMETH | SEFFMETH | SEFFMETH | NUMC | 1 | 0 | Effective Interest Method (Financial Mathematics) | ||
63 | XEFFMETH | TB_XEFFMETH | TEXT60 | CHAR | 60 | 0 | Name of effective interest rate method | ||
64 | RDEALER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | * | |
65 | DVTRAB | TB_DVTRAB | DATUM | DATS | 8 | 0 | Contract Conclusion Date | ||
66 | TVTRAB | TB_TVTRAB | UZEIT | TIMS | 6 | 0 | Time of contract conclusion | ||
67 | GSPPART | TB_GSPPART | TEXT19 | CHAR | 19 | 0 | Contact Person | ||
68 | NORDEXT | TB_NORDEXT | FTI_CHAR16LOW | CHAR | 16 | 0 | External Reference | ||
69 | BANLAGE | TM_BSUMME | WERT8 | CURR | 15 | 2 | Single or totaled amount | ||
70 | BBLFZ | TM_BBLFZ | WERT8 | CURR | 15 | 2 | Amount at start of term/ last rollover date | ||
71 | BELFZ | TM_BELFZ | WERT8 | CURR | 15 | 2 | Amount at end of term | ||
72 | BNOMI | TM_BNOMI | WERT8 | CURR | 15 | 2 | Nominal amount | ||
73 | BZINSBLFZ | TM_BZINSBLFZ | WERT8 | CURR | 15 | 2 | Interest Total at Start of Term | ||
74 | BZINSELFZ | TM_BZINSELFZ | WERT8 | CURR | 15 | 2 | Interest Total at End of Term | ||
75 | BZINSSTICH | TM_BZINSSTICH | WERT8 | CURR | 15 | 2 | Interest Total on Key Date | ||
76 | PZINS | TM_PZINS | DEC3_7 | DEC | 10 | 7 | Interest rate | ||
77 | SZINSKAP | TB_SZINSKAP | XFELD | CHAR | 1 | 0 | Capitalize Interest | ||
78 | JEXPOZINS | TB_JZINSRE | XFELD | CHAR | 1 | 0 | Exponential Interest Calculation | ||
79 | PKOND1STPER | TFM_PKOND1STPER | DECV3_7 | DEC | 10 | 7 | Interest Rate for the First Period | ||
80 | SZSREF | SZSREF | ZIREFKU | CHAR | 10 | 0 | Reference Interest Rate | * | |
81 | FORMULA | TB_IRATE_FORMULA | TEXT100 | CHAR | 100 | 0 | FTR: Interest Formula | ||
82 | AMNT_DELTA | TB_FC_AMOUNT_DELTA | T_POS_AMOUNT | CURR | 17 | 2 | FTR Facility: Amount Above/Below the Limit | ||
83 | AMNT_LIMIT | TB_FC_AMOUNT_LIMIT | T_POS_AMOUNT | CURR | 17 | 2 | FTR Facility: Limit Amount on Key Date | ||
84 | AMNT_USED | TB_FC_AMOUNT_USED | T_POS_AMOUNT | CURR | 17 | 2 | FTR Facility: Utilization on Key Date | ||
85 | AMNT_FREE | TB_FC_AMOUNT_FREE | T_POS_AMOUNT | CURR | 17 | 2 | FTR Facility: Amount Available on Key Date | ||
86 | AMNT_OVER | TB_FC_AMOUNT_OVER | T_POS_AMOUNT | CURR | 17 | 2 | FTR Facility: Overdraft Amount on Key Date | ||
87 | XNPVCAL | TB_XNPVCAL | TEXT30 | CHAR | 30 | 0 | Name of NPV calculation | ||
88 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
89 | XKONTRH | TB_XKONTRH | TEXT80 | CHAR | 80 | 0 | Name and address of business partner | ||
90 | XGSART | TB_XGSART | TEXT30 | CHAR | 30 | 0 | Name of product type | ||
91 | XFHAART | TB_XFHAART | TEXT30 | CHAR | 30 | 0 | Name of transaction type | ||
92 | XANLF | TB_XANLF | TEXT30 | CHAR | 30 | 0 | Product Category Name | ||
93 | XFGTYP | TB_XFGTYP | TEXT30 | CHAR | 30 | 0 | Transaction category name | ||
94 | XPGTYP | TB_XPGTYP | TEXT60 | CHAR | 60 | 0 | Description of product category and transaction category | ||
95 | XFGZUSTT | TB_XFGZUSTT | TEXT30 | CHAR | 30 | 0 | Name of Activity Category | ||
96 | XAKTIV | TB_XAKTIV | TEXT30 | CHAR | 30 | 0 | Active status name | ||
97 | ICON_CHECKED | TB_ICON_CHECKED | CHAR4 | CHAR | 4 | 0 | Processing indicator | ||
98 | PZINS_AMOUNT | TB_BKOND | WERTV7 | CURR | 13 | 2 | Interest rate as amount | ||
99 | ICON_LOCKED | ICON_D | ICON | CHAR | 4 | 0 | Icon in text fields (substitute display, alias) | * |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |