1. Home
  2. Resources
  3. SAP Tables
  4. TRDT_TRDBUSTRANS - Treasury: Persistent distributor business transaction

SAP Table TRDT_TRDBUSTRANS

Treasury: Persistent distributor business transaction

TRDT_TRDBUSTRANS (Treasury: Persistent distributor business transaction) 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 TRDT_TRDBUSTRANS to other SAP tables.

TRDT_TRDBUSTRANS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
OS_GUID Object Identity in Database Format TPM_DB_OS_GUID CHAR 32 0
USER_DATA_CLS Object Identity in Database Format TPM_DB_OS_GUID CHAR 32 0
USER_DATA_OID Object Identity in Database Format TPM_DB_OS_GUID TRGT_USER_DATA CHAR 32 0
VERSION Distributor Version in Generation of Data TPM_TRDVERSION CHAR 6 0
ERP07 ERP 2005 EhP3 / ERP 2005s
ERP2.0 Enterprise 2.0 to ERP 2005
CFM3_0 Enterprise 1.10
CFM1_4 CFM 1.0 SP 4 to CFM 2.0
OWNER Origin of a Distributor Business Transaction TPM_BUSTRANS_OWNER INT1 3 0
1 Transaction Management
2 Securities Account Management
3 Securities Account Transfer
4 Corporate Action
5 Exercise Rights
6 Margin Management TRF
7 Operative Loans Management
8 Interest Accrual/Deferral
9 Taxes
100 Initialize Positions
101 Generation of Derived Business Transactions
102 Key Date Valuation
103 Local Currency Reconciliation TR Ledger
104 FAS 133 Distribution
105 Valuation Class Transfer
106 Transfer Account Assignment Reference
107 Legacy Data Transfer
112 Currency Changeover
109 Portfolio Transfer
110 Designation / De-designation
111 External Account: Central Counterparty Clearing
COMPANY_CODE Company Code BUKRS T001 CHAR 4 0
VALUATION_AREA Valuation Area TPM_VAL_AREA TRGC_VAL_AREA CHAR 3 0
BUSTRANSID Identifier of the Distributor Business Transaction TPM_BUSTRANSID RAW 16 0
EXTBUSTRANSID Default ID from Creator for Distributor Business Transaction TPM_EXTBUSTRANSID CHAR 60 0
BUSTRANSCAT Business Transaction Category TPM_BUSTRANSCAT TRDTS_BT_CAT NUMC 4 0
PRODUCT_GROUP Product Group TPM_PRODUCT_GROUP NUMC 3 0
001 Securities
002 Loans
003 OTC Transactions: Money Market, FX, Derivatives
004 Listed Options / Futures
005 External Accounts
PRODUCT_CATEGORY Product Category SANLF TZAF NUMC 3 0
BUSTRANS_STATE Status of Distributor Business Transaction TPM_BUSTRANS_STATE CHAR 1 0
1 Scheduled
2 Fixed
3 To Delete
4 Reversed
5 To Be Fixed
6 To Be Reversed
7 Operatively Fixed
8 Payment Initiated
9 Payment Reversed
A Payment To Be Reversed
PLANNED_ACTION Planned Action in a Business Transaction TPM_PLANNED_ACTION INT1 3 0
0 No Action
10 Migration: Generate TRD BusTrans (No Distribution)
11 Migration: Distribute TRD BusTrans
20 Futures Migration: Generate BusTrans (No Distribution)
21 Futures Migration: Distribute BusTrans
30 Initialization: Distribute TRD BusTrans in New Val. Area
31 Initialization: Reverse Distribution
40 Initialization: Fix TRD BusTrans in New Valuation Area
41 Initialization: Fix Reversal
50 Asynchronous Distribution
60 Asynchronous Update
70 Migration OTC, Val Area 001: Group BusTrans
71 Migration OTC, Val Area 001: Distribute BusTrans
72 Migration OTC, Val Area 001: Reverse BusTrans
80 Migration OTC, Val Area<>001: Group BusTrans
81 Migration OTC, Val Area<>001: Distribute BusTrans
82 Migration OTC, Val Area<>001: Reverse BusTrans
90 Migration SEC, Val Area 001: Group BusTrans
91 Migration SEC, Val Area 001: Distribute BusTrans
92 Migration SEC, Val Area 001: Reverse BusTrans
100 Migration SEC, Val Area<>001: Group BusTrans
101 Migration SEC, Val Area<>001: Distribute BusTrans
102 Migration SEC, Val Area<>001: Reverse BusTrans
110 Migration Loan, Val Area<>001: Group BusTrans
111 Migration Loan, Val Area<>001: Distribute BusTrans
112 Migration Loan, Val Area<>001: Reverse BusTrans
120 Migration Fut, Val Area <>001: Group BusTrans
121 Migration Fut, Val Area <>001: Distribute BusTrans
122 Migration Fut, Val Area <>001: Reverse BusTrans
POSITION_DATE Posting Date for the Subledger TPM_POSTING_DATE DATS 8 0
CREATE_DATE Creation Date of the Operative Business Transaction TPM_BT_CREATE_DATE DATS 8 0
CREATE_TIME Creation Time of the Operative Business Transaction TPM_BT_CREATE_TIME TIMS 6 0
REF_BUSTRANSID Business Transaction ID of Reference Business Transaction TPM_REFBUSTRANSID RAW 16 0
TR_REV_REASON Reason for Reversal SSTOGRD TZST CHAR 2 0
DOCUMENT_DATE Document Date in Document BLDAT DATS 8 0
FI_POST_DATE Different FI Posting Date TPM_FI_POSTING_DATE DATS 8 0
FI_POST_PERIOD Different FI Posting Period TPM_FI_POSTING_PERIOD NUMC 2 0
FI_REV_DATE Different FI Reversal Date TPM_FI_REVERSAL_DATE DATS 8 0
FI_REV_PERIOD Alternative FI Reversal Period TPM_FI_REVERSAL_PERIOD NUMC 2 0
DEAL_NUMBER Financial Transaction TB_RFHA VTBFHA CHAR 13 0
TABLES_USED Bit Field for Database Tables Used TPM_TABLES_USED RAW 1 0

TRDT_TRDBUSTRANS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TRDT_TRDBUSTRANS BUSTRANSCAT TRDT_TRDBUSTRANS BUSTRANSCAT TRDTS_BT_CAT Treasury: Business Transaction Categories BUSTRANSCAT
TRDT_TRDBUSTRANS COMPANY_CODE TRDT_TRDBUSTRANS COMPANY_CODE T001 Company Codes BUKRS
TRDT_TRDBUSTRANS COMPANY_CODE SYST MANDT T001 Company Codes MANDT
TRDT_TRDBUSTRANS DEAL_NUMBER TRDT_TRDBUSTRANS COMPANY_CODE VTBFHA Transaction BUKRS
TRDT_TRDBUSTRANS DEAL_NUMBER TRDT_TRDBUSTRANS DEAL_NUMBER VTBFHA Transaction RFHA
TRDT_TRDBUSTRANS DEAL_NUMBER SYST MANDT VTBFHA Transaction MANDT
TRDT_TRDBUSTRANS MANDT TRDT_TRDBUSTRANS MANDT T000 Clients MANDT
TRDT_TRDBUSTRANS PRODUCT_CATEGORY TRDT_TRDBUSTRANS PRODUCT_CATEGORY TZAF Product categories SANLF
TRDT_TRDBUSTRANS TR_REV_REASON SYST MANDT TZST Reasons for reversal MANDT
TRDT_TRDBUSTRANS TR_REV_REASON TRDT_TRDBUSTRANS TR_REV_REASON TZST Reasons for reversal SSTOGRD
TRDT_TRDBUSTRANS USER_DATA_OID TRDT_TRDBUSTRANS USER_DATA_OID TRGT_USER_DATA TR Position Management - User Data OS_GUID
TRDT_TRDBUSTRANS USER_DATA_OID TRDT_TRDBUSTRANS MANDT TRGT_USER_DATA TR Position Management - User Data MANDT
TRDT_TRDBUSTRANS VALUATION_AREA SYST MANDT TRGC_VAL_AREA Valuation Areas MANDT
TRDT_TRDBUSTRANS VALUATION_AREA TRDT_TRDBUSTRANS VALUATION_AREA TRGC_VAL_AREA Valuation Areas VALUATION_AREA