P_ACMPnLNewActDeltaValUpdData

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_ACMPnLNewActDeltaValUpdData.
-- 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: PACMPNLNAVALUPD
-- 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 P_ACMPnLNewActDeltaValUpdData AS
SELECT
  source.PricingKey AS PricingKey,
  source.Version AS Version,
  source.SourceDocumentItem AS SourceDocumentItem,
  source.ConditionType AS ConditionType,
  source.SubConditionType AS SubConditionType,
  source.EvaluationDate AS EvaluationDate,
  source.ComparativeEvaluationDate AS ComparativeEvaluationDate,
  source.ContractConditionType AS ContractConditionType,
  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.MTMDataSourceType AS MTMDataSourceType,
  source.ValidityStartDate AS ValidityStartDate,
  source.ValidityStartDateTime AS ValidityStartDateTime,
  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.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.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.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.CommodityUnit AS CommodityUnit,
  source.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  source.StatisticsCurrency AS StatisticsCurrency,
  source.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  source.ContrConditionTermRateCurrency AS ContrConditionTermRateCurrency,
  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.PnLCalculationRelevantValue AS PnLCalculationRelevantValue,
  source.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
  source.ComparMktMarketToStstcExchRate AS ComparMktMarketToStstcExchRate,
  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._ConditionTermRateQuantityUnit AS _ConditionTermRateQuantityUnit,
  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._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
FROM P_ACMPnLNewActDeltaValExtn
;