I_CmmdtyBeginPosPnLValue

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_CmmdtyBeginPosPnLValue.
-- 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: ICMMBPPNLVAL
-- Parameters: P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate, 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 I_CmmdtyBeginPosPnLValue AS
SELECT
  source.PricingKey AS PricingKey,
  source.Version AS LogisticsDocumentVersion,
  source.PricingDocumentItem AS PricingDocumentItem,
  source.ConditionType AS ConditionType,
  source.SubConditionType AS SubConditionType,
  source.VersStockRecordUUID AS VersStockRecordUUID,
  source.PnLValue AS PnLValue,
  source.MktPricePnLValue AS MktPricePnLValue,
  source.SpreadPnLValue AS SpreadPnLValue,
  source.DocToStstcFXPnLValue AS DocToStstcFXPnLValue,
  source.MktToStstcFXPnLValue AS MktToStstcFXPnLValue,
  source.MktValAdjmtFXBroughtFwdVal AS MktValAdjmtFXBroughtFwdVal,
  source.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  source.MarketConditionTermRate AS MarketConditionTermRate,
  source.ComparMktConditionTermRate AS ComparMktConditionTermRate,
  source.ContrSpreadCndnTermRate AS ContrSpreadCndnTermRate,
  source.ComparContrSpreadCndnTermRate AS ComparContrSpreadCndnTermRate,
  source.FixedMktSpreadCndnTermRate AS FixedMktSpreadCndnTermRate,
  source.FloatingMktSpreadCndnTermRate AS FloatingMktSpreadCndnTermRate,
  source.SpreadCurrency AS SpreadCurrency,
  source.MktDocToStstcExchRate AS MktDocToStstcExchRate,
  source.ComparMktDocToStstcExchRate AS ComparMktDocToStstcExchRate,
  source.MktMarketToDocExchRate AS MktMarketToDocExchRate,
  source.ComparMktMarketToDocExchRate AS ComparMktMarketToDocExchRate,
  source.ContractMktToDocExchRate AS ContractMktToDocExchRate,
  source.MktAdjmtValDocToStstcExchRate AS MktAdjmtValDocToStstcExchRate,
  source.MktAdjmtValueCndnTermValue AS MktAdjmtValueCndnTermValue,
  source.PnLCalculationRelevantQuantity AS PnLCalculationRelevantQuantity,
  source.PnLCalculationRelevantValue AS PnLCalculationRelevantValue,
  source.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
  source.ComparMktMarketToStstcExchRate AS ComparMktMarketToStstcExchRate,
  source.ContractConditionTermRate AS ContractConditionTermRate,
  source.ComparContrCndnTermRate AS ComparContrCndnTermRate,
  source.ComparCmmdtyQuantityInTermUnit AS ComparCmmdtyQuantityInTermUnit,
  source.EvaluationDate AS EvaluationDate,
  source.ComparativeEvaluationDate AS ComparativeEvaluationDate,
  source.MarketDCS AS MarketDCS,
  source.MktMarketIdentifierCode AS MktMarketIdentifierCode,
  source.MktDrvtvContrMaturityCode AS MktDrvtvContrMaturityCode,
  source.MktMaturityKeyDate AS MktMaturityKeyDate,
  source.MarketBasisType AS MarketBasisType,
  source.MarketBasisID AS MarketBasisID,
  source.MktQuotationPriceType AS MktQuotationPriceType,
  source.HasError AS HasError,
  source.SystemMessageNumber AS SystemMessageNumber,
  source.MTMDataSourceType AS MTMDataSourceType,
  source.ValidityStartDate AS ValidityStartDate,
  source.ValidityStartDateTime AS ValidityStartTime,
  source.ValidityEndDate AS ValidityEndDate,
  source.ValidityEndDateTime AS ValidityEndTime,
  source.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  source.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  source.EndOfDayBusinessEntityKey AS CmmdtyEndOfDayBusinessEntyKey,
  source.CompanyCode AS CompanyCode,
  source.SalesOrganization AS SalesOrganization,
  source.DistributionChannel AS DistributionChannel,
  source.Division AS Division,
  source.Creditor AS Creditor,
  source.SoldToParty AS SoldToParty,
  source.Material AS Material,
  source.Commodity AS Commodity,
  source.Plant AS Plant,
  source.StorageLocation AS StorageLocation,
  source.Batch AS Batch,
  source.IncotermsClassification AS IncotermsClassification,
  source.IncotermsTransferLocation AS IncotermsTransferLocation,
  source.ConditionApplication AS ConditionApplication,
  source.SourceDocumentShortNumber AS SourceDocumentShortNumber,
  source.SourceDocument AS SourceDocument,
  source.SourceDocumentItem AS SourceDocumentItem,
  source.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  source.OrignRefDocumentShortNumber AS OrignRefDocumentShortNumber,
  source.OriginReferenceDocument AS OriginReferenceDocument,
  source.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  source.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  source.ReferenceDocument AS ReferenceDocumentLongNumber,
  source.ReferenceDocumentItem AS ReferenceDocumentItem,
  source.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  source.DeliveryDate AS DeliveryDate,
  source.ExpectedPaymentDate AS ExpectedPaymentDate,
  source.StatisticsCurrency AS StatisticsCurrency,
  source.DocumentCurrency AS DocumentCurrency,
  source.ProfitCenter AS ProfitCenter,
  source.BusinessArea AS BusinessArea,
  source.PurchasingOrganization AS PurchasingOrganization,
  source.MaterialGroup AS MaterialGroup,
  source.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  source.ConditionCalculationType AS ConditionCalculationTypeShort,
  source.ConditionRate AS ConditionRateAmount,
  source.ConditionCurrency AS ConditionCurrency,
  source.ConditionQuantity AS ConditionQuantity,
  source.ConditionQuantityUnit AS ConditionQuantityUnit,
  source.ConditionTermRate AS ConditionTermRate,
  source.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  source.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  source.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  source.ConditionTermValue AS ConditionTermValue,
  source.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  source.ConditionTermName AS ConditionTermName,
  source.ConditionTermStatus AS ConditionTermStatus,
  source.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  source.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
  source.ConditionTermRateNmrtr AS ConditionTermRateNmrtr,
  source.ConditionTermRateDnmntr AS ConditionTermRateDnmntr,
  source.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  source.MaturitySelectionType AS MaturitySelectionType,
  source.ExchRateMaturityDate AS ExchRateMaturityDate,
  source.FixedExchRateDate AS FixedExchRateDate,
  source.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  source.QuotationKeyType AS QuotationKeyType,
  source.QuotationDateList AS QuotationDateList,
  source.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  source.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  source.ComparativeMarketDCS AS ComparativeMarketDCS,
  source.ComparMktMarketIdentifierCode AS ComparMktMarketIdentifierCode,
  source.ComparMktMaturityKeyDate AS ComparMktMaturityKeyDate,
  source.ComparMktDrvtvContrCode AS ComparMktDrvtvContrCode,
  source.ComparMarketBasisID AS ComparMarketBasisID,
  source.ComparMarketBasisType AS ComparMarketBasisType,
  source.ComparMktQuotationPriceType AS ComparMktQuotationPriceType,
  source.ComparQtanPeriodReferenceDate AS ComparQtanPeriodReferenceDate,
  source.QuotationGroup AS QuotationGroup,
  source.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  source.ConditionTermRateFixation AS ConditionTermRateFixation,
  source.PricingStatus AS PricingStatus,
  source.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  source.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  source.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  source.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  source.CommodityQuantity AS CommodityQuantity,
  source.CommodityUnit AS CommodityUnit,
  source.QuantitySign AS QuantitySign,
  source.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  source.MTMConditionGroup AS MTMConditionGroup,
  source.MTMCalculationGroup AS MTMCalculationGroup,
  source.MTMAdjustmentType AS MTMAdjustmentType,
  source.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  source.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  source.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  source.PriceIsRealized AS PriceIsRealized,
  source.PnLEventGroup AS PnLEventGroup,
  source.PnLEventCategory AS PnLEventCategory,
  source.PnLEventType AS PnLEventType,
  source.ConditionTermFactor AS ConditionTermFactor,
  source.ComparConditionTermFactor AS ComparConditionTermFactor,
  source.ControllingArea AS ControllingArea,
  source._BasisID AS _BasisID,
  source._CmmdtyMTMMessage AS _CmmdtyMTMMessage,
  source._CommodityUnit AS _CommodityUnit,
  source._CompanyCode AS _CompanyCode,
  source._ComparativeMarketDCS AS _ComparativeMarketDCS,
  source._ComparMktMarketIdentifierCode AS _ComparMktMarketIdentifierCode,
  source._ConditionTermRateCurrency AS _ConditionTermRateCurrency,
  source._ConditionTermRateQuantityUnit AS _ConditionTermRateQuantityUnit,
  source._Creditor AS _Creditor,
  source._DocumentCurrency AS _DocumentCurrency,
  source._SpreadCurrency AS _SpreadCurrency,
  source._IncotermsClassification AS _IncotermsClassification,
  source._MarketDCS AS _MarketDCS,
  source._Material AS _Material,
  source._MktMarketIdentifierCode AS _MktMarketIdentifierCode,
  source._MTMAdjustmentType AS _MTMAdjustmentType,
  source._MTMCalculationGroup AS _MTMCalculationGroup,
  source._MTMConditionGroup AS _MTMConditionGroup,
  source._MTMConditionGroupCategory AS _MTMConditionGroupCategory,
  source._MTMDataSourceType AS _MTMDataSourceType,
  source._OriginReferenceDocBusObjType AS _OriginReferenceDocBusObjType,
  source._Commodity AS _Commodity,
  source._Plant AS _Plant,
  source._PnLEventCategory AS _PnLEventCategory,
  source._PnLEventType AS _PnLEventType,
  source._PricingStatus AS _PricingStatus,
  source._ReferenceDocBusObjType AS _ReferenceDocBusObjType,
  source._SoldToParty AS _SoldToParty,
  source._SourceDocumentBusObjType AS _SourceDocumentBusObjType,
  source._StatisticsCurrency AS _StatisticsCurrency,
  source._StorageLocation AS _StorageLocation,
  source._ProfitCenter AS _ProfitCenter,
  source._ControllingArea AS _ControllingArea,
  source.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  source.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  source.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  source.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  source.MarketToTermExchangeRateType AS MarketToTermExchangeRateType,
  source.CndnToStstcExchangeRateType AS CndnToStstcExchangeRateType,
  source.ConditionToDocExchangeRateType AS ConditionToDocExchangeRateType,
  source.DocToStstcExchangeRateType AS DocToStstcExchangeRateType,
  source.PriceSettingMethod AS PriceSettingMethod,
  source.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  source.ValidToDateTime AS ValidToDateTime,
  source.PricingProcedure AS PricingProcedure,
  source.PricingConditionTerm AS PricingConditionTerm,
  source.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
  source.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber
FROM P_CmmdtyBPPnLValue_2
LEFT OUTER JOIN I_PnLEventGroup AS _PnLEventGroup ON PnLEventGroup = _PnLEventGroup.PnLEventGroup  -- association [1..1]
LEFT OUTER JOIN E_VersionedLogisticDocument AS _Extension ON PricingKey = _Extension.PricingKey AND LogisticsDocumentVersion = _Extension.Version AND PricingDocumentItem = _Extension.PricingDocumentItem AND ConditionType = _Extension.ConditionType AND SubConditionType = _Extension.SubConditionType  -- association [1..1]
LEFT OUTER JOIN E_Vlogpkonvd AS _Extension_Konvd ON PricingKey = _Extension_Konvd.PricingKey AND PricingDocumentItem = _Extension_Konvd.PricingDocumentItem AND ConditionType = _Extension_Konvd.ConditionType AND SubConditionType = _Extension_Konvd.SubConditionType AND VersStockRecordUUID = _Extension_Konvd.VersStockRecordUUID  -- association [1..1]
;