P_Versionedlogisticdocument

@AbapCatalog.sqlViewName: 'PVLOGP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_Versionedlogisticdocument
  with parameters
    P_consumption_type  : cmm_vlogp_consumptiontype, -- analytic consumption type
    P_valuation_date0   : cmm_eval_keydate, -- valuation key date
    P_valuation_date1   : cmm_eval_keydate, -- valuation key date
    P_FX_valuation_date : cmm_eval_keydate, -- FX valuation date
    P_snapshot_date0    : cmm_dend_cutdate, -- date of snapshot to be selected
    P_snapshot_date1    : cmm_dend_cutdate -- date of snapshot to be selected
  as select from I_VersionedLogisticDocument
{
  key PricingKey,
  key Version,
  key PricingDocumentItem,
  key ConditionType,
  key SubConditionType,

      MTMDataSourceType,
      ValidityStartDate,
      ValidityStartDateTime,
      ValidityEndDate,
      ValidityEndDateTime,
      SourceTransactionEventDateTime,
      SourceTransacEventEndDateTime,
      EndOfDayBusinessEntityKey,
      MarketNormBusinessEntityKey,
      DeliveryPeriodStartDate,
      DeliveryPeriodEndDate,
      SpreadBusinessEntityKey,
      MaximumVersion,
      PreviousVersion,
      PrevVersionSubConditionType    as PreviousSubConditionType,

      -- Parameter Columns
      :P_consumption_type            as ConsumptionType,
      :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,

      -- Business Document
      CompanyCode,
      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,

      -- Pricing
      ConditionCalculationType,
      ConditionRate,
      ConditionCurrency,
      ConditionQuantity,
      ConditionQuantityUnit,

      -- Commodity Pricing Engine
      @Semantics.amount.currencyCode: 'ConditionTermRateCurrency'
      @DefaultAggregation:#NONE
      ConditionTermRate,
      @Semantics.amount.currencyCode: 'ConditionTermRateCurrency'
      @DefaultAggregation:#NONE
      ConditionTermRate              as OldConditionTermrate,
      @Semantics.currencyCode: true
      ConditionTermRateCurrency,
      ConditionTermRateQuantity,
      ConditionTermRateQuantityUnit,
      @Semantics.amount.currencyCode: 'ConditionTermValueCurrency'
      @DefaultAggregation:#NONE
      ConditionTermValue,
      @Semantics.amount.currencyCode: 'ConditionTermValueCurrency'
      @DefaultAggregation:#NONE
      ConditionTermValue             as OldConditionTermValue,
      @Semantics.currencyCode: true
      ConditionTermValueCurrency,
      ConditionTermRateMktCurrency,
      ConditionTermName,
      ConditionTermStatus,
      RoundingDecimalPlaces,
      ConditionTermRateIsRounded,
      ConditionTermRateNmrtr,
      ConditionTermRateDnmntr,
      ConditionTermExtensionUsage,
      MaturitySelectionType,
      MaturitySelectionRoutine,
      DCSPeriodType,
      QuotationPeriodReferenceDate,
      cast( substring(coalesce(CmmdtyLtstEvalKeyDateTime, '              '), 1, 8)
       as cpet_erp_latest_ekd_dat)   as CmmdtyLtstEvaluationKeyDate,
      -- Quotations / Commodity Curve
      QuotationKeyType,
      QuotationDateList,
      FutureRefQuotationDateList, --n_2416345
      QuotationPeriodStartDate,
      QuotationPeriodEndDate,
      -- Fixed terms may still refer to DCS, MIC etc.
      DerivativeContrSpecification,
      MarketIdentifierCode,
      FutureRefMarketIdentifierCode,
      MaturityKeyDate,
      DerivativeContractMaturityCode as CommodityContractMaturityCode,
      BasisID,
      BasisType,

      QuotationGroup,
      QuotationGroupCalculationRule,
      PriceIsRealized,
      ConditionTermRateFixation,
      PricingStatus,
      CndnTermRateFixationDate,
      CndnTermRateFixationTime,
      CndnTermExchRateFixationDate,
      CndnTermExchRateFixationTime,
      FixedExchRateDate,
      ExchRateMaturityDate,

      -- Miscellanous fields
      @Semantics.quantity.unitOfMeasure: 'CommodityUnit'
      @DefaultAggregation:#NONE
      CommodityQuantity,
      @Semantics.unitOfMeasure: true
      CommodityUnit,
      QuantitySign,
      MTMConditionGroupCategory,
      MTMConditionGroup,
      MTMCalculationGroup,
      MTMAdjustmentType,
      MTMCalcGrpMarketPriceCondition,
      ConditionTermRateIsFixed,
      ConditionTermExchRateIsFixed,
      @Semantics.quantity.unitOfMeasure: 'ConditionTermRateQuantityUnit'
      @DefaultAggregation:#NONE
      CommodityQuantityInTermUnit, --n_2308030
      OldMarketNormMaturityKeyDate, --n_2416345
      NewMarketNormMaturityKeyDate, --n_2416345
      FixedSpreadIsInverted,        --n_2416345

      -- Treasury fields
      FinancialInstrumentProductType,
      FinancialInstrTransactionType,
      BusinessPartner,
      SecurityClass,
      NumberOfCommodityContracts,
      TreasuryPositionAccount,
      TreasuryContractType,
      TreasuryPositionLongShortCode,

      -- TPL
      PrevVersionCommodityQuantity,
      PreviousVersionQuantitySign,
      PrevVersCndnTermRateCurrency,
      PrevVersionConditionTermValue,

      ImplicitFixationIsRelevant,
      ConditionTermFactorNumerator,
      ConditionTermFactorDenominator,
      ComparImplicitFixationIsRlvt, -- Implicit relevant
      ComparCndnTermFactorNumerator, -- Implicit relevant
      ComparCndnTrmFctrDenominator, -- Implicit relevant
      ComparMinCndnTermLimitRate, -- Implicit relevant
      ComparMaxCndnTermLimitRate, -- Implicit relevant
      --- Added Volume and Mass
      CmmdtyPriceExpsrMassUnit,
      @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrMassUnit'
      @DefaultAggregation:#NONE
      CmmdtyPriceExpsrQtyInMassUnit,

      CmmdtyPriceExpsrVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrVolumeUnit'
      @DefaultAggregation:#NONE
      CmmdtyPriceExpsrQtyInVolUnit,

      ContrPriceExposureIsExecuted,
      CmmdtyForwardIndexTiming,
      PriceSettingMethod,
      PriceSettingMethodStatus,
      ValidToDateTime,
      PricingProcedure,
      PricingConditionTerm,
      CmmdtyRootDocExternalNumber,
      CmmdtyDocumentExternalNumber
            


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_VERSIONEDLOGISTICDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/