SAP ABAP View TERV_TRANS_FLOW (View: Securities Rights)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

View Type	D	Database View
Database View	TERV_TRANS_FLOW
Short Description	View: Securities Rights
Root table	TERT_TRANSACTION	Business Transaction: Exercise of Rights

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TERT_TRANSACTION	TERT_TRANSACTION
2	TERT_FLOW

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TERT_TRANSACTION	MANDT		☐	MANDT	☐	Client
2	ERNR	TERT_TRANSACTION	ERNR		☐	TER_HEADNUMBER	☐	ID number of exercised right
3	COMPANY_CODE	TERT_TRANSACTION	COMPANY_CODE		☐	BUKRS	☐	Company Code
4	SECURITY_ID	TERT_TRANSACTION	SECURITY_ID		☐	TER_EXECRANL	☐	ID number of exercised securities right
5	SECURITY_ACCOUNT	TERT_TRANSACTION	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
6	COM_VAL_CLASS	TERT_TRANSACTION	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
7	PORTFOLIO	TERT_TRANSACTION	PORTFOLIO		☐	RPORTB	☐	Portfolio
8	TRADER	TERT_TRANSACTION	TRADER		☐	RDEALER	☐	Trader
9	RIGHTTYPE	TERT_TRANSACTION	RIGHTTYPE		☐	TER_RIGHTTYPE	☐	Rights category of an executable right
10	RIGHTNUMBER	TERT_TRANSACTION	RIGHTNUMBER		☐	TER_RIGHTNUMBER	☐	ID number of executable right
11	EXECUTION_DATE	TERT_TRANSACTION	EXECUTION_DATE		☐	TER_SDATUM	☐	Key date for exercising rights
12	BUSTRANSID	TERT_TRANSACTION	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
13	CREATE_DATE	TERT_TRANSACTION	CREATE_DATE		☐	TPM_BT_CREATE_DATE	☐	Creation Date of the Operative Business Transaction
14	CREATE_TIME	TERT_TRANSACTION	CREATE_TIME		☐	TPM_BT_CREATE_TIME	☐	Creation Time of the Operative Business Transaction
15	UNITS	TERT_TRANSACTION	UNITS		☐	TPM_UNITS	☐	Units
16	NOMINAL_AMT	TERT_TRANSACTION	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
17	NOMINAL_CURR	TERT_TRANSACTION	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
18	EXERCISETYPE	TERT_TRANSACTION	EXERCISETYPE		☐	SOPTTYP	☐	Indicator: Option Category
19	SETTLEMENT	TERT_TRANSACTION	SETTLEMENT		☐	SVERROPT	☐	Option Settlement Indicator
20	EXPIRE	TERT_TRANSACTION	EXPIRE		☐	TER_EXPIRE	☐	Expiration of a right
21	STATUS	TERT_TRANSACTION	STATUS		☐	TER_STATUS_HEAD	☐	Status of executed right
22	DOCUMENT_DATE	TERT_TRANSACTION	DOCUMENT_DATE		☐	BLDAT	☐	Document Date in Document
23	FI_POSTING_DATE	TERT_TRANSACTION	FI_POSTING_DATE		☐	TPM_FI_POSTING_DATE	☐	Different FI Posting Date
24	REVERSAL_REASON	TERT_TRANSACTION	REVERSAL_REASON		☐	SSTOGRD	☐	Reason for Reversal
25	BOOKING_TEXT	TERT_TRANSACTION	BOOKING_TEXT		☐	XZUSATZ	☐	Assignment
26	SECURITY_ID1	TERT_TRANSACTION	SECURITY_ID1		☐	TER_RANL	☐	ID number of reference security of an executable right
27	SECURITY_ID2	TERT_TRANSACTION	SECURITY_ID2		☐	TER_RANL	☐	ID number of reference security of an executable right
28	INDEXTYPE	TERT_TRANSACTION	INDEXTYPE		☐	IDX	☐	Securities Index
29	INDEXVALUE	TERT_TRANSACTION	INDEXVALUE		☐	IDXSTAND	☐	Index value
30	RATE_SEC_ID	TERT_TRANSACTION	RATE_SEC_ID		☐	VVPKTKUR	☐	Price of Unit- or Percentage-Quoted Security
31	RATE_SEC_ID1	TERT_TRANSACTION	RATE_SEC_ID1		☐	VVPKTKUR	☐	Price of Unit- or Percentage-Quoted Security
32	RATE_SEC_ID2	TERT_TRANSACTION	RATE_SEC_ID2		☐	VVPKTKUR	☐	Price of Unit- or Percentage-Quoted Security
33	CURR_SEC_ID	TERT_TRANSACTION	CURR_SEC_ID		☐	WAERS	☐	Currency Key
34	CURR_SEC_ID1	TERT_TRANSACTION	CURR_SEC_ID1		☐	WAERS	☐	Currency Key
35	CURR_SEC_ID2	TERT_TRANSACTION	CURR_SEC_ID2		☐	WAERS	☐	Currency Key
36	EXRATE1	TERT_TRANSACTION	EXRATE1		☐	KURSF	☐	Exchange rate
37	EXRATE2	TERT_TRANSACTION	EXRATE2		☐	KURSF	☐	Exchange rate
38	EXRATE3	TERT_TRANSACTION	EXRATE3		☐	KURSF	☐	Exchange rate
39	CURR1_FROM	TERT_TRANSACTION	CURR1_FROM		☐	WAERS	☐	Currency Key
40	CURR1_TO	TERT_TRANSACTION	CURR1_TO		☐	WAERS	☐	Currency Key
41	CURR2_TO	TERT_TRANSACTION	CURR2_TO		☐	WAERS	☐	Currency Key
42	CURR2_FROM	TERT_TRANSACTION	CURR2_FROM		☐	WAERS	☐	Currency Key
43	CURR3_TO	TERT_TRANSACTION	CURR3_TO		☐	WAERS	☐	Currency Key
44	CURR3_FROM	TERT_TRANSACTION	CURR3_FROM		☐	WAERS	☐	Currency Key
45	MIGRATION_FLG	TERT_TRANSACTION	MIGRATION_FLG		☐	CHAR1	☐	Single-Character Flag
46	RERF	TERT_TRANSACTION	RERF		☐	RERF	☐	Entered by
47	DERF	TERT_TRANSACTION	DERF		☐	DERF	☐	First Entered on
48	TERF	TERT_TRANSACTION	TERF		☐	TERF	☐	Time of Initial Entry
49	REHER	TERT_TRANSACTION	REHER		☐	REHER	☐	Source of initial entry
50	RBEAR	TERT_TRANSACTION	RBEAR		☐	RBEAR	☐	Employee ID
51	DBEAR	TERT_TRANSACTION	DBEAR		☐	DBEAR	☐	Last Edited on
52	TBEAR	TERT_TRANSACTION	TBEAR		☐	TBEAR	☐	Last Edited at
53	RBHER	TERT_TRANSACTION	RBHER		☐	RBHER	☐	Editing Source
54	FLOW_NUMBER	TERT_FLOW	FLOW_NUMBER		☐	TER_FLOWNUMBER	☐	Flow Number of Rights Exercise
55	FLOW_CATEGORY	TERT_FLOW	FLOW_CATEGORY		☐	TER_FLOW_CATEGORY	☐	Flow Category: Rights that can be Exercised
56	FLOW_TYPE	TERT_FLOW	FLOW_TYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
57	AMOUNT_FACTOR	TERT_FLOW	AMOUNT_FACTOR		☐	TER_AMOUNT_FACTOR	☐	Value Factor: Rights can be Exercised
58	ALLOC_NMBR	TERT_FLOW	ALLOC_NMBR		☐	DZUONR	☐	Assignment number
59	LOCAL_CURR	TERT_FLOW	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
60	LOCAL_AMT	TERT_FLOW	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
61	PAYMENT_DATE	TERT_FLOW	PAYMENT_DATE		☐	TPM_PAYMENT_DATE	☐	Payment Date
62	PAYMENT_AMT	TERT_FLOW	PAYMENT_AMT		☐	TPM_PAYMENT_AMT	☐	Amount in Payment Currency
63	PAYMENT_CURR	TERT_FLOW	PAYMENT_CURR		☐	TPM_PAYMENT_CURR	☐	Payment Currency
64	HOUSE_BANK	TERT_FLOW	HOUSE_BANK		☐	TB_RHABKI	☐	Short key for own house bank
65	HOUSE_BANK_ACC	TERT_FLOW	HOUSE_BANK_ACC		☐	TB_RHKTID	☐	Short key for house bank account
66	POSITION_DATE	TERT_FLOW	POSITION_DATE		☐	TER_POSITION_DATE	☐	Position Date: Rights that can be Exercised
67	POSITION_CURR	TERT_FLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
68	POSITION_AMT	TERT_FLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
69	CALCULATION_DATE	TERT_FLOW	CALCULATION_DATE		☐	DVALUT	☐	Calculation Date
70	CALC_DATE_INCL	TERT_FLOW	CALC_DATE_INCL		☐	VVSINCL	☐	Inclusive indicator for beginning and end of a period

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