SAP ABAP Table TBAS_DCS_MIC_OVERVIEW_UI (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

Table Category	INTTAB	Structure
Structure	TBAS_DCS_MIC_OVERVIEW_UI	Table Relationship Diagram
Short Description	Overview of DCS/MIC combinations

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Overview of Derivative Contract Specifications
2	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	*
3	DCSID_TXT	☐	TBA_DCSID_TXT	TEXT40	CHAR	40	0	Derivative Contract Specification Description
4	VALIDFROM	☐	TBA_DCS_VALIDFROM	DATE	DATS	8	0	Derivative Contract Specification: Valid From
5	.INCLUDE	☐				0	0	DCS Attribute Structure
6	DERIVATIVETYPE	☐	TBA_DERIVATIVETYPE	TBA_DERIVATIVETYPE	NUMC	3	0	Derivative Category
7	LIFECYCLESTATUS	☐	TBA_DCS_LIFECYCLESTATUS	TBA_DCS_LIFECYCLESTATUS	NUMC	3	0	Derivative Contract Specification of Lifecycle Status
8	DCS_URL	☐	TBA_DCS_URL	TEXT255	CHAR	255	0	Derivative Contract Specification URL
9	.INCLUDE	☐				0	0	Derivative Contract Specification Data Structure
10	DCS_QNT	☐	TBA_DCS_QNT	MENG13	QUAN	13	3	Derivative Contract Specification Quantity
11	DCS_UOM	☐	TBA_DCS_UOM	MEINS	UNIT	3	0	Derivative Contract Specification Unit of Measure	T006
12	DCS_CPE_UOM	☐	TBA_CPEUOM	MEINS	UNIT	3	0	Commodity Pricing Engine Unit of Measure	T006
13	QUOT_UOM	☐	TBA_UOM	MEINS	UNIT	3	0	Quotation Unit of Measure	*
14	QUOT_CURRUNIT	☐	TBA_CURRUNIT	TBA_CURRUNIT	CHAR	5	0	Currency Unit
15	QUOT_CURR	☐	TBA_CURRENCY	WAERS	CUKY	5	0	Quotation Currency	TCURC
16	QUOT_DECIMALS	☐	TBA_NODECIMALS	TBA_NODECIMALS	NUMC	2	0	Number of Decimal Places
17	.INCLUDE	☐				0	0	DCS Attribute Structure Listed Options, Futures
18	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity	TBAC_PHYSCOMM
19	DCSSYMBL	☐	TBA_DCS_SYMBL	TBA_DCS_SYMBL	CHAR	4	0	Derivative Contract Specification: Product Symbol
20	CALENDAR	☐	TBA_PROMPT_DATE_CALENDAR	WFCID	CHAR	2	0	Prompt Date Calendar	*
21	PDEF_ID	☐	TBA_PERIODDEF_ID	TBA_PERIODDEF_ID	CHAR	10	0	Period Determination Method	TBAC_PDEF_ID
22	EXPDATELOGIC	☐	TBA_EXPIRATIONDATE	TBA_EXPIRATIONDATE	NUMC	3	0	Expiration Date Logic
23	REPDATELOGIC	☐	TBA_REPORTINGDATE	TBA_REPORTINGDATE	NUMC	3	0	Reporting Date
24	SDEF_ID	☐	TBA_SECIDDEF_ID	TBA_SECIDDEF_ID	CHAR	4	0	Security ID Determination Method	TBAC_SDEF_ID
25	UNDERLYING_DCSID	☐	TBA_DCSID_UNDERLYING	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	TBAC_DCS
26	OPTSTYLE	☐	TBA_OPTSTYLE	TBA_OPTSTYLE	NUMC	1	0	Exercise Type
27	RETENTION_TIME	☐	TBA_RETENTION_TIME	TBA_RETENTION_TIME	NUMC	4	0	Retention Period in Days
28	PDEF_ID_TXT	☐	TBA_PERIODDEF_ID_TXT	TEXT40	CHAR	40	0	Period Determination Method Description
29	SDEF_ID_TXT	☐	TBA_SECIDDEF_ID_TXT	TEXT40	CHAR	40	0	Security ID Determination Method Description
30	COMMODITY_TXT	☐	TBA_STOEFFCHEN_TXT	TEXT40	CHAR	40	0	Physical Commodity Description
31	.INCLUDE	☐				0	0	User Data
32	ENTERED_BY	☐	TBA_CRUSER	SYCHAR12	CHAR	12	0	First Entered By
33	ENTERED_DATE	☐	TBA_CRDAT	DATUM	DATS	8	0	First Entered on
34	ENTERED_TIME	☐	TBA_CRTIM	UZEIT	TIMS	6	0	First Entered at
35	CHANGED_BY	☐	TBA_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
36	CHANGED_DATE	☐	TBA_UPDAT	DATUM	DATS	8	0	Last Changed on
37	CHANGED_TIME	☐	TBA_UPTIM	UZEIT	TIMS	6	0	Last Changed at
38	PHYSCOMM_UOM	☐	TBA_PHYSCOMM_UOM	MEINS	UNIT	3	0	Unit of Measure of Physical Commodity	*
39	.INCLUDE	☐				0	0	Overview of DCS/MIC combinations
40	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	*
41	MIC_TXT	☐	TBA_MIC_TXT	TEXT40	CHAR	40	0	Market Identifier Code Description
42	.INCLUDE	☐				0	0	DCS Tick Structure
43	DCS_TICK_AMNT	☐	TBA_TICK_AMNT	TBA_DEC13_7	DEC	13	7	Tick Size
44	DCS_TICK_CURRUNIT	☐	TBA_CURRUNIT	TBA_CURRUNIT	CHAR	5	0	Currency Unit
45	DCS_TICK_VALUE	☐	TBA_TICK_VALUE	TBA_DEC13_7	DEC	13	7	Tick Value
46	DCS_TICK_CURR	☐	TBA_TICK_CURR	WAERS	CUKY	5	0	Tick Currency	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TBAS_DCS_MIC_OVERVIEW_UI	COMMODITY	TBAC_PHYSCOMM	COMMODITY
2	TBAS_DCS_MIC_OVERVIEW_UI	DCS_CPE_UOM	T006	MSEHI
3	TBAS_DCS_MIC_OVERVIEW_UI	DCS_TICK_CURR	TCURC	WAERS
4	TBAS_DCS_MIC_OVERVIEW_UI	DCS_UOM	T006	MSEHI		1	CN
5	TBAS_DCS_MIC_OVERVIEW_UI	PDEF_ID	TBAC_PDEF_ID	PDEF_ID
6	TBAS_DCS_MIC_OVERVIEW_UI	QUOT_CURR	TCURC	WAERS		1	CN
7	TBAS_DCS_MIC_OVERVIEW_UI	SDEF_ID	TBAC_SDEF_ID	SDEF_ID

History

Last changed by/on	SAP	20141013
SAP Release Created in