P_ACMMtMStkQltyCharsFinEODVal

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 P_ACMMtMStkQltyCharsFinEODVal.
-- 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: PACMMTMSTKQCFEOD
-- Parameters: P_CompanyCode : bukrs, P_DisplayView : cds_view_uom, P_Language : spras, P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate, P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime, P_MinPriceQuotationDate : cmm_min_price_quotation_date, P_MaxPriceQuotationDate : cmm_max_price_quotation_date, P_MinSubstnPrcQtanDate : cmm_min_sub_price_quote_date, P_MaxSubstnPrcQtanDate : cmm_max_sub_price_quote_date, P_MinExchRateMttyDate : cmm_min_ex_rate_maturity_date, P_MaxExchRateMttyDate : cmm_max_ex_rate_maturity_date, P_MinFwdQuotationDate : cmm_min_fwd_quotation_date, P_MaxFwdQuotationDate : cmm_max_fwd_quotation_date

CREATE VIEW P_ACMMtMStkQltyCharsFinEODVal AS
SELECT
  mtmphy.PricingKey AS PricingKey,
  mtmphy.ACMPricingVersion AS ACMPricingVersion,
  mtmphy.PricingDocumentItem AS PricingDocumentItem,
  mtmphy.ConditionType AS ConditionType,
  mtmphy.SubConditionType AS SubConditionType,
  mtmphy.VersStockRecordUUID AS VersStockRecordUUID,
  mtmphy.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  mtmphy.CompanyCode 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,
  mtmphy.MTMDataSourceType AS MTMDataSourceType,
  mtmphy.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
  mtmphy.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
  mtmphy.SalesOrganization AS SalesOrganization,
  mtmphy.DistributionChannel AS DistributionChannel,
  mtmphy.Division AS Division,
  mtmphy.Creditor AS Creditor,
  mtmphy.SoldToParty AS SoldToParty,
  mtmphy.Material AS Material,
  mtmphy.Plant AS Plant,
  mtmphy.StorageLocation AS StorageLocation,
  mtmphy.Batch AS Batch,
  mtmphy.GoodsMovementType AS GoodsMovementType,
  mtmphy.IncotermsClassification AS IncotermsClassification,
  mtmphy.IncotermsTransferLocation AS IncotermsTransferLocation,
  mtmphy.ConditionApplication AS ConditionApplication,
  mtmphy.ReferenceDocument AS ReferenceDocument,
  mtmphy.ReferenceDocumentItem AS ReferenceDocumentItem,
  mtmphy.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  mtmphy.ExpectedPaymentDate AS ExpectedPaymentDate,
  mtmphy.ExchRateEvaluationDate AS ExchRateEvaluationDate,
  mtmphy.DocToStstcCrcyExchRateEvalDate AS DocToStstcCrcyExchRateEvalDate,
  mtmphy.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  mtmphy.ProfitCenter AS ProfitCenter,
  mtmphy.BusinessArea AS BusinessArea,
  mtmphy.PurchasingOrganization AS PurchasingOrganization,
  mtmphy.MaterialGroup AS MaterialGroup,
  mtmphy.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  mtmphy.MarketToDocFrozenExchRate AS MarketToDocFrozenExchRate,
  mtmphy.BasisID AS BasisID,
  mtmphy.OldestQuotationDate AS OldestQuotationDate,
  mtmphy.SystemMessageNumber AS SystemMessageNumber,
  mtmphy.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  mtmphy.MTMConditionGroup AS MTMConditionGroup,
  mtmphy.MTMCalculationGroup AS MTMCalculationGroup,
  mtmphy.MTMAdjustmentType AS MTMAdjustmentType,
  mtmphy.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  mtmphy.ConditionTermRateFixation AS ConditionTermRateFixation,
  mtmphy.PricingStatus AS PricingStatus,
  mtmphy.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  mtmphy.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  mtmphy.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  mtmphy.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  mtmphy.ExchRateMaturityDate AS ExchRateMaturityDate,
  mtmphy.BsMktRefDrvtvContrMaturityCode AS BsMktRefDrvtvContrMaturityCode,
  mtmphy.BasisMarketRefRate AS BasisMarketRefRate,
  mtmphy.BasisMarketRefRateCurrency AS BasisMarketRefRateCurrency,
  mtmphy.BasisMarketRefKeyDate AS BasisMarketRefKeyDate,
  mtmphy.BasisMarketRefAdjustmentSpread AS BasisMarketRefAdjustmentSpread,
  mtmphy.ConditionTermFactor AS ConditionTermFactor,
  mtmphy.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  mtmphy.PricingProcedure AS PricingProcedure,
  cast(' ' as /accgo/e_ref_vlogp_doc) AS StockRefDocument,
  cast( '000000' as /accgo/e_ref_doc_item) AS StockRefDocumentItem,
  cast( '0000' as mjahr) AS RefDocumentYear,
  cast( ' ' as /accgo/e_vlogp_refdoc_type ) AS StockRefDocType,
  cast( '000000' as /accgo/e_split_line_number ) AS SplitItemLineNumber,
  cast( ' ' as /accgo/e_appldoc ) AS ApplicationDocument,
  cast( '0000000000' as /accgo/e_appldoc_item_num ) AS ApplicationDocumentItem,
  cast( ' ' as /accgo/e_uis_id ) AS LDCId,
  cast( ' ' as /accgo/e_netdry_event) AS LoadDataCaptureEventType,
  cast( ' ' as /accgo/e_driver ) AS CmmdtyTransptDriverID,
  cast( ' ' as /accgo/e_license_plate) AS VehicleLicensePlateNumber,
  cast( ' ' as /accgo/e_veh_no ) AS VehicleId,
  cast( ' ' as /accgo/e_truck_rail_barge_id ) AS TruckRailBargeId,
  cast( ' ' as /accgo/e_vessel_name ) AS CmmdtyTransptVesselID,
  cast( ' ' as /accgo/e_val_sched_charc) AS DiscPremCharcValsInValSchedTxt,
  cast( ' ' as /accgo/e_vol_sched_charc) AS DiscPremCharcValsInVolSchedTxt,
  cast( ' ' as /accgo/e_value_schedule_name) AS DPQSValueScheduleName,
  cast( ' ' as /accgo/e_volume_schedule_name) AS DPQSVolumeScheduleName,
  cast( 0 as /accgo/e_incrtmntl_rate) AS IncrmtlAmtInDocCrcy,
  cast( 0 as /accgo/e_pd_val_in_statcur) AS DiscPremQltyAdjustedVal,
  cast( ' ' as /accgo/cas_relevant) AS NonCASPurIsRlvt,
  cast( ' ' as waerk) AS ConditionRateValueCrcy,
  cast(0 as ftr_valid_from_stmp) AS ValidityStartDateTime,
  cast(0 as ftr_valid_to_stmp) AS ValidityEndDateTime,
  cast('' as ftr_valid_from_time) AS ValidityStartTime,
  cast('' as ftr_valid_to) AS ValidityEndDate,
  cast('' as ftr_valid_to_time) AS ValidityEndTime,
  cast('' as cmm_mtm_version_max) AS MaximumVersion,
  cast (' ' as ftr_exposure_date) AS ExposureDueDate,
  cast('' as ftr_reporting_date) AS ReportingDate,
  cast (' ' as cmm_side) AS CashFlowDirection,
  cast (' ' as tba_tenor) AS TimeToMaturity,
  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_event) AS PnLEventType,
  cast (' ' as tb_dblfz) AS TermStartDate,
  cast (' ' as tb_delfz) AS TermEndDate,
  cast ( 0 as tb_contracts_number) AS NumberOfCommodityContracts,
  cast (' ' as tpm_pos_account_fut) AS TreasuryPositionAccount,
  cast (' ' as ftr_derivative_contract_id) AS DerivativeContract,
  cast ( 0 as cmm_option_strike_price) AS OptionStrikePrice,
  cast (' ' as ti_ofwaers) AS OptionStrikeCurrency,
  cast (' ' as ti_sputcal) AS OptionPutCallCode,
  cast('' as soptaus) AS OptionExerciseType,
  cast (' ' as cds_external_key_figures) AS ExternalKeyFigureValue,
  cast('0' as cmm_eval_option_delta_factor ) AS OptionDeltaFactorKeyFigure,
  cast(' ' as cds_option_delta_factor) AS OptionDeltaFactor,
  $parameters.P_EvaluationDate AS EvaluationDate,
  $parameters.P_MTMDataSelectionType AS MTMDataSelectionType,
  $parameters.P_DisplayView AS DisplayView,
  cast('' as cds_error_description) AS HasErrorDescription,
  mtmphy.PhysicalCommodity AS PhysicalCommodity,
  mtmphy.ValidityStartDate AS ValidityStartDate,
  mtmphy.SourceDocument AS SourceDocument,
  mtmphy.SourceDocumentItem AS SourceDocumentItem,
  mtmphy.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  mtmphy.OriginReferenceDocument AS OriginReferenceDocument,
  mtmphy.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  mtmphy.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  mtmphy.DeliveryDate AS DeliveryDate,
  mtmphy.DeliveryYear AS DeliveryYear,
  mtmphy.DeliveryMonth AS DeliveryMonth,
  mtmphy.DerivativeContrSpecification AS DerivativeContrSpecification,
  mtmphy.MarketIdentifierCode AS MarketIdentifierCode,
  mtmphy.MaturityKeyDate AS MaturityKeyDate,
  mtmphy.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  mtmphy.HasError AS HasError,
  mtmphy.StatisticsCurrency AS StatisticsCurrency,
  mtmphy.ConditionTermValueInStstcCrcy AS ConditionTermValueInStstcCrcy,
  mtmphy.DocumentCurrency AS DocumentCurrency,
  mtmphy.ConditionTermValueInDocCrcy AS ConditionTermValueInDocCrcy,
  cast(' ' as cmm_eval_quot_curr) AS QuotationCurrency,
  cast(0 as cmm_eval_cv_quot_curr) AS RiskAnalyzerKeyFigInQtanCrcy,
  mtmphy.ConditionTermRate AS ConditionTermRate,
  mtmphy.MarketToDocExchRate AS MarketToDocExchRate,
  mtmphy.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  mtmphy.DocToStatisticalExchRate AS DocToStatisticalExchRate,
  mtmphy.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  mtmphy.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  cast( 0 as /accgo/e_gross_qnty ) AS GrossQuantity,
  cast( 0 as /accgo/e_net_quan_comm ) AS NetPriceExpsrQuantity,
  cast( 0 as cds_market_termrate ) AS MarketConditionTermRate,
  cast( ' ' as /accgo/e_pd_rate_currency ) AS PremDiscRateCrcy,
  cast( 0 as /accgo/e_pd_rate ) AS PremDiscRateInValSchedCrcy,
  cast( 0 as /accgo/e_pd_to_doc_exchange ) AS PremDiscToDocExchRate,
  cast( 0 as /accgo/e_market_val_in_statcur ) AS MarketValueInStstcCurrency,
  cast( 0 as /accgo/e_pd_val_in_statcur ) AS PremDiscValueInStstcCurrency,
  cast( 0 as /accgo/e_market_val_in_doccur ) AS MarketValueInDocCurrency,
  cast( 0 as /accgo/e_pd_val_in_doccur) AS PremDiscValueInDocCurrency,
  cast( 0 as /accgo/e_net_val_in_statcur) AS NetValueInStstcCurrency,
  cast( 0 as /accgo/e_net_val_in_doccur) AS NetValueInDocCurrency
FROM P_ACMContractMtMValue
-- UNION ALL with additional select branch(es): P_ACMStkWithQltyCharsMTM
;