SAP ABAP View TBAV_DCS_OVR (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_OVR
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_DCS
4	TBAC_DCS_CTY
5	TBAC_DCS_LOF
6	TBAC_PHYSCOMM

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_DCS	CLIENT	JL	EQ				0	0
6	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
7	TBAC_DCS	DCSID	JL	EQ				0	0
8	TBAC_DCS_MIC	DCSID	JR	EQ			AND	0	0
9	TBAC_DCS	CLIENT	JL	EQ				0	0
10	TBAC_DCS_CTY	CLIENT	JR	EQ			AND	0	0
11	TBAC_DCS	DCSID	JL	EQ				0	0
12	TBAC_DCS_CTY	DCSID	JR	EQ			AND	0	0
13	TBAC_DCS	CLIENT	JL	EQ				0	0
14	TBAC_DCS_LOF	CLIENT	JR	EQ			AND	0	0
15	TBAC_DCS	DCSID	JL	EQ				0	0
16	TBAC_DCS_LOF	DCSID	JR	EQ			AND	0	0
17	TBAC_PHYSCOMM	CLIENT	JL	EQ				0	0
18	TBAC_DCS_MIC	CLIENT	JR	EQ			AND	0	0
19	TBAC_PHYSCOMM	COMMODITY	JL	EQ				0	0
20	TBAC_DCS_LOF	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	DCS_QNT	TBAC_DCS_CTY	DCS_QNT		☐	TBA_DCS_QNT	☐	Derivative Contract Specification Quantity
15	DCS_UOM	TBAC_DCS_CTY	DCS_UOM		☐	TBA_DCS_UOM	☐	Derivative Contract Specification Unit of Measure
16	DCS_CPE_UOM	TBAC_DCS_CTY	DCS_CPE_UOM		☐	TBA_CPEUOM	☐	Commodity Pricing Engine Unit of Measure
17	QUOT_UOM	TBAC_DCS_CTY	QUOT_UOM		☐	TBA_UOM	☐	Quotation Unit of Measure
18	QUOT_CURRUNIT	TBAC_DCS_CTY	QUOT_CURRUNIT		☐	TBA_CURRUNIT	☐	Currency Unit
19	QUOT_CURR	TBAC_DCS_CTY	QUOT_CURR		☐	TBA_CURRENCY	☐	Quotation Currency
20	QUOT_DECIMALS	TBAC_DCS_CTY	QUOT_DECIMALS		☐	TBA_NODECIMALS	☐	Number of Decimal Places
21	DCSSYMBL	TBAC_DCS_LOF	DCSSYMBL		☐	TBA_DCS_SYMBL	☐	Derivative Contract Specification: Product Symbol
22	CALENDAR	TBAC_DCS_LOF	CALENDAR		☐	TBA_PROMPT_DATE_CALENDAR	☐	Prompt Date Calendar
23	EXPDATELOGIC	TBAC_DCS_LOF	EXPDATELOGIC		☐	TBA_EXPIRATIONDATE	☐	Expiration Date Logic
24	REPDATELOGIC	TBAC_DCS_LOF	REPDATELOGIC		☐	TBA_REPORTINGDATE	☐	Reporting Date
25	UNDERLYING_DCSID	TBAC_DCS_LOF	UNDERLYING_DCSID		☐	TBA_DCSID_UNDERLYING	☐	Derivative Contract Specification ID
26	OPTSTYLE	TBAC_DCS_LOF	OPTSTYLE		☐	TBA_OPTSTYLE	☐	Exercise Type
27	PHYSCOMM_UOM	TBAC_PHYSCOMM	UOM		☐	TBA_PHYSCOMM_UOM	☐	Unit of Measure of Physical Commodity
28	COMMODITY	TBAC_PHYSCOMM	COMMODITY		☐	TBA_STOEFFCHEN	☐	Physical Commodity
29	PDEF_ID	TBAC_DCS_LOF	PDEF_ID		☐	TBA_PERIODDEF_ID	☐	Period Determination Method
30	SDEF_ID	TBAC_DCS_LOF	SDEF_ID		☐	TBA_SECIDDEF_ID	☐	Security ID 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	20140802
SAP Release Created in