R_PPDSProductOverview

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_PPDSProductOverview.
-- 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_PPDSProductOverview AS
SELECT
  cast('' as /sapapo/pov_plan_version_uuid) AS PPDSProdOvwPlngVers,
  cast('' as /sapapo/pov_plan_version) AS PPDSProdOvwPlngVersVal,
  cast('' as /sapapo/pegid) AS PPDSProdOvwPeggingArea,
  cast('' as /sapapo/locno) AS PPDSProdOvwLocation,
  cast('' as /sapapo/pov_product) AS PPDSProdOvwProduct,
  cast('' as /sapapo/pov_processed) AS PPDSProdOvwProcessingStatus,
  cast('' as /sapapo/pov_orderid) AS PPDSProdOvwOrderID,
  cast('' as /sapapo/om_simsession) AS PPDSProdOvwSimSessionUUID,
  cast('' as /sapapo/resuid) AS PPDSProdOvwInputResourceID,
  cast('' as /sapapo/resuid) AS PPDSProdOvwOutputResourceID,
  cast('' as /sapapo/c_pp_prof_id) AS PPDSProdOvwAlrtPrflVal,
  cast('' as /sapapo/pov_plan_segment) AS PPDSProdOvwPlngSegmentCode,
  cast('' as /sapapo/pov_plsec_icon) AS PPDSProdOvwPlanSegmentValue,
  cast('' as /sapapo/maktx ) AS PPDSProdOvwProductDescription,
  cast('' as /sapapo/planner_pps) AS PPDSProdOvwProductionPlanner,
  cast('' as /sapapo/loc_descr40) AS PPDSProdOvwLocDescription,
  cast('' as tznzone) AS PPDSProdOvwTimeZone,
  cast( '' as /sapapo/pov_matplsta_scope) AS PPDSProdOvwScopeCode,
  cast('' as /sapapo/scope_profile_id) AS PPDSProdOvwScopeProfile,
  cast('' as val_text) AS PPDSProdOvwScopeDesc,
  cast('' as /sapapo/pov_alert_max) AS PPDSProdOvwMaxAlertValue,
  cast('' as /sapapo/pov_max_alert_crit) AS PPDSProdOvwMaxAlertCriticality,
  cast('' as meins) AS PPDSProdOvwUnitOfMeasure,
  cast('' as /sapapo/pov_destno) AS PPDSProdOvwTargetLocation,
  cast('' as /sapapo/pov_target_loc_descr) AS PPDSProdOvwTarLocDescription,
  cast('' as /sapapo/pov_sourcno) AS PPDSProdOvwSourceLocation,
  cast('' as /sapapo/pov_source_loc_descr) AS PPDSProdOvwSrcLocDescription,
  cast('' as /sapapo/pov_in_res_name) AS PPDSProdOvwInputResValue,
  cast('' as /sapapo/pov_input_res_descr) AS PPDSProdOvwInputResDescription,
  cast('' as /sapapo/pov_out_res_name) AS PPDSProdOvwOutputResValue,
  cast('' as /sapapo/pov_output_res_descr) AS PPDSProdOvwOutResDescription,
  cast('' as /sapapo/pov_end_pr_hor_d) AS PPDSProdOvwEndOfProdHorizonDte,
  cast('' as /sapapo/pov_planning_date) AS PPDSProdOvwPlanningDate,
  cast('0' as /sapapo/pov_max_shortage) AS PPDSProdOvwMaxShortageQuantity,
  cast('0' as /sapapo/pov_surplus) AS PPDSProdOvwSurplusQuantity,
  cast('0' as /sapapo/pov_max_delay) AS PPDSProdOvwMaximumDelayValue,
  cast('0' as /sapapo/pt_t_stock) AS PPDSProdOvwTotalStocksQuantity,
  cast('0' as /sapapo/pt_t_recpt) AS PPDSProdOvwTotalReceiptsQty,
  cast('0' as /sapapo/pt_t_requi) AS PPDSProdOvwTotalReqQuantity,
  cast('' as /sapapo/alert_time) AS PPDSProdOvwDateTimeAlertValue,
  cast('' as /sapapo/pov_dt_alert_crit) AS PPDSProdOvwDteTmeAlrtCritlty,
  cast('' as /sapapo/alert_quan) AS PPDSProdOvwQuantityAlertValue,
  cast('' as /sapapo/pov_quan_alert_crit) AS PPDSProdOvwQuantityAlrtCritlty,
  cast('' as /sapapo/alert_char) AS PPDSProdOvwCharcsAlrtValue,
  cast('' as /sapapo/pov_charact_alert_crit) AS PPDSProdOvwCharcsAlrtCritlty,
  cast('' as /sapapo/alert_network) AS PPDSProdOvwNetworkAlrtValue,
  cast('' as /sapapo/pov_network_alert_crit) AS PPDSProdOvwNetworkAlrtCritlty,
  cast('' as /sapapo/alert_order) AS PPDSProdOvwOrderAlertValue,
  cast('' as /sapapo/pov_order_alert_crit) AS PPDSProdOvwOrderAlrtCritlty,
  cast('' as /sapapo/pov_plan_run_info) AS PPDSProdOvwPlnRunInfoValue,
  cast('' as /sapapo/pov_plan_run_info_crit) AS PPDSProdOvwPlnRunInfoCritlty,
  cast('0' as /sapapo/pov_plan_run_date_time) AS PPDSProdOvwPlnRunDateTme,
  cast('' as /sapapo/cmds_cust_locno) AS PPDSProdOvwCustomerLocation,
  cast('' as /sapapo/extra) AS PPDSProdOvwRcptRqmtsElmntVal,
  cast('' as /sapapo/pov_charact_values) AS PPDSProdOvwCharcValCode,
  cast('' as /sapapo/pov_char_v_p) AS PPDSProdOvwCharcValue,
  cast('0' as /sapapo/pov_avail_req_datetime) AS PPDSProdOvwAvailyRqmtDteTme,
  cast('0' as /sapapo/pov_calc_days_supply1) AS PPDSProdOvwCalcdDaysSup1Val,
  cast('' as /sapapo/alert_cover1) AS PPDSProdOvwDaysSupAlrt1,
  cast('' as /sapapo/pov_dayssup_alrt1_crit) AS PPDSProdOvwDaysSupAlrt1Critlty,
  cast('0' as /sapapo/pov_calc_days_supply2) AS PPDSProdOvwCalcdDaysSup2Val,
  cast('' as /sapapo/alert_cover2) AS PPDSProdOvwDaysSupAlrt2,
  cast('' as /sapapo/pov_dayssup_alrt2_crit) AS PPDSProdOvwDaysSupAlrt2Critlty,
  cast('0' as /sapapo/pov_planning_horizon) AS PPDSProdOvwPlnHrznDteTme,
  cast('' as /sapapo/pov_extended_selection) AS PPDSProdOvwExtdSelValue,
  cast('0' as /sapapo/startti) AS PPDSProdOvwStrtPlnHrznDteTme,
  cast('0' as /sapapo/endti) AS PPDSProdOvwEndPlnHrznDteTme,
  cast('' as /sapapo/pov_timezone_mode) AS PPDSProdOvwTimeZoneMode,
  cast('' as tzniana) AS PPDSProdOvwTimeZoneApp,
  cast('' as tzniana) AS PPDSProdOvwTimeZoneFLP,
  cast('' as /sapapo/pov_plan_seg_account) AS PPDSProdOvwPlngSgmtAcct
FROM /sapapo/simsess
;