SAP ABAP View TRDV_TRANS_FLOW (Distributor: View of Business Transactions and Flows)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_DISTRIBUTOR (Package) CFM-TM: Distributor

Basic Data

View Type	D	Database View
Database View	TRDV_TRANS_FLOW
Short Description	Distributor: View of Business Transactions and Flows
Root table	TRDT_TRDBUSTRANS	Treasury: Persistent distributor business transaction

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRDT_TRDBUSTRANS	TRDT_TRDBUSTRANS
2	TRDT_FLOW
3	TRGT_USER_DATA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRDT_TRDBUSTRANS	MANDT	JL	EQ				0	0
2	TRDT_FLOW	MANDT	JR	EQ			AND	0	0
3	TRDT_TRDBUSTRANS	OS_GUID	JL	EQ				0	0
4	TRDT_FLOW	BUSTRANS_OS_GUID	JR	EQ			AND	0	0
5	TRGT_USER_DATA	MANDT	JL	EQ				0	0
6	TRDT_TRDBUSTRANS	MANDT	JR	EQ			AND	0	0
7	TRGT_USER_DATA	OS_GUID	JL	EQ				0	0
8	TRDT_TRDBUSTRANS	USER_DATA_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRDT_TRDBUSTRANS	MANDT		☐	MANDT	☐	Client
2	OS_GUID	TRDT_TRDBUSTRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	VERSION	TRDT_TRDBUSTRANS	VERSION		☐	TPM_TRDVERSION	☐	Distributor Version in Generation of Data
4	OWNER	TRDT_TRDBUSTRANS	OWNER		☐	TPM_BUSTRANS_OWNER	☐	Origin of a Distributor Business Transaction
5	COMPANY_CODE	TRDT_TRDBUSTRANS	COMPANY_CODE		☐	BUKRS	☐	Company Code
6	VALUATION_AREA	TRDT_TRDBUSTRANS	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
7	BUSTRANSID	TRDT_TRDBUSTRANS	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
8	EXTBUSTRANSID	TRDT_TRDBUSTRANS	EXTBUSTRANSID		☐	TPM_EXTBUSTRANSID	☐	Default ID from Creator for Distributor Business Transaction
9	BUSTRANSCAT	TRDT_TRDBUSTRANS	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
10	BUSTRANS_STATE	TRDT_TRDBUSTRANS	BUSTRANS_STATE		☐	TPM_BUSTRANS_STATE	☐	Status of Distributor Business Transaction
11	POSITION_DATE	TRDT_TRDBUSTRANS	POSITION_DATE		☐	TPM_POSTING_DATE	☐	Posting Date for the Subledger
12	USER_CREATE_DATE	TRDT_TRDBUSTRANS	CREATE_DATE		☐	TPM_BT_CREATE_DATE	☐	Creation Date of the Operative Business Transaction
13	USER_CREATE_TIME	TRDT_TRDBUSTRANS	CREATE_TIME		☐	TPM_BT_CREATE_TIME	☐	Creation Time of the Operative Business Transaction
14	REF_BUSTRANSID	TRDT_TRDBUSTRANS	REF_BUSTRANSID		☐	TPM_REFBUSTRANSID	☐	Business Transaction ID of Reference Business Transaction
15	TR_REV_REASON	TRDT_TRDBUSTRANS	TR_REV_REASON		☐	SSTOGRD	☐	Reason for Reversal
16	DOCUMENT_DATE	TRDT_TRDBUSTRANS	DOCUMENT_DATE		☐	BLDAT	☐	Document Date in Document
17	PRODUCT_CATEGORY	TRDT_TRDBUSTRANS	PRODUCT_CATEGORY		☐	SANLF	☐	Product Category
18	CREATE_NAME	TRGT_USER_DATA	CREATE_NAME		☐	RERF	☐	Entered by
19	CREATE_DATE	TRGT_USER_DATA	CREATE_DATE		☐	DERF	☐	First Entered on
20	CREATE_TIME	TRGT_USER_DATA	CREATE_TIME		☐	TERF	☐	Time of Initial Entry
21	CREATE_TCODE	TRGT_USER_DATA	CREATE_TCODE		☐	TCODE	☐	Transaction Code
22	CHANGE_NAME	TRGT_USER_DATA	CHANGE_NAME		☐	RBEAR	☐	Employee ID
23	CHANGE_DATE	TRGT_USER_DATA	CHANGE_DATE		☐	DBEAR	☐	Last Edited on
24	CHANGE_TIME	TRGT_USER_DATA	CHANGE_TIME		☐	TBEAR	☐	Last Edited at
25	CHANGE_TCODE	TRGT_USER_DATA	CHANGE_TCODE		☐	TCODE	☐	Transaction Code
26	FLOW_NUMBER	TRDT_FLOW	FLOW_NUMBER		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
27	DIS_FLOWTYPE	TRDT_FLOW	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
28	ALLOC_NMBR	TRDT_FLOW	ALLOC_NMBR		☐	DZUONR	☐	Assignment number
29	PRODUCT_TYPE	TRDT_FLOW	PRODUCT_TYPE		☐	VVSART	☐	Product Type
30	COM_VAL_CLASS	TRDT_FLOW	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
31	VALUATION_CLASS	TRDT_FLOW	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
32	SECURITY_ID	TRDT_FLOW	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
33	SECURITY_ACCOUNT	TRDT_FLOW	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
34	ACCOUNT_GROUP	TRDT_FLOW	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
35	PORTFOLIO	TRDT_FLOW	PORTFOLIO		☐	RPORTB	☐	Portfolio
36	TRADER	TRDT_FLOW	TRADER		☐	RDEALER	☐	Trader
37	LOANS_CONTRACT	TRDT_FLOW	LOANS_CONTRACT		☐	RANL	☐	Contract Number
38	POSITION_ACCOUNT	TRDT_FLOW	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
39	FLAG_LONG_SHORT	TRDT_FLOW	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
40	UNITS	TRDT_FLOW	UNITS		☐	TPM_UNITS	☐	Units
41	NOMINAL_CURR	TRDT_FLOW	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
42	NOMINAL_AMT	TRDT_FLOW	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
43	POSITION_CURR	TRDT_FLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
44	POSITION_AMT	TRDT_FLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
45	POSAMT_IDX_CLEAN	TRDT_FLOW	POSAMT_IDX_CLEAN		☐	TPM_POSITION_AMT_IDX_CLEAN	☐	Amount in Position Currency Index-Clean
46	LOCAL_CURR	TRDT_FLOW	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
47	LOCAL_AMT	TRDT_FLOW	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
48	VALUATION_CURR	TRDT_FLOW	VALUATION_CURR		☐	TPM_VALUATION_CURR	☐	Valuation Currency
49	VALUATION_AMT	TRDT_FLOW	VALUATION_AMT		☐	TPM_VALUATION_AMT	☐	Amount in Valuation Currency
50	TRL_POS_MAN_CAT	TRDT_FLOW	TRL_POS_MAN_CAT		☐	TPM_AMT_PM_CAT	☐	Position Change Category
51	SOURCETARGET_FLG	TRDT_FLOW	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
52	TRANSFER_GROUP	TRDT_FLOW	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
53	LOT_CREATION	TRDT_FLOW	LOT_CREATION		☐	TPM_LOT_CREATION	☐	Lot Creation Category
54	PAYMENT_CURR	TRDT_FLOW	PAYMENT_CURR		☐	TPM_PAYMENT_CURR	☐	Payment Currency
55	PAYMENT_AMT	TRDT_FLOW	PAYMENT_AMT		☐	TPM_PAYMENT_AMT	☐	Amount in Payment Currency
56	SIGN	TRDT_FLOW	SIGN		☐	TB_SSIGN	☐	Direction of flow
57	HOUSE_BANK	TRDT_FLOW	HOUSE_BANK		☐	TB_RHABKI	☐	Short key for own house bank
58	HOUSE_BANK_ACC	TRDT_FLOW	HOUSE_BANK_ACC		☐	TB_RHKTID	☐	Short key for house bank account
59	PAYMENT_DATE	TRDT_FLOW	PAYMENT_DATE		☐	TPM_PAYMENT_DATE	☐	Payment Date
60	CALCULATION_DATE	TRDT_FLOW	CALCULATION_DATE		☐	DVALUT	☐	Calculation Date
61	CALC_DATE_INCL	TRDT_FLOW	CALC_DATE_INCL		☐	VVSINCL	☐	Inclusive indicator for beginning and end of a period
62	COUPON_DATE	TRDT_FLOW	COUPON_DATE		☐	TPM_COUPON_DATE	☐	Date of the Next Coupon
63	COUPON_SIGN	TRDT_FLOW	COUPON_SIGN		☐	TPM_COUPON_SIGN	☐	Coupon ID for Interest and Accrued Interest Calculation
64	CALC_BEGIN	TRDT_FLOW	CALC_BEGIN		☐	DBERVON	☐	Start of Calculation Period
65	CALC_END	TRDT_FLOW	CALC_END		☐	DBERBIS	☐	End of Calculation Period
66	TRANSACTION_TYPE	TRDT_FLOW	TRANSACTION_TYPE		☐	TB_SFHAART	☐	Financial Transaction Type
67	LOT_ID	TRDT_FLOW	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
68	QUANT_CAT	TRDT_FLOW	QUANT_CAT		☐	TPM_QTY_PM_CAT	☐	Position Change Category: Quantity
69	AMOUNT_FACTOR	TRDT_FLOW	AMOUNT_FACTOR		☐	TPM_AMOUNT_FACTOR	☐	Value Coefficient
70	FIXED_AA_REF	TRDT_FLOW	FIXED_AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
71	DUE_DATE	TRDT_FLOW	DUE_DATE		☐	TPM_DUE_DATE	☐	Due Date
72	RPBANK	TRDT_FLOW	RPBANK		☐	TB_RPBANK	☐	Partner bank details
73	RPZAHL	TRDT_FLOW	RPZAHL		☐	TB_RPZAHL_NEW	☐	Payer/payee
74	SZART	TRDT_FLOW	SZART		☐	TB_SZART	☐	Payment transaction
75	ZLSCH	TRDT_FLOW	ZLSCH		☐	DZLSCH	☐	Payment method
76	UZAWE	TRDT_FLOW	UZAWE		☐	UZAWE	☐	Payment method supplement
77	SPAYRQ	TRDT_FLOW	SPAYRQ		☐	TB_SPAYRQ	☐	Payment request allowed
78	SPRSNG	TRDT_FLOW	SPRSNG		☐	TB_SPRSNG	☐	Individual payment required
79	SPRGRD	TRDT_FLOW	SPRGRD		☐	TB_SPRGRD	☐	Determine grouping definition
80	SCSPAY	TRDT_FLOW	SCSPAY		☐	TB_SCSPAY	☐	Same direction necessary for joint payment?
81	ZWELS	TRDT_FLOW	ZWELS		☐	DZWELS	☐	List of the Payment Methods to be Considered
82	PAYGR	TRDT_FLOW	PAYGR		☐	PAYGR	☐	Grouping Field for Automatic Payments
83	PLANNED_ACTION	TRDT_TRDBUSTRANS	PLANNED_ACTION		☐	TPM_PLANNED_ACTION	☐	Planned Action in a Business Transaction
84	FI_POST_DATE	TRDT_TRDBUSTRANS	FI_POST_DATE		☐	TPM_FI_POSTING_DATE	☐	Different FI Posting Date
85	FI_POST_PERIOD	TRDT_TRDBUSTRANS	FI_POST_PERIOD		☐	TPM_FI_POSTING_PERIOD	☐	Different FI Posting Period
86	DEAL_NUMBER	TRDT_TRDBUSTRANS	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
87	PRODUCT_GROUP	TRDT_TRDBUSTRANS	PRODUCT_GROUP		☐	TPM_PRODUCT_GROUP	☐	Product Group
88	FI_REV_DATE	TRDT_TRDBUSTRANS	FI_REV_DATE		☐	TPM_FI_REVERSAL_DATE	☐	Different FI Reversal Date
89	FI_REV_PERIOD	TRDT_TRDBUSTRANS	FI_REV_PERIOD		☐	TPM_FI_REVERSAL_PERIOD	☐	Alternative FI Reversal Period
90	NOMINAL_ORG_AMT	TRDT_FLOW	NOMINAL_ORG_AMT		☐	TPM_NOMINAL_ORG_AMT	☐	Original Nominal Amount in Position Currency
91	ACTIVE_PASSIVE	TRDT_FLOW	ACTIVE_PASSIVE		☐	TPM_ACTIVE_PASSIVE	☐	Indicator: Assets/Liabilities Position
92	EFF_INT_RATE_U	TRDT_FLOW	EFF_INT_RATE_U		☐	TPM_TRL_EFF_INT_RATE_USED	☐	For Calculation of Amortization Amts (SAC) for Used EffInR
93	EFF_INT_RATE_N	TRDT_FLOW	EFF_INT_RATE_N		☐	TPM_TRL_EFF_INT_RATE_NEW	☐	Valid Effective Interest Rate for the Next Amortization
94	LANDL	TRDT_FLOW	LANDL		☐	LANDL	☐	Supplying Country
95	LZBKZ	TRDT_FLOW	LZBKZ		☐	LZBKZ	☐	State central bank indicator
96	RPCODE	TRDT_FLOW	RPCODE		☐	RPCODE	☐	Repetitive Code
97	RP_TEXT	TRDT_FLOW	RP_TEXT		☐	RPCODE_TEXT	☐	Reference Text for Repetitive Code
98	RFHAZU	TRDT_FLOW	RFHAZU		☐	TB_RFHAZU	☐	Transaction activity
99	NORDEXT	TRDT_FLOW	NORDEXT		☐	TB_NORDEXT	☐	External Reference
100	SFGZUSTT	TRDT_FLOW	SFGZUSTT		☐	TB_SFGZUTY	☐	Transaction Activity Category

Maintenance Status

Access

☑   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