TBAC_DCS_LOF
Derivative Contrac Specification for Listed Options, Futures
TBAC_DCS_LOF is an SAP database table in S/4HANA. Derivative Contrac Specification for Listed Options, Futures. It contains 18 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /dmbe/i_Cpe_Dcs_Commodity | view | from | DCS for Listed Options, Futures | |
| /dmbe/i_Cpe_Maturity_KeyDate | view | inner | Maturity Key Date | |
| I_BrkrRecnclnContrSpecOptnFutr | view | from | BASIC | Brkr Recon Contr Spec for Opt and Futr |
| I_CmmdtyDrvtvContrMicPhys | view | left_outer | BASIC | View for DCS, MIC and Commodity |
| I_CmmdtyDrvtvContrSpecAttrib | view | from | BASIC | Basic View Drvtv Contr Spec Attributes |
| I_COND_HEADER | view | left_outer | COMPOSITE |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | dcsid | TBA_DCSID | DCS ID | |||
| commodity | TBA_STOEFFCHEN | Commodity | ||||
| dcssymbl | TBA_DCS_SYMBL | Product Symbol | ||||
| calendar | TBA_PROMPT_DATE_CALENDAR | Prompt Date Cal. | ||||
| pdef_id | TBA_PERIODDEF_ID | Period Determination | ||||
| expdatelogic | TBA_EXPIRATIONDATE | Exp. Date Logic | ||||
| repdatelogic | TBA_REPORTINGDATE | Reporting Date | ||||
| sdef_id | TBA_SECIDDEF_ID | Sec. ID Determin. | ||||
| underlying_dcsid | TBA_DCSID_UNDERLYING | Underlying DCS | ||||
| optstyle | TBA_OPTSTYLE | Exercise Type | ||||
| retention_time | TBA_RETENTION_TIME | Retention Period | ||||
| publication_calendar | SKALID | Calendar | ||||
| timing | CMM_TIMING | Timing | ||||
| pricetype | TBA_PRICETYPE | Price Type | ||||
| opttyp | CMM_OPTTYP | Option Category | ||||
| flt_prc | CMM_FLT_PRC | Floating Price Def. | ||||
| common_pricing | CMM_COMMON_PRICING | Common Pricing |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derivative Contrac Specification for Listed Options, Futures
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBAC_DCS_LOF (
CLIENT, -- Client [MANDT]
DCSID, -- DCS ID [TBA_DCSID]
COMMODITY, -- Commodity [TBA_STOEFFCHEN]
DCSSYMBL, -- Product Symbol [TBA_DCS_SYMBL]
CALENDAR, -- Prompt Date Cal. [TBA_PROMPT_DATE_CALENDAR]
PDEF_ID, -- Period Determination [TBA_PERIODDEF_ID]
EXPDATELOGIC, -- Exp. Date Logic [TBA_EXPIRATIONDATE]
REPDATELOGIC, -- Reporting Date [TBA_REPORTINGDATE]
SDEF_ID, -- Sec. ID Determin. [TBA_SECIDDEF_ID]
UNDERLYING_DCSID, -- Underlying DCS [TBA_DCSID_UNDERLYING]
OPTSTYLE, -- Exercise Type [TBA_OPTSTYLE]
RETENTION_TIME, -- Retention Period [TBA_RETENTION_TIME]
PUBLICATION_CALENDAR, -- Calendar [SKALID]
TIMING, -- Timing [CMM_TIMING]
PRICETYPE, -- Price Type [TBA_PRICETYPE]
OPTTYP, -- Option Category [CMM_OPTTYP]
FLT_PRC, -- Floating Price Def. [CMM_FLT_PRC]
COMMON_PRICING, -- Common Pricing [CMM_COMMON_PRICING]
PRIMARY KEY (CLIENT, DCSID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA