I_BrkrRecnclnCmmdtyMaturityCl

DDL: I_BRKRRECNCLNCMMDTYMATURITYCL SQL: IBRRECONMATCL Type: view COMPOSITE

Brkr Recon Commodity Derivitives Cl Data

I_BrkrRecnclnCmmdtyMaturityCl is a Composite CDS View that provides data about "Brkr Recon Commodity Derivitives Cl Data" in SAP S/4HANA. It reads from 1 data source (I_BrkrRecnclnCmmdtyDrvtvClData) and exposes 18 fields with key field SecurityClass.

Data Sources (1)

SourceAliasJoin Type
I_BrkrRecnclnCmmdtyDrvtvClData _SecClass from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBRRECONMATCL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Brkr Recon Commodity Derivitives Cl Data view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass I_BrkrRecnclnCmmdtyDrvtvClData SecurityClass
ContrDrvtvContrMaturityCode _MaturityCode ContrDrvtvContrMaturityCode
ExtListedDerivativeCategory I_BrkrRecnclnCmmdtyDrvtvClData ExtListedDerivativeCategory
OptionType I_BrkrRecnclnCmmdtyDrvtvClData OptionType Option Category
OptionPutCallCode I_BrkrRecnclnCmmdtyDrvtvClData OptionPutCallCode Put/Call
FinancialInstrumentProductType I_BrkrRecnclnCmmdtyDrvtvClData FinancialInstrumentProductType Product Type
UnderlyingSecurityClass I_BrkrRecnclnCmmdtyDrvtvClData UnderlyingSecurityClass
KeyDate I_BrkrRecnclnCmmdtyDrvtvClData KeyDate Maturity Key Date
UnderlyingKeyDate I_BrkrRecnclnCmmdtyDrvtvClData UnderlyingKeyDate Underlying Key Date
BrkrReconciliationStrikePrice I_BrkrRecnclnCmmdtyDrvtvClData BrkrReconciliationStrikePrice
OptionStrikeCurrency I_BrkrRecnclnCmmdtyDrvtvClData OptionStrikeCurrency
CommodityProductSymbol I_BrkrRecnclnCmmdtyDrvtvClData CommodityProductSymbol Product Symbol
FinancialInstrProductCategory I_BrkrRecnclnCmmdtyDrvtvClData FinancialInstrProductCategory
DerivativeContrSpecification I_BrkrRecnclnCmmdtyDrvtvClData DerivativeContrSpecification DCS ID
DerivativeContrSpecName I_BrkrRecnclnCmmdtyDrvtvClData DerivativeContrSpecName
LotSize I_BrkrRecnclnCmmdtyDrvtvClData LotSize Quantity
LotSizeUnitOfMeasure I_BrkrRecnclnCmmdtyDrvtvClData LotSizeUnitOfMeasure Unit of M
UnderlyingCommodityProductSym _UndSecClass CommodityProductSymbol Product Symbol

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BrkrRecnclnCmmdtyMaturityCl.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IBRRECONMATCL

CREATE VIEW I_BrkrRecnclnCmmdtyMaturityCl AS
SELECT
  _SecClass.SecurityClass AS SecurityClass,
  _MaturityCode.ContrDrvtvContrMaturityCode AS ContrDrvtvContrMaturityCode,
  _SecClass.ExtListedDerivativeCategory AS ExtListedDerivativeCategory,
  _SecClass.OptionType AS OptionType,
  _SecClass.OptionPutCallCode AS OptionPutCallCode,
  _SecClass.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _SecClass.UnderlyingSecurityClass AS UnderlyingSecurityClass,
  _SecClass.KeyDate AS KeyDate,
  _SecClass.UnderlyingKeyDate AS UnderlyingKeyDate,
  _SecClass.BrkrReconciliationStrikePrice AS BrkrReconciliationStrikePrice,
  _SecClass.OptionStrikeCurrency AS OptionStrikeCurrency,
  _SecClass.CommodityProductSymbol AS CommodityProductSymbol,
  _SecClass.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _SecClass.DerivativeContrSpecification AS DerivativeContrSpecification,
  _SecClass.DerivativeContrSpecName AS DerivativeContrSpecName,
  _SecClass.LotSize AS LotSize,
  _SecClass.LotSizeUnitOfMeasure AS LotSizeUnitOfMeasure,
  _UndSecClass.CommodityProductSymbol AS UnderlyingCommodityProductSym
FROM I_BrkrRecnclnCmmdtyDrvtvClData AS _SecClass
;