I_UtilitiesPremise

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_UtilitiesPremise.
-- 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: IEPREMISE

CREATE VIEW I_UtilitiesPremise AS
SELECT
  vstelle AS UtilitiesPremise,
  anzpers AS NumberOfPersons,
  eigent AS UtilitiesOwner,
  cast( haus as e_haus_vdm preserving type ) AS UtilitiesConnectionObject,
  erdat AS UtilitiesPremiseCreationDate,
  hptwhnsitz AS UtilsPremiseIsMainResidence,
  cast( tplnummer as tplnr_unconverted preserving type ) AS FunctionalLocation,
  begru AS AuthorizationGroup,
  vbsart AS UtilitiesPremiseType,
  loevm AS DeletionIndicator,
  lgzusatz AS LocationSupplement,
  Floor,
  haus_num2 AS HouseNumberSupplementText,
  RoomNumber,
  str_erg2 AS StreetSupplement1,
  str_erg4 AS StreetSupplement2
FROM evbs
LEFT OUTER JOIN I_UtilsTechObjLocationAddr AS _UtilsTechObjLocationAddr ON UtilitiesConnectionObject = _UtilsTechObjLocationAddr.FunctionalLocation  -- association [1..1]
LEFT OUTER JOIN I_UtilsPremiseIsMainResidence AS _UtilsPremiseIsMainResidence ON UtilsPremiseIsMainResidence = _UtilsPremiseIsMainResidence.UtilsPremiseIsMainResidence  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPremiseType AS _UtilitiesPremiseType ON UtilitiesPremiseType = _UtilitiesPremiseType.UtilitiesPremiseType  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON UtilitiesOwner = _BusinessPartner.BusinessPartner  -- association [0..1]
;