C_CmmdtyPosCurrentDateQry_2

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 C_CmmdtyPosCurrentDateQry_2.
-- 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: CCMMPOSCURQRY2
-- Parameters: P_MTMDataSelectionType : cmm_vlogp_posrep_consump_type, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_DisplayUnitOfMeasure : cds_posrep_view_uom, P_Language : spras, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime, P_MinEODaySnapshotDate : cmm_min_eod_snapshot_date, P_MinPriceQuotationDate : cmm_min_price_quotation_date, P_MaxPriceQuotationDate : cmm_max_price_quotation_date

CREATE VIEW C_CmmdtyPosCurrentDateQry_2 AS
SELECT
  resultElement: 'MinimumEndOfDayFromDateTime' AS resultElementMinimumEndOfDayFromDateTime,
  resultElement: 'MaximumEndOfDayToDateTime' AS resultElementMaximumEndOfDayToDateTime,
  resultElement: 'MinimumEndOfDaySnapshotDate' AS resultElementMinimumEndOfDaySnapshotDate,
  resultElement: 'MinimumPriceQuotationDate' AS resultElementMinimumPriceQuotationDate,
  resultElement: 'MaximumPriceQuotationDate' AS resultElementMaximumPriceQuotationDate,
  P_OptionDeltaMethod : '2' AS P_OptionDeltaMethod2,
  P_OptionDeltaThreshold : 1 AS P_OptionDeltaThreshold1,
  PricingKey,
  ConditionType,
  EvaluationDate,
  CompanyCode,
  CommodityExposureCategory,
  vlogp.EndOfDaySnapshotFromDate AS EndOfDaySnapshotFromDate,
  vlogp.EndOfDaySnapshotToDate AS EndOfDaySnapshotToDate,
  vlogp.MTMDataSelectionType AS MTMDataSelectionType,
  vlogp.MTMDataSourceType AS MTMDataSourceType,
  vlogp.FinInstrExternalReference AS FinInstrExternalReference,
  vlogp.DistributionChannel AS DistributionChannel,
  vlogp.Division AS Division,
  vlogp.Creditor AS Creditor,
  vlogp.SoldToParty AS SoldToParty,
  vlogp.PhysicalCommodity AS PhysicalCommodity,
  vlogp.Material AS Material,
  vlogp.Plant AS Plant,
  vlogp.StorageLocation AS StorageLocation,
  vlogp.Batch AS Batch,
  vlogp.IncotermsClassification AS IncotermsClassification,
  vlogp.IncotermsTransferLocation AS IncotermsTransferLocation,
  vlogp.ConditionApplication AS ConditionApplication,
  vlogp.SourceDocumentShortNumber AS SourceDocumentShortNumber,
  vlogp.SourceDocumentItem AS SourceDocumentItem,
  _SourceDocumentBusObjType._Text[1:Language = :P_Language].BusinessObjectTypeName AS SourceDocumentBusObjTypeName,
  vlogp.OriginReferenceDocument AS OriginReferenceDocument,
  vlogp.OrignRefDocumentShortNumber AS OrignRefDocumentShortNumber,
  vlogp.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  vlogp.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  vlogp.ReferenceDocumentLongNumber AS ReferenceDocumentLongNumber,
  vlogp.ReferenceDocumentItem AS ReferenceDocumentItem,
  vlogp.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  vlogp.DeliveryDate AS DeliveryDate,
  vlogp.ExpectedPaymentDate AS ExpectedPaymentDate,
  ProfitCenterName,
  vlogp.BusinessArea AS BusinessArea,
  vlogp.PurchasingOrganization AS PurchasingOrganization,
  vlogp.MaterialGroup AS MaterialGroup,
  vlogp.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  vlogp.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  vlogp.TimeToMaturity AS TimeToMaturity,
  vlogp.CmmdtyForwardIndexTimingText AS CmmdtyForwardIndexTimingText,
  vlogp.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  vlogp.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  vlogp.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  vlogp.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  vlogp.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  vlogp.OptionStrikeCurrencyUnit AS OptionStrikeCurrencyUnit,
  vlogp.OptionStrikeAmount AS OptionStrikeAmount,
  vlogp.OptionPutCallCode AS OptionPutCallCode,
  vlogp.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  vlogp.OptionDeltaFactor AS OptionDeltaFactor,
  vlogp.DerivativeContrSpecification AS DerivativeContrSpecification,
  vlogp.MarketIdentifierCode AS MarketIdentifierCode,
  vlogp.MaturityKeyDate AS MaturityKeyDate,
  vlogp.CommodityUnit AS CommodityUnit,
  vlogp.PriceIsRealized AS PriceIsRealized,
  vlogp.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
  vlogp.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  MaterialStockPriceExposureUnit,
  UnpricedDeliveredCtrExpsrQty,
  UnpricedContrPriceExposureQty,
  PricedUndeliveredContrExpsrQty,
  PricedDeliveredContrExpsrQty,
  PricedContractsExposureQty,
  TodayPricedUndeliveredExpsrQty,
  UndeliveredMarketPrExposureQty,
  DeliveredMarketPrExposureQty,
  UnrlzdMarketPriceExposureQty,
  UnrealizedGoodsRcptPrcExpsrQty,
  UnrealizedGoodsIssPrcExpsrQty,
  MaterialStockExposureQty,
  RealizedMaterialStkPrcExpsrQty,
  OutrightPriceExposureQty,
  vlogp.AdjustedReportingDate AS AdjustedReportingDate,
  vlogp.AdjustedReportingYear AS AdjustedReportingYear,
  vlogp.AdjustedReportingMonth AS AdjustedReportingMonth,
  _CmmdtyMtmMessage[1:Language = :P_Language].SystemMessageText AS SystemMessageText,
  vlogp.HasError AS HasError,
  vlogp.PriceSettingMethod AS PriceSettingMethod,
  vlogp.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  vlogp.ValidToDateTime AS ValidToDateTime,
  vlogp.PricingProcedure AS PricingProcedure,
  vlogp.PricingConditionTerm AS PricingConditionTerm
FROM I_CmmdtyPositionRepQtyCube_2
;