P_SchedProdnPlantTimeZone

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 P_SchedProdnPlantTimeZone.
-- 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: PSHPDTMZNE

CREATE VIEW P_SchedProdnPlantTimeZone AS
SELECT
  t001w.werks AS werks,
  case t001w.adrnr when ' ' then case t001w.land1 when ' ' then ' ' else case t001w.regio when ' ' then ' ' else case _ttz5s_d.tzone when ' ' then _ttz5s.tzone else _ttz5s_d.tzone end end end else case _address.AddressTimeZone when ' ' then case _ttz5_d.tzone when ' ' then _ttz5.tzone else _ttz5_d.tzone end else _address.AddressTimeZone end end as PlantTimeZone AS AddressTimeZoneendendasPlantTimeZone
LEFT OUTER JOIN I_OrganizationAddress AS _address ON _address.AddressID = t001w.adrnr AND _address.AddressRepresentationCode is initial AND _address.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN ttz5s AS _ttz5s_d ON _ttz5s_d.land1 = t001w.land1 AND _ttz5s_d.bland = t001w.regio AND _ttz5s_d.tzonedft = 'X'  -- association [0..1]
LEFT OUTER JOIN ttz5s AS _ttz5s ON _ttz5s.land1 = t001w.land1 AND _ttz5s.bland = t001w.regio  -- association [0..1]
LEFT OUTER JOIN ttz5 AS _ttz5_d ON _ttz5_d.land1 = t001w.land1 AND _ttz5_d.tzonedft = 'X'  -- association [0..1]
LEFT OUTER JOIN ttz5 AS _ttz5 ON _ttz5.land1 = t001w.land1  -- association [0..1]
;