SAP ABAP View VTBDEALFLW (Treasury: Transaction + flows)

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	VTBDEALFLW
Short Description	Treasury: Transaction + flows
Root table	VTBFHA	Transaction

Table

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

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	VTBFHAPO	MANDT	JR	EQ			AND	0	0
3	VTBFHA	BUKRS	JL	EQ				0	0
4	VTBFHAPO	BUKRS	JR	EQ			AND	0	0
5	VTBFHA	RFHA	JL	EQ				0	0
6	VTBFHAPO	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	RFHAZU	VTBFHAPO	RFHAZU		☐	TB_RFHAZU	☐	Transaction activity
5	DCRDAT	VTBFHAPO	DCRDAT		☐	TB_CRDAT	☐	Entered On
6	TCRTIM	VTBFHAPO	TCRTIM		☐	TB_TCRTIM	☐	Entry Time
7	RFHAZB	VTBFHAPO	RFHAZB		☐	TB_RFHAZB	☐	Transaction flow
8	CRUSER	VTBFHA	CRUSER		☐	TB_CRUSER	☐	Entered by
9	DCRDAT_D	VTBFHA	DCRDAT		☐	TB_DCRDAT	☐	Entered On
10	TCRTIM_D	VTBFHA	TCRTIM		☐	TB_TCRTIM	☐	Entry Time
11	UPUSER	VTBFHA	UPUSER		☐	TB_UPUSER	☐	Last Changed by
12	DUPDAT	VTBFHA	DUPDAT		☐	TB_DUPDAT	☐	Changed on
13	TUPTIM	VTBFHA	TUPTIM		☐	TB_TUPTIM	☐	Time changed
14	RANTYP	VTBFHA	RANTYP		☐	RANTYP	☐	Contract Type
15	SANLF	VTBFHA	SANLF		☐	SANLF	☐	Product Category
16	SFGTYP	VTBFHA	SFGTYP		☐	TB_SFGTYP	☐	Transaction Category
17	SGSART	VTBFHA	SGSART		☐	VVSART	☐	Product Type
18	SFHAART	VTBFHA	SFHAART		☐	TB_SFHAART	☐	Financial Transaction Type
19	RGATT	VTBFHA	RGATT		☐	TI_RGATT	☐	Class
20	RFHAZUNR	VTBFHA	RFHAZUNR		☐	TB_RFHAZUN	☐	Number status of activity
21	RFHAZUL	VTBFHA	RFHAZUL		☐	TB_RFHAZUL	☐	Last Active Transaction Activity
22	SAKTIV	VTBFHA	SAKTIV		☐	TB_SAKTIV	☐	Active Status of Transaction or Activity
23	KONTRH	VTBFHA	KONTRH		☐	TB_KUNNR_NEW	☐	Business Partner Number
24	RREFKONT	VTBFHA	RREFKONT		☐	RREFKONT_OBSOLETE	☐	Obsolete: Accnt Assignment Ref. in Fin. Assets Management
25	RREFKONT2	VTBFHA	RREFKONT2		☐	RREFKONT_OBSOLETE	☐	Obsolete: Accnt Assignment Ref. in Fin. Assets Management
26	RPORTB	VTBFHA	RPORTB		☐	RPORTB	☐	Portfolio
27	WGSCHFT	VTBFHA	WGSCHFT		☐	TB_WGSCHFT	☐	Currency of transaction
28	WGSCHFT1	VTBFHA	WGSCHFT1		☐	TB_WGSCHF1	☐	Currency of Outgoing Side
29	WGSCHFT2	VTBFHA	WGSCHFT2		☐	TB_WGSCHF2	☐	Currency of Incoming Side
30	DBLFZ	VTBFHA	DBLFZ		☐	TB_DBLFZ	☐	Term Start
31	SKALID	VTBFHA	SKALID		☐	SKALID	☐	Factory calendar
32	SKALID2	VTBFHA	SKALID2		☐	SKALID	☐	Factory calendar
33	JLIMIT	VTBFHA	JLIMIT		☐	TB_JLIMIT	☐	Limit indicator
34	AKUEND	VTBFHA	AKUEND		☐	TB_AKUEND	☐	Period of Notice
35	SKUEND	VTBFHA	SKUEND		☐	TB_SKUEND	☐	Unit of Period of Notice
36	RLDEPO	VTBFHA	RLDEPO		☐	VRLDEPO	☐	Securities Account
37	ZUONR	VTBFHA	ZUONR		☐	TB_TFPROJ	☐	Finance Project
38	DELFZ	VTBFHA	DELFZ		☐	TB_DELFZ	☐	Term End
39	ABWTYP	VTBFHA	ABWTYP		☐	TB_ABWTYP	☐	Processing Category
40	ZUOND	VTBFHA	ZUOND		☐	TB_ZUOND	☐	Assignment
41	REFER	VTBFHA	REFER		☐	TB_REFER	☐	Internal Reference
42	MERKM	VTBFHA	MERKM		☐	TB_MERKM	☐	Characteristics
43	SBEWEBE	VTBFHAPO	SBEWEBE		☐	TB_SBEWEBE	☐	Posting Status of Flow
44	SSPRGRD	VTBFHAPO	SSPRGRD		☐	TB_SSPRGRD	☐	Reason Why Flow Is Blocked for Posting
45	SBFREI	VTBFHAPO	SBFREI		☐	TB_SBFREI	☐	Release Given for Flow to Be Posted?
46	DZTERM	VTBFHAPO	DZTERM		☐	TB_DZTERM	☐	Payment or Delivery Date
47	SFHAZBA	VTBFHAPO	SFHAZBA		☐	TB_SFHAZBA	☐	Flow Type
48	SBKKLAS	VTBFHAPO	SBKKLAS		☐	TB_SBKKLAS	☐	Classification of flows and conditions
49	SBKTYP	VTBFHAPO	SBKTYP		☐	TB_SBKTYP	☐	Category of Flows and Conditions

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