P_Versionedlogisticdocument_2

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_2.
-- 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: PVLOGP2
-- 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, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime

CREATE VIEW P_Versionedlogisticdocument_2 AS
SELECT
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  MTMDataSourceType,
  ValidityStartDate,
  ValidityStartTime AS ValidityStartDateTime,
  ValidityEndDate,
  ValidityEndTime AS 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,
  SourceDocumentShortNumber,
  SourceDocument,
  SourceDocumentBusObjType,
  OrignRefDocumentShortNumber,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  DeliveryDate,
  ExpectedPaymentDate,
  StatisticsCurrency,
  DocumentCurrency,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  CmmdtyRootDocExternalNumber,
  CmmdtyDocumentExternalNumber,
  ConditionRateAmount AS 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,
  CmmdtyLtstEvaluationKeyDate,
  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,
  PrevVersionCommodityQuantity,
  PreviousVersionQuantitySign,
  PrevVersCndnTermRateCurrency,
  PrevVersionConditionTermValue,
  ImplicitFixationIsRelevant,
  ConditionTermFactorNumerator,
  ConditionTermFactorDenominator,
  ComparImplicitFixationIsRlvt,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrVolumeUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  ContrPriceExposureIsExecuted,
  CmmdtyForwardIndexTiming,
  QuotationUnitOfMeasure,
  FixedCalculationType,
  ThresholdValueLow AS TermToDocFixedFactorFrom,
  ThresholdValueHigh AS TermToDocFixedFactorTo,
  MarketToTermExchangeRateType,
  CndnToStstcExchangeRateType,
  ConditionToDocExchangeRateType,
  DocToStstcExchangeRateType,
  ExchangeRateType,
  QuotationCurrency,
  SkipReportingIndicatorIsSet,
  OldScore AS FixedFactorFrom,
  NewScore AS FixedFactorTo,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm,
  ExcludeBasedate
FROM I_VersionedLogcDocument
;