P_UnionViewPhysFin

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.
-- 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: PCMMUNIONPF
-- 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

CREATE VIEW P_UnionViewPhysFin 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,
  SourceDocument,
  SourceDocumentItem,
  SourceDocumentBusObjType,
  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 cmm_option_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,
  cast( ' ' as cmm_error_flag ) AS HasError,
  cast( ' ' as cds_systemmessagenumber ) AS SystemMessageNumber,
  PricedDays,
  UnPricedDays,
  TodayDays,
  cast( '' as tb_nordext ) AS FinInstrExternalReference,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm,
  CmmdtyDocumentExternalNumber,
  CmmdtyRootDocExternalNumber
FROM P_PositionRep_Inverse_DOD
LEFT OUTER JOIN I_Vlogpkonvd AS konvd ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_DerivativePosInterfaceLayer
;