1. Home
  2. Resources
  3. SAP Tables
  4. VTMWRK1 - Transaction view for collective processing

SAP Table VTMWRK1

Transaction view for collective processing

VTMWRK1 (Transaction view for collective processing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VTMWRK1 to other SAP tables.

VTMWRK1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RFHA Financial Transaction TB_RFHA CHAR 13 0
CRUSER Entered by TB_CRUSER CHAR 12 0
DCRDAT Entered On TB_DCRDAT DATS 8 0
TCRTIM Entry Time TB_TCRTIM TIMS 6 0
UPUSER Last Changed by TB_UPUSER CHAR 12 0
DUPDAT Changed on TB_DUPDAT DATS 8 0
TUPTIM Time changed TB_TUPTIM TIMS 6 0
RANTYP Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
SANLF Product Category SANLF TZAF NUMC 3 0
SFGTYP Transaction Category TB_SFGTYP AT01 NUMC 3 0
SGSART Product Type VVSART TZPA CHAR 3 0
SFHAART Financial Transaction Type TB_SFHAART AT10 CHAR 3 0
RGATT Class TI_RGATT CHAR 13 0
RMAID Master Agreement TB_RMAID VTBMA CHAR 10 0
RFHAZUNR Number status of activity TB_RFHAZUN NUMC 5 0
RFHAZUL Last Active Transaction Activity TB_RFHAZUL NUMC 5 0
SAKTIV Active Status of Transaction or Activity TB_SAKTIV NUMC 1 0
0 Active
1 Concluded
2 Replaced
3 Reversed
4 Offer
5 Simulation
6 Old Transaction - No Editing Possible
KONTRH Business Partner Number TB_KUNNR_NEW CHAR 10 0
SROLEXT 3-Byte field CHAR3 CHAR 3 0
RGARANT Guarantor of Financial Transaction TB_RGARANT_NEW CHAR 10 0
RREFKONT Obsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETE T037S CHAR 8 0
RREFKONT2 Obsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETE T037S CHAR 8 0
RPORTB Portfolio RPORTB TWPOB CHAR 10 0
WGSCHFT Currency of transaction TB_WGSCHFT TCURC CUKY 5 0
WGSCHFT1 Currency of Outgoing Side TB_WGSCHF1 CUKY 5 0
WGSCHFT2 Currency of Incoming Side TB_WGSCHF2 CUKY 5 0
AMTINPUT Note field for traded amount forex transactions TB_AMTIN CHAR 1 0
1 Sale amount was traded
2 Purchase amount was traded
DBLFZ Term Start TB_DBLFZ DATS 8 0
SKALID Factory calendar SKALID TFACD CHAR 2 0
SKALID2 Factory calendar SKALID TFACD CHAR 2 0
JLIMIT Limit indicator TB_JLIMIT CHAR 1 0
X Yes
NULL No
AKUEND Period of Notice TB_AKUEND NUMC 2 0
SKUEND Unit of Period of Notice TB_SKUEND NUMC 1 0
0 Days
1 Months
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
RLDEPO Securities Account VRLDEPO TWD01 CHAR 10 0
ZUONR Finance Project TB_TFPROJ CHAR 13 0
DELFZ Term End TB_DELFZ DATS 8 0
ABWTYP Processing Category TB_ABWTYP AT05 CHAR 5 0
TBEGRU Authorization Group TBEGRU TRBRG CHAR 4 0
VRFHA Reference transaction (Rollover/premature settlement) TB_VORFHA CHAR 13 0
SINCLBE Calculation Period: Start Inclusive vs. End Inclusive TB_SINCLBE CHAR 1 0
NULL Start inclusive
X End inclusive
SNPVCAL NPV Calculation TB_SNPVCAL CHAR 1 0
NULL Yield
X Discount
SRNDNG Rounding of Amount from Generated Flows TB_SRNDNG CHAR 1 0
NULL Round to the Nearest
- Round Down
+ Round Up
ZUOND Assignment TB_ZUOND CHAR 18 0
REFER Internal Reference TB_REFER CHAR 16 0
MERKM Characteristics TB_MERKM CHAR 25 0
SFRGZUST Transaction Release: Release Status TB_FRGZUST CHAR 1 0
NULL Release Not Checked
1 Release Not Required
2 Release Required
3 Release Granted
4 Release Rejected
RANL Security ID Number VVRANLW CHAR 13 0
RCOMVALCL General Valuation Class TPM_COM_VAL_CLASS TRGC_COM_VALCL NUMC 4 0
FACILITYNR Transaction Number of Facility TB_FACILITYNR VTBFHA CHAR 13 0
FACILITYBUKRS Company Code of Facility TB_FACILITYBUKRS T001 CHAR 4 0
POSACC Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT TRFT_POS_ACCOUNT CHAR 10 0
RCOMVALCL2 General Valuation Class TPM_COM_VAL_CLASS TRGC_COM_VALCL NUMC 4 0
FUND Fund FM_FUND CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
TIMESTAMP_DEAL UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
COMMODITY_ID Commodity ID TRCO_COMM_ID TRCOT_CTY_MASTER CHAR 18 0
RPORTB2 Portfolio RPORTB TWPOB CHAR 10 0
COMMODITY_ID1 Commodity ID TRCO_COMM_ID TRCOT_CTY_MASTER CHAR 18 0
COMMODITY_ID2 Commodity ID TRCO_COMM_ID TRCOT_CTY_MASTER CHAR 18 0
CLEARING_OPTION Central Clearing Option (TREA) TPM_TREA_CLEARING_OPT NUMC 1 0
0 Not Relevant
1 Central Clearing Optional
2 Central Clearing Mandatory
3 Central Clearing Already Occurred
CLEARING_STATUS Clearing Status (TREA) TPM_TREA_CLEARING_STATUS NUMC 1 0
0 Not Relevant for Clearing
1 Clearing Requested (Planned)
2 Clearing Accepted
3 Clearing Rejected
CLEARING_DATE Planned Clearing Date TPM_TREA_CLEARING_DATE DATS 8 0
EXT_ACCOUNT External Account TPM_EXT_ACCOUNT CHAR 10 0
CLEAR_DATE_ACT Actual Clearing Date TPM_TREA_CLEARING_DATE_ACT DATS 8 0
SCONDITION Indicates Whether Financial Trans. Is Based on a Condition FTR_CONDITION_USED CHAR 1 0
NULL Financial Transaction Is Not Based on a Condition
1 Financial Transaction Is Based on a Condition
RISK_MITIGATING Risk Mitigation Indicator FTR_THRESHOLD_RISK_MITIGATING CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EBELN Purchasing Document Number EBELN CHAR 10 0
VBELN Sales Document VBELN_VA CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
VBELP Sales document item VBELP NUMC 6 0
SFGZUSTT Transaction Activity Category TB_SFGZUTY NUMC 2 0
DPROLOL Last rollover date TB_DPROLOL DATS 8 0
PEFFZINS Effective Interest Rate TB_PYIELD DEC 10 7
SEFFMETH Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
XEFFMETH Name of effective interest rate method TB_XEFFMETH CHAR 60 0
RDEALER Trader RDEALER CHAR 12 0
DVTRAB Contract Conclusion Date TB_DVTRAB DATS 8 0
TVTRAB Time of contract conclusion TB_TVTRAB TIMS 6 0
GSPPART Contact Person TB_GSPPART CHAR 19 0
NORDEXT External Reference TB_NORDEXT CHAR 16 0
BANLAGE Single or totaled amount TM_BSUMME CURR 15 2
BBLFZ Amount at start of term/ last rollover date TM_BBLFZ CURR 15 2
BELFZ Amount at end of term TM_BELFZ CURR 15 2
BNOMI Nominal amount TM_BNOMI CURR 15 2
BZINSBLFZ Interest Total at Start of Term TM_BZINSBLFZ CURR 15 2
BZINSELFZ Interest Total at End of Term TM_BZINSELFZ CURR 15 2
BZINSSTICH Interest Total on Key Date TM_BZINSSTICH CURR 15 2
PZINS Interest rate TM_PZINS DEC 10 7
SZINSKAP Capitalize Interest TB_SZINSKAP CHAR 1 0
X Yes
NULL No
JEXPOZINS Exponential Interest Calculation TB_JZINSRE CHAR 1 0
X Yes
NULL No
PKOND1STPER Interest Rate for the First Period TFM_PKOND1STPER DEC 10 7
SZSREF Reference Interest Rate SZSREF CHAR 10 0
FORMULA FTR: Interest Formula TB_IRATE_FORMULA CHAR 100 0
AMNT_DELTA FTR Facility: Amount Above/Below the Limit TB_FC_AMOUNT_DELTA CURR 17 2
AMNT_LIMIT FTR Facility: Limit Amount on Key Date TB_FC_AMOUNT_LIMIT CURR 17 2
AMNT_USED FTR Facility: Utilization on Key Date TB_FC_AMOUNT_USED CURR 17 2
AMNT_FREE FTR Facility: Amount Available on Key Date TB_FC_AMOUNT_FREE CURR 17 2
AMNT_OVER FTR Facility: Overdraft Amount on Key Date TB_FC_AMOUNT_OVER CURR 17 2
XNPVCAL Name of NPV calculation TB_XNPVCAL CHAR 30 0
BUTXT Name of Company Code or Company BUTXT CHAR 25 0
XKONTRH Name and address of business partner TB_XKONTRH CHAR 80 0
XGSART Name of product type TB_XGSART CHAR 30 0
XFHAART Name of transaction type TB_XFHAART CHAR 30 0
XANLF Product Category Name TB_XANLF CHAR 30 0
XFGTYP Transaction category name TB_XFGTYP CHAR 30 0
XPGTYP Description of product category and transaction category TB_XPGTYP CHAR 60 0
XFGZUSTT Name of Activity Category TB_XFGZUSTT CHAR 30 0
XAKTIV Active status name TB_XAKTIV CHAR 30 0
ICON_CHECKED Processing indicator TB_ICON_CHECKED CHAR 4 0
PZINS_AMOUNT Interest rate as amount TB_BKOND CURR 13 2
ICON_LOCKED Icon in text fields (substitute display, alias) ICON_D CHAR 4 0
SEL Single-Character Indicator CHAR1 CHAR 1 0
XPORTB Portfolio name VVXPORTB CHAR 30 0

VTMWRK1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTMWRK1 ABWTYP VTMWRK1 SANLF AT05 Processing Categories SANLF
VTMWRK1 ABWTYP VTMWRK1 SFGTYP AT05 Processing Categories SFGTYP
VTMWRK1 ABWTYP VTMWRK1 ABWTYP AT05 Processing Categories ABWTYP
VTMWRK1 BUKRS VTMWRK1 BUKRS T001 Company Codes BUKRS
VTMWRK1 BUKRS VTMWRK1 MANDT T001 Company Codes MANDT
VTMWRK1 COMMODITY_ID VTMWRK1 MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTMWRK1 COMMODITY_ID VTMWRK1 COMMODITY_ID TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
VTMWRK1 COMMODITY_ID1 VTMWRK1 MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTMWRK1 COMMODITY_ID1 VTMWRK1 COMMODITY_ID1 TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
VTMWRK1 COMMODITY_ID2 VTMWRK1 COMMODITY_ID2 TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
VTMWRK1 COMMODITY_ID2 VTMWRK1 MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTMWRK1 FACILITYBUKRS VTMWRK1 MANDT T001 Company Codes MANDT
VTMWRK1 FACILITYBUKRS VTMWRK1 FACILITYBUKRS T001 Company Codes BUKRS
VTMWRK1 FACILITYNR VTMWRK1 FACILITYBUKRS VTBFHA Transaction BUKRS
VTMWRK1 FACILITYNR VTMWRK1 FACILITYNR VTBFHA Transaction RFHA
VTMWRK1 FACILITYNR VTMWRK1 MANDT VTBFHA Transaction MANDT
VTMWRK1 MANDT VTMWRK1 MANDT T000 Clients MANDT
VTMWRK1 OBJNR VTMWRK1 MANDT ONR00 General Object Number MANDT
VTMWRK1 OBJNR VTMWRK1 OBJNR ONR00 General Object Number OBJNR
VTMWRK1 POSACC VTMWRK1 MANDT TRFT_POS_ACCOUNT Treasury: Futures Account Master Data MANDT
VTMWRK1 POSACC VTMWRK1 BUKRS TRFT_POS_ACCOUNT Treasury: Futures Account Master Data COMPANY_CODE
VTMWRK1 POSACC VTMWRK1 POSACC TRFT_POS_ACCOUNT Treasury: Futures Account Master Data POS_ACCOUNT
VTMWRK1 RCOMVALCL VTMWRK1 RCOMVALCL TRGC_COM_VALCL General valuation class COM_VAL_CLASS
VTMWRK1 RCOMVALCL VTMWRK1 MANDT TRGC_COM_VALCL General valuation class MANDT
VTMWRK1 RCOMVALCL2 VTMWRK1 MANDT TRGC_COM_VALCL General valuation class MANDT
VTMWRK1 RCOMVALCL2 VTMWRK1 RCOMVALCL2 TRGC_COM_VALCL General valuation class COM_VAL_CLASS
VTMWRK1 RLDEPO VTMWRK1 RLDEPO TWD01 Treasury: Securities Account Master Data RLDEPO
VTMWRK1 RLDEPO VTMWRK1 MANDT TWD01 Treasury: Securities Account Master Data MANDT
VTMWRK1 RLDEPO VTMWRK1 BUKRS TWD01 Treasury: Securities Account Master Data BUKRS
VTMWRK1 RMAID VTMWRK1 MANDT VTBMA Master Agreement MANDT
VTMWRK1 RMAID VTMWRK1 RMAID VTBMA Master Agreement RMAID
VTMWRK1 RPORTB VTMWRK1 MANDT TWPOB Portfolio position MANDT
VTMWRK1 RPORTB VTMWRK1 BUKRS TWPOB Portfolio position BUKRS
VTMWRK1 RPORTB VTMWRK1 RPORTB TWPOB Portfolio position RPORTB
VTMWRK1 RPORTB2 VTMWRK1 RPORTB2 TWPOB Portfolio position RPORTB
VTMWRK1 RPORTB2 VTMWRK1 MANDT TWPOB Portfolio position MANDT
VTMWRK1 RPORTB2 VTMWRK1 BUKRS TWPOB Portfolio position BUKRS
VTMWRK1 RREFKONT VTMWRK1 RREFKONT T037S Account Assignment References acc. to Transaction Type RREFKONT
VTMWRK1 RREFKONT VTMWRK1 MANDT T037S Account Assignment References acc. to Transaction Type MANDT
VTMWRK1 RREFKONT VTMWRK1 BUKRS T037S Account Assignment References acc. to Transaction Type BUKRS
VTMWRK1 RREFKONT VTMWRK1 RANTYP T037S Account Assignment References acc. to Transaction Type RANTYP
VTMWRK1 RREFKONT2 VTMWRK1 MANDT T037S Account Assignment References acc. to Transaction Type MANDT
VTMWRK1 RREFKONT2 VTMWRK1 BUKRS T037S Account Assignment References acc. to Transaction Type BUKRS
VTMWRK1 RREFKONT2 VTMWRK1 RANTYP T037S Account Assignment References acc. to Transaction Type RANTYP
VTMWRK1 RREFKONT2 VTMWRK1 RREFKONT2 T037S Account Assignment References acc. to Transaction Type RREFKONT
VTMWRK1 SANLF VTMWRK1 SANLF TZAF Product categories SANLF
VTMWRK1 SFGTYP VTMWRK1 SANLF AT01 Transaction Category SANLFOR
VTMWRK1 SFGTYP VTMWRK1 SFGTYP AT01 Transaction Category SFGTYP
VTMWRK1 SFHAART VTMWRK1 SFHAART AT10 Transaction Types SFHAART
VTMWRK1 SFHAART VTMWRK1 MANDT AT10 Transaction Types MANDT
VTMWRK1 SFHAART VTMWRK1 SGSART AT10 Transaction Types SGSART
VTMWRK1 SGSART VTMWRK1 MANDT TZPA Financial Assets Management Product Types MANDT
VTMWRK1 SGSART VTMWRK1 SGSART TZPA Financial Assets Management Product Types GSART
VTMWRK1 SKALID VTMWRK1 SKALID TFACD Factory calendar definition IDENT
VTMWRK1 SKALID2 VTMWRK1 SKALID2 TFACD Factory calendar definition IDENT
VTMWRK1 TBEGRU VTMWRK1 TBEGRU TRBRG Authorization Group for Treasury Transactions TBEGRU
VTMWRK1 TBEGRU VTMWRK1 MANDT TRBRG Authorization Group for Treasury Transactions MANDT
VTMWRK1 WGSCHFT VTMWRK1 MANDT TCURC Currency Codes MANDT
VTMWRK1 WGSCHFT VTMWRK1 WGSCHFT TCURC Currency Codes WAERS