TRLT_DERIVFLOWS SAP (Treasury: Flows for Derived Business Transactions) Table details
Description: Treasury: Flows for Derived Business Transactions
Related tables to TRLT_DERIVFLOWS
Access table TRLT_DERIVFLOWS
Table field list including key, data, relationships and ABAP select examples
TRLT_DERIVFLOWS is a standard SAP Table which is used to store Treasury: Flows for Derived Business Transactions data and is available within R/3 SAP systems depending on the version and release level.
The TRLT_DERIVFLOWS table consists of various fields, each holding specific information or linking keys about Treasury: Flows for Derived Business Transactions data available in SAP. These include DERIV_TRANS_OID (Object Identity in Database Format), DERIV_FLOWNUMBER (Number of TRL Flow), POSITION_OID (Object Identity in Database Format), SUBPOSITION_OID (Globally Unique Identifier).. 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: Cannot Be Enhanced
SAP TRLT_DERIVFLOWS 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 | |||
DERIV_TRANS_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TRLT_DERIVTRANS | TPM_DB_OS_GUID | |||
DERIV_FLOWNUMBER | Number of TRL Flow | TPM_TRLDERIVFLOWNR | INT4 | 10 | TPM_TRLFLOW_NR | ||||
POSITION_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TRLT_POSITION | TPM_DB_OS_GUID | |||
SUBPOSITION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
DIST_FLOW_NUMBER | Number of a Distributor Flow | TPM_TRDFLOWNR | INT4 | 10 | TPM_TRDFLOWNR | ||||
POS_MAN_PROC | Position Management Procedure | TPM_POS_MAN_PROC | CHAR | 4 | Assigned to domain | TPM_POS_MAN_PROC | |||
DERIV_METHOD | Derivation Method | TPM_DERIV_METHOD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | TCURC | WAERS | |||
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 | ||||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
POSITION_AMT | Amount (Position Currency) | TPM_POSITION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | TPM_POSITION_AMT_IDX_CLEAN | CURR | 21(2) | TPM_AMOUNT | ||||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
VALUATION_AMT | Amount in Valuation Currency | TPM_VALUATION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
AMT_PM_CAT | Position Change Category | TPM_AMT_PM_CAT | CHAR | 4 | Assigned to domain | TPM_PM_CAT | |||
QUANT_CAT | Position Change Category: Quantity | TPM_QTY_PM_CAT | CHAR | 4 | TPM_QTY_PM_CAT | ||||
DIST_FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | Assigned to domain | TPM_DIS_FLOWTYPE | |||
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 | ||||
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 | |||||
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 | ||||
EFFTEST_RESULT | Result of Effectiveness Test for Flows | TPM_EFFTEST_RESULTFORFLOWS | NUMC | 1 | TPM_EFFTEST_RESULTFORFLOWS |
Key field | Non-key field |
How do I retrieve data from SAP table TRLT_DERIVFLOWS using ABAP code
The following ABAP code Example will allow you to do a basic selection on TRLT_DERIVFLOWS to SELECT all data from the tableDATA: WA_TRLT_DERIVFLOWS TYPE TRLT_DERIVFLOWS.
SELECT SINGLE *
FROM TRLT_DERIVFLOWS
INTO CORRESPONDING FIELDS OF WA_TRLT_DERIVFLOWS
WHERE...
How to access SAP table TRLT_DERIVFLOWS
Within an ECC or HANA version of SAP you can also view further information about TRLT_DERIVFLOWS 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