P_Cmmdtynewactpnlvalue_Calc2

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

CREATE VIEW P_Cmmdtynewactpnlvalue_Calc2 AS
SELECT
  source.PricingKey AS PricingKey,
  source.Version AS Version,
  source.PricingDocumentItem AS PricingDocumentItem,
  source.ConditionType AS ConditionType,
  source.SubConditionType AS SubConditionType,
  source.PriceSetValue AS PriceSetValue,
  source.PriceRemoveValue AS PriceRemoveValue,
  source.OldQuantityPriceSetValue AS OldQuantityPriceSetValue,
  source.OldQuantityPriceRemoveValue AS OldQuantityPriceRemoveValue,
  source.PriceSetMktAdjmtValue AS PriceSetMktAdjmtValue,
  source.PriceRemoveMktAdjmtValue AS PriceRemoveMktAdjmtValue,
  source.FXRemoveMktAdjmtValue AS FXRemoveMktAdjmtValue,
  source.OldQtyPriceSetMktAdjmtValue AS OldQtyPriceSetMktAdjmtValue,
  source.OldQtyFXSetMktAdjmtValue AS OldQtyFXSetMktAdjmtValue,
  source.OldQtyPriceRemoveMktAdjmtValue AS OldQtyPriceRemoveMktAdjmtValue,
  source.OldQtyFXRemoveMktAdjmtValue AS OldQtyFXRemoveMktAdjmtValue,
  source.ContractConditionType AS ContractConditionType,
  source.ContrConditionTermRateCurrency AS ContrConditionTermRateCurrency,
  source.ComparativeCndnTrmRateIsFixed AS ComparativeCndnTrmRateIsFixed,
  source.ContractConditionTermRate AS ContractConditionTermRate,
  source.ComparContrCndnTermRate AS ComparContrCndnTermRate,
  source.CalcRelContrConditionTermRate AS CalcRelContrConditionTermRate,
  source.MarketAdjustmentValueRate AS MarketAdjustmentValueRate,
  source.ComparMktAdjmtValCndnTermValue AS ComparMktAdjmtValCndnTermValue,
  source.MarketAdjustmentValueCurrency AS MarketAdjustmentValueCurrency,
  source.FloatingMktSpreadCndnTermRate AS FloatingMktSpreadCndnTermRate,
  source.FixedMktSpreadCndnTermRate AS FixedMktSpreadCndnTermRate,
  source.MktMarketToDocExchRate AS MktMarketToDocExchRate,
  source.SpreadMarketToDocExchRate AS SpreadMarketToDocExchRate,
  source.SpreadMarketToStstcExchRate AS SpreadMarketToStstcExchRate,
  source.MktDocToStstcExchRate AS MktDocToStstcExchRate,
  source.ContrTrmExchRateIsFxd AS ContrTrmExchRateIsFxd,
  source.ComparCndnTrmExchRateIsFxd AS ComparCndnTrmExchRateIsFxd,
  source.ContractMktToDocExchRate AS ContractMktToDocExchRate,
  source.ComparContrMktToDocExchRate AS ComparContrMktToDocExchRate,
  source.ContrDocToStstcExchRate AS ContrDocToStstcExchRate,
  source.ContrMarketToStstcExchRate AS ContrMarketToStstcExchRate,
  source.ComparContrDocToStstcExchRate AS ComparContrDocToStstcExchRate,
  source.PnlEventGroup AS PnlEventGroup,
  source.ComparativeEvaluationDate AS ComparativeEvaluationDate,
  source.ContrCmmdtyQtyInTermUnit AS ContrCmmdtyQtyInTermUnit,
  source.ComparContrCmmdtyQtyInTrmUnit AS ComparContrCmmdtyQtyInTrmUnit,
  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.PhysicalCommodity AS PhysicalCommodity,
  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.SourceDocumentItem AS SourceDocumentItem,
  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.QuotationPriceType AS QuotationPriceType,
  source.ConditionTermRate AS ConditionTermRate,
  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.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.ContractDCS AS ContractDCS,
  source.ContractMarketIdentifierCode AS ContractMarketIdentifierCode,
  source.ContractMaturityKeyDate AS ContractMaturityKeyDate,
  source.ContrDrvtvContrMaturityCode AS ContrDrvtvContrMaturityCode,
  source.ContractBasisID AS ContractBasisID,
  source.ContractBasisType AS ContractBasisType,
  source.ContractQuotationPriceType AS ContractQuotationPriceType,
  source.QuotationGroup AS QuotationGroup,
  source.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  source.ConditionTermRateFixation AS ConditionTermRateFixation,
  source.PricingStatus AS PricingStatus,
  source.ComparativePricingStatus AS ComparativePricingStatus,
  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.VersStockRecordUUID AS VersStockRecordUUID,
  source.PriceIsRealized AS PriceIsRealized,
  source.PnLEventType AS PnLEventType,
  source.MtMDataSourceGroup AS MtMDataSourceGroup,
  source.SystemMessageNumber AS SystemMessageNumber,
  source.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
  source.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber
FROM P_Cmmdtynewactpnlvalue_Calc
;