SAP ABAP View VTBDEALACT (Treasury: Transaction + activity)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen

Basic Data

View Type	D	Database View
Database View	VTBDEALACT
Short Description	Treasury: Transaction + activity
Root table	VTBFHA	Transaction

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VTBFHA	VTBFHA
2	VTBFHAZU

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VTBFHA	MANDT	JL	EQ				0	0
2	VTBFHAZU	MANDT	JR	EQ			AND	0	0
3	VTBFHA	BUKRS	JL	EQ				0	0
4	VTBFHAZU	BUKRS	JR	EQ			AND	0	0
5	VTBFHA	RFHA	JL	EQ				0	0
6	VTBFHAZU	RFHA	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VTBFHA	MANDT		☐	MANDT	☐	Client
2	BUKRS	VTBFHA	BUKRS		☐	BUKRS	☐	Company Code
3	RFHA	VTBFHA	RFHA		☐	TB_RFHA	☐	Financial Transaction
4	CRUSER	VTBFHA	CRUSER		☐	TB_CRUSER	☐	Entered by
5	DCRDAT_D	VTBFHA	DCRDAT		☐	TB_DCRDAT	☐	Entered On
6	TCRTIM_D	VTBFHA	TCRTIM		☐	TB_TCRTIM	☐	Entry Time
7	UPUSER	VTBFHA	UPUSER		☐	TB_UPUSER	☐	Last Changed by
8	DUPDAT	VTBFHA	DUPDAT		☐	TB_DUPDAT	☐	Changed on
9	TUPTIM	VTBFHA	TUPTIM		☐	TB_TUPTIM	☐	Time changed
10	RANTYP	VTBFHA	RANTYP		☐	RANTYP	☐	Contract Type
11	SANLF	VTBFHA	SANLF		☐	SANLF	☐	Product Category
12	SFGTYP	VTBFHA	SFGTYP		☐	TB_SFGTYP	☐	Transaction Category
13	SGSART	VTBFHA	SGSART		☐	VVSART	☐	Product Type
14	SFHAART	VTBFHA	SFHAART		☐	TB_SFHAART	☐	Financial Transaction Type
15	RGATT	VTBFHA	RGATT		☐	TI_RGATT	☐	Class
16	RFHAZUNR	VTBFHA	RFHAZUNR		☐	TB_RFHAZUN	☐	Number status of activity
17	RFHAZUL	VTBFHA	RFHAZUL		☐	TB_RFHAZUL	☐	Last Active Transaction Activity
18	SAKTIV	VTBFHA	SAKTIV		☐	TB_SAKTIV	☐	Active Status of Transaction or Activity
19	KONTRH	VTBFHA	KONTRH		☐	TB_KUNNR_NEW	☐	Business Partner Number
20	RREFKONT	VTBFHA	RREFKONT		☐	RREFKONT_OBSOLETE	☐	Obsolete: Accnt Assignment Ref. in Fin. Assets Management
21	RREFKONT2	VTBFHA	RREFKONT2		☐	RREFKONT_OBSOLETE	☐	Obsolete: Accnt Assignment Ref. in Fin. Assets Management
22	RPORTB	VTBFHA	RPORTB		☐	RPORTB	☐	Portfolio
23	WGSCHFT	VTBFHA	WGSCHFT		☐	TB_WGSCHFT	☐	Currency of transaction
24	WGSCHFT1	VTBFHA	WGSCHFT1		☐	TB_WGSCHF1	☐	Currency of Outgoing Side
25	WGSCHFT2	VTBFHA	WGSCHFT2		☐	TB_WGSCHF2	☐	Currency of Incoming Side
26	SKALID	VTBFHA	SKALID		☐	SKALID	☐	Factory calendar
27	SKALID2	VTBFHA	SKALID2		☐	SKALID	☐	Factory calendar
28	JLIMIT	VTBFHA	JLIMIT		☐	TB_JLIMIT	☐	Limit indicator
29	AKUEND	VTBFHA	AKUEND		☐	TB_AKUEND	☐	Period of Notice
30	SKUEND	VTBFHA	SKUEND		☐	TB_SKUEND	☐	Unit of Period of Notice
31	RLDEPO	VTBFHA	RLDEPO		☐	VRLDEPO	☐	Securities Account
32	ZUONR	VTBFHA	ZUONR		☐	TB_TFPROJ	☐	Finance Project
33	ABWTYP	VTBFHA	ABWTYP		☐	TB_ABWTYP	☐	Processing Category
34	RMAID	VTBFHA	RMAID		☐	TB_RMAID	☐	Master Agreement
35	RGARANT	VTBFHA	RGARANT		☐	TB_RGARANT_NEW	☐	Guarantor of Financial Transaction
36	ZUOND	VTBFHA	ZUOND		☐	TB_ZUOND	☐	Assignment
37	REFER	VTBFHA	REFER		☐	TB_REFER	☐	Internal Reference
38	MERKM	VTBFHA	MERKM		☐	TB_MERKM	☐	Characteristics
39	RANL	VTBFHA	RANL		☐	VVRANLW	☐	Security ID Number
40	SSTOGRD	VTBFHAZU	SSTOGRD		☐	SSTOGRD	☐	Reason for Reversal
41	RDEALER	VTBFHAZU	RDEALER		☐	RDEALER	☐	Trader
42	DVTRAB	VTBFHAZU	DVTRAB		☐	TB_DVTRAB	☐	Contract Conclusion Date
43	GSPPART	VTBFHAZU	GSPPART		☐	TB_GSPPART	☐	Contact Person
44	XAKT	VTBFHAZU	XAKT		☐	XAKT	☐	File Number
45	NORDEXT	VTBFHAZU	NORDEXT		☐	TB_NORDEXT	☐	External Reference
46	LIMITART	VTBFHAZU	LIMITART		☐	TB_LIMITAR	☐	Limit type
47	RFHAZU	VTBFHAZU	RFHAZU		☐	TB_RFHAZU	☐	Transaction activity
48	SFGZUSTT	VTBFHAZU	SFGZUSTT		☐	TB_SFGZUTY	☐	Transaction Activity Category
49	SAKTIV_HAZU	VTBFHAZU	SAKTIV		☐	TB_SAKTIV	☐	Active Status of Transaction or Activity

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