I_Cmmdtynapnlvalue

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_Cmmdtynapnlvalue.
-- 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: ICMMNAPNLVALUE
-- Parameters: P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate

CREATE VIEW I_Cmmdtynapnlvalue AS
SELECT
  source.PricingKey AS PricingKey,
  source.Version AS Version,
  source.SourceDocumentItem AS SourceDocumentItem,
  source.ConditionType AS ConditionType,
  source.SubConditionType AS SubConditionType,
  source.ContractConditionType AS ContractConditionType,
  source.MktPricePnLValue AS MktPricePnLValue,
  source.SpreadPnLValue AS SpreadPnLValue,
  source.DocToStstcFXPnLValue AS DocToStstcFXPnLValue,
  source.MktToStstcFXPnLValue AS MktToStstcFXPnLValue,
  source.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  source.ComparCmmdtyQuantityInTermUnit AS ComparCmmdtyQuantityInTermUnit,
  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.MktMarketToDocExchRate AS MktMarketToDocExchRate,
  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.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
  source.ComparMktMarketToStstcExchRate AS ComparMktMarketToStstcExchRate,
  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.PricingDocumentItem AS PricingDocumentItem,
  source.MTMDataSourceType AS MTMDataSourceType,
  source.ValidityStartDate AS ValidityStartDate,
  source.ValidityStartDateTime AS ValidityStartDateTime,
  source.ValidityEndDate AS ValidityEndDate,
  source.ValidityEndDateTime AS ValidityEndDateTime,
  source.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  source.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  source.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  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.SourceDocument AS SourceDocument,
  source.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  source.OriginReferenceDocument AS OriginReferenceDocument,
  source.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  source.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  source.ReferenceDocument AS ReferenceDocument,
  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 ConditionCalculationType,
  source.ConditionRate AS ConditionRate,
  source.ConditionCurrency AS ConditionCurrency,
  source.ConditionQuantity AS ConditionQuantity,
  source.ConditionQuantityUnit AS ConditionQuantityUnit,
  source.ContractConditionTermRate AS ContractConditionTermRate,
  source.ContrConditionTermRateCurrency AS ContrConditionTermRateCurrency,
  source.ComparContrCndnTermRate AS ComparContrCndnTermRate,
  source.ComparContrCndnTrmRateCurrency AS ComparContrCndnTrmRateCurrency,
  source.CalcRlvtContrCndnTrmRateCrcy AS CalcRlvtContrCndnTrmRateCrcy,
  source.CalcRelComparContrCndnTermRate AS CalcRelComparContrCndnTermRate,
  source.CalcRlvtComparCndnTrmRateCrcy AS CalcRlvtComparCndnTrmRateCrcy,
  source.MarketConditionTermRate AS MarketConditionTermRate,
  source.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  source.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  source.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  source.MarketPriceQuantityUnit AS MarketPriceQuantityUnit,
  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.ConditionTermFactor AS ConditionTermFactor,
  source.ComparConditionTermFactor AS ComparConditionTermFactor,
  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.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.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.PnLElementaryEventType AS PnLElementaryEventType,
  source._BasisID AS _BasisID,
  source._CmmdtyMtmMessage AS _CmmdtyMtmMessage,
  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._MktCndnTermRateQuantityUnit AS _MktCndnTermRateQuantityUnit,
  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._PnLEventGroup AS _PnLEventGroup,
  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.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  source.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  source.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  source.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  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_Cmmdtynapnlvalue
LEFT OUTER JOIN E_VersionedLogisticDocument AS _Extension ON PricingKey = _Extension.PricingKey AND Version = _Extension.Version AND SourceDocumentItem = _Extension.PricingDocumentItem AND ConditionType = _Extension.ConditionType AND SubConditionType = _Extension.SubConditionType  -- association [1..1]
;