I_NetPositionRepSlateCube_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 I_NetPositionRepSlateCube_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: INETPOSREPSLCB2
-- Parameters: P_DisplayUnitOfMeasure : cds_view_uom, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cds_cmm_vlogp_consumptiontype, 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 I_NetPositionRepSlateCube_2 AS
SELECT
  CommodityTransactionType,
  PricingKey,
  cast( Version as vsnmr ) AS Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  VersStockRecordUUID,
  EvaluationDate,
  PriceQuotationDate,
  CompanyCode,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  EndOfDaySnapshotFromDate,
  EndOfDaySnapshotToDate,
  MTMDataSourceType,
  EndOfDaySnapshotDateTimeFrom,
  EndOfDaySnapshotDateTimeTo,
  MaximumVersion,
  PreviousVersion,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  Plant,
  StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  SourceDocument,
  SourceDocumentBusObjType,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  cast( ReferenceDocument as awref ) AS ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  ExpectedPaymentDate,
  StatisticsCurrency,
  DocumentCurrency,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionTermRate,
  CommodityPriceFixationStatus,
  ConditionTermRateCurrency,
  ConditionTermRateQuantityUnit,
  ConditionTermValueCurrency,
  ConditionTermRateMktCurrency,
  ConditionTermName,
  ConditionTermStatus,
  RoundingDecimalPlaces,
  ConditionTermRateIsRounded,
  ConditionTermRateNmrtr,
  ConditionTermRateDnmntr,
  ConditionTermExtensionUsage,
  MaturitySelectionType,
  QuotationPeriodReferenceDate,
  QuotationKeyType,
  QuotationDateList,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  BasisType,
  BasisID,
  QuotationGroup,
  QuotationGroupCalculationRule,
  PricingStatus,
  ConditionTermRateFixation,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  FixedExchRateDate,
  ExchRateMaturityDate,
  QuantitySign,
  MTMConditionGroupCategory,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  PriceIsRealized,
  ContrPriceExposureIsExecuted,
  ImplicitFixationIsRelevant,
  MinimumConditionTermLimitRate,
  MaximumConditionTermLimitRate,
  ConditionTermLimitRateCurrency,
  CndnTermLimitRateQuantityUnit,
  ConditionTermLimitRateStatus,
  AdjustedReportingDate,
  AdjustedReportingYear,
  AdjustedReportingMonth,
  cast( GoodsMovement as mblnr ) AS GoodsMovement,
  ACMGoodsMovementYear,
  ApplicationDocument,
  LoadDataCaptureObjectID,
  LoadDataCaptureEventType,
  MaterialStockPriceExposureUnit,
  ExposureDueDate,
  cast( CashFlowDirection as fclm_direction ) AS CashFlowDirection,
  TreasuryPositionLongShortCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  DerivativeContractMaturityCode,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  FinancialObject,
  TermStartDate,
  TermEndDate,
  NumberOfCommodityContracts,
  TreasuryPositionAccount,
  DerivativeContract,
  OptionStrikeCurrency,
  OptionPutCallCode,
  EndOfDaySnapshotDateTime,
  MTMDataSelectionType,
  EndOfDaySnapshotDate,
  ValidityStartDate,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  ValidityStartDateTime,
  ValidityEndDateTime,
  Commodity,
  PhysicalCommodity,
  DeliveryDate,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  MaturityKeyDate,
  DisplayView,
  ConditionTermRateIsFixed,
  ReportingDate,
  cast( ReportingYear as cds_reporting_year ) AS ReportingYear,
  ReportingMonth,
  CommodityUnit,
  PricedUndeliveredContrExpsrQty,
  UnpricedUndeliveredCtrExpsrQty,
  UndeliveredMarketPrExposureQty,
  UnpricedDeliveredCtrExpsrQty,
  PricedDeliveredContrExpsrQty,
  DeliveredMarketPrExposureQty,
  UnpricedContrPriceExposureQty,
  UnrlzdMarketPriceExposureQty,
  OutrightPriceExposureQty,
  PricedContractsExposureQty,
  MaterialStockExposureQty,
  UnrealizedGoodsRcptPrcExpsrQty,
  UnrealizedGoodsIssPrcExpsrQty,
  RealizedMaterialStkPrcExpsrQty,
  TodayPricedUndeliveredExpsrQty,
  UnrealizedPriceExposureQty,
  UnpricedUnrealizedPrcExpsrQty,
  TodayUnpricedUnrlzdCtrExpsrQty,
  FlatPricedContractsQty,
  NoFutrEstablishedContrExpsrQty,
  NoBsEstablishedContrExpsrQty,
  NoPrcEstablishedContrExpsrQty,
  FixPricedDelivsPriceExpsrQty,
  UndeliveredFixPrCtrPrExpsrQty,
  UnpricedUnrlzdGdsIssExpsrQty,
  UnpricedUnrlzdGdsRcptExpsrQty,
  FixPricedContrPriceExpsrQty,
  TodayPricedContractsExpsrQty,
  BasisPositionQty,
  NoFutureEsDelContractQty,
  FlatPricedUNDelContractQty,
  NoFutureEsUNDelContractQty,
  FuturesTradePositionQty,
  UnRealflatApplicationQty,
  StorageBinHasNetDryError,
  PhysicalCmmdtyHasNetDryError,
  PhysicalCommodityErrorText
FROM P_NetPositionSlateReport_2
;