I_CmmdtyNewActPnLValCube

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_CmmdtyNewActPnLValCube.
-- 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: ICMMNAPNLVALCUB2
-- 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_CmmdtyNewActPnLValCube AS
SELECT
  source.PricingKey AS PricingKey,
  source.LogisticsDocumentVersion AS LogisticsDocumentVersion,
  source.SourceDocumentItem AS SourceDocumentItem,
  source.ConditionType AS ConditionType,
  source.SubConditionType AS SubConditionType,
  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.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  source.CmmdtyEndOfDayBusinessEntyKey AS CmmdtyEndOfDayBusinessEntyKey,
  source.MTMDataSourceType AS MTMDataSourceType,
  source.ValidityStartDate AS ValidityStartDate,
  source.ValidityStartTime AS ValidityStartTime,
  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.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  source.OrignRefDocumentShortNumber AS OrignRefDocumentShortNumber,
  source.OriginReferenceDocument AS OriginReferenceDocument,
  source.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  source.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  source.ReferenceDocumentLongNumber AS ReferenceDocumentLongNumber,
  source.ReferenceDocumentItem AS ReferenceDocumentItem,
  source.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  source.DeliveryDate AS DeliveryDate,
  source.ExpectedPaymentDate AS ExpectedPaymentDate,
  source.DocumentCurrency AS DocumentCurrency,
  source.ProfitCenter AS ProfitCenter,
  source.ControllingArea AS ControllingArea,
  source.BusinessArea AS BusinessArea,
  source.PurchasingOrganization AS PurchasingOrganization,
  source.MaterialGroup AS MaterialGroup,
  source.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  source.ConditionCalculationTypeShort AS ConditionCalculationTypeShort,
  source.ConditionRateAmount AS ConditionRateAmount,
  source.ConditionCurrency AS ConditionCurrency,
  source.ConditionQuantity AS ConditionQuantity,
  source.ConditionQuantityUnit AS ConditionQuantityUnit,
  source.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  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.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  source.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  source.ContractConditionType AS ContractConditionType,
  source.ContractDCS AS ContractDCS,
  source.ContractMarketIdentifierCode AS ContractMarketIdentifierCode,
  source.ContrDrvtvContrMaturityCode AS ContrDrvtvContrMaturityCode,
  source.ContractMaturityKeyDate AS ContractMaturityKeyDate,
  source.ContractBasisType AS ContractBasisType,
  source.ContractBasisID AS ContractBasisID,
  source.ContractQuotationPriceType AS ContractQuotationPriceType,
  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.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.PnLElementaryEventType AS PnLElementaryEventType,
  source.HasError AS HasError,
  source.SystemMessageNumber AS SystemMessageNumber,
  source._CmmdtyMTMMessage AS _CmmdtyMTMMessage,
  source.CommodityUnit AS CommodityUnit,
  source.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  source.MarketPriceQuantityUnit AS MarketPriceQuantityUnit,
  source.StatisticsCurrency AS StatisticsCurrency,
  source.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  source.ContrConditionTermRateCurrency AS ContrConditionTermRateCurrency,
  source.ComparContrCndnTrmRateCurrency AS ComparContrCndnTrmRateCurrency,
  source.CalcRlvtContrCndnTrmRateCrcy AS CalcRlvtContrCndnTrmRateCrcy,
  source.CalcRlvtComparCndnTrmRateCrcy AS CalcRlvtComparCndnTrmRateCrcy,
  source.SpreadCurrency AS SpreadCurrency,
  source.ConditionTermFactor AS ConditionTermFactor,
  source.ComparConditionTermFactor AS ComparConditionTermFactor,
  source.PnLValue AS PnLValue,
  source.MktPricePnLValue AS MktPricePnLValue,
  source.SpreadPnLValue AS SpreadPnLValue,
  source.DocToStstcFXPnLValue AS DocToStstcFXPnLValue,
  source.MktToStstcFXPnLValue AS MktToStstcFXPnLValue,
  source.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  source.CommodityQuantity AS CommodityQuantity,
  source.ComparCmmdtyQuantityInTermUnit AS ComparCmmdtyQuantityInTermUnit,
  source.ConditionTermRate AS ConditionTermRate,
  source.MarketConditionTermRate AS MarketConditionTermRate,
  source.ComparMktConditionTermRate AS ComparMktConditionTermRate,
  source.ContractConditionTermRate AS ContractConditionTermRate,
  source.ComparContrCndnTermRate AS ComparContrCndnTermRate,
  source.ContrSpreadCndnTermRate AS ContrSpreadCndnTermRate,
  source.ComparContrSpreadCndnTermRate AS ComparContrSpreadCndnTermRate,
  source.FixedMktSpreadCndnTermRate AS FixedMktSpreadCndnTermRate,
  source.FloatingMktSpreadCndnTermRate AS FloatingMktSpreadCndnTermRate,
  source.MktMarketToDocExchRate AS MktMarketToDocExchRate,
  source.MktDocToStstcExchRate AS MktDocToStstcExchRate,
  source.ContractMktToDocExchRate AS ContractMktToDocExchRate,
  source.ComparContrMktToDocExchRate AS ComparContrMktToDocExchRate,
  source.ContrDocToStstcExchRate AS ContrDocToStstcExchRate,
  source.ComparContrDocToStstcExchRate AS ComparContrDocToStstcExchRate,
  source.PnLCalculationRelevantQuantity AS PnLCalculationRelevantQuantity,
  source.PnLCalcRelevantMarketQuantity AS PnLCalcRelevantMarketQuantity,
  source.PnLCalculationRelevantValue AS PnLCalculationRelevantValue,
  source.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
  source.ComparMktMarketToStstcExchRate AS ComparMktMarketToStstcExchRate,
  source.CalcRelContrConditionTermRate AS CalcRelContrConditionTermRate,
  source.CalcRelComparContrCndnTermRate AS CalcRelComparContrCndnTermRate,
  source._BasisID AS _BasisID,
  source._CommodityUnit AS _CommodityUnit,
  source._CompanyCode AS _CompanyCode,
  source._ContractDCS AS _ContractDCS,
  source._ContractMarketIdentifierCode AS _ContractMarketIdentifierCode,
  source._ConditionTermRateCurrency AS _ConditionTermRateCurrency,
  source._ContrCndnTermRateCurrency AS _ContrCndnTermRateCurrency,
  source._SpreadCurrency AS _SpreadCurrency,
  source._ConditionTermRateQuantityUnit AS _ConditionTermRateQuantityUnit,
  source._MktCndnTermRateQuantityUnit AS _MktCndnTermRateQuantityUnit,
  source._Creditor AS _Creditor,
  source._DocumentCurrency AS _DocumentCurrency,
  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._PnLElementaryEventType AS _PnLElementaryEventType,
  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.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  source.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  source.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  source.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  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 I_CmmdtyNewActPnLValue
;