I_LocationVersion

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_LocationVersion.
-- 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: ILOCATIONVERS

CREATE VIEW I_LocationVersion AS
SELECT
  cast( locid as /sapapo/location_id preserving type ) AS LocationUUID,
  cast( simid as /sapapo/pln_version_uuid preserving type ) AS PlanningVersionUUID,
  cast( tsdurat as /sapapo/duration_max preserving type ) AS MaximumDuration,
  cast( tsdurat_min as /sapapo/duration_min preserving type ) AS MinimumDuration,
  conhinb_tp AS HandlingCapacityConsumptionInb,
  unitinb_tp AS HndlgCapConsumptionInboundUnit,
  conhout_tp AS HndlgCapacityConsumptionOutb,
  unitout_tp AS HndlgCapCnsmpnOutboundUnit,
  stkprofid AS SrvcPartsStkngStrgyPrfl,
  dstkprofid AS SrvcPartsDstkngStrgyPrfl,
  wssprofid AS SrvcPartsWrhsSpaceSvngPrfl,
  minsrplvallmt AS SrvcPartsSurplusQtyThldVal,
  srplapprvallmt AS SrvcPartsSurplusApprvlThldVal
FROM /sapapo/locver
LEFT OUTER JOIN I_LocationBasic AS _LocationBasic ON LocationUUID = _LocationBasic.LocationUUID  -- association [1..1]
;