SAP ABAP Table TRLV_TRANS1 (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | TRLV_TRANS1 | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | OS_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
3 | BUSTRANSCAT | TPM_BUSTRANSCAT | TPM_BUSTRANSCAT | NUMC | 4 | 0 | Business Transaction Category | TRDTS_BT_CAT | |
4 | TRLDATE | TPM_TRLDATE | DATUM | DATS | 8 | 0 | Treasury Ledger Date | ||
5 | BUSTRANSID | TPM_BUSTRANSID | SYSUUID | RAW | 16 | 0 | Identifier of the Distributor Business Transaction | ||
6 | CREATE_DATE | TPM_BT_CREATE_DATE | DATUM | DATS | 8 | 0 | Creation Date of the Operative Business Transaction | ||
7 | CREATE_TIME | TPM_BT_CREATE_TIME | UZEIT | TIMS | 6 | 0 | Creation Time of the Operative Business Transaction | ||
8 | BUSTRANSSTATE | TPM_TRLTRANSTATE | TPM_TRANSACTION_STATE | CHAR | 1 | 0 | Status of Treasury Ledger Business Transaction | ||
9 | BOOKING_STATE | TPM_TRL_BOOKINGSTATE | TPM_TRL_BOOKINGSTATE | CHAR | 1 | 0 | Posting Status Treasury Ledger Business Transaction | ||
10 | VALUATION_AREA | TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | ||
11 | TR_ACC_CODE | TPM_ACC_CODE | TPM_ACC_CODE | CHAR | 4 | 0 | Accounting Code | ||
12 | REFBUSTRANSID | TPM_BUSTRANSID | SYSUUID | RAW | 16 | 0 | Identifier of the Distributor Business Transaction | ||
13 | USER_DATA_OID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | TRGT_USER_DATA | |
14 | USER_DATA_CLS | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
15 | TRLFLOWNUMBER | TPM_TRLFLOWNR | TPM_TRLFLOW_NR | INT4 | 10 | 0 | Number of TRL Flow | ||
16 | FLOWNUMBER | TPM_TRDFLOWNR | TPM_TRDFLOWNR | INT4 | 10 | 0 | Number of a Distributor Flow | ||
17 | SOURCETARGET_FLG | TPM_SOURCE_TARGET_FLG | TPM_SOURCE_TARGET_FLG | CHAR | 1 | 0 | Indicator: Source or Target of a Flow | ||
18 | TRANSFER_GROUP | TPM_TRANSFER_GROUP | TPM_SYSTEM_KEY | NUMC | 4 | 0 | Group of Flows from a Source or Target | ||
19 | FLOWTYPE | TPM_DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | CHAR | 8 | 0 | Update Type | ||
20 | AMOUNT_FACTOR | TPM_AMOUNT_FACTOR | TPM_AMOUNT_FACTOR | FLTP | 16 | 16 | Value Coefficient | ||
21 | QUANT_CAT | TPM_QTY_PM_CAT | TPM_QTY_PM_CAT | CHAR | 4 | 0 | Position Change Category: Quantity | ||
22 | AMOUNT_CAT | TPM_AMT_PM_CAT | TPM_PM_CAT | CHAR | 4 | 0 | Position Change Category | ||
23 | UNITS | TPM_UNITS | TPM_UNITS | DEC | 22 | 6 | Units | ||
24 | NOMINAL_AMT | TPM_NOMINAL_AMT | TPM_AMOUNT | CURR | 21 | 2 | Nominal Amount | ||
25 | NOMINAL_CURR | TPM_NOMINAL_CURR | WAERS | CUKY | 5 | 0 | Nominal Currency | ||
26 | POSAMT_IDX_CLEAN | TPM_POSITION_AMT_IDX_CLEAN | TPM_AMOUNT | CURR | 21 | 2 | Amount in Position Currency Index-Clean | ||
27 | POSITION_AMT | TPM_POSITION_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Position Currency | ||
28 | POSITION_CURR | TPM_POSITION_CURR | WAERS | CUKY | 5 | 0 | Position Currency | ||
29 | VALUATION_AMT | TPM_VALUATION_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Valuation Currency | ||
30 | VALUATION_CURR | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | ||
31 | POSITION_OID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | TRLT_POSITION | |
32 | PRODUCT_GROUP | TPM_PRODUCT_GROUP | TPM_PRODUCT_GROUP | NUMC | 3 | 0 | Product Group | ||
33 | FI_POST_DATE | TPM_FI_POSTING_DATE | DATUM | DATS | 8 | 0 | Different FI Posting Date | ||
34 | FI_POST_PERIOD | TPM_FI_POSTING_PERIOD | MONAT | NUMC | 2 | 0 | Different FI Posting Period | ||
35 | FI_REV_DATE | TPM_FI_REVERSAL_DATE | DATUM | DATS | 8 | 0 | Different FI Reversal Date | ||
36 | FI_REV_PERIOD | TPM_FI_REVERSAL_PERIOD | MONAT | NUMC | 2 | 0 | Alternative FI Reversal Period | ||
37 | MIGR_INIT_FLG | TPM_FLG_MIGR_INIT | TPM_FLG_MIGR_INIT | CHAR | 1 | 0 | Bus. Transaction Originated from Migration/Initialization | ||
38 | NOMINAL_ORG_AMT | TPM_NOMINAL_ORG_AMT | TPM_AMOUNT | CURR | 21 | 2 | Original Nominal Amount in Position Currency | ||
39 | CALCULATION_DATE | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
40 | CALC_DATE_INCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
41 | DUE_DATE | TPM_DUE_DATE | DATUM | DATS | 8 | 0 | Due Date | ||
42 | CALC_BEGIN | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
43 | CALC_END | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
44 | EFF_INT_RATE_U | TPM_TRL_EFF_INT_RATE_USED | DEC3_7 | DEC | 10 | 7 | For Calculation of Amortization Amts (SAC) for Used EffInR | ||
45 | EFF_INT_RATE_N | TPM_TRL_EFF_INT_RATE_NEW | DEC3_7 | DEC | 10 | 7 | Valid Effective Interest Rate for the Next Amortization |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TRLV_TRANS1 | BUSTRANSCAT | TRDTS_BT_CAT | BUSTRANSCAT | |||
2 | TRLV_TRANS1 | POSITION_OID | TRLT_POSITION | OS_GUID | |||
3 | TRLV_TRANS1 | USER_DATA_OID | TRGT_USER_DATA | OS_GUID |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |