TRLT_FLOW - Treasury Ledger Flows
Treasury Ledger Flows information is stored in SAP table TRLT_FLOW.
It is part of development package FTR_TREASURY_LEDGER in software component FIN-FSCM-TRM-TM-AC. This development package consists of objects that can be grouped under "Treasury Ledger".
It is part of development package FTR_TREASURY_LEDGER in software component FIN-FSCM-TRM-TM-AC. This development package consists of objects that can be grouped under "Treasury Ledger".
Fields for table TRLT_FLOW
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
TRANSACTION_OID | Object Identity in Database Format | X | TPM_DB_OS_GUID | CHAR | 64 | TRLT_TRANSACTION |
TRLFLOWNUMBER | Number of TRL Flow | X | TPM_TRLFLOWNR | INT4 | 4 | |
.INCLUDE | TRLS_FLOW_I | 0 | ||||
FLOWNUMBER | Number of a Distributor Flow | TPM_TRDFLOWNR | INT4 | 4 | ||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 2 | ||
TRANSFER_GROUP | Group of Flows from a Source or Target | TPM_TRANSFER_GROUP | NUMC | 8 | ||
FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 16 | * | |
AMOUNT_FACTOR | Value Coefficient | TPM_AMOUNT_FACTOR | FLTP | 8 | ||
QUANT_CAT | Position Change Category: Quantity | TPM_QTY_PM_CAT | CHAR | 8 | ||
AMOUNT_CAT | Position Change Category | TPM_AMT_PM_CAT | CHAR | 8 | * | |
UNITS | Units | TPM_UNITS | DEC | 12 | ||
NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 11 | ||
NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 11 | ||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 10 | * | |
POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | TPM_POSITION_AMT_IDX_CLEAN | CURR | 11 | ||
POSITION_AMT | Amount (Position Currency) | TPM_POSITION_AMT | CURR | 11 | ||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 10 | * | |
VALUATION_AMT | Amount in Valuation Currency | TPM_VALUATION_AMT | CURR | 11 | ||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 10 | * | |
CALCULATION_DATE | Calculation Date | DVALUT | DATS | 16 | ||
CALC_DATE_INCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 2 | ||
DUE_DATE | Due Date | TPM_DUE_DATE | DATS | 16 | ||
CALC_BEGIN | Start of Calculation Period | DBERVON | DATS | 16 | ||
CALC_END | End of Calculation Period | DBERBIS | DATS | 16 | ||
EFF_INT_RATE_U | For Calculation of Amortization Amts (SAC) for Used EffInR | TPM_TRL_EFF_INT_RATE_USED | DEC | 6 | ||
SCHED_EFF_RATE | Key for Redemption Schedule that Explains Effect. Int. Rate | RDPT_SCHEDULE_KEY_EFF_RATE | INT4 | 4 | ||
EFF_INT_RATE_N | Valid Effective Interest Rate for the Next Amortization | TPM_TRL_EFF_INT_RATE_NEW | DEC | 6 | ||
SCHED_FIX | Key for Fixed Redemption Schedule | RDPT_SCHEDULE_KEY_FIX | INT4 | 4 | ||
BBASIS | Calculation Base Amount | BBASIS | CURR | 7 | ||
PAR_USAGE | Parameter Usage | TPM_PAR_USAGE | CHAR | 2 | ||
SUB_SOURCETARGET | Source or Target of Subposition Transfer | TPM_SUB_SOURCE_TARGET | CHAR | 2 | ||
SUB_TRANSFERGRP | Group of Flows in Subposition Transfer | TPM_SUB_TRANSFER_GROUP | NUMC | 8 | ||
INIT_CLASSIFIER | Initial Stage Value | TRPA_INITIAL_STAGE | CHAR | 20 | ||
.INCLUDE | CMMS_HACC_COMMODITY | 0 | ||||
.INCLUDE | CMMS_HACC_DCS | 0 | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 40 | ||
.INCLUDE | CMMS_HACC_QUANTITY | 0 | ||||
QUANTITY | Quantity | FTR_QUAN | QUAN | 7 | ||
UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 6 | * | |
.INCLUDE | TRLS_DOCUMENT_I | 0 | ||||
DOCUMENTID | Distributor Document ID | TPM_TRDDOCID | RAW | 16 | ||
BOOKING_STATE | Posting Status Treasury Ledger Business Transaction | TPM_TRL_BOOKINGSTATE | CHAR | 2 | ||
USER_DATA_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 64 | TRGT_USER_DATA | |
POSITION_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 64 | TRLT_POSITION | |
TRLDATE | Treasury Ledger Date | TPM_TRLDATE | DATS | 16 | ||
SUBPOSITION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 |