I_SrvcPartsDealerProdBasic

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_SrvcPartsDealerProdBasic.
-- 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 I_SrvcPartsDealerProdBasic AS
SELECT
  matid AS ProductInternalUUID,
  locid AS LocationUUID,
  cast( simid as lca_planversion preserving type ) AS PlanningVersionUUID,
  eoqty AS SrvcPartsEconomicOrderQty,
  eoqdura AS SrvcPartsNrOfDaysEOQPlngDurn,
  eoqcal_mthd AS SrvcPartsEOQSftyMod,
  eoqcalc_l_mthd AS SrvcPartsLongEOQSftyMod,
  eoqpod_fix AS SrvcPartsEOQFixPeriod,
  eoqrescode AS SrvcPartsEOQCalculationType,
  eoqsft_flg AS SrvcPartsEOQSftyStkHasTimeSers,
  maxeoq_pod AS SrvcPartsNrOfMaxDaysEOQ,
  maxparent_pod AS SrvcPartsNrOfMaxDaysEOQParent,
  maxreord_pod AS SrvcPartsNrOfMaxDaysReorderPt,
  mineoq_pod AS SrvcPartsNrOfMinDaysEOQPeriod,
  policy_lock AS ReplenishmentIndIsLocked,
  cast (reviewtime as vdm_sapapo_review_time) AS SrvcPartsDRPReviewTimeDurn,
  cast(reviewtime_dl as vdm_sapapo_review_time_depl) AS SrvcPartsDplntReviewTimeDurn,
  cast(planrun_dl as vdm_sapapo_plrun_dur_depl ) AS SrvcPartsDplntPlanningRunDurn,
  cast(planrun as vdm_sapapo_plrun_dur) AS SrvcPartsDRPPlanningRunDurn,
  ordcostpull AS SrvcPartsFixOrdgCostPullAmtVal,
  ordcostpush AS SrvcPartsFixOrdgCostPushAmtVal,
  minord_qty AS SrvcPartsMinPurOrderQty,
  cast ( replch_date as vdm_sapapo_setdate ) AS ChangeOfRepIndDateTime,
  cast ( (repldur_stk ) as vdm_sapapo_stabilitydur_stk) AS SrvcPartsStkngStbltyDurnInHrs,
  cast( '' as abap.char(41) ) AS SrvcPartsStkngStbltyDurnTxt,
  cast ((repldur_dstk ) as vdm_sapapo_stabilitydur_dstk) AS SrvcPartsDstkngStbltyDurnInHrs,
  cast( '' as abap.char(41) ) AS SrvcPrtsDstkngStbltyDurnTxt,
  rgstk_indi AS SrvcPartsLocationIsStockedRgnl,
  plock_reason AS SrvcPartsLocationExclusionRsn,
  pod_fixdmd AS SrvcPartsHrznFixedDmndIsTaken,
  pod_fixdmdtyp AS SrvcPartsProcmtLeadTimeDetn,
  pod_fixdmdhor AS SrvcPartsNmbrOfDaysForHorizon,
  cast ( initstdate as vdm_sapapo_initstdate ) AS SrvcPartsLocInitStockedDteTme,
  ss_cal_mthd AS SrvcPartsSftyStkCalcMethod,
  eoq_l_reas AS SrvcPartsSftyStkEOQLockRsn,
  plrsteoq_sdat AS SrvcPartsPlngLockEOQStrtDate,
  plrsteoq_edat AS SrvcPartsPlngLockEOQEndDate,
  cast ( maxstorage as ui_maxstorage ) AS SrvcPartsRecmddStorQuantity,
  cast ( depl_indi as vdm_sapapo_depl_indi ) AS SrvcPartsDeploymentPlng,
  cast ( depl_indich as vdm_sapapo_deplst_dt preserving type ) AS SrvcPartsDplntPlngStbltyDteTme,
  cast ( expshp_mult as ui_expshp_mult preserving type ) AS SrvcPartsMltplrExprShptVal,
  cast ( plrstdrp_en as vdm_sapapo_plrstdrp_end preserving type ) AS SrvcPartsDRPPlngLockEndDteTme,
  cast ( plrstdrp_st as vdm_sapapo_plrstdrp_start preserving type ) AS SrvcPartsDRPPlngLockStrtDteTme,
  cast ( plrst_en as vdm_sapapo_plrst_end preserving type ) AS SrvcPartsLockEndDteTme,
  cast ( plrst_st as vdm_sapapo_plrst_start preserving type ) AS SrvcPartsLockStartDteTme,
  cast ( plrstloc_en as vdm_sapapo_plrstloc_end preserving type ) AS SrvcPartsLocLockEndDteTme,
  cast ( plrstloc_st as vdm_sapapo_plrstloc_start preserving type ) AS SrvcPartsLocLockStrtDteTme,
  cast ( ret_residual as ui_ret_residual preserving type ) AS SrvcPartsParLocRmngQtyIsKept,
  cast ( tsl_shift as ui_tsl_shift preserving type ) AS SrvcPartsAddlGrossDemandVal,
  lowthreshold AS SrvcPartsMinNetDemandQty,
  expresesbuy AS SrvcPartsPseasnIsExcluded,
  num_period AS SrvcPartsDRPNrOfMonthsRndng,
  vp_switch AS SrvcPartsCnsldtdOrdering,
  cast ( max_tsl as ui_max_tsl preserving type ) AS SrvcPartsMaximumGrossDemandVal,
  seaspullprf_id AS SrvcPartsAntcptdDemandCoverage,
  cast ( avgprod_perbin as ui_avgprod_perbin preserving type ) AS SrvcPartsAvgQtyStorBinQtyVal,
  cast ( wssstr_type as ui_wssstr_type preserving type ) AS SrvcPartsWrhsSpaceSvngStorType,
  cast ( srvben as ui_srvben preserving type ) AS SrvcPartsSvngPreventedLossVal,
  cast ( manfrhor_st as vdm_sapapo_manfrhor_st ) AS SrvcPartsManFreezeHrznDteTme,
  trg_det_drp_pm AS SrvcPartsDRPPlngModeTrggrIsSet,
  drp_plan_mode AS SrvcPartsDRPPlngMode,
  maxstklvl_flg AS SrvcPartsRndngMaxStockIsSet,
  no_inv_bal AS SrvcPartsInventoryBalancing,
  inf_deal_stdec AS SrvcPartsCustInfoStkDcsnIsUsd,
  lp_vmi_handle AS SrvcPartsOEMMngdInvtryIsRlvt,
  proh_su_ord AS NoSubOrdSupersessionIsAllwd,
  proh_su_dem AS NoSubOrdRemnftdIsAllwd,
  cast ( appr_dep_sto as ui_appr_dep_sto preserving type ) AS SrvcPartsCustApprvlReplnmtOrd,
  drp_l_reas AS SrvcPartsDRPLockRsn,
  cast ( dep_l_reas as ui_dep_l_reas preserving type ) AS SrvcPartsDeploymentLockRsn,
  loc_l_reas AS SrvcPartsLocationLockRsn,
  sca_plnr AS SrvcPartsSupplyChainAnalyst,
  drp_plnr AS SrvcPartsDRPPlanner,
  ipl_plnr AS SrvcPartsInventoryPlanner,
  buy_plnr AS SrvcPartsPlanningBuyer,
  sca_lock AS SrvcPartsSCMAnalystIsLocked,
  _ProductMappg.BaseUnit AS BaseUnit,
  cast ( div (bp_grprt, 240000) as grprt preserving type ) AS GoodsReceiptDuration,
  cast ( bp_grprt as grprt preserving type ) AS GoodsReceiptDurationDisplay,
  bp_ndcostwe AS SrvcPartsBPGdsRcptCostVal,
  bp_scost_prcnt AS CostFactorForStockHoldingVal,
  bp_safty AS SafetyStockQuantity,
  bp_ppsaftystk AS ParLocSafetyStockQuantity,
  bp_proc_cost AS ProductProcurementCostsVal,
  bp_maxstock AS MaximumStockQuantity,
  bp_reord AS ReorderThresholdQuantity,
  bp_lvorm AS IsMarkedForDeletion,
  bp_createuser AS ServicePartsCreatedByUser,
  cast ( bp_createutc as icl_createutc_fiori preserving type ) AS ServicePartsCreatedAtDateTime,
  bp_changeuser AS ServicePartsLastChangedByUser,
  cast ( bp_changeutc as icl_changeutc_fiori preserving type ) AS ServicePartsLastChangeDateTime,
  _LocationMappg.Customer AS BusinessPartner
FROM /sapapo/matlspp
LEFT OUTER JOIN I_SrvcPartsLocMapForCustomer AS _LocationMappg ON LocationUUID = _LocationMappg.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_SrvcPartsProductMap AS _ProductMappg ON ProductInternalUUID = _ProductMappg.ProductInternalUUID  -- association [0..1]
;