P_UnionViewPhysFin_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_UnionViewPhysFin_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: PCMMUNIONPF2
-- Parameters: P_DisplayUnitOfMeasure : cds_view_uom, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_OptionDeltaMethod : cds_option_delta_method, P_OptionDeltaThreshold : cds_option_delta_threshold, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime, P_MinPriceQuotationDate : cmm_min_price_quotation_date, P_MaxPriceQuotationDate : cmm_max_price_quotation_date

CREATE VIEW P_UnionViewPhysFin_2 AS
SELECT
  cast('P' as fti_exp_group_indicator preserving type) AS CommodityTransactionType,
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  VersStockRecordUUID,
  EvaluationDate,
  QuotationPeriodDate AS PriceQuotationDate,
  CompanyCode,
  cast(' ' as ftr_cty_expos_id) AS CommodityPriceExposure,
  cast(' ' as cmm_vfind_exposure_cat) AS CommodityExposureCategory,
  cast(' ' as cmm_vfind_exposure_subkey) AS CommodityPriceSubExposure,
  EndOfDaySnapshotFromDate,
  EndOfDaySnapshotToDate,
  MTMDataSourceType,
  EndOfDaySnapshotDateTimeFrom,
  EndOfDaySnapshotDateTimeTo,
  MaximumVersion,
  PreviousVersion,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  Plant,
  StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  SourceDocumentShortNumber,
  SourceDocument,
  SourceDocumentItem,
  SourceDocumentBusObjType,
  OrignRefDocumentShortNumber,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  ExpectedPaymentDate,
  StatisticsCurrency,
  DocumentCurrency,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValue,
  ConditionTermValueCurrency,
  ConditionTermRateMktCurrency,
  ConditionTermName,
  ConditionTermStatus,
  RoundingDecimalPlaces,
  ConditionTermRateIsRounded,
  ConditionTermRateNmrtr,
  ConditionTermRateDnmntr,
  ConditionTermExtensionUsage,
  MaturitySelectionType,
  QuotationPeriodReferenceDate,
  CommodityCurve,
  QuotationPriceType,
  QuotationDateList,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  BasisType,
  BasisID,
  QuotationGroup,
  QuotationGroupCalculationRule,
  PricingStatus,
  ConditionTermRateFixation,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  FixedExchRateDate,
  ExchRateMaturityDate,
  MaturitySelectionRoutine,
  DCSPeriodType,
  QuantitySign,
  MTMConditionGroupCategory,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  PriceIsRealized,
  ContrPriceExposureIsExecuted,
  ImplicitFixationIsRelevant,
  MinimumConditionTermLimitRate,
  MaximumConditionTermLimitRate,
  ConditionTermLimitRateCurrency,
  ConditionTermLimitRateQuantity,
  CndnTermLimitRateQuantityUnit,
  ConditionTermLimitRateStatus,
  AdjustedReportingDate,
  AdjustedReportingYear,
  AdjustedReportingMonth,
  CommodityPriceFixationStatus,
  GoodsMovementDocument AS GoodsMovement,
  InventoryCommodityUnit AS MaterialStockPriceExposureUnit,
  ExposureDueDate,
  SubstitutePriceQuotationDate,
  cast (' ' as cmm_side) AS CashFlowDirection,
  cast (' ' as tba_tenor) AS TimeToMaturity,
  CmmdtyForwardIndexTiming,
  cast (' ' as tba_contract_code) AS DerivativeContractMaturityCode,
  cast (' ' as sanlf) AS FinancialInstrProductCategory,
  cast (' ' as vvsart) AS FinancialAssetsMgmtProductType,
  cast (' ' as tb_sfgtyp) AS FinInstrTransactionCategory,
  cast (' ' as tb_sfhaart) AS FinancialInstrumentProductType,
  cast (' ' as tb_sfgzuty) AS FinancialInstrActivityCategory,
  cast (' ' as ftr_objnr) AS FinancialObject,
  cast (' ' as tb_dblfz) AS TermStartDate,
  cast (' ' as tb_delfz) AS TermEndDate,
  cast ( 0 as tb_contracts_number) AS NumberOfCommodityContracts,
  cast (' ' as tpm_pos_account_fut) AS TreasuryPositionAccount,
  cast (' ' as ftr_derivative_contract_id) AS DerivativeContract,
  cast (' ' as cmm_eval_quot_curr) AS QuotationCurrency,
  cast (' ' as cmm_eval_paym_curr) AS PaymentCurrency,
  cast ( 0 as tb_cty_strike_price) AS OptionStrikePrice,
  cast (' ' as tb_runit) AS OptionStrikeCurrency,
  cast (' ' as ti_sputcal) AS OptionPutCallCode,
  cast (' ' as cds_external_key_figures ) AS ExternalKeyFigureValue,
  cast (' ' as cds_option_delta_factor ) AS OptionDeltaFactor,
  cast( '0' as cmm_eval_option_delta_factor ) AS OptionDeltaFactorKeyFigure,
  cast (0 as cmm_dend_tmstmp) AS EndOfDaySnapshotDateTime,
  MTMDataSelectionType,
  EndOfDaySnapshotDate,
  ValidityStartDate,
  ValidityStartDateTime AS ValidityStartTime,
  ValidityEndDate,
  ValidityEndDateTime AS ValidityEndTime,
  SourceTransactionEventDateTime AS ValidityStartDateTime,
  SourceTransacEventEndDateTime AS ValidityEndDateTime,
  PhysicalCommodity,
  DeliveryDate,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  MaturityKeyDate,
  DisplayView,
  ConditionTermRateIsFixed,
  ReportingDate,
  ReportingYear,
  ReportingMonth,
  CommodityExposureQuantity AS CommodityPriceExposureQuantity,
  CommodityExposureUnit AS CommodityUnit,
  PricedUndeliveredContractQty AS PricedUndeliveredContrExpsrQty,
  UnpricedUndeliveredContractQty AS UnpricedUndeliveredCtrExpsrQty,
  UndeliveredMarketQuantity AS UndeliveredMarketPrExposureQty,
  UnpricedDeliveredContractQty AS UnpricedDeliveredCtrExpsrQty,
  PricedDeliveredContractQty AS PricedDeliveredContrExpsrQty,
  DeliveredMarketQuantity AS DeliveredMarketPrExposureQty,
  UnpricedContractQuantity AS UnpricedContrPriceExposureQty,
  UnrealizedMarketQuantity AS UnrlzdMarketPriceExposureQty,
  OutrightExposureQty AS OutrightPriceExposureQty,
  PricedContractQuantity AS PricedContractsExposureQty,
  OnHandStockQuantity AS MaterialStockExposureQty,
  UnrealizedGoodsReceiptQuantity AS UnrealizedGoodsRcptPrcExpsrQty,
  UnrealizedGoodsIssueQuantity AS UnrealizedGoodsIssPrcExpsrQty,
  RealizedStockQuantity AS RealizedMaterialStkPrcExpsrQty,
  NotExecutedImlicitlyPrToday AS TodayPricedUndeliveredExpsrQty,
  UnrealizedQuantity AS UnrealizedPriceExposureQty,
  UnpricedUnrealizedQuantity AS UnpricedUnrealizedPrcExpsrQty,
  TodayUnpricedUnrealizedQty AS TodayUnpricedUnrlzdCtrExpsrQty,
  ReducingNoPrcEstablishedCtrQty AS ReducnNoPrcEstablishedExpsrQty,
  NoFutureEstabPurchaseContrQty,
  NoFutureEstabSalesContrQty,
  FlatPricedContractQty AS FlatPricedContractsQty,
  NoFutureEstablishedContractQty AS NoFutrEstablishedContrExpsrQty,
  NoBasisEstablishedContractQty AS NoBsEstablishedContrExpsrQty,
  NoPriceEstablishedContractQty AS NoPrcEstablishedContrExpsrQty,
  FixPriceDeliveryQuantity AS FixPricedDelivsPriceExpsrQty,
  FixPricePhysicalCtrQty AS UndeliveredFixPrCtrPrExpsrQty,
  UnpricedUnrealizedGoodsIssue AS UnpricedUnrlzdGdsIssExpsrQty,
  UnpricedUnrealizedGoodsReceipt AS UnpricedUnrlzdGdsRcptExpsrQty,
  PhysicalTransactionPriced AS FixPricedContrPriceExpsrQty,
  PhysicalPricedToday AS TodayPricedContractsExpsrQty,
  InventoryAndContractsQty,
  TotalPhysicalPositionQty,
  ImpliedFuturesPositionQty,
  BasisPositionQty,
  HasError,
  cast( SystemMessageNumber as cds_systemmessagenumber ) AS SystemMessageNumber,
  PricedDays,
  UnPricedDays,
  TodayDays,
  cast( '' as tb_nordext ) AS FinInstrExternalReference,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm,
  CmmdtyRootDocExternalNumber,
  P_EvaluationDate : :P_EndOfDaySnapshotToDate AS P_EvaluationDateP_EndOfDaySnapshotToDate,
  P_ConsumptionType : :P_MTMDataSelectionType AS P_ConsumptionTypeP_MTMDataSelectionType,
  cast (0 as cmm_termrate) AS ConditionTermRate,
  cast (' ' as cpet_quotkey_all) AS QuotationKeyType,
  cast (0 as cmm_mtm_quan_comm_adj) AS CommodityQuantityInTermUnit,
  TreasuryPositionLongShortCode,
  cast( ' ' as cmm_vlogp_source_doc_ex ) AS CmmdtyDocumentExternalNumber
FROM P_PositionRep_Inverse_DOD_2
-- UNION ALL with additional select branch(es): P_DerivativePosInterfaceLayer
;