SAP ABAP View TBAV_DCS_OVRVIEW (Overview of DCS/MIC Combinations)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA-GTF-TRB (Application Component) Financial Risk Management Basis
     ⤷ FTR_BASIS_PERSISTENCY (Package) Treasury Basis Objects - Data Persistency

Basic Data

View Type	D	Database View
Database View	TBAV_DCS_OVRVIEW
Short Description	Overview of DCS/MIC Combinations
Root table	TBAC_DCS_MIC	Dervative contract specification - MIC

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TBAC_DCS_MIC	TBAC_DCS_MIC
2	TBAC_MIC
3	TBAC_MICT
4	TBAC_DCS
5	TBAC_DCST
6	TBAC_DCS_CTY
7	TBAC_DCS_LOF
8	TBAC_PHYSCOMM
9	TBAC_PHYSCOMMT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TBAC_MIC	CLIENT	JL	EQ				0	0
2	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
3	TBAC_MIC	MIC	JL	EQ				0	0
4	TBAC_DCS_MIC	MIC	JR	EQ			AND	0	0
5	TBAC_MIC	CLIENT	JL	EQ				0	0
6	TBAC_MICT	CLIENT	JR	EQ			AND	0	0
7	TBAC_MIC	MIC	JL	EQ				0	0
8	TBAC_MICT	MIC	JR	EQ			AND	0	0
9	TBAC_DCS	CLIENT	JL	EQ				0	0
10	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
11	TBAC_DCS	DCSID	JL	EQ				0	0
12	TBAC_DCS_MIC	DCSID	JR	EQ			AND	0	0
13	TBAC_DCS	CLIENT	JL	EQ				0	0
14	TBAC_DCST	CLIENT	JR	EQ			AND	0	0
15	TBAC_DCS	DCSID	JL	EQ				0	0
16	TBAC_DCST	DCSID	JR	EQ			AND	0	0
17	TBAC_DCS	CLIENT	JL	EQ				0	0
18	TBAC_DCS_CTY	CLIENT	JR	EQ			AND	0	0
19	TBAC_DCS	DCSID	JL	EQ				0	0
20	TBAC_DCS_CTY	DCSID	JR	EQ			AND	0	0
21	TBAC_DCS	CLIENT	JL	EQ				0	0
22	TBAC_DCS_LOF	CLIENT	JR	EQ			AND	0	0
23	TBAC_DCS	DCSID	JL	EQ				0	0
24	TBAC_DCS_LOF	DCSID	JR	EQ			AND	0	0
25	TBAC_PHYSCOMM	CLIENT	JL	EQ				0	0
26	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
27	TBAC_PHYSCOMM	COMMODITY	JL	EQ				0	0
28	TBAC_DCS_LOF	COMMODITY	JR	EQ			AND	0	0
29	TBAC_PHYSCOMM	CLIENT	JL	EQ				0	0
30	TBAC_PHYSCOMMT	CLIENT	JR	EQ			AND	0	0
31	TBAC_PHYSCOMM	COMMODITY	JL	EQ				0	0
32	TBAC_PHYSCOMMT	COMMODITY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	TBAC_DCS	CLIENT		☐	MANDT	☐	Client
2	DCSID	TBAC_DCS	DCSID		☐	TBA_DCSID	☐	Derivative Contract Specification ID
3	MIC	TBAC_MIC	MIC		☐	TBA_MIC	☐	Market Identifier Code
4	VALIDFROM	TBAC_DCS_CTY	VALIDFROM		☐	TBA_DCS_VALIDFROM	☐	Derivative Contract Specification: Valid From
5	DERIVATIVETYPE	TBAC_DCS	DERIVATIVETYPE		☐	TBA_DERIVATIVETYPE	☐	Derivative Category
6	LIFECYCLESTATUS	TBAC_DCS	LIFECYCLESTATUS		☐	TBA_DCS_LIFECYCLESTATUS	☐	Derivative Contract Specification of Lifecycle Status
7	DCS_URL	TBAC_DCS	DCS_URL		☐	TBA_DCS_URL	☐	Derivative Contract Specification URL
8	ENTERED_BY	TBAC_DCS	ENTERED_BY		☐	TBA_CRUSER	☐	First Entered By
9	ENTERED_DATE	TBAC_DCS	ENTERED_DATE		☐	TBA_CRDAT	☐	First Entered on
10	ENTERED_TIME	TBAC_DCS	ENTERED_TIME		☐	TBA_CRTIM	☐	First Entered at
11	CHANGED_BY	TBAC_DCS	CHANGED_BY		☐	TBA_UPUSER	☐	Last Changed by
12	CHANGED_DATE	TBAC_DCS	CHANGED_DATE		☐	TBA_UPDAT	☐	Last Changed on
13	CHANGED_TIME	TBAC_DCS	CHANGED_TIME		☐	TBA_UPTIM	☐	Last Changed at
14	MIC_LANGU	TBAC_MICT	LANGU		☐	SPRAS	☐	Language Key
15	MIC_TXT	TBAC_MICT	TEXT		☐	TBA_MIC_TXT	☐	Market Identifier Code Description
16	DCSID_LANGU	TBAC_DCST	LANGU		☐	SPRAS	☐	Language Key
17	DCSID_TXT	TBAC_DCST	TEXT		☐	TBA_DCSID_TXT	☐	Derivative Contract Specification Description
18	DCS_QNT	TBAC_DCS_CTY	DCS_QNT		☐	TBA_DCS_QNT	☐	Derivative Contract Specification Quantity
19	DCS_UOM	TBAC_DCS_CTY	DCS_UOM		☐	TBA_DCS_UOM	☐	Derivative Contract Specification Unit of Measure
20	DCS_CPE_UOM	TBAC_DCS_CTY	DCS_CPE_UOM		☐	TBA_CPEUOM	☐	Commodity Pricing Engine Unit of Measure
21	QUOT_UOM	TBAC_DCS_CTY	QUOT_UOM		☐	TBA_UOM	☐	Quotation Unit of Measure
22	QUOT_CURRUNIT	TBAC_DCS_CTY	QUOT_CURRUNIT		☐	TBA_CURRUNIT	☐	Currency Unit
23	QUOT_CURR	TBAC_DCS_CTY	QUOT_CURR		☐	TBA_CURRENCY	☐	Quotation Currency
24	QUOT_DECIMALS	TBAC_DCS_CTY	QUOT_DECIMALS		☐	TBA_NODECIMALS	☐	Number of Decimal Places
25	DCSSYMBL	TBAC_DCS_LOF	DCSSYMBL		☐	TBA_DCS_SYMBL	☐	Derivative Contract Specification: Product Symbol
26	CALENDAR	TBAC_DCS_LOF	CALENDAR		☐	TBA_PROMPT_DATE_CALENDAR	☐	Prompt Date Calendar
27	EXPDATELOGIC	TBAC_DCS_LOF	EXPDATELOGIC		☐	TBA_EXPIRATIONDATE	☐	Expiration Date Logic
28	REPDATELOGIC	TBAC_DCS_LOF	REPDATELOGIC		☐	TBA_REPORTINGDATE	☐	Reporting Date
29	UNDERLYING_DCSID	TBAC_DCS_LOF	UNDERLYING_DCSID		☐	TBA_DCSID_UNDERLYING	☐	Derivative Contract Specification ID
30	OPTSTYLE	TBAC_DCS_LOF	OPTSTYLE		☐	TBA_OPTSTYLE	☐	Exercise Type
31	COMMODITY_LANGU	TBAC_PHYSCOMMT	LANGU		☐	SPRAS	☐	Language Key
32	COMMODITY_TXT	TBAC_PHYSCOMMT	TEXT		☐	TBA_STOEFFCHEN_TXT	☐	Physical Commodity Description
33	PHYSCOMM_UOM	TBAC_PHYSCOMM	UOM		☐	TBA_PHYSCOMM_UOM	☐	Unit of Measure of Physical Commodity
34	COMMODITY	TBAC_PHYSCOMM	COMMODITY		☐	TBA_STOEFFCHEN	☐	Physical Commodity
35	SDEF_ID	TBAC_DCS_LOF	SDEF_ID		☐	TBA_SECIDDEF_ID	☐	Security ID Determination Method
36	PDEF_ID	TBAC_DCS_LOF	PDEF_ID		☐	TBA_PERIODDEF_ID	☐	Period Determination Method

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