SAP ABAP Table TRLV_TRANS_POS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure TRLV_TRANS_POS   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 REFBUSTRANSID TPM_BUSTRANSID SYSUUID RAW 16   0   Identifier of the Distributor Business Transaction  
11 FI_POST_DATE TPM_FI_POSTING_DATE DATUM DATS 8   0   Different FI Posting Date  
12 FI_POST_PERIOD TPM_FI_POSTING_PERIOD MONAT NUMC 2   0   Different FI Posting Period  
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 POS_MAN_PROC TPM_POS_MAN_PROC TPM_POS_MAN_PROC CHAR 4   0   Position Management Procedure  
32 ACTIVE_PASSIVE TPM_ACTIVE_PASSIVE TPM_ACTIVE_PASSIVE CHAR 1   0   Indicator: Assets/Liabilities Position  
33 SBILK SBILK SBILK CHAR 2   0   Balance Sheet Indicator  
34 SKWG14NEU VVSKWG14 VVSKWG14 CHAR 2   0   Position grouping acc. Para 14 GBA (Sec. and loans)  
35 VALUATION_AREA TPM_VAL_AREA TPM_VAL_AREA CHAR 3   0   Valuation Area TRGC_VAL_AREA
36 COM_VAL_CLASS TPM_COM_VAL_CLASS TPM_COM_VAL_CLASS NUMC 4   0   General Valuation Class TRGC_COM_VALCL
37 VALUATION_CLASS TPM_VAL_CLASS TPM_VAL_CLASS NUMC 4   0   Valuation Class TRGC_VAL_CLASS
38 ACCOUNTING_CODE TPM_ACC_CODE TPM_ACC_CODE CHAR 4   0   Accounting Code TRGC_TR_ACC_CODE
39 COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code T001
40 PRODUCT_TYPE VVSART VVSART CHAR 3   0   Product Type TZPA
41 SECURITY_ACCOUNT RLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
42 SECURITY_ID VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
43 PORTFOLIO TPM_PORTFOLIO_DIFF RPORTB CHAR 10   0   Portfolio as Differentiation Characteristic TWPOB
44 TRADER RDEALER RDEALER CHAR 12   0   Trader TZDEA
45 ACCOUNT_GROUP TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group TRGT_SECACCGRP
46 LOANS_CONTRACT RANL RANL CHAR 13   0   Contract Number VDARL
47 POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT TPM_POS_ACCOUNT_FUT CHAR 10   0   Futures Account for Listed Options and Futures TRFT_POS_ACCOUNT
48 FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT CHAR 1   0   Indicator: Long or Short Position  
49 LOT_ID TPM_LOT_ID SYSUUID RAW 16   0   Identifier of the Lot  
50 DEAL_NUMBER TB_RFHA T_RFHA CHAR 13   0   Financial Transaction VTBFHA
51 NOMINAL_ORG_AMT TPM_NOMINAL_ORG_AMT TPM_AMOUNT CURR 21   2   Original Nominal Amount in Position Currency  
52 CALCULATION_DATE DVALUT DATUM DATS 8   0   Calculation Date  
53 CALC_DATE_INCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
54 DUE_DATE TPM_DUE_DATE DATUM DATS 8   0   Due Date  
55 CALC_BEGIN DBERVON DATUM DATS 8   0   Start of Calculation Period  
56 CALC_END DBERBIS DATUM DATS 8   0   End of Calculation Period  
57 EFF_INT_RATE_U TPM_TRL_EFF_INT_RATE_USED DEC3_7 DEC 10   7   For Calculation of Amortization Amts (SAC) for Used EffInR  
58 EFF_INT_RATE_N TPM_TRL_EFF_INT_RATE_NEW DEC3_7 DEC 10   7   Valid Effective Interest Rate for the Next Amortization  
59 IDENTIFIER_OID TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR 32   0   Object Identity in Database Format DIFT_POS_IDENT
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TRLV_TRANS_POS ACCOUNTING_CODE TRGC_TR_ACC_CODE TR_ACC_CODE    
2 TRLV_TRANS_POS ACCOUNT_GROUP TRGT_SECACCGRP SEC_ACCT_GRP    
3 TRLV_TRANS_POS BUSTRANSCAT TRDTS_BT_CAT BUSTRANSCAT    
4 TRLV_TRANS_POS COMPANY_CODE T001 BUKRS    
5 TRLV_TRANS_POS COM_VAL_CLASS TRGC_COM_VALCL COM_VAL_CLASS    
6 TRLV_TRANS_POS DEAL_NUMBER VTBFHA RFHA KEY 1 CN
7 TRLV_TRANS_POS IDENTIFIER_OID DIFT_POS_IDENT OS_GUID    
8 TRLV_TRANS_POS LOANS_CONTRACT VDARL RANL    
9 TRLV_TRANS_POS PORTFOLIO TWPOB RPORTB    
10 TRLV_TRANS_POS POSITION_ACCOUNT TRFT_POS_ACCOUNT POS_ACCOUNT KEY 1 CN
11 TRLV_TRANS_POS PRODUCT_TYPE TZPA GSART    
12 TRLV_TRANS_POS SECURITY_ACCOUNT TWD01 RLDEPO    
13 TRLV_TRANS_POS SECURITY_ID VWPANLA RANL    
14 TRLV_TRANS_POS TRADER TZDEA RDEALER    
15 TRLV_TRANS_POS USER_DATA_OID TRGT_USER_DATA OS_GUID    
16 TRLV_TRANS_POS VALUATION_AREA TRGC_VAL_AREA VALUATION_AREA    
17 TRLV_TRANS_POS VALUATION_CLASS TRGC_VAL_CLASS VALUATION_CLASS    
History
Last changed by/on SAP  20130529 
SAP Release Created in