I_UtilitiesDownload

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_UtilitiesDownload.
-- 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: IDOWNLOADFBR

CREATE VIEW I_UtilitiesDownload AS
SELECT
  object_id AS ISU_BR_DownloadObject,
  meter_reader_unit AS MeterReadingUnit,
  scheduled_meter_reading_date AS ScheduledMeterReadingDate,
  meter_reading_document AS MeterReadingDocument,
  contract AS UtilitiesContract,
  material_number AS Material,
  object_status AS ObjectStatus,
  download_date AS DownloadDate,
  download_execution_date AS ISU_BR_DownloadExecutionDate,
  download_user AS SubmittedByUser,
  download_execution_hour AS DownloadTime,
  target_system_id AS ISU_BR_TargetSystemNumber,
  meter_reading_reason AS MeterReadingReason,
  installation AS UtilitiesInstallation,
  industry_system AS IndustrySystemType,
  meter_reading_center AS ISU_BR_MeterReadingCenterLbl,
  meter_reading_date_relevant_to AS MeterReadingDate,
  equipment_number AS Equipment,
  register AS UtilitiesRegister,
  meter_reading_type AS MeterReadingType,
  upload_date AS ISU_BR_UploadDate,
  upload_hour AS ISU_BR_UploadTime,
  upload_user AS ISU_BR_UploadedByUser,
  reverse_date AS ISU_BR_ReverseDate,
  reverse_hour AS ISU_BR_ReverseTime,
  reverse_user AS ISU_BR_ReversedByUser
FROM P_UtilitiesDownload
;