I_OIL_GeneralMeter

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_OIL_GeneralMeter.
-- 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_OIL_GeneralMeter AS
SELECT
  gmmnr AS GeneralMeterNumber,
  objnr AS ControllingObject,
  gmmtyp AS GeneralMeterType,
  equnr AS Equipment,
  cast(tplnr as char30 ) AS FunctionalLocation,
  herst AS EquipmentManufacturerName,
  herld AS ManufacturerCountry,
  serge AS ManufacturerSerialNumber,
  typbz AS ManufacturerModelNumber,
  baujj AS MeterYearOfConstruction,
  baumm AS ConstructionMonth,
  volun AS VolumeUnit,
  masun AS TankMassUnit,
  lenun AS TankLengthUnit,
  nrdig AS NumberOfDigitsOnMeter,
  nrdpl AS NumberOfDecimalPlacesOnMeter,
  confac AS MeterConversionFactor,
  matnr AS Material,
  recdat AS LastRecalibrationDate,
  rectim AS LastRecalibrationTime,
  stcoun AS StartReadingValue,
  servtyp AS SrvcStnRetailingServiceType,
  qmet_ind AS MeterReadingIsQuantityValue,
  matswitch AS MeterMatStorObjIsDifferent,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion,
  last_rdg_chk AS LastMeterReadingCheckIsActive,
  st_mtr_rt AS StopMeterCalcRoutineType
FROM oiigmmk
LEFT OUTER JOIN I_OIL_GeneralMeterText AS _Text ON GeneralMeterNumber = _Text.GeneralMeterNumber  -- association [0..*]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [1..1]
LEFT OUTER JOIN I_OIL_GeneralMeterTypeVH AS _GeneralMeterTypeVH ON GeneralMeterType = _GeneralMeterTypeVH.GeneralMeterType  -- association [1..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON ManufacturerCountry = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON VolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MassUnit ON TankMassUnit = _MassUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LengthUnit ON TankLengthUnit = _LengthUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [1..1]
LEFT OUTER JOIN I_OIL_StoreStopMtrCalcRoutnVH AS _StoreStopMtrCalcRoutnVH ON StopMeterCalcRoutineType = _StoreStopMtrCalcRoutnVH.StopMeterCalcRoutineType  -- association [1..1]
;