1. Home
  2. Resources
  3. SAP Tables
  4. TRLS_TRANSACTION - Mapping Structure Treasury Ledger Business Transactions

SAP Table TRLS_TRANSACTION

Mapping Structure Treasury Ledger Business Transactions

TRLS_TRANSACTION (Mapping Structure Treasury Ledger Business Transactions) 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 TRLS_TRANSACTION to other SAP tables.

TRLS_TRANSACTION table fields

Field Data element Checktable Datatype Length Decimals
OS_GUID Globally Unique Identifier OS_GUID RAW 16 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
BUSTRANSCAT Business Transaction Category TPM_BUSTRANSCAT TRDTS_BT_CAT NUMC 4 0
TRLDATE Treasury Ledger Date TPM_TRLDATE DATS 8 0
BUSTRANSID Identifier of the Distributor Business Transaction TPM_BUSTRANSID RAW 16 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
BUSTRANSSTATE Status of Treasury Ledger Business Transaction TPM_TRLTRANSTATE CHAR 1 0
U Updated
N Not updated
E No valid effectiveness test
BOOKING_STATE Posting Status Treasury Ledger Business Transaction TPM_TRL_BOOKINGSTATE CHAR 1 0
1 Scheduled
2 Fixed
3 Deleted
4 Reversed
5 To Be Fixed
6 To Be Reversed
7 Operatively Fixed
8 Paid
9 Payment Reversed
A Payment To Be Reversed
VALUATION_AREA Valuation Area TPM_VAL_AREA CHAR 3 0
TR_ACC_CODE Accounting Code TPM_ACC_CODE CHAR 4 0
REFBUSTRANSID Identifier of the Distributor Business Transaction TPM_BUSTRANSID RAW 16 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
MIGR_INIT_FLG Bus. Transaction Originated from Migration/Initialization TPM_FLG_MIGR_INIT CHAR 1 0
M Business transaction was caused by migration
I Business transaction was caused by initialization
IGT_STATUS IGT: Status of an Intragroup transaction TPM_IGT_STATUS CHAR 1 0
NULL No IGT
1 Open IGT
2 Closed IGT with value transfer
3 Closed IGT without value transfer
FBP_NEEDED Flow Backpack Required? TPM_FBP_NEEDED NUMC 1 0
0 Not Required
1 Required
FBP_EXISTS Flow Add-On Is Available (Hedge Accounting) TPM_FBP_EXISTS NUMC 1 0
0 Flow Add-On Is Not Available
1 Current Flow Add-On Is Available
2 Current Flow Add-On and Quantity Flows Available
3 Manual Flow Add-On Is Available
4 Manaul Flow Add-On and Quantity Flows Available
LINK_VAL_AREA Valuation Area TPM_VAL_AREA CHAR 3 0
LINK_BUSTRANSID Identifier of the Distributor Business Transaction TPM_BUSTRANSID RAW 16 0
FLG_EFFTEST effectiveness test existent for business transaction TPM_FLG_EFFTEST CHAR 1 0
X Yes
NULL No
USER_DATA_OID Globally Unique Identifier OS_GUID RAW 16 0
USER_DATA_CLS Globally Unique Identifier OS_GUID RAW 16 0
TAB_FLOW_PERS TRLY_FLOW_PERS TTYP 0 0
CREATE_UTC UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
CHANGE_UTC UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0

TRLS_TRANSACTION foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TRLS_TRANSACTION BUSTRANSCAT TRLS_TRANSACTION BUSTRANSCAT TRDTS_BT_CAT Treasury: Business Transaction Categories BUSTRANSCAT