SAP ABAP View TRQV_BUS_ASSIG (CFM: View of TRQ BT with flow group and lot assignment)

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_BUS_ASSIG
Short Description	CFM: View of TRQ BT with flow group and lot assignment
Root table	TRQT_BUSTRANS	Treasury: Business Transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRQT_BUSTRANS	TRQT_BUSTRANS
2	TRQT_FLOWGROUP
3	TRQT_ASSIGNMENT
4	TRQT_ASSIGN_ITEM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRQT_BUSTRANS	MANDT	JL	EQ				0	0
2	TRQT_FLOWGROUP	MANDT	JR	EQ			AND	0	0
3	TRQT_BUSTRANS	OS_GUID	JL	EQ				0	0
4	TRQT_FLOWGROUP	BUSTRANS_OID	JR	EQ			AND	0	0
5	TRQT_FLOWGROUP	MANDT	JL	EQ				0	0
6	TRQT_ASSIGNMENT	MANDT	JR	EQ			AND	0	0
7	TRQT_FLOWGROUP	OS_GUID	JL	EQ				0	0
8	TRQT_ASSIGNMENT	FLOWGROUP_OID	JR	EQ			AND	0	0
9	TRQT_ASSIGNMENT	MANDT	JL	EQ				0	0
10	TRQT_ASSIGN_ITEM	MANDT	JR	EQ			AND	0	0
11	TRQT_ASSIGNMENT	OS_GUID	JL	EQ				0	0
12	TRQT_ASSIGN_ITEM	RULE_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRQT_BUSTRANS	MANDT		☐	MANDT	☐	Client
2	BUSTRANS_GUID	TRQT_BUSTRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	BUSTRANSID	TRQT_BUSTRANS	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
4	BUSTRANSCAT	TRQT_BUSTRANS	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
5	POSITION_DATE	TRQT_BUSTRANS	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
6	FLOWGROUP_GUID	TRQT_FLOWGROUP	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
7	TRANSFER_GROUP	TRQT_FLOWGROUP	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
8	SOURCETARGET_FLG	TRQT_FLOWGROUP	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
9	LOT_CREATION	TRQT_FLOWGROUP	LOT_CREATION		☐	TPM_LOT_CREATION	☐	Lot Creation Category
10	RULE_GUID	TRQT_ASSIGNMENT	OS_GUID		☐	TPM_ASSIGNMENT	☐	Allocation rule
11	TOTAL	TRQT_ASSIGNMENT	TOTAL		☐	TPM_CONTRIBUTION	☐	Distribution Key for Lot Assignment
12	FLG_LOT_CREATION	TRQT_ASSIGNMENT	FLG_LOT_CREATION		☐	XFELD	☐	Checkbox
13	SIGN_OF_TOTAL	TRQT_ASSIGNMENT	SIGN_OF_TOTAL		☐	SIGN	☐	Debit/Credit Sign (+/-)
14	ITEM_GUID	TRQT_ASSIGN_ITEM	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	LOT_ID	TRQT_ASSIGN_ITEM	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
16	CONTRIBUTION	TRQT_ASSIGN_ITEM	CONTRIBUTION		☐	TPM_CONTRIBUTION	☐	Distribution Key for Lot Assignment

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	20011002
SAP Release Created in	462_10