R_SrvcPrtsMassProcDealerProdTP

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 R_SrvcPrtsMassProcDealerProdTP.
-- 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.

CREATE VIEW R_SrvcPrtsMassProcDealerProdTP AS
SELECT
  Location,
  Product,
  _VersionMappg.PlanningVersionExternal AS PlanningVersionExternal,
  cast( ProductInternalUUID as sysuuid_22 preserving type ) AS ProductInternalUUID,
  LocationUUID,
  SrvcPartsPlanningVersionUUID,
  PlanningVersionUUID,
  MaterialExternalID,
  cast( SrvcPartsEconomicOrderQty as abap.dec(13, 3) ) AS SrvcPartsEconomicOrderQty,
  SrvcPartsNrOfDaysEOQPlngDurn,
  SrvcPartsEOQSftyMod,
  SrvcPartsLongEOQSftyMod,
  SrvcPartsEOQFixPeriod,
  SrvcPartsEOQCalculationType,
  SrvcPartsEOQSftyStkHasTimeSers,
  SrvcPartsNrOfMaxDaysEOQ,
  SrvcPartsNrOfMaxDaysEOQParent,
  SrvcPartsNrOfMaxDaysReorderPt,
  SrvcPartsNrOfMinDaysEOQPeriod,
  ReplenishmentIndIsLocked,
  SrvcPartsDRPReviewTimeDurn,
  SrvcPartsDplntReviewTimeDurn,
  SrvcPartsDplntPlanningRunDurn,
  SrvcPartsDRPPlanningRunDurn,
  SrvcPartsFixOrdgCostPullAmtVal,
  SrvcPartsFixOrdgCostPushAmtVal,
  cast( SrvcPartsMinPurOrderQty as abap.dec(13, 3) ) AS SrvcPartsMinPurOrderQty,
  ReplenishmentStatusCode,
  ChangeOfRepIndDateTime,
  SrvcPartsStkngStbltyDurnInHrs,
  SrvcPartsDstkngStbltyDurnInHrs,
  SrvcPartsLocationIsStockedRgnl,
  SrvcPartsLocationExclusionRsn,
  SrvcPartsHrznFixedDmndIsTaken,
  SrvcPartsProcmtLeadTimeDetn,
  SrvcPartsNmbrOfDaysForHorizon,
  SrvcPartsLocInitStockedDteTme,
  SrvcPartsSftyStkCalcMethod,
  SrvcPartsSftyStkEOQLockRsn,
  SrvcPartsPlngLockEOQStrtDate,
  SrvcPartsPlngLockEOQEndDate,
  cast( SrvcPartsRecmddStorQuantity as abap.dec(15, 3) ) AS SrvcPartsRecmddStorQuantity,
  SrvcPartsDeploymentPlng,
  SrvcPartsDplntPlngStbltyDteTme,
  SrvcPartsMltplrExprShptVal,
  SrvcPartsDRPPlngLockEndDteTme,
  SrvcPartsDRPPlngLockStrtDteTme,
  SrvcPartsLockEndDteTme,
  SrvcPartsLockStartDteTme,
  SrvcPartsLocLockEndDteTme,
  SrvcPartsLocLockStrtDteTme,
  SrvcPartsParLocRmngQtyIsKept,
  SrvcPartsAddlGrossDemandVal,
  cast( SrvcPartsMinNetDemandQty as abap.dec(13, 4) ) AS SrvcPartsMinNetDemandQty,
  SrvcPartsPseasnIsExcluded,
  SrvcPartsDRPNrOfMonthsRndng,
  SrvcPartsCnsldtdOrdering,
  SrvcPartsMaximumGrossDemandVal,
  SrvcPartsAntcptdDemandCoverage,
  SrvcPartsAvgQtyStorBinQtyVal,
  SrvcPartsWrhsSpaceSvngStorType,
  SrvcPartsSvngPreventedLossVal,
  SrvcPartsManFreezeHrznDteTme,
  SrvcPartsDRPPlngModeTrggrIsSet,
  SrvcPartsDRPPlngMode,
  SrvcPartsRndngMaxStockIsSet,
  SrvcPartsInventoryBalancing,
  SrvcPartsCustInfoStkDcsnIsUsd,
  SrvcPartsOEMMngdInvtryIsRlvt,
  NoSubOrdSupersessionIsAllwd,
  NoSubOrdRemnftdIsAllwd,
  SrvcPartsCustApprvlReplnmtOrd,
  SrvcPartsDRPLockRsn,
  SrvcPartsDeploymentLockRsn,
  SrvcPartsLocationLockRsn,
  SrvcPartsSupplyChainAnalyst,
  SrvcPartsDRPPlanner,
  SrvcPartsInventoryPlanner,
  SrvcPartsPlanningBuyer,
  SrvcPartsSCMAnalystIsLocked,
  BaseUnit,
  GoodsReceiptDuration,
  SrvcPartsBPGdsRcptCostVal,
  CostFactorForStockHoldingVal,
  cast( SafetyStockQuantity as abap.dec(13, 3) ) AS SafetyStockQuantity,
  cast( ParLocSafetyStockQuantity as abap.dec(13,3) ) AS ParLocSafetyStockQuantity,
  ProductProcurementCostsVal,
  cast( MaximumStockQuantity as abap.dec(13, 3) ) AS MaximumStockQuantity,
  cast( ReorderThresholdQuantity as abap.dec(13, 3) ) AS ReorderThresholdQuantity,
  IsMarkedForDeletion,
  ServicePartsCreatedByUser,
  ServicePartsCreatedAtDateTime,
  ServicePartsLastChangedByUser,
  ServicePartsLastChangeDateTime,
  _SCMPlanningVersion.PlanningVersionName AS PlanningVersionName,
  BusinessPartner,
  _LocationBasic.AuthorizationGroup AS AuthorizationGroup
FROM I_SrvcPartsDealerProdDetail
LEFT OUTER JOIN I_SCMVersionMap AS _VersionMappg ON PlanningVersionUUID = _VersionMappg.PlanningVersionUUID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON BaseUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_SCMPlanningVersion AS _SCMPlanningVersion ON PlanningVersionUUID = _SCMPlanningVersion.AdvncdPlngPlanningVersionUUID  -- association [0..1]
LEFT OUTER JOIN I_SrvcPartsCustomerStockUpInf AS _StockInfoSendDateTime ON Location = _StockInfoSendDateTime.Location AND Product = _StockInfoSendDateTime.Product  -- association [0..1]
;