P_ContrPosRepValueSync

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_ContrPosRepValueSync.
-- 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: PACMPOSREPSYNC
-- Parameters: P_DisplayUnitOfMeasure : cds_view_uom, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cmm_vlogp_consumptiontype

CREATE VIEW P_ContrPosRepValueSync AS
SELECT
  CommodityTransactionType,
  P_ContrPosRepValues.PricingKey AS PricingKey,
  P_ContrPosRepValues.Version AS Version,
  P_ContrPosRepValues.PricingDocumentItem AS PricingDocumentItem,
  P_ContrPosRepValues.ConditionType AS ConditionType,
  P_ContrPosRepValues.SubConditionType AS SubConditionType,
  P_ContrPosRepValues.VersStockRecordUUID AS VersStockRecordUUID,
  EvaluationDate,
  PriceQuotationDate,
  P_ContrPosRepValues.CompanyCode AS CompanyCode,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  EndOfDaySnapshotFromDate,
  EndOfDaySnapshotToDate,
  P_ContrPosRepValues.MTMDataSourceType AS MTMDataSourceType,
  EndOfDaySnapshotDateTimeFrom,
  EndOfDaySnapshotDateTimeTo,
  MaximumVersion,
  PreviousVersion,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  P_ContrPosRepValues.Material AS Material,
  P_ContrPosRepValues.Plant AS Plant,
  P_ContrPosRepValues.StorageLocation AS StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  vlogp.ConditionApplication AS ConditionApplication,
  P_ContrPosRepValues.SourceDocument AS SourceDocument,
  P_ContrPosRepValues.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  ExpectedPaymentDate,
  StatisticsCurrency,
  DocumentCurrency,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionTermRate,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValue,
  ConditionTermValueCurrency,
  ConditionTermRateMktCurrency,
  vlogp.ConditionTermName AS ConditionTermName,
  ConditionTermStatus,
  RoundingDecimalPlaces,
  ConditionTermRateIsRounded,
  ConditionTermRateNmrtr,
  ConditionTermRateDnmntr,
  ConditionTermExtensionUsage,
  MaturitySelectionType,
  QuotationPeriodReferenceDate,
  QuotationKeyType,
  QuotationDateList,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  BasisType,
  BasisID,
  QuotationGroup,
  QuotationGroupCalculationRule,
  PricingStatus,
  ConditionTermRateFixation,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  FixedExchRateDate,
  ExchRateMaturityDate,
  CommodityQuantityInTermUnit,
  P_ContrPosRepValues.QuantitySign AS QuantitySign,
  P_ContrPosRepValues.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  PriceIsRealized,
  ContrPriceExposureIsExecuted,
  ImplicitFixationIsRelevant,
  MinimumConditionTermLimitRate,
  MaximumConditionTermLimitRate,
  ConditionTermLimitRateCurrency,
  ConditionTermLimitRateQuantity,
  CndnTermLimitRateQuantityUnit,
  ConditionTermLimitRateStatus,
  GoodsMovement,
  MaterialStockPriceExposureUnit,
  ExposureDueDate,
  CashFlowDirection,
  TreasuryPositionLongShortCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  vlogp.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  FinancialObject,
  TermStartDate,
  TermEndDate,
  NumberOfCommodityContracts,
  TreasuryPositionAccount,
  DerivativeContract,
  OptionStrikePrice,
  OptionStrikeCurrency,
  OptionPutCallCode,
  EndOfDaySnapshotDateTime,
  MTMDataSelectionType,
  EndOfDaySnapshotDate,
  ValidityStartDate,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  ValidityStartDateTime,
  ValidityEndDateTime,
  Commodity,
  DeliveryDate,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  MaturityKeyDate,
  DisplayView,
  ConditionTermRateIsFixed,
  ReportingDate,
  ReportingYear,
  ReportingMonth,
  CommodityPriceExposureQuantity,
  P_ContrPosRepValues.CommodityUnit AS CommodityUnit,
  PricedUndeliveredContrExpsrQty,
  UnpricedUndeliveredCtrExpsrQty,
  UndeliveredMarketPrExposureQty,
  UnpricedDeliveredCtrExpsrQty,
  PricedDeliveredContrExpsrQty,
  DeliveredMarketPrExposureQty,
  UnpricedContrPriceExposureQty,
  UnrlzdMarketPriceExposureQty,
  OutrightPriceExposureQty,
  PricedContractsExposureQty,
  MaterialStockExposureQty,
  UnrealizedGoodsRcptPrcExpsrQty,
  UnrealizedGoodsIssPrcExpsrQty,
  RealizedMaterialStkPrcExpsrQty,
  TodayPricedUndeliveredExpsrQty,
  UnrealizedPriceExposureQty,
  UnpricedUnrealizedPrcExpsrQty,
  TodayUnpricedUnrlzdCtrExpsrQty,
  ReducnNoPrcEstablishedExpsrQty,
  NoFutureEstabPurchaseContrQty,
  NoFutureEstabSalesContrQty,
  FlatPricedContractsQty,
  NoFutrEstablishedContrExpsrQty,
  NoBsEstablishedContrExpsrQty,
  NoPrcEstablishedContrExpsrQty,
  FixPricedDelivsPriceExpsrQty,
  UndeliveredFixPrCtrPrExpsrQty,
  UnpricedUnrlzdGdsIssExpsrQty,
  UnpricedUnrlzdGdsRcptExpsrQty,
  FixPricedContrPriceExpsrQty,
  TodayPricedContractsExpsrQty,
  InventoryAndContractsQty,
  TotalPhysicalPositionQty,
  ImpliedFuturesPositionQty,
  BasisPositionQty,
  AdjustedReportingDate,
  AdjustedReportingYear,
  AdjustedReportingMonth
FROM P_ContrPosRepValues
LEFT OUTER JOIN I_ContrPrcAttribLogSync AS LogSync ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS vlogp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS PricingMethod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS PricingMethodRoll ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS PricingMethodFuture ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS PricingMethodLift ON /* join condition not captured in parsed metadata */
;