SAP ABAP Table TBAV_DCS_OVRVIEW (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TBAV_DCS_OVRVIEW	Table Relationship Diagram
Short Description	Generated Table for View

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DCSID	☑	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID
3	MIC	☑	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code
4	VALIDFROM	☑	TBA_DCS_VALIDFROM	DATE	DATS	8	0	Derivative Contract Specification: Valid From
5	DERIVATIVETYPE	☑	TBA_DERIVATIVETYPE	TBA_DERIVATIVETYPE	NUMC	3	0	Derivative Category
6	LIFECYCLESTATUS	☑	TBA_DCS_LIFECYCLESTATUS	TBA_DCS_LIFECYCLESTATUS	NUMC	3	0	Derivative Contract Specification of Lifecycle Status
7	DCS_URL	☑	TBA_DCS_URL	TEXT255	CHAR	255	0	Derivative Contract Specification URL
8	ENTERED_BY	☑	TBA_CRUSER	SYCHAR12	CHAR	12	0	First Entered By
9	ENTERED_DATE	☑	TBA_CRDAT	DATUM	DATS	8	0	First Entered on
10	ENTERED_TIME	☑	TBA_CRTIM	UZEIT	TIMS	6	0	First Entered at
11	CHANGED_BY	☑	TBA_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
12	CHANGED_DATE	☑	TBA_UPDAT	DATUM	DATS	8	0	Last Changed on
13	CHANGED_TIME	☑	TBA_UPTIM	UZEIT	TIMS	6	0	Last Changed at
14	MIC_LANGU	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
15	MIC_TXT	☑	TBA_MIC_TXT	TEXT40	CHAR	40	0	Market Identifier Code Description
16	DCSID_LANGU	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
17	DCSID_TXT	☑	TBA_DCSID_TXT	TEXT40	CHAR	40	0	Derivative Contract Specification Description
18	DCS_QNT	☑	TBA_DCS_QNT	MENG13	QUAN	13	3	Derivative Contract Specification Quantity
19	DCS_UOM	☑	TBA_DCS_UOM	MEINS	UNIT	3	0	Derivative Contract Specification Unit of Measure	T006
20	DCS_CPE_UOM	☑	TBA_CPEUOM	MEINS	UNIT	3	0	Commodity Pricing Engine Unit of Measure	T006
21	QUOT_UOM	☑	TBA_UOM	MEINS	UNIT	3	0	Quotation Unit of Measure
22	QUOT_CURRUNIT	☑	TBA_CURRUNIT	TBA_CURRUNIT	CHAR	5	0	Currency Unit
23	QUOT_CURR	☑	TBA_CURRENCY	WAERS	CUKY	5	0	Quotation Currency	TCURC
24	QUOT_DECIMALS	☑	TBA_NODECIMALS	TBA_NODECIMALS	NUMC	2	0	Number of Decimal Places
25	DCSSYMBL	☑	TBA_DCS_SYMBL	TBA_DCS_SYMBL	CHAR	4	0	Derivative Contract Specification: Product Symbol
26	CALENDAR	☑	TBA_PROMPT_DATE_CALENDAR	WFCID	CHAR	2	0	Prompt Date Calendar
27	EXPDATELOGIC	☑	TBA_EXPIRATIONDATE	TBA_EXPIRATIONDATE	NUMC	3	0	Expiration Date Logic
28	REPDATELOGIC	☑	TBA_REPORTINGDATE	TBA_REPORTINGDATE	NUMC	3	0	Reporting Date
29	UNDERLYING_DCSID	☑	TBA_DCSID_UNDERLYING	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	TBAC_DCS
30	OPTSTYLE	☑	TBA_OPTSTYLE	TBA_OPTSTYLE	NUMC	1	0	Exercise Type
31	COMMODITY_LANGU	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
32	COMMODITY_TXT	☐	TBA_STOEFFCHEN_TXT	TEXT40	CHAR	40	0	Physical Commodity Description
33	PHYSCOMM_UOM	☐	TBA_PHYSCOMM_UOM	MEINS	UNIT	3	0	Unit of Measure of Physical Commodity	T006
34	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity
35	SDEF_ID	☐	TBA_SECIDDEF_ID	TBA_SECIDDEF_ID	CHAR	4	0	Security ID Determination Method	TBAC_SDEF_ID
36	PDEF_ID	☐	TBA_PERIODDEF_ID	TBA_PERIODDEF_ID	CHAR	10	0	Period Determination Method	TBAC_PDEF_ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TBAV_DCS_OVRVIEW	CLIENT	T000	MANDT
2	TBAV_DCS_OVRVIEW	COMMODITY_LANGU	T002	SPRAS
3	TBAV_DCS_OVRVIEW	DCSID_LANGU	T002	SPRAS
4	TBAV_DCS_OVRVIEW	DCS_CPE_UOM	T006	MSEHI
5	TBAV_DCS_OVRVIEW	DCS_UOM	T006	MSEHI		1	CN
6	TBAV_DCS_OVRVIEW	MIC_LANGU	T002	SPRAS	KEY	1	CN
7	TBAV_DCS_OVRVIEW	PDEF_ID	TBAC_PDEF_ID	PDEF_ID
8	TBAV_DCS_OVRVIEW	PHYSCOMM_UOM	T006	MSEHI
9	TBAV_DCS_OVRVIEW	QUOT_CURR	TCURC	WAERS		1	CN
10	TBAV_DCS_OVRVIEW	SDEF_ID	TBAC_SDEF_ID	SDEF_ID

History

Last changed by/on	SAP	20141013
SAP Release Created in