I_ProductionSupplyArea

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_ProductionSupplyArea.
-- 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: IPPPRODNSUPAREA

CREATE VIEW I_ProductionSupplyArea AS
SELECT
  cast(pvbe.prvbe as vdm_prvbe preserving type) AS ProductionSupplyArea,
  pvbe.werks AS Plant,
  cast(pvbe.lgort as pph_lgort preserving type) AS StorageLocation,
  pvbe.ablad AS UnloadingPointName,
  pvbe.pvadr AS AddressID,
  pvbe.rgver AS ProductionSupplyAreaRespPerson,
  cast(pvbe.fabklv as fabkl preserving type) AS FactoryCalendar,
  pvbe.schgrupv AS ShiftGrouping,
  pvbe.sprogv AS ShiftSequence,
  pvbe.pintvd AS PullIntervalInWorkdays,
  cast(pvbe.pintvm as pintv_hrs_min) AS PullIntervalInHoursAndMinutes,
  pvbe.lgbzo AS UnloadingWarehouseStagingArea,
  pvbe.lastchange_datetime AS LastChangeDateTime,
  pvbe.loadingpoint AS AutomotiveLoadingPoint
FROM pvbe
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _ResponsiblePerson ON Plant = _ResponsiblePerson.Plant AND ProductionSupplyAreaRespPerson = _ResponsiblePerson.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _Text ON Plant = _Text.Plant AND ProductionSupplyArea = _Text.ProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN I_OrganizationAddress AS _Address ON AddressID = _Address.AddressID AND _Address.AddressPersonID is initial AND _Address.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_ShiftGrouping AS _ShiftGrouping ON ShiftGrouping = _ShiftGrouping.ShiftGrouping  -- association [0..1]
LEFT OUTER JOIN I_ShiftSequence AS _ShiftSequence ON ShiftSequence = _ShiftSequence.ShiftSequence AND ShiftGrouping = _ShiftSequence.ShiftGrouping  -- association [0..1]
;