SAP ABAP Table TRLS_FLOW_ALV (Structure for Output of Flows in SAP List Viewer)
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
Basic Data
Table Category INTTAB    Structure 
Structure TRLS_FLOW_ALV   Table Relationship Diagram
Short Description Structure for Output of Flows in SAP List Viewer    
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 .INCLUDE       0   0   Structure for Differentiation Values  
2 VALUATION_AREA TPM_VAL_AREA TPM_VAL_AREA CHAR 3   0   Valuation Area TRGC_VAL_AREA
3 COM_VAL_CLASS TPM_COM_VAL_CLASS TPM_COM_VAL_CLASS NUMC 4   0   General Valuation Class TRGC_COM_VALCL
4 VALUATION_CLASS TPM_VAL_CLASS TPM_VAL_CLASS NUMC 4   0   Valuation Class TRGC_VAL_CLASS
5 ACCOUNTING_CODE TPM_ACC_CODE TPM_ACC_CODE CHAR 4   0   Accounting Code TRGC_TR_ACC_CODE
6 COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code T001
7 PRODUCT_TYPE VVSART VVSART CHAR 3   0   Product Type TZPA
8 SECURITY_ACCOUNT RLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
9 SECURITY_ID VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
10 PORTFOLIO TPM_PORTFOLIO_DIFF RPORTB CHAR 10   0   Portfolio as Differentiation Characteristic TWPOB
11 TRADER RDEALER RDEALER CHAR 12   0   Trader TZDEA
12 ACCOUNT_GROUP TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group TRGT_SECACCGRP
13 LOANS_CONTRACT RANL RANL CHAR 13   0   Contract Number VDARL
14 POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT TPM_POS_ACCOUNT_FUT CHAR 10   0   Futures Account for Listed Options and Futures *
15 FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT CHAR 1   0   Indicator: Long or Short Position  
16 LOT_ID TPM_LOT_ID_EXT TPM_DB_OS_GUID CHAR 32   0   Lot-ID for External Display  
17 DEAL_NUMBER TB_RFHA T_RFHA CHAR 13   0   Financial Transaction VTBFHA
18 PORTFOLIO_TM RPORTB RPORTB CHAR 10   0   Portfolio *
19 PORTFOLIO_TM_T VVXPORTB TEXT30 CHAR 30   0   Portfolio name  
20 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
21 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
22 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
23 ACTIVE_PASSIVE TPM_ACTIVE_PASSIVE_2 TPM_ACTIVE_PASSIVE_2 CHAR 1   0   Assets/Liabilities Position (without Conversion Routine)  
24 ACTIVE_PASSIVE_T TPM_ACTIVE_PASSIVE_T TEXT20 CHAR 20   0   Assets/Liabilities Position  
25 .INCLUDE       0   0   Include Structure Treasury Ledger Flows  
26 FLOWNUMBER TPM_TRDFLOWNR TPM_TRDFLOWNR INT4 10   0   Number of a Distributor Flow  
27 SOURCETARGET_FLG TPM_SOURCE_TARGET_FLG TPM_SOURCE_TARGET_FLG CHAR 1   0   Indicator: Source or Target of a Flow  
28 TRANSFER_GROUP TPM_TRANSFER_GROUP TPM_SYSTEM_KEY NUMC 4   0   Group of Flows from a Source or Target  
29 FLOWTYPE TPM_DIS_FLOWTYPE TPM_DIS_FLOWTYPE CHAR 8   0   Update Type *
30 AMOUNT_FACTOR TPM_AMOUNT_FACTOR TPM_AMOUNT_FACTOR FLTP 16   16   Value Coefficient  
31 QUANT_CAT TPM_QTY_PM_CAT TPM_QTY_PM_CAT CHAR 4   0   Position Change Category: Quantity  
32 AMOUNT_CAT TPM_AMT_PM_CAT TPM_PM_CAT CHAR 4   0   Position Change Category *
33 UNITS TPM_UNITS TPM_UNITS DEC 22   6   Units  
34 NOMINAL_AMT TPM_NOMINAL_AMT TPM_AMOUNT CURR 21   2   Nominal Amount  
35 NOMINAL_ORG_AMT TPM_NOMINAL_ORG_AMT TPM_AMOUNT CURR 21   2   Original Nominal Amount in Position Currency  
36 NOMINAL_CURR TPM_NOMINAL_CURR WAERS CUKY 5   0   Nominal Currency *
37 POSAMT_IDX_CLEAN TPM_POSITION_AMT_IDX_CLEAN TPM_AMOUNT CURR 21   2   Amount in Position Currency Index-Clean  
38 POSITION_AMT TPM_POSITION_AMT TPM_AMOUNT CURR 21   2   Amount in Position Currency  
39 POSITION_CURR TPM_POSITION_CURR WAERS CUKY 5   0   Position Currency *
40 VALUATION_AMT TPM_VALUATION_AMT TPM_AMOUNT CURR 21   2   Amount in Valuation Currency  
41 VALUATION_CURR TPM_VALUATION_CURR WAERS CUKY 5   0   Valuation Currency *
42 CALCULATION_DATE DVALUT DATUM DATS 8   0   Calculation Date  
43 CALC_DATE_INCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
44 DUE_DATE TPM_DUE_DATE DATUM DATS 8   0   Due Date  
45 CALC_BEGIN DBERVON DATUM DATS 8   0   Start of Calculation Period  
46 CALC_END DBERBIS DATUM DATS 8   0   End of Calculation Period  
47 EFF_INT_RATE_U TPM_TRL_EFF_INT_RATE_USED DEC3_7 DEC 10   7   For Calculation of Amortization Amts (SAC) for Used EffInR  
48 SCHED_EFF_RATE RDPT_SCHEDULE_KEY_EFF_RATE   INT4 10   0   Key for Redemption Schedule that Explains Effect. Int. Rate  
49 EFF_INT_RATE_N TPM_TRL_EFF_INT_RATE_NEW DEC3_7 DEC 10   7   Valid Effective Interest Rate for the Next Amortization  
50 SCHED_FIX RDPT_SCHEDULE_KEY_FIX   INT4 10   0   Key for Fixed Redemption Schedule  
51 .INCLUDE       0   0   Posting Data for Flow Display  
52 GL_ACCOUNT_D SAKNR SAKNR CHAR 10   0   G/L Account Number *
53 GL_ACCOUNT_C SAKNR SAKNR CHAR 10   0   G/L Account Number *
54 KUNNR_D KUNNR KUNNR CHAR 10   0   Customer Number *
55 KUNNR_C KUNNR KUNNR CHAR 10   0   Customer Number *
56 GL_POS_ACCOUNT SAKNR SAKNR CHAR 10   0   G/L Account Number *
57 FISCAL_YEAR GJAHR GJAHR NUMC 4   0   Fiscal Year  
58 POSTING_PERIOD MONAT MONAT NUMC 2   0   Fiscal period  
59 POSTING_DATE BUDAT DATUM DATS 8   0   Posting Date in the Document  
60 ACC_ASS_REF TPM_AA_REF TPM_AA_REF CHAR 12   0   Account Assignment Reference of Position Management *
61 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
62 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
63 REVERSAL_YEAR GJAHR GJAHR NUMC 4   0   Fiscal Year  
64 REVERSAL_PERIOD MONAT MONAT NUMC 2   0   Fiscal period  
65 REVERSAL_DATE BUDAT DATUM DATS 8   0   Posting Date in the Document  
66 REVERSAL_AWKEY REVERSAL_AWKEY AWKEY CHAR 20   0   Reversal Reference Key  
67 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
68 BELNR2 BELNR_D BELNR CHAR 10   0   Accounting Document Number  
69 REVERSAL_BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
70 REVERSAL_BELNR2 BELNR_D BELNR CHAR 10   0   Accounting Document Number  
71 .INCLUDE       0   0   Include Structure for Condition Data for Cash Flow Display  
72 FLOWCAT_TRS TPM_FLOWCAT_TRS TPM_FLOWCAT_TRS CHAR 3   0   Flow Category for Securities Account Management *
73 COUPON_DATE TPM_COUPON_DATE DATUM DATS 8   0   Date of the Next Coupon  
74 COUPON_SIGN TPM_COUPON_SIGN VVSCOUPON CHAR 1   0   Coupon ID for Interest and Accrued Interest Calculation  
75 RAHABKI TB_RHABKI HBKID CHAR 5   0   Short key for own house bank *
76 RAHKTID TB_RHKTID HKTID CHAR 5   0   Short key for house bank account *
77 SBERFIMA SBEWFIMA SBEWFIMA CHAR 4   0   Calculation category for cash flow calculator AT40
78 PAYMENT_DATE TPM_PAYMENT_DATE TPM_POSITION_DATE DATS 8   0   Payment Date  
79 DFAELL DFAELL DATUM DATS 8   0   Due date  
80 SWOHER SWOHER CHAR1 CHAR 1   0   Source of flow record  
81 SEXCLVON VVSEXCLVON VVSEXCLVON NUMC 1   0   Exclusive Indicator for the Start of a Calculation Period  
82 SULTVON VVSULTVON VVSULT CHAR 1   0   Month-End Indicator for Start of a Calculation Period  
83 SINCLBIS VVSINCLBIS VVSINCLBIS NUMC 1   0   Inclusive Indicator for the End of a Calculation Period  
84 SULTBIS VVSULTBIS VVSULT CHAR 1   0   Month-End Indicator for the End of a Calculation Period  
85 SVULT VVSVULT VVSULT CHAR 1   0   Month-End Indicator for Value Date  
86 SFULT SFULT VVSULT CHAR 1   0   Month-End Indicator for Due Date  
87 ATAGE TFMATAGE INT4 INT4 10   0   Number of Days  
88 APERTAGE VVAPERTAGE INT6 NUMC 6   0   No. of days of a (calculation) period in cash flow  
89 STGBASIS VVSTGBASIS VVSTGBASIS CHAR 1   0   Base Days Method  
90 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
91 SPAEXCL TFMSPAEXCL TFMSPAEXCL NUMC 1   0   Exclusive Indicator for Start Date of a Period  
92 SPAULT TFMSPAULT VVSULT CHAR 1   0   Month-End Indicator for Start Date of a Period  
93 SPEINCL TFMSPEINCL TFMSPEINCL NUMC 1   0   Inclusive Indicator for End Date of a Period  
94 SPEULT TFMSPEULT VVSULT CHAR 1   0   Month-End Indicator for End of a Period  
95 SSTCKKZ SSTCKKZ SSTCKKZ CHAR 1   0   Accrued interest method  
96 SSTCKTG SSTCKTG SZBMETH CHAR 1   0   Accrued interest: Daily method  
97 SFLAT VVSFLAT XFELD CHAR 1   0   Indicator 'Traded flat',i.e.no accrued interest calculation  
98 SKOART SKOART SKOART NUMC 4   0   Condition Type (Smallest Subdivision of Condition Records) *
99 SKALIDWT TFMSKALIDWT WFCID CHAR 2   0   Interest Calendar *
100 DGUEL_KP DGUEL_KP DATUM DATS 8   0   Condition Item Valid From  
101 .INCLUDE       0   0   Include Structure TRD Fields for Cash Flow Display  
102 EXTBUSTRANSID TPM_EXTBUSTRANSID TPM_EXTBUSTRANSID CHAR 60   0   Default ID from Creator for Distributor Business Transaction  
103 .INCLUDE       0   0   Lot Attribute Values  
104 DLOTGENERATION DLOTGENERATION DATUM DATS 8   0   Date On Which Lot Was Generated  
105 TLOTGENERATION TLOTGENERATION UZEIT TIMS 6   0   Lot Generation Time  
106 LOTGENERATION_USER FTI_LOTGENERATIONUSER SYCHAR12 CHAR 12   0   Lot Entered By  
107 LOTGENERATION_BUSTRANSCAT FTI_LOTGENERATION_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category Which Generated the Lot *
108 LOTPOSITION_INIT_DATE FTI_LOTPOSITION_INIT_DATE TPM_POSITION_DATE DATS 8   0   Position Acquisition Date of a Lot  
109 LOTPOSITION_ORG_DATE FTI_LOTPOSITION_ORG_DATE TPM_POSITION_DATE DATS 8   0   Original Position Acquisition Date of a Lot  
110 LOTGENERATION_BUKRS FTI_LOTGENERATION_BUKRS BUKRS CHAR 4   0   Company Code of Lot-Generating Transaction *
111 LOTGENERATION_DEALNR FTI_LOTGENERATION_DEALNR T_RFHA CHAR 13   0   Lot-Generating Transaction Number *
112 DOCUMENTID TPM_TRDDOCID SYSUUID RAW 16   0   Distributor Document ID  
113 TRLDATE TPM_TRLDATE DATUM DATS 8   0   Treasury Ledger Date  
114 BOOKING_STATE TPM_TRL_BOOKINGSTATE TPM_TRL_BOOKINGSTATE CHAR 1   0   Posting Status Treasury Ledger Business Transaction  
115 FI_POST_DATE TPM_FI_POSTING_DATE DATUM DATS 8   0   Different FI Posting Date  
116 FI_POST_PERIOD TPM_FI_POSTING_PERIOD MONAT NUMC 2   0   Different FI Posting Period  
117 FI_REV_DATE TPM_FI_REVERSAL_DATE DATUM DATS 8   0   Different FI Reversal Date  
118 FI_REV_PERIOD TPM_FI_REVERSAL_PERIOD MONAT NUMC 2   0   Alternative FI Reversal Period  
119 QUANT_CAT_T TPM_QTY_PM_CAT_NAME TPM_DESCRIPTION CHAR 60   0   Position Change Category: Quantity (Text)  
120 AMOUNT_CAT_T TPM_AMT_PM_CAT_NAME TPM_DESCRIPTION CHAR 60   0   Position Change Category (long name)  
121 BUSTRANSCAT TPM_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category *
122 BUSTRANSCAT_T TPM_BUSTRANSCAT_TEXT TPM_DESCRIPTION CHAR 60   0   Name of Business Transaction Category  
123 MIGR_INIT_FLG TPM_FLG_MIGR_INIT TPM_FLG_MIGR_INIT CHAR 1   0   Bus. Transaction Originated from Migration/Initialization  
124 FLOWTYPE_T TPM_DFT_TEXT TPM_DESCRIPTION CHAR 60   0   Update Type Text  
125 ACCOUNTING_CODE_T TPM_TR_ACC_CODE_NAME TPM_DESCRIPTION CHAR 60   0   Name of Accounting Code  
126 COMPANY_CODE_T BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
127 VALUATION_AREA_T TPM_VAL_AREA_NAME TPM_DESCRIPTION CHAR 60   0   Name of the Valuation Area  
128 VALUATION_CLASS_T TPM_VAL_CLASS_NAME TPM_DESCRIPTION CHAR 60   0   Description of valuation class  
129 PRODUCT_TYPE_T TEXT10 TEXT10 CHAR 10   0   Text (10 Characters)  
130 SECURITY_ID_T XALKZ XKBEZ CHAR 15   0   Short name  
131 SECURITY_ID_TL XALLB XLBEZ CHAR 60   0   Long name  
132 SECURITY_ACCOUNT_T XLDEPO XLDEPO CHAR 30   0   Securities account ID  
133 ACCOUNT_GRP_T TPM_SEC_ACCT_GRP_NAME TPM_DESCRIPTION CHAR 60   0   Name of Securities Account Group  
134 PORTFOLIO_T VVXPORTB TEXT30 CHAR 30   0   Portfolio name  
135 POSITION_ACCOUNT_T TPM_POS_ACC_FUT_TEXT TPM_POS_ACC_FUT_TEXT CHAR 30   0   Futures Account Text  
136 TRANS_NUMBER TPM_TRANS_NR DEC6 DEC 6   0   Business Transaction Number  
137 TRLFLOWNUMBER TPM_TRLFLOWNR TPM_TRLFLOW_NR INT4 10   0   Number of TRL Flow  
138 BUSTRANSID TPM_BUSTRANSID SYSUUID RAW 16   0   Identifier of the Distributor Business Transaction  
139 BUSTRANSSTATE TPM_TRLTRANSTATE TPM_TRANSACTION_STATE CHAR 1   0   Status of Treasury Ledger Business Transaction  
140 REFBUSTRANSID TPM_REFBUSTRANSID SYSUUID RAW 16   0   Business Transaction ID of Reference Business Transaction  
141 TRANSACTION_TYPE TB_SFHAART T_SFHAART CHAR 3   0   Financial Transaction Type *
142 DEAL_NUMBER_TM TB_RFHA T_RFHA CHAR 13   0   Financial Transaction *
143 SCHED_EFF_RATE_NAME RDPT_SCHEDULE_NAME   CHAR 15   0   Redemption Schedule  
144 SCHED_FIX_NAME RDPT_SCHEDULE_NAME   CHAR 15   0   Redemption Schedule  
145 SCHED_EFF_RATE_T RDPT_SCHEDULE_TEXT XLBEZ CHAR 60   0   Long Text for Redemption Schedule  
146 SCHED_FIX_T RDPT_SCHEDULE_TEXT XLBEZ CHAR 60   0   Long Text for Redemption Schedule  
147 COLOR CHAR3 CHAR3 CHAR 3   0   3-Byte field  
148 TRANSACTION_OID TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR 32   0   Object Identity in Database Format  
149 POSITION_OID TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR 32   0   Object Identity in Database Format  
150 FIXINGSUM_OID TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR 32   0   Object Identity in Database Format  
151 USER_DATA_OID TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR 32   0   Object Identity in Database Format  
152 .INCLUDE       0   0   Include Structure for ALV Display of User Data  
153 CREATE_NAME RERF SYCHAR12 CHAR 12   0   Entered by  
154 CREATE_DATE DERF DATUM DATS 8   0   First Entered on  
155 CREATE_TIME TERF TIMES TIMS 6   0   Time of Initial Entry  
156 CREATE_TCODE TCODE TCODE CHAR 20   0   Transaction Code *
157 CHANGE_NAME RBEAR SYCHAR12 CHAR 12   0   Employee ID  
158 CHANGE_DATE DBEAR DATUM DATS 8   0   Last Edited on  
159 CHANGE_TIME TBEAR TIMES TIMS 6   0   Last Edited at  
160 CHANGE_TCODE TCODE TCODE CHAR 20   0   Transaction Code *
161 .INCLUDE       0   0   Comprehensive Cash Flow: Data from Payment Partner  
162 PRQ_KEYNO PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
163 PAYMENT_AWKEY TPM_PAYMENT_AWKEY AWKEY CHAR 20   0   Payment Reference Key  
164 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
165 SPRGRD TB_SPRGRD T_SPRGRD CHAR 1   0   Determine grouping definition  
166 RELEASE_STATE TPM_TRPR_RELSTATE TPM_TRPR_RELSTATE CHAR 1   0   Release Status for Payment Requests  
167 RPCODE RPCODE RPCODE CHAR 20   0   Repetitive Code *
168 RP_TEXT RPCODE_TEXT XTEXT50 CHAR 50   0   Reference Text for Repetitive Code  
169 SWIFT_TEXT PRQ_SWTXT PRQ_SWTXT CHAR 140   0   Swift Text  
170 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
171 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TRLS_FLOW_ALV ACCOUNTING_CODE TRGC_TR_ACC_CODE TR_ACC_CODE REF 1 CN
2 TRLS_FLOW_ALV ACCOUNT_GROUP TRGT_SECACCGRP SEC_ACCT_GRP REF 1 CN
3 TRLS_FLOW_ALV COMPANY_CODE T001 BUKRS REF 1 CN
4 TRLS_FLOW_ALV COM_VAL_CLASS TRGC_COM_VALCL COM_VAL_CLASS REF 1 CN
5 TRLS_FLOW_ALV DEAL_NUMBER VTBFHA RFHA REF 1 CN
6 TRLS_FLOW_ALV LOANS_CONTRACT VDARL RANL REF 1 CN
7 TRLS_FLOW_ALV PORTFOLIO TWPOB RPORTB REF 1 CN
8 TRLS_FLOW_ALV PRODUCT_TYPE TZPA GSART REF 1 CN
9 TRLS_FLOW_ALV SBERFIMA AT40 SBERFIMA    
10 TRLS_FLOW_ALV SECURITY_ACCOUNT TWD01 RLDEPO REF 1 CN
11 TRLS_FLOW_ALV SECURITY_ID VWPANLA RANL REF 1 CN
12 TRLS_FLOW_ALV TRADER TZDEA RDEALER REF 1 CN
13 TRLS_FLOW_ALV VALUATION_AREA TRGC_VAL_AREA VALUATION_AREA REF 1 CN
14 TRLS_FLOW_ALV VALUATION_CLASS TRGC_VAL_CLASS VALUATION_CLASS REF 1 CN
History
Last changed by/on SAP  20141121 
SAP Release Created in