SAP ABAP View TRQV_ASSIGN (View for Assignment Rule)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_QUANTITY_LEDGER (Package) Treasury: Quantity Ledger

Basic Data

View Type	D	Database View
Database View	TRQV_ASSIGN
Short Description	View for Assignment Rule
Root table	TRQT_ASSIGNMENT	Treasury: Assignment Rule

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRQT_ASSIGNMENT	TRQT_ASSIGNMENT
2	TRQT_FLOWGROUP
3	TRQT_ASSIGN_ITEM
4	TRQT_BUSTRANS
5	TRDT_TRDBUSTRANS
6	TRQT_POSITION
7	DIFT_POS_IDENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRQT_FLOWGROUP	MANDT	JL	EQ				0	0
2	TRQT_ASSIGNMENT	MANDT	JR	EQ			AND	0	0
3	TRQT_FLOWGROUP	OS_GUID	JL	EQ				0	0
4	TRQT_ASSIGNMENT	FLOWGROUP_OID	JR	EQ			AND	0	0
5	TRQT_ASSIGNMENT	MANDT	JL	EQ				0	0
6	TRQT_ASSIGN_ITEM	MANDT	JR	EQ			AND	0	0
7	TRQT_ASSIGNMENT	OS_GUID	JL	EQ				0	0
8	TRQT_ASSIGN_ITEM	RULE_GUID	JR	EQ			AND	0	0
9	TRQT_BUSTRANS	MANDT	JL	EQ				0	0
10	TRQT_FLOWGROUP	MANDT	JR	EQ			AND	0	0
11	TRQT_BUSTRANS	OS_GUID	JL	EQ				0	0
12	TRQT_FLOWGROUP	BUSTRANS_OID	JR	EQ			AND	0	0
13	TRQT_BUSTRANS	MANDT	JL	EQ				0	0
14	TRDT_TRDBUSTRANS	MANDT	JR	EQ			AND	0	0
15	TRQT_BUSTRANS	BUSTRANSID	JL	EQ				0	0
16	TRDT_TRDBUSTRANS	BUSTRANSID	JR	EQ			AND	0	0
17	TRQT_FLOWGROUP	MANDT	JL	EQ				0	0
18	TRQT_POSITION	MANDT	JR	EQ			AND	0	0
19	TRQT_FLOWGROUP	POSITION_OID	JL	EQ				0	0
20	TRQT_POSITION	OS_GUID	JR	EQ			AND	0	0
21	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
22	TRQT_POSITION	MANDT	JR	EQ			AND	0	0
23	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
24	TRQT_POSITION	SELECTOR_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT_RULE	TRQT_ASSIGNMENT	MANDT		☐	MANDT	☐	Client
2	COMPANY_CODE	TRDT_TRDBUSTRANS	COMPANY_CODE		☐	BUKRS	☐	Company Code
3	BUSTRANSID	TRDT_TRDBUSTRANS	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
4	EXTBUSTRANSID	TRDT_TRDBUSTRANS	EXTBUSTRANSID		☐	TPM_EXTBUSTRANSID	☐	Default ID from Creator for Distributor Business Transaction
5	DEAL_NUMBER	TRDT_TRDBUSTRANS	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
6	MANDT	TRQT_ASSIGN_ITEM	MANDT		☐	MANDT	☐	Client
7	LOT_ID	TRQT_ASSIGN_ITEM	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
8	CONTRIBUTION	TRQT_ASSIGN_ITEM	CONTRIBUTION		☐	TPM_CONTRIBUTION	☐	Distribution Key for Lot Assignment
9	TRANSFER_GROUP	TRQT_ASSIGN_ITEM	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
10	LOT_ID_REF	TRQT_ASSIGN_ITEM	LOT_ID_REF		☐	TPM_LOT_ID	☐	Identifier of the Lot
11	FLOWGROUP_GUID	TRQT_FLOWGROUP	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
12	ASSIGNMENT_GUID	TRQT_ASSIGNMENT	OS_GUID		☐	TPM_ASSIGNMENT	☐	Allocation rule
13	ITEM_GUID	TRQT_ASSIGN_ITEM	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
14	BUSTRANS_GUID	TRQT_BUSTRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	BUSTRANSCAT	TRQT_BUSTRANS	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
16	POSITION_GUID	TRQT_POSITION	OS_GUID		☐	TPM_QUANTITIY_POSITION	☐	Quantity Position
17	SELECTOR_GUID	DIFT_POS_IDENT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
18	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
19	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
20	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
21	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
22	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
23	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
24	CONSUMPTION_CAT	TRQT_POSITION	CONSUMPTION_CAT		☐	TPM_CONSUMPTION_CAT	☐	Consumption Sequence Procedure
25	TRDBUSTRANS_GUID	TRDT_TRDBUSTRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
26	TRANSFER_GROUPFG	TRQT_FLOWGROUP	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
27	SOURCETARGET_FLG	TRQT_FLOWGROUP	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
28	LOT_CREATION	TRQT_FLOWGROUP	LOT_CREATION		☐	TPM_LOT_CREATION	☐	Lot Creation Category
29	MANDT_FG	TRQT_FLOWGROUP	MANDT		☐	MANDT	☐	Client
30	MANDT_BT	TRQT_BUSTRANS	MANDT		☐	MANDT	☐	Client
31	MANDT_TRD_BT	TRDT_TRDBUSTRANS	MANDT		☐	MANDT	☐	Client
32	MANDT_POS	TRQT_POSITION	MANDT		☐	MANDT	☐	Client
33	MANDT_DIF	DIFT_POS_IDENT	MANDT		☐	MANDT	☐	Client

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	20080505
SAP Release Created in	463_20