P_Versionedlogisticdocument

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_Versionedlogisticdocument.
-- 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: PVLOGP
-- Parameters: P_consumption_type : cmm_vlogp_consumptiontype, P_valuation_date0 : cmm_eval_keydate, P_valuation_date1 : cmm_eval_keydate, P_FX_valuation_date : cmm_eval_keydate, P_snapshot_date0 : cmm_dend_cutdate, P_snapshot_date1 : cmm_dend_cutdate

CREATE VIEW P_Versionedlogisticdocument AS
SELECT
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  MTMDataSourceType,
  ValidityStartDate,
  ValidityStartDateTime,
  ValidityEndDate,
  ValidityEndDateTime,
  SourceTransactionEventDateTime,
  SourceTransacEventEndDateTime,
  EndOfDayBusinessEntityKey,
  MarketNormBusinessEntityKey,
  DeliveryPeriodStartDate,
  DeliveryPeriodEndDate,
  SpreadBusinessEntityKey,
  MaximumVersion,
  PreviousVersion,
  PrevVersionSubConditionType AS PreviousSubConditionType,
  :P_valuation_date0 AS ValuationDate0,
  :P_valuation_date1 AS ValuationDate1,
  :P_FX_valuation_date AS FxValuationDate,
  :P_snapshot_date0 AS SnapshotDate0,
  :P_snapshot_date1 AS SnapshotDate1,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  PhysicalCommodity,
  Plant,
  StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  SourceDocument,
  SourceDocumentBusObjType,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  DeliveryDate,
  ExpectedPaymentDate,
  StatisticsCurrency,
  DocumentCurrency,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionRate,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionTermRate AS OldConditionTermrate,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValue,
  ConditionTermValue AS OldConditionTermValue,
  ConditionTermValueCurrency,
  ConditionTermRateMktCurrency,
  ConditionTermName,
  ConditionTermStatus,
  RoundingDecimalPlaces,
  ConditionTermRateIsRounded,
  ConditionTermRateNmrtr,
  ConditionTermRateDnmntr,
  ConditionTermExtensionUsage,
  MaturitySelectionType,
  MaturitySelectionRoutine,
  DCSPeriodType,
  QuotationPeriodReferenceDate,
  QuotationDateList,
  FutureRefQuotationDateList,
  QuotationPeriodEndDate,
  MIC etc. DerivativeContrSpecification AS DerivativeContrSpecification,
  MarketIdentifierCode,
  FutureRefMarketIdentifierCode,
  MaturityKeyDate,
  DerivativeContractMaturityCode AS CommodityContractMaturityCode,
  BasisID,
  BasisType,
  QuotationGroup,
  QuotationGroupCalculationRule,
  PriceIsRealized,
  ConditionTermRateFixation,
  PricingStatus,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  FixedExchRateDate,
  ExchRateMaturityDate,
  CommodityUnit,
  QuantitySign,
  MTMConditionGroupCategory,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  ConditionTermRateIsFixed,
  ConditionTermExchRateIsFixed,
  CommodityQuantityInTermUnit,
  FinancialInstrTransactionType,
  BusinessPartner,
  SecurityClass,
  NumberOfCommodityContracts,
  TreasuryPositionAccount,
  TreasuryContractType,
  TreasuryPositionLongShortCode,
  PreviousVersionQuantitySign,
  PrevVersCndnTermRateCurrency,
  PrevVersionConditionTermValue,
  ImplicitFixationIsRelevant,
  ConditionTermFactorNumerator,
  ConditionTermFactorDenominator,
  ComparImplicitFixationIsRlvt,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrVolumeUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  ContrPriceExposureIsExecuted,
  CmmdtyForwardIndexTiming,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm,
  CmmdtyRootDocExternalNumber,
  CmmdtyDocumentExternalNumber
FROM I_VersionedLogisticDocument
;