SAP ABAP View TRLV_TRANS1 (View of TR Ledger Business Transactions and Corresp. Flows)
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_TRANS1 | |
Short Description | View of TR Ledger Business Transactions and Corresp. Flows | |
Root table | TRLT_TRANSACTION | Treasury Ledger Business Transactions |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TRLT_TRANSACTION | TRLT_TRANSACTION | ||
2 | TRLT_FLOW |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | TRLT_TRANSACTION | MANDT | JL | EQ | 0 | 0 | ||||
2 | TRLT_FLOW | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | TRLT_TRANSACTION | OS_GUID | JL | EQ | 0 | 0 | ||||
4 | TRLT_FLOW | TRANSACTION_OID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TRLT_TRANSACTION | MANDT | MANDT | Client | |||
2 | OS_GUID | TRLT_TRANSACTION | OS_GUID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
3 | BUSTRANSCAT | TRLT_TRANSACTION | BUSTRANSCAT | TPM_BUSTRANSCAT | Business Transaction Category | |||
4 | TRLDATE | TRLT_TRANSACTION | TRLDATE | TPM_TRLDATE | Treasury Ledger Date | |||
5 | BUSTRANSID | TRLT_TRANSACTION | BUSTRANSID | TPM_BUSTRANSID | Identifier of the Distributor Business Transaction | |||
6 | CREATE_DATE | TRLT_TRANSACTION | CREATE_DATE | TPM_BT_CREATE_DATE | Creation Date of the Operative Business Transaction | |||
7 | CREATE_TIME | TRLT_TRANSACTION | CREATE_TIME | TPM_BT_CREATE_TIME | Creation Time of the Operative Business Transaction | |||
8 | BUSTRANSSTATE | TRLT_TRANSACTION | BUSTRANSSTATE | TPM_TRLTRANSTATE | Status of Treasury Ledger Business Transaction | |||
9 | BOOKING_STATE | TRLT_TRANSACTION | BOOKING_STATE | TPM_TRL_BOOKINGSTATE | Posting Status Treasury Ledger Business Transaction | |||
10 | VALUATION_AREA | TRLT_TRANSACTION | VALUATION_AREA | TPM_VAL_AREA | Valuation Area | |||
11 | TR_ACC_CODE | TRLT_TRANSACTION | TR_ACC_CODE | TPM_ACC_CODE | Accounting Code | |||
12 | REFBUSTRANSID | TRLT_TRANSACTION | REFBUSTRANSID | TPM_BUSTRANSID | Identifier of the Distributor Business Transaction | |||
13 | USER_DATA_OID | TRLT_TRANSACTION | USER_DATA_OID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
14 | USER_DATA_CLS | TRLT_TRANSACTION | USER_DATA_CLS | TPM_DB_OS_GUID | Object Identity in Database Format | |||
15 | TRLFLOWNUMBER | TRLT_FLOW | TRLFLOWNUMBER | TPM_TRLFLOWNR | Number of TRL Flow | |||
16 | FLOWNUMBER | TRLT_FLOW | FLOWNUMBER | TPM_TRDFLOWNR | Number of a Distributor Flow | |||
17 | SOURCETARGET_FLG | TRLT_FLOW | SOURCETARGET_FLG | TPM_SOURCE_TARGET_FLG | Indicator: Source or Target of a Flow | |||
18 | TRANSFER_GROUP | TRLT_FLOW | TRANSFER_GROUP | TPM_TRANSFER_GROUP | Group of Flows from a Source or Target | |||
19 | FLOWTYPE | TRLT_FLOW | FLOWTYPE | TPM_DIS_FLOWTYPE | Update Type | |||
20 | AMOUNT_FACTOR | TRLT_FLOW | AMOUNT_FACTOR | TPM_AMOUNT_FACTOR | Value Coefficient | |||
21 | QUANT_CAT | TRLT_FLOW | QUANT_CAT | TPM_QTY_PM_CAT | Position Change Category: Quantity | |||
22 | AMOUNT_CAT | TRLT_FLOW | AMOUNT_CAT | TPM_AMT_PM_CAT | Position Change Category | |||
23 | UNITS | TRLT_FLOW | UNITS | TPM_UNITS | Units | |||
24 | NOMINAL_AMT | TRLT_FLOW | NOMINAL_AMT | TPM_NOMINAL_AMT | Nominal Amount | |||
25 | NOMINAL_CURR | TRLT_FLOW | NOMINAL_CURR | TPM_NOMINAL_CURR | Nominal Currency | |||
26 | POSAMT_IDX_CLEAN | TRLT_FLOW | POSAMT_IDX_CLEAN | TPM_POSITION_AMT_IDX_CLEAN | Amount in Position Currency Index-Clean | |||
27 | POSITION_AMT | TRLT_FLOW | POSITION_AMT | TPM_POSITION_AMT | Amount in Position Currency | |||
28 | POSITION_CURR | TRLT_FLOW | POSITION_CURR | TPM_POSITION_CURR | Position Currency | |||
29 | VALUATION_AMT | TRLT_FLOW | VALUATION_AMT | TPM_VALUATION_AMT | Amount in Valuation Currency | |||
30 | VALUATION_CURR | TRLT_FLOW | VALUATION_CURR | TPM_VALUATION_CURR | Valuation Currency | |||
31 | POSITION_OID | TRLT_FLOW | POSITION_OID | TPM_DB_OS_GUID | Object Identity in Database Format | |||
32 | PRODUCT_GROUP | TRLT_TRANSACTION | PRODUCT_GROUP | TPM_PRODUCT_GROUP | Product Group | |||
33 | FI_POST_DATE | TRLT_TRANSACTION | FI_POST_DATE | TPM_FI_POSTING_DATE | Different FI Posting Date | |||
34 | FI_POST_PERIOD | TRLT_TRANSACTION | FI_POST_PERIOD | TPM_FI_POSTING_PERIOD | Different FI Posting Period | |||
35 | FI_REV_DATE | TRLT_TRANSACTION | FI_REV_DATE | TPM_FI_REVERSAL_DATE | Different FI Reversal Date | |||
36 | FI_REV_PERIOD | TRLT_TRANSACTION | FI_REV_PERIOD | TPM_FI_REVERSAL_PERIOD | Alternative FI Reversal Period | |||
37 | MIGR_INIT_FLG | TRLT_TRANSACTION | MIGR_INIT_FLG | TPM_FLG_MIGR_INIT | Bus. Transaction Originated from Migration/Initialization | |||
38 | NOMINAL_ORG_AMT | TRLT_FLOW | NOMINAL_ORG_AMT | TPM_NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | |||
39 | CALCULATION_DATE | TRLT_FLOW | CALCULATION_DATE | DVALUT | Calculation Date | |||
40 | CALC_DATE_INCL | TRLT_FLOW | CALC_DATE_INCL | VVSINCL | Inclusive indicator for beginning and end of a period | |||
41 | DUE_DATE | TRLT_FLOW | DUE_DATE | TPM_DUE_DATE | Due Date | |||
42 | CALC_BEGIN | TRLT_FLOW | CALC_BEGIN | DBERVON | Start of Calculation Period | |||
43 | CALC_END | TRLT_FLOW | CALC_END | DBERBIS | End of Calculation Period | |||
44 | 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 | |||
45 | 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 | 20110901 |
SAP Release Created in | 462_10 |