P_NETPOSITIONUPDATEPHYUOM

@AbapCatalog.sqlViewName: 'PNETPOSUPDPHYUOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Update Physical Commodity Uom'


@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_NetPositionUpdatePhyUom
with parameters
    P_MTMDataSelectionType     : cmm_vlogp_consumptiontype, -- Analytic consumption type
    P_Displayview              : cds_view_uom,              -- UoM
    P_EndOfDaySnapshotFromDate : cmm_dend_cutdate,          -- Date of snapshot to be selected
    P_EndOfDaySnapshotToDate   : cmm_dend_cutdate           -- Date of snapshot to be selected
as select from P_NetPositionReportSync
(
                      P_MTMDataSelectionType     : :P_MTMDataSelectionType,
                      P_Displayview              : :P_Displayview,
                      P_EndOfDaySnapshotFromDate : :P_EndOfDaySnapshotFromDate,
                      P_EndOfDaySnapshotToDate   : :P_EndOfDaySnapshotToDate  ) as Vlogp
left outer join I_PhysCmmdtyUnit                                                as PUom  on Vlogp.PhysicalCommodity = PUom.PhysicalCommodity

{
  key Vlogp.PricingKey,
  key Vlogp.Version,
  key Vlogp.PricingDocumentItem,
  key Vlogp.ConditionType,
  key Vlogp.SubConditionType,
  key Vlogp.EvaluationDate,
  key Vlogp.QuotationPeriodDate,
      Vlogp.SubstitutePriceQuotationDate,
      Vlogp.EndOfDaySnapshotFromDate,
      Vlogp.EndOfDaySnapshotToDate,
      Vlogp.MTMDataSelectionType,
      Vlogp.MTMDataSourceType,
      Vlogp.ValidityStartDate,
      Vlogp.ValidityStartDateTime,
      Vlogp.ValidityEndDate,
      Vlogp.ValidityEndDateTime,
      Vlogp.SourceTransactionEventDateTime,
      Vlogp.SourceTransacEventEndDateTime,
      Vlogp.EndOfDaySnapshotDateTimeFrom,
      Vlogp.EndOfDaySnapshotDateTimeTo,
      Vlogp.EndOfDaySnapshotDate,
      Vlogp.EndOfDayBusinessEntityKey,
      Vlogp.MaximumVersion,
      Vlogp.PreviousVersion,
      Vlogp.CompanyCode,
      Vlogp.SalesOrganization,
      Vlogp.DistributionChannel,
      Vlogp.Division,
      Vlogp.Creditor,
      Vlogp.SoldToParty,
      Vlogp.Material,
      Vlogp.Commodity,
      Vlogp.PhysicalCommodity,
      Vlogp.Plant,
      Vlogp.StorageLocation,
      Vlogp.Batch,
      Vlogp.IncotermsClassification,
      Vlogp.IncotermsTransferLocation,
      Vlogp.ConditionApplication,
      Vlogp.SourceDocument,
      Vlogp.SourceDocumentBusObjType,
      Vlogp.OriginReferenceDocument,
      Vlogp.OriginReferenceDocumentItem,
      Vlogp.OriginReferenceDocBusObjType,
      Vlogp.ReferenceDocument,
      Vlogp.ReferenceDocumentItem,
      Vlogp.ReferenceDocBusObjType,
      Vlogp.DeliveryDate,
      Vlogp.ExpectedPaymentDate,
      Vlogp.StatisticsCurrency,
      Vlogp.DocumentCurrency,
      Vlogp.ProfitCenter,
      Vlogp.BusinessArea,
      Vlogp.PurchasingOrganization,
      Vlogp.MaterialGroup,
      Vlogp.IsIntercompanyTransfer,
      Vlogp.ConditionTermRate,
      Vlogp.ConditionTermRateCurrency,
      Vlogp.ConditionTermRateQuantity,
      Vlogp.ConditionTermRateQuantityUnit,
      Vlogp.ConditionTermValue,
      Vlogp.ConditionTermValueCurrency,
      Vlogp.ConditionTermRateMktCurrency,
      Vlogp.ConditionTermName,
      Vlogp.ConditionTermStatus,
      Vlogp.RoundingDecimalPlaces,
      Vlogp.ConditionTermRateIsRounded,
      Vlogp.ConditionTermRateNmrtr,
      Vlogp.ConditionTermRateDnmntr,
      Vlogp.ConditionTermExtensionUsage,
      Vlogp.MaturitySelectionType,
      Vlogp.QuotationPeriodReferenceDate,
      Vlogp.QuotationKeyType,
      Vlogp.QuotationDateList,
      Vlogp.QuotationPeriodStartDate,
      Vlogp.QuotationPeriodEndDate,
      Vlogp.DerivativeContrSpecification,
      Vlogp.MarketIdentifierCode,
      Vlogp.MaturityKeyDate,
      Vlogp.BasisType,
      Vlogp.BasisID,
      Vlogp.QuotationGroup,
      Vlogp.QuotationGroupCalculationRule,
      Vlogp.PricingStatus,
      Vlogp.ConditionTermRateFixation,
      Vlogp.CndnTermRateFixationDate,
      Vlogp.CndnTermRateFixationTime,
      Vlogp.CndnTermExchRateFixationDate,
      Vlogp.CndnTermExchRateFixationTime,
      Vlogp.FixedExchRateDate,
      Vlogp.ExchRateMaturityDate,
      Vlogp.MaturitySelectionRoutine,
      Vlogp.DCSPeriodType,
      Vlogp.CommodityQuantity,
      Vlogp.CommodityUnit,
      Vlogp.CommodityQuantityInTermUnit,
      Vlogp.QuantitySign,
      Vlogp.MTMConditionGroupCategory,
      Vlogp.MTMConditionGroup,
      Vlogp.MTMCalculationGroup,
      Vlogp.MTMAdjustmentType,
      Vlogp.MTMCalcGrpMarketPriceCondition,
      Vlogp.DisplayView,

      @Semantics.quantity.unitOfMeasure: 'CommodityExposureUnit'
      Vlogp.CommodityExposureQuantity,
      @Semantics.unitOfMeasure: true
      Vlogp.CommodityExposureUnit,
      Vlogp.DCSReportingDate,
      Vlogp.PriceIsRealized,
      Vlogp.ContrPriceExposureIsExecuted,
      Vlogp.CommodityPriceFixationStatus,
      Vlogp.ImplicitFixationIsRelevant,
      Vlogp.ConditionTermRateIsFixed,
      Vlogp.MinimumConditionTermLimitRate,
      Vlogp.MaximumConditionTermLimitRate,
      Vlogp.ConditionTermLimitRateCurrency,
      Vlogp.ConditionTermLimitRateQuantity,
      Vlogp.CndnTermLimitRateQuantityUnit,
      Vlogp.ConditionTermLimitRateStatus,
      Vlogp.TotalQuotationPeriodDays,
      Vlogp.FirstQuotationPeriodDate,
      Vlogp.LastQuotationPeriodDate,
      Vlogp.QuantityPerDay,
      Vlogp.AdjustedQuantityPerDay,
      Vlogp.ReportingDate,
      Vlogp.ReportingYear,
      Vlogp.ReportingMonth,
      Vlogp.AdjustedReportingDate,
      Vlogp.AdjustedReportingYear,
      Vlogp.AdjustedReportingMonth,
      Vlogp.BinHasError,
      Vlogp.PhysicalCommodityHasError,
      Vlogp.PhysicalCommodityErrorText,

      //Fill Phusical commodity Unit

      PUom.CommodityUnit               as PhysicalCommodityUnit,
      Vlogp.DerivativeContractMaturityCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PHYSCMMDTYUNIT",
"P_NETPOSITIONREPORTSYNC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/