TRLT_FLOW SAP (Treasury Ledger Flows) Table details
Dictionary Type: Table
Description: Treasury Ledger Flows
Description: Treasury Ledger Flows
Table field list including key, data, relationships and ABAP select examples
TRLT_FLOW is a standard SAP Table which is used to store Treasury Ledger Flows data and is available within R/3 SAP systems depending on the version and release level.
The TRLT_FLOW table consists of various fields, each holding specific information or linking keys about Treasury Ledger Flows data available in SAP. These include TRANSACTION_OID (Object Identity in Database Format), TRLFLOWNUMBER (Number of TRL Flow), FLOWNUMBER (Number of a Distributor Flow), SOURCETARGET_FLG (Indicator: Source or Target of a Flow).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP TRLT_FLOW table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
TRANSACTION_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TRLT_TRANSACTION | TPM_DB_OS_GUID | |||
TRLFLOWNUMBER | Number of TRL Flow | TPM_TRLFLOWNR | INT4 | 10 | TPM_TRLFLOW_NR | ||||
FLOWNUMBER | Number of a Distributor Flow | TPM_TRDFLOWNR | INT4 | 10 | TPM_TRDFLOWNR | ||||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 1 | TPM_SOURCE_TARGET_FLG | ||||
TRANSFER_GROUP | Group of Flows from a Source or Target | TPM_TRANSFER_GROUP | NUMC | 4 | TPM_SYSTEM_KEY | ||||
FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | Assigned to domain | TPM_DIS_FLOWTYPE | |||
AMOUNT_FACTOR | Value Coefficient | TPM_AMOUNT_FACTOR | FLTP | 16(16) | TPM_AMOUNT_FACTOR | ||||
QUANT_CAT | Position Change Category: Quantity | TPM_QTY_PM_CAT | CHAR | 4 | TPM_QTY_PM_CAT | ||||
AMOUNT_CAT | Position Change Category | TPM_AMT_PM_CAT | CHAR | 4 | Assigned to domain | TPM_PM_CAT | |||
UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | TPM_POSITION_AMT_IDX_CLEAN | CURR | 21(2) | TPM_AMOUNT | ||||
POSITION_AMT | Amount (Position Currency) | TPM_POSITION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
VALUATION_AMT | Amount in Valuation Currency | TPM_VALUATION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
CALCULATION_DATE | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
CALC_DATE_INCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
DUE_DATE | Due Date | TPM_DUE_DATE | DATS | 8 | DATUM | ||||
CALC_BEGIN | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
CALC_END | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
EFF_INT_RATE_U | For Calculation of Amortization Amts (SAC) for Used EffInR | TPM_TRL_EFF_INT_RATE_USED | DEC | 10(7) | DEC3_7 | ||||
SCHED_EFF_RATE | Key for Redemption Schedule that Explains Effect. Int. Rate | RDPT_SCHEDULE_KEY_EFF_RATE | INT4 | 10 | |||||
EFF_INT_RATE_N | Valid Effective Interest Rate for the Next Amortization | TPM_TRL_EFF_INT_RATE_NEW | DEC | 10(7) | DEC3_7 | ||||
SCHED_FIX | Key for Fixed Redemption Schedule | RDPT_SCHEDULE_KEY_FIX | INT4 | 10 | |||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
PAR_USAGE | Parameter Usage | TPM_PAR_USAGE | CHAR | 1 | TPM_PAR_USAGE | ||||
SUB_SOURCETARGET | Source or Target of Subposition Transfer | TPM_SUB_SOURCE_TARGET | CHAR | 1 | TPM_SUB_SOURCE_TARGET | ||||
SUB_TRANSFERGRP | Group of Flows in Subposition Transfer | TPM_SUB_TRANSFER_GROUP | NUMC | 4 | TPM_SYSTEM_KEY | ||||
DOCUMENTID | Distributor Document ID | TPM_TRDDOCID | RAW | 16 | SYSUUID | ||||
BOOKING_STATE | Posting Status Treasury Ledger Business Transaction | TPM_TRL_BOOKINGSTATE | CHAR | 1 | TRLBS | TPM_TRL_BOOKINGSTATE | |||
USER_DATA_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TRGT_USER_DATA | TPM_DB_OS_GUID | |||
POSITION_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TRLT_POSITION | TPM_DB_OS_GUID | |||
TRLDATE | Treasury Ledger Date | TPM_TRLDATE | DATS | 8 | DATUM | ||||
SUBPOSITION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID |
Key field | Non-key field |
How do I retrieve data from SAP table TRLT_FLOW using ABAP code
The following ABAP code Example will allow you to do a basic selection on TRLT_FLOW to SELECT all data from the tableDATA: WA_TRLT_FLOW TYPE TRLT_FLOW.
SELECT SINGLE *
FROM TRLT_FLOW
INTO CORRESPONDING FIELDS OF WA_TRLT_FLOW
WHERE...
How to access SAP table TRLT_FLOW
Within an ECC or HANA version of SAP you can also view further information about TRLT_FLOW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects