P_Vlogp_PositionRep

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_Vlogp_PositionRep.
-- 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.
-- Parameters: P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_DisplayView : cds_view_uom, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate

CREATE VIEW P_Vlogp_PositionRep AS
SELECT
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  ValidityStartDate,
  ValidityStartDateTime,
  ValidityEndDate,
  ValidityEndDateTime,
  SourceTransactionEventDateTime,
  SourceTransacEventEndDateTime,
  EndOfDayBusinessEntityKey,
  MarketNormBusinessEntityKey,
  DeliveryPeriodStartDate,
  DeliveryPeriodEndDate,
  SpreadBusinessEntityKey,
  MaximumVersion,
  PreviousVersion,
  cast(:P_EndOfDaySnapshotFromDate as cmm_snapshot_start) AS EndOfDaySnapshotFromDate,
  cast(:P_EndOfDaySnapshotToDate as cmm_snapshot_end) AS EndOfDaySnapshotToDate,
  cast(:P_DisplayView as cds_view_uom) AS DisplayView,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  PhysicalCommodity,
  Plant,
  StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  SourceDocument,
  cast( SourceDocumentBusObjType as cds_vlogp_doc_type ) AS SourceDocumentBusObjType,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  cast( OriginReferenceDocBusObjType as cds_vlogp_root_doctyp ) AS OriginReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  cast( ReferenceDocBusObjType as cds_vlogp_predecessor_doctyp ) AS ReferenceDocBusObjType,
  DeliveryDate,
  ExpectedPaymentDate,
  StatisticsCurrency,
  DocumentCurrency,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionRate,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionTermRate,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValue,
  ConditionTermValueCurrency,
  ConditionTermRateMktCurrency,
  ConditionTermName,
  ConditionTermStatus,
  RoundingDecimalPlaces,
  ConditionTermRateIsRounded,
  ConditionTermRateNmrtr,
  ConditionTermRateDnmntr,
  ConditionTermExtensionUsage,
  CmmdtyForwardIndexTiming,
  QuotationPeriodReferenceDate,
  CommodityCurve,
  QuotationDateList,
  FutureRefQuotationDateList,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  MIC etc. DerivativeContrSpecification AS DerivativeContrSpecification,
  MarketIdentifierCode,
  FutureRefMarketIdentifierCode,
  MaturityKeyDate,
  BasisID,
  BasisType,
  QuotationGroup,
  QuotationGroupCalculationRule,
  PriceIsRealized,
  ConditionTermRateFixation,
  PricingStatus,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  FixedExchRateDate,
  ExchRateMaturityDate,
  vlogp.MaturitySelectionRoutine AS MaturitySelectionRoutine,
  DCSPeriodType,
  CommodityUnit,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  CmmdtyPriceExpsrVolumeUnit,
  DCSReportingDate,
  QuantitySign,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  ConditionTermRateIsFixed,
  ConditionTermExchRateIsFixed,
  CommodityQuantityInTermUnit,
  OldMarketNormMaturityKeyDate,
  NewMarketNormMaturityKeyDate,
  FixedSpreadIsInverted,
  MTMDataSourceType,
  ConditionTermFactorNumerator,
  ConditionTermFactorDenominator,
  ContrPriceExposureIsExecuted,
  CommodityPriceFixationStatus,
  ImplicitFixationIsRelevant,
  vlogp.TimeToMaturity AS TimeToMaturity,
  cast(_TimeToMaturity.NumberOfYearsOfTimeToMaturity as abap.int4) AS NumberOfYearsOfTimeToMaturity,
  cast(_TimeToMaturity.NumberOfMonthsOfTimeToMaturity as abap.int4) AS NumberOfMonthsOfTimeToMaturity,
  cast(_TimeToMaturity.NumberOfDaysOfTimeToMaturity as abap.int4) AS NumberOfDaysOfTimeToMaturity,
  MinimumConditionTermLimitRate,
  MaximumConditionTermLimitRate,
  ConditionTermLimitRateCurrency,
  ConditionTermLimitRateQuantity,
  CndnTermLimitRateQuantityUnit,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm,
  CmmdtyRootDocExternalNumber,
  CmmdtyDocumentExternalNumber,
  ExcludeBasedate
FROM I_VersionedLogisticDocument AS vlogp
LEFT OUTER JOIN I_TimeToMaturity AS _TimeToMaturity ON /* join condition not captured in parsed metadata */
;