SAP ABAP Table TBAS_DCS_OVERVIEW_UI (Overview of Derivative Contract Specifications)
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
⤷ 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_OVERVIEW_UI | Table Relationship Diagram |
Short Description | Overview of Derivative Contract Specifications |
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 | DCSID | TBA_DCSID | TBA_DCSID | CHAR | 6 | 0 | Derivative Contract Specification ID | * | |
2 | DCSID_TXT | TBA_DCSID_TXT | TEXT40 | CHAR | 40 | 0 | Derivative Contract Specification Description | ||
3 | VALIDFROM | TBA_DCS_VALIDFROM | DATE | DATS | 8 | 0 | Derivative Contract Specification: Valid From | ||
4 | .INCLUDE | 0 | 0 | DCS Attribute Structure | |||||
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 | .INCLUDE | 0 | 0 | Derivative Contract Specification Data Structure | |||||
9 | DCS_QNT | TBA_DCS_QNT | MENG13 | QUAN | 13 | 3 | Derivative Contract Specification Quantity | ||
10 | DCS_UOM | TBA_DCS_UOM | MEINS | UNIT | 3 | 0 | Derivative Contract Specification Unit of Measure | T006 | |
11 | DCS_CPE_UOM | TBA_CPEUOM | MEINS | UNIT | 3 | 0 | Commodity Pricing Engine Unit of Measure | T006 | |
12 | QUOT_UOM | TBA_UOM | MEINS | UNIT | 3 | 0 | Quotation Unit of Measure | * | |
13 | QUOT_CURRUNIT | TBA_CURRUNIT | TBA_CURRUNIT | CHAR | 5 | 0 | Currency Unit | ||
14 | QUOT_CURR | TBA_CURRENCY | WAERS | CUKY | 5 | 0 | Quotation Currency | TCURC | |
15 | QUOT_DECIMALS | TBA_NODECIMALS | TBA_NODECIMALS | NUMC | 2 | 0 | Number of Decimal Places | ||
16 | .INCLUDE | 0 | 0 | DCS Attribute Structure Listed Options, Futures | |||||
17 | COMMODITY | TBA_STOEFFCHEN | TBA_STOEFFCHEN | CHAR | 18 | 0 | Physical Commodity | TBAC_PHYSCOMM | |
18 | DCSSYMBL | TBA_DCS_SYMBL | TBA_DCS_SYMBL | CHAR | 4 | 0 | Derivative Contract Specification: Product Symbol | ||
19 | CALENDAR | TBA_PROMPT_DATE_CALENDAR | WFCID | CHAR | 2 | 0 | Prompt Date Calendar | * | |
20 | PDEF_ID | TBA_PERIODDEF_ID | TBA_PERIODDEF_ID | CHAR | 10 | 0 | Period Determination Method | TBAC_PDEF_ID | |
21 | EXPDATELOGIC | TBA_EXPIRATIONDATE | TBA_EXPIRATIONDATE | NUMC | 3 | 0 | Expiration Date Logic | ||
22 | REPDATELOGIC | TBA_REPORTINGDATE | TBA_REPORTINGDATE | NUMC | 3 | 0 | Reporting Date | ||
23 | SDEF_ID | TBA_SECIDDEF_ID | TBA_SECIDDEF_ID | CHAR | 4 | 0 | Security ID Determination Method | TBAC_SDEF_ID | |
24 | UNDERLYING_DCSID | TBA_DCSID_UNDERLYING | TBA_DCSID | CHAR | 6 | 0 | Derivative Contract Specification ID | TBAC_DCS | |
25 | OPTSTYLE | TBA_OPTSTYLE | TBA_OPTSTYLE | NUMC | 1 | 0 | Exercise Type | ||
26 | RETENTION_TIME | TBA_RETENTION_TIME | TBA_RETENTION_TIME | NUMC | 4 | 0 | Retention Period in Days | ||
27 | PDEF_ID_TXT | TBA_PERIODDEF_ID_TXT | TEXT40 | CHAR | 40 | 0 | Period Determination Method Description | ||
28 | SDEF_ID_TXT | TBA_SECIDDEF_ID_TXT | TEXT40 | CHAR | 40 | 0 | Security ID Determination Method Description | ||
29 | COMMODITY_TXT | TBA_STOEFFCHEN_TXT | TEXT40 | CHAR | 40 | 0 | Physical Commodity Description | ||
30 | .INCLUDE | 0 | 0 | User Data | |||||
31 | ENTERED_BY | TBA_CRUSER | SYCHAR12 | CHAR | 12 | 0 | First Entered By | ||
32 | ENTERED_DATE | TBA_CRDAT | DATUM | DATS | 8 | 0 | First Entered on | ||
33 | ENTERED_TIME | TBA_CRTIM | UZEIT | TIMS | 6 | 0 | First Entered at | ||
34 | CHANGED_BY | TBA_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
35 | CHANGED_DATE | TBA_UPDAT | DATUM | DATS | 8 | 0 | Last Changed on | ||
36 | CHANGED_TIME | TBA_UPTIM | UZEIT | TIMS | 6 | 0 | Last Changed at | ||
37 | PHYSCOMM_UOM | TBA_PHYSCOMM_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure of Physical Commodity | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TBAS_DCS_OVERVIEW_UI | COMMODITY | TBAC_PHYSCOMM | COMMODITY | |||
2 | TBAS_DCS_OVERVIEW_UI | DCS_CPE_UOM | T006 | MSEHI | |||
3 | TBAS_DCS_OVERVIEW_UI | DCS_UOM | T006 | MSEHI | 1 | CN | |
4 | TBAS_DCS_OVERVIEW_UI | PDEF_ID | TBAC_PDEF_ID | PDEF_ID | |||
5 | TBAS_DCS_OVERVIEW_UI | QUOT_CURR | TCURC | WAERS | 1 | CN | |
6 | TBAS_DCS_OVERVIEW_UI | SDEF_ID | TBAC_SDEF_ID | SDEF_ID |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in |