C_CmmdtyBeginPosPnLValQry

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 C_CmmdtyBeginPosPnLValQry.
-- 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: CCMMBPPNLVALQRY
-- Parameters: P_EndOfDaySnapshotFromDate : cmm_snapshot_start, P_EndOfDaySnapshotToDate : cmm_snapshot_end, P_Language : spras, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime, P_MinEODaySnapshotDate : cmm_min_eod_snapshot_date, 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 C_CmmdtyBeginPosPnLValQry AS
SELECT
  resultElement: 'MinimumEndOfDayFromDateTime' AS resultElementMinimumEndOfDayFromDateTime,
  resultElement: 'MaximumEndOfDayToDateTime' AS resultElementMaximumEndOfDayToDateTime,
  resultElement: 'MinimumEndOfDaySnapshotDate' AS resultElementMinimumEndOfDaySnapshotDate,
  resultElement: 'MinimumPriceQuotationDate' AS resultElementMinimumPriceQuotationDate,
  resultElement: 'MaximumPriceQuotationDate' AS resultElementMaximumPriceQuotationDate,
  resultElement: 'MinSubstnPriceQuotationDate' AS resultElementMinSubstnPriceQuotationDate,
  resultElement: 'MaxSubstnPriceQuotationDate' AS resultElementMaxSubstnPriceQuotationDate,
  resultElement: 'MinExchangeRateMaturityDate' AS resultElementMinExchangeRateMaturityDate,
  resultElement: 'MaxExchangeRateMaturityDate' AS resultElementMaxExchangeRateMaturityDate,
  resultElement: 'MinimumForwardQuotationDate' AS resultElementMinimumForwardQuotationDate,
  resultElement: 'MaximumForwardQuotationDate' AS resultElementMaximumForwardQuotationDate,
  ComparativeEvaluationDate,
  CompanyCode,
  ProfitCenter,
  ProfitCenterName,
  Plant,
  Commodity,
  MTMCalculationGroup,
  PnLEventGroup,
  MTMAdjustmentType,
  OrignRefDocumentShortNumber,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  SourceDocumentShortNumber,
  SourceDocumentItem,
  SourceDocumentBusObjType,
  ConditionTermRateFixation,
  ConditionType,
  MarketDCS,
  MktMarketIdentifierCode,
  MktDrvtvContrMaturityCode,
  MktMaturityKeyDate,
  MarketBasisType,
  MarketBasisID,
  MktQuotationPriceType,
  MTMDataSourceType,
  ComparativeMarketDCS,
  ComparMktMarketIdentifierCode,
  ComparMktMaturityKeyDate,
  ComparMktDrvtvContrCode,
  ComparMarketBasisID,
  ComparMarketBasisType,
  ComparMktQuotationPriceType,
  PricingStatus,
  SubConditionType,
  HasError,
  SystemMessageNumber,
  CommodityUnit,
  ConditionTermRateQuantityUnit,
  StatisticsCurrency,
  PnLValue,
  MktPricePnLValue,
  SpreadPnLValue,
  DocToStstcFXPnLValue,
  MktToStstcFXPnLValue,
  MktValAdjmtFXBroughtFwdVal,
  CommodityQuantityInTermUnit,
  ComparCmmdtyQuantityInTermUnit,
  PnLCalculationRelevantQuantity,
  MarketConditionTermRate,
  ComparMktConditionTermRate,
  PnLCalculationRelevantValue,
  ContrSpreadCndnTermRate,
  ComparContrSpreadCndnTermRate,
  FixedMktSpreadCndnTermRate,
  FloatingMktSpreadCndnTermRate,
  ContractConditionTermRate,
  ComparContrCndnTermRate,
  MktMarketToDocExchRate,
  ComparMktMarketToDocExchRate,
  ContractMktToDocExchRate,
  MktDocToStstcExchRate,
  ComparMktDocToStstcExchRate,
  MktMarketToStstcExchRate,
  ComparMktMarketToStstcExchRate,
  MktAdjmtValDocToStstcExchRate,
  MktAdjmtValueCndnTermValue,
  ConditionTermFactor,
  ComparConditionTermFactor,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  ReferenceDocumentLongNumber,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  DeliveryDate,
  ExpectedPaymentDate,
  DocumentCurrency,
  SpreadCurrency,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ExchRateMaturityDate,
  FixedExchRateDate,
  QuotationPeriodReferenceDate,
  ComparQtanPeriodReferenceDate,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  QuotationGroup,
  QuotationGroupCalculationRule,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  _MTMConditionGroupCategory._MtmConditionGroupCategoryT[1:Language = :P_Language].MTMConditionGroupCategoryName AS MTMConditionGroupCategoryName,
  MTMConditionGroup,
  MTMCalcGrpMarketPriceCondition,
  PriceIsRealized,
  PricingKey,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  CmmdtyPriceExpsrVolumeUnit,
  _CmmdtyMTMMessage[1:Language = :P_Language].SystemMessageText AS SystemMessageText,
  ConditionTermRateCurrency,
  MarketToTermExchangeRateType,
  CndnToStstcExchangeRateType,
  ConditionToDocExchangeRateType,
  DocToStstcExchangeRateType,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm
FROM I_CmmdtyBeginPosPnLValCube
;