SAP ABAP View TRLV_FLOW (View of TRL Flows and Positions)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
⤷ FTR_TREASURY_LEDGER (Package) Treasury Ledger
⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
⤷ FTR_TREASURY_LEDGER (Package) Treasury Ledger
Basic Data
View Type | D | Database View |
Database View | TRLV_FLOW | |
Short Description | View of TRL Flows and Positions | |
Root table | TRLT_POSITION | Treasury Ledger Position |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TRLT_POSITION | TRLT_POSITION | ||
2 | TRLT_FLOW |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | TRLT_POSITION | MANDT | JL | EQ | 0 | 0 | ||||
2 | TRLT_FLOW | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | TRLT_POSITION | OS_GUID | JL | EQ | 0 | 0 | ||||
4 | TRLT_FLOW | POSITION_OID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TRLT_POSITION | MANDT | MANDT | Client | |||
2 | OS_GUID | TRLT_POSITION | OS_GUID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
3 | POS_MAN_PROC | TRLT_POSITION | POS_MAN_PROC | TPM_POS_MAN_PROC | Position Management Procedure | |||
4 | IDENTIFIER_OID | TRLT_POSITION | IDENTIFIER_OID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
5 | IDENTIFIER_CLS | TRLT_POSITION | IDENTIFIER_CLS | TPM_DB_OS_GUID | Object Identity in Database Format | |||
6 | TRANSACTION_OID | TRLT_FLOW | TRANSACTION_OID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
7 | TRLFLOWNUMBER | TRLT_FLOW | TRLFLOWNUMBER | TPM_TRLFLOWNR | Number of TRL Flow | |||
8 | FLOWNUMBER | TRLT_FLOW | FLOWNUMBER | TPM_TRDFLOWNR | Number of a Distributor Flow | |||
9 | SOURCETARGET_FLG | TRLT_FLOW | SOURCETARGET_FLG | TPM_SOURCE_TARGET_FLG | Indicator: Source or Target of a Flow | |||
10 | TRANSFER_GROUP | TRLT_FLOW | TRANSFER_GROUP | TPM_TRANSFER_GROUP | Group of Flows from a Source or Target | |||
11 | FLOWTYPE | TRLT_FLOW | FLOWTYPE | TPM_DIS_FLOWTYPE | Update Type | |||
12 | AMOUNT_FACTOR | TRLT_FLOW | AMOUNT_FACTOR | TPM_AMOUNT_FACTOR | Value Coefficient | |||
13 | QUANT_CAT | TRLT_FLOW | QUANT_CAT | TPM_QTY_PM_CAT | Position Change Category: Quantity | |||
14 | AMOUNT_CAT | TRLT_FLOW | AMOUNT_CAT | TPM_AMT_PM_CAT | Position Change Category | |||
15 | UNITS | TRLT_FLOW | UNITS | TPM_UNITS | Units | |||
16 | NOMINAL_AMT | TRLT_FLOW | NOMINAL_AMT | TPM_NOMINAL_AMT | Nominal Amount | |||
17 | NOMINAL_CURR | TRLT_FLOW | NOMINAL_CURR | TPM_NOMINAL_CURR | Nominal Currency | |||
18 | POSAMT_IDX_CLEAN | TRLT_FLOW | POSAMT_IDX_CLEAN | TPM_POSITION_AMT_IDX_CLEAN | Amount in Position Currency Index-Clean | |||
19 | POSITION_AMT | TRLT_FLOW | POSITION_AMT | TPM_POSITION_AMT | Amount in Position Currency | |||
20 | POSITION_CURR | TRLT_FLOW | POSITION_CURR | TPM_POSITION_CURR | Position Currency | |||
21 | VALUATION_AMT | TRLT_FLOW | VALUATION_AMT | TPM_VALUATION_AMT | Amount in Valuation Currency | |||
22 | VALUATION_CURR | TRLT_FLOW | VALUATION_CURR | TPM_VALUATION_CURR | Valuation Currency | |||
23 | DOCUMENTID | TRLT_FLOW | DOCUMENTID | TPM_TRDDOCID | Distributor Document ID | |||
24 | BOOKING_STATE | TRLT_FLOW | BOOKING_STATE | TPM_TRL_BOOKINGSTATE | Posting Status Treasury Ledger Business Transaction | |||
25 | USER_DATA_OID | TRLT_FLOW | USER_DATA_OID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
26 | TRLDATE | TRLT_FLOW | TRLDATE | TPM_TRLDATE | Treasury Ledger Date | |||
27 | NOMINAL_ORG_AMT | TRLT_FLOW | NOMINAL_ORG_AMT | TPM_NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | |||
28 | CALCULATION_DATE | TRLT_FLOW | CALCULATION_DATE | DVALUT | Calculation Date | |||
29 | CALC_DATE_INCL | TRLT_FLOW | CALC_DATE_INCL | VVSINCL | Inclusive indicator for beginning and end of a period | |||
30 | DUE_DATE | TRLT_FLOW | DUE_DATE | TPM_DUE_DATE | Due Date | |||
31 | CALC_BEGIN | TRLT_FLOW | CALC_BEGIN | DBERVON | Start of Calculation Period | |||
32 | CALC_END | TRLT_FLOW | CALC_END | DBERBIS | End of Calculation Period | |||
33 | EFF_INT_RATE_U | TRLT_FLOW | EFF_INT_RATE_U | TPM_TRL_EFF_INT_RATE_USED | For Calculation of Amortization Amts (SAC) for Used EffInR | |||
34 | EFF_INT_RATE_N | TRLT_FLOW | EFF_INT_RATE_N | TPM_TRL_EFF_INT_RATE_NEW | Valid Effective Interest Rate for the Next Amortization | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462_10 |