I_UtilsPoDService

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_UtilsPoDService.
-- 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 I_UtilsPoDService AS
SELECT
  vertrag AS UtilsPoDService,
  int_ui AS UtilsInternalPointOfDelivery,
  service_start AS UtilsPoDServiceStartDate,
  service_end AS UtilsPoDServiceEndDate,
  service AS UtilitiesSrvcProviderRole,
  serviceid AS UtilitiesServiceProvider,
  srvprvref AS UtilsServiceProviderRefNumber,
  servprov_pay AS UtilsServiceProviderPaytClass,
  sparte AS UtilitiesDivision,
  startobjtype AS UtilsPoDServiceStartObjectType,
  startobjkey AS UtilsPoDServiceStartObjectKey,
  endobjtype AS UtilsPoDServiceEndObjectType,
  endobjkey AS UtilsPoDServiceEndObjectKey,
  erdat AS UtilsPoDServiceCreationDate,
  ernam AS UtilsPoDServiceCreatedByUser,
  aedat AS UtilsPoDServiceLastChangeDate,
  aenam AS UtilsPoDServiceLastChgdByUser,
  begru AS UtilitiesAuthorizationGroup,
  loevm AS IsMarkedForDeletion,
  prev_serv_start AS UtilsPoDServicePrevStartDate,
  prev_serv_end AS UtilsPoDServicePrevEndDate
FROM eservice
LEFT OUTER JOIN I_UtilsPoDHeader AS _UtilsPoDHeader ON UtilsInternalPointOfDelivery = _UtilsPoDHeader.UtilsInternalPointOfDelivery  -- association [1..1]
LEFT OUTER JOIN I_UtilsServiceProviderRole AS _UtilsServiceProviderRole ON UtilitiesSrvcProviderRole = _UtilsServiceProviderRole.UtilitiesSrvcProviderRole  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesServiceProvider AS _UtilitiesServiceProvider ON UtilitiesServiceProvider = _UtilitiesServiceProvider.UtilitiesServiceProvider  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON UtilitiesDivision = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _StartBusinessObjType ON UtilsPoDServiceStartObjectType = _StartBusinessObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _EndBusinessObjType ON UtilsPoDServiceEndObjectType = _EndBusinessObjType.BusinessObjectType  -- association [0..1]
;