SAP ABAP View TRQV_LOT_ATTR (View for Lot Attributes)

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_LOT_ATTR
Short Description	View for Lot Attributes
Root table	TRQT_LOT	Treasury: Lot

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRQT_LOT	TRQT_LOT
2	TRDT_TRDBUSTRANS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRQT_LOT	MANDT	JL	EQ				0	0
2	TRDT_TRDBUSTRANS	MANDT	JR	EQ			AND	0	0
3	TRQT_LOT	BUSTRANSID	JL	EQ				0	0
4	TRDT_TRDBUSTRANS	BUSTRANSID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRQT_LOT	MANDT		☐	MANDT	☐	Client
2	OS_GUID	TRQT_LOT	OS_GUID		☐	TPM_POSITION_LOT	☐	Lot
3	POSITION_DATE	TRQT_LOT	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
4	ORIGIN_DATE	TRQT_LOT	ORIGIN_DATE		☐	TPM_ORIGIN_DATE	☐	Original Position Acquisition Date
5	BUSTRANSID	TRQT_LOT	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
6	LOT_ID	TRQT_LOT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
7	COMPANY_CODE	TRDT_TRDBUSTRANS	COMPANY_CODE		☐	BUKRS	☐	Company Code
8	VALUATION_AREA	TRDT_TRDBUSTRANS	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
9	DEAL_NUMBER	TRDT_TRDBUSTRANS	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
10	BUSTRANSCAT	TRDT_TRDBUSTRANS	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
11	PRODUCT_GROUP	TRDT_TRDBUSTRANS	PRODUCT_GROUP		☐	TPM_PRODUCT_GROUP	☐	Product Group
12	PRODUCT_CATEGORY	TRDT_TRDBUSTRANS	PRODUCT_CATEGORY		☐	SANLF	☐	Product Category
13	BUSTRANS_STATE	TRDT_TRDBUSTRANS	BUSTRANS_STATE		☐	TPM_BUSTRANS_STATE	☐	Status of Distributor Business Transaction
14	CREATE_DATE	TRDT_TRDBUSTRANS	CREATE_DATE		☐	TPM_BT_CREATE_DATE	☐	Creation Date of the Operative Business Transaction
15	CREATE_TIME	TRDT_TRDBUSTRANS	CREATE_TIME		☐	TPM_BT_CREATE_TIME	☐	Creation Time of the Operative Business Transaction

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	20070913
SAP Release Created in