SAP ABAP Table TBAV_DCS_OVR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TBAV_DCS_OVR	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	DCS_QNT	☐	TBA_DCS_QNT	MENG13	QUAN	13	3	Derivative Contract Specification Quantity
15	DCS_UOM	☐	TBA_DCS_UOM	MEINS	UNIT	3	0	Derivative Contract Specification Unit of Measure	T006
16	DCS_CPE_UOM	☐	TBA_CPEUOM	MEINS	UNIT	3	0	Commodity Pricing Engine Unit of Measure	T006
17	QUOT_UOM	☐	TBA_UOM	MEINS	UNIT	3	0	Quotation Unit of Measure
18	QUOT_CURRUNIT	☐	TBA_CURRUNIT	TBA_CURRUNIT	CHAR	5	0	Currency Unit
19	QUOT_CURR	☐	TBA_CURRENCY	WAERS	CUKY	5	0	Quotation Currency	TCURC
20	QUOT_DECIMALS	☐	TBA_NODECIMALS	TBA_NODECIMALS	NUMC	2	0	Number of Decimal Places
21	DCSSYMBL	☐	TBA_DCS_SYMBL	TBA_DCS_SYMBL	CHAR	4	0	Derivative Contract Specification: Product Symbol
22	CALENDAR	☐	TBA_PROMPT_DATE_CALENDAR	WFCID	CHAR	2	0	Prompt Date Calendar
23	EXPDATELOGIC	☐	TBA_EXPIRATIONDATE	TBA_EXPIRATIONDATE	NUMC	3	0	Expiration Date Logic
24	REPDATELOGIC	☐	TBA_REPORTINGDATE	TBA_REPORTINGDATE	NUMC	3	0	Reporting Date
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	PHYSCOMM_UOM	☐	TBA_PHYSCOMM_UOM	MEINS	UNIT	3	0	Unit of Measure of Physical Commodity	T006
28	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity
29	PDEF_ID	☐	TBA_PERIODDEF_ID	TBA_PERIODDEF_ID	CHAR	10	0	Period Determination Method	TBAC_PDEF_ID
30	SDEF_ID	☐	TBA_SECIDDEF_ID	TBA_SECIDDEF_ID	CHAR	4	0	Security ID Determination Method	TBAC_SDEF_ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TBAV_DCS_OVR	CLIENT	T000	MANDT
2	TBAV_DCS_OVR	DCS_CPE_UOM	T006	MSEHI
3	TBAV_DCS_OVR	DCS_UOM	T006	MSEHI		1	CN
4	TBAV_DCS_OVR	PDEF_ID	TBAC_PDEF_ID	PDEF_ID
5	TBAV_DCS_OVR	PHYSCOMM_UOM	T006	MSEHI
6	TBAV_DCS_OVR	QUOT_CURR	TCURC	WAERS		1	CN
7	TBAV_DCS_OVR	SDEF_ID	TBAC_SDEF_ID	SDEF_ID

History

Last changed by/on	SAP	20140802
SAP Release Created in