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_CmmdtyHedgeExposurePosition.
-- 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: IEXPPOSITION
-- Parameters: P_EvalDate : cds_evaluation_date, P_CompanyCode : bukrs, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cmm_vlogp_consumptiontype
CREATE VIEW I_CmmdtyHedgeExposurePosition AS
SELECT
exp.CmmdtyHdgPlnExpsrCompanyCode AS CompanyCode,
cast( '' as ftr_cty_expos_id ) AS CommodityPriceExposure,
cast( '' as cmm_vfind_exposure_cat ) AS CommodityExposureCategory,
cast( '' as cmm_vfind_exposure_subkey ) AS CommodityPriceSubExposure,
exp.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
cast( concat( '0000', exp.CmmdtyHedgePlanExposureVersion ) as ftr_cty_expos_version ) AS CommodityPriceExposureVersion,
cast('' as abap.char(5) ) AS CommodityViewTypeText,
cast('' as abap.char(1) ) AS CommodityViewSelectionType,
cast( cast( concat( exp.CmmdtyHdgPlnExpsrValidFromDate, '000000' ) as abap.numc( 15 ) ) as ftr_valid_from_stmp ) AS ValidityStartDateTime,
cast( '0' as ftr_valid_to_stmp ) AS ValidityEndDateTime,
exp.CmmdtyHdgPlnExpsrValidFromDate AS ValidityStartDate,
cast( '000000' as ftr_valid_from_time ) AS ValidityStartTime,
cast( '00000000' as ftr_valid_to ) AS ValidityEndDate,
cast( '000000' as ftr_valid_to_time ) AS ValidityEndTime,
cast( '0000000000' as cmm_mtm_version_max ) AS MaximumVersion,
cast( hextobin( '00000000000000000000000000000000' ) as cmm_vfind_version_guid ) AS RiskAnalyzerVersionUUID,
cal.CalendarDate AS ExposureDueDate,
cast( '00000000' as ftr_reporting_date ) AS ReportingDate,
exp.PhysicalCommodity AS Commodity,
cast( '' as fclm_direction ) AS CashFlowDirection,
cast( '' as ftr_gen_long_short_code ) AS TreasuryPositionLongShortCode,
exp.CmmdtyHedgePlanExposureDCSID AS DerivativeContrSpecification,
exp.CmmdtyHdgPlanExpsrMktIDCode AS MarketIdentifierCode,
cast( '' as tba_tenor ) AS TimeToMaturity,
cast( '' as tba_timing ) AS CmmdtyForwardIndexTiming,
cast( '00000000' as tba_keydate ) AS MaturityKeyDate,
cast( '' as tba_contract_code ) AS DerivativeContractMaturityCode,
cast( '' as sanlf ) AS FinancialInstrProductCategory,
cast( '' as vvsart ) AS FinancialAssetsMgmtProductType,
cast( '' as tb_sfgtyp ) AS FinInstrTransactionCategory,
cast( '' as tb_sfhaart ) AS FinancialInstrumentProductType,
cast( '' as tb_sfgzuty ) AS FinancialInstrActivityCategory,
cast( '' as ftr_objnr ) AS FinancialObject,
cast( '' as cmm_error_flag ) AS HasError,
cast('' as abap.char(3) ) AS SystemMessageNumber,
cast( '00000000' as tb_dblfz ) AS TermStartDate,
cast( '00000000' as tb_delfz ) AS TermEndDate,
cast( '00000000' as ftr_delivery_date ) AS DeliveryDate,
cast( '0' as tb_contracts_number ) AS NumberOfCommodityContracts,
cast( '' as domvalue_l ) AS CommodityPriceFixationStatus,
cast( '' as tpm_pos_account_fut ) AS TreasuryPositionAccount,
cast( '' as ftr_derivative_contract_id ) AS DerivativeContract,
cast( '0' as tb_cty_strike_price ) AS OptionStrikePrice,
cast( '' as ti_ofwaers ) AS OptionStrikeCurrency,
cast( '' as ti_sputcal ) AS OptionPutCallCode,
cast( '' as soptaus) AS OptionExerciseType,
cast ( 0.00 as rdb_keyfvalue ) AS RiskAnalyzerKeyFigureFactor,
cast('' as cds_external_key_figures) AS ExternalKeyFigureValue,
cast('' as char3) AS OptionDeltaFactor,
cast( hextobin( '0000000000000000000000000000000000000000' ) as cmm_dend_entity_key ) AS EndOfDayBusinessEntityKey,
cast(substring(cast( '00000000' as ftr_reporting_date ) , 5, 2)as cds_reporting_month) AS ReportingMonth,
cast(substring(cast( '00000000' as ftr_reporting_date ) , 1, 4) as cds_reporting_year) AS ReportingYear,
EvaluationDate,
cast ($parameters.P_EvalDate as cmm_dend_cutdate ) AS EndOfDaySnapshotDate,
cast ( 0 as cmm_dend_tmstmp) AS EndOfDaySnapshotDateTime,
cast ('' as cmm_vlogp_consumptiontype ) AS MTMDataSelectionType,
cast ('' as cds_view_uom ) AS DisplayView,
division ( exp.CmmdtyHedgePlnExposureQuantity,exp.CmmdtyHdgNmbrOfWrkDayPrcgPerd, 3 ) AS CommodityPriceExposureQuantity,
exp.CmmdtyHdgPlnExpsrQuantityUnit AS CommodityPriceExposureUnit,
cast ( '0' as cds_due_past_unpriced_fin_qty ) AS DueInPastUnpricedFinPosQty,
cast ( '0' as cds_due_cls_unpriced_fin_qty ) AS DueMktOnClsUnpricedFinPosQty,
cast ( '0' as cds_due_fut_unpriced_fin_qty ) AS DueInFutureUnpricedFinPosQty,
cast( '0' as cds_unpriced_cntrct_exp_qty) AS UnpricedContrPriceExposureQty,
cast( '0' as cds_undlvrd_mkt_pr_exp_qty) AS UndeliveredMarketPrExposureQty,
cast( 0 as abap.quan( 31, 14 )) AS OutrightPriceExposureQty,
cast( 0 as abap.quan( 13, 3 )) AS FinancialPositionQty,
cast('' as tb_nordext ) AS FinInstrExternalReference,
cast('' as abap.char(20) ) AS TradedDrvtvContrSpecification,
cast('' as abap.char(20) ) AS ParDrvtvContractSpecification,
cast('' as abap.char(1) ) AS RiskViewIsNotRelevant,
exp.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
exp.CmmdtyHdgPlanExposurePortfolio AS CmmdtyHdgPlanExposurePortfolio,
exp.CmmdtyHdgPlnExpsrPrcgStartDate AS CalculationPeriodStartDate,
exp.CmmdtyHdgPlnExpsrPrcgEndDate AS CalculationPeriodEndDate,
exp._CompanyCode AS _CompanyCode
FROM I_CmmdtyHdgExpsrPositionCount
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentifierCode ON MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode -- association [0..1]
LEFT OUTER JOIN I_Cmmdty AS _PhysicalCommodity ON Commodity = _PhysicalCommodity.Commodity -- association [0..1]
LEFT OUTER JOIN I_CmmdtyPriceFixationStatus AS _CommodityPriceFixationStatus ON CommodityPriceFixationStatus = _CommodityPriceFixationStatus.CommodityPriceFixationStatus -- association [0..1]
LEFT OUTER JOIN I_FinAssetsMgntProductType AS _FinAssetsMgmtProductType ON FinancialAssetsMgmtProductType = _FinAssetsMgmtProductType.FinancialAssetsMgmtProductType -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CommodityPriceExposureUnit = _UnitOfMeasure.UnitOfMeasure -- association [0..1]
;