I_OIL_StorageObjCharcSegment

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_StorageObjCharcSegment.
-- 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_StorageObjCharcSegment AS
SELECT
  socnr AS StorObjectCharcSegmentNumber,
  objnr AS ControllingObject,
  socam AS StorageObjectCharcAccessMode,
  sockl AS StorObjectCharacteristicClass,
  soctyp AS StorageObjectType,
  equnr AS StorageObjEquipmentNumber,
  cast ( tplnr as tplnr_unconverted ) AS StorageObjectFunctionalLoc,
  herst AS StorObjEquipmentManufacturer,
  herld AS ManufacturerCountry,
  hzein AS ManufacturerDrawingNumber,
  serge AS ManufacturerSerialNumber,
  typbz AS ManufacturerModelNumber,
  baujj AS StorObjectYearOfConstruction,
  baumm AS StorObjectMonthOfConstruction,
  volun AS TankVolumeUnitOfMeasure,
  masun AS TankMassUnit,
  lenun AS TankLengthUnit,
  frtun AS FlowRateUnitOfMeasure,
  timun AS TankTimeUnit,
  tmpun AS TankTemperatureUnit,
  dnsun AS DensityUnitOfMeasure,
  spvun AS VolumePerHeightUnitOfMeasure,
  dntyp AS OilDensityType,
  kapaz AS StorageObjectCapacity,
  mxmas AS StorageObjectMaxSafetyWeight,
  gxdat AS GenStorageObjectUsgeExpiryDate,
  gxtim AS GenStorageObjectUsgeExpiryTime,
  gxrea AS GenStorObjectUsgeExpiryReason,
  sogrp AS StorageObjectHasGroup,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion,
  st_gauge_rt AS StopGaugeCalculationRoutine
FROM oiisock
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON _ControllingObject.ControllingObject = ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_OIL_StorageObjectAccessMode AS _StorageObjectAccessMode ON _StorageObjectAccessMode.StorageObjectCharcAccessMode = StorageObjectCharcAccessMode  -- association [0..1]
LEFT OUTER JOIN I_OIL_StorObjectCharcClassVH AS _StorObjectCharcClass ON _StorObjectCharcClass.StorObjectCharacteristicClass = StorObjectCharacteristicClass  -- association [0..1]
LEFT OUTER JOIN I_OIL_StorageObjectTypeVH AS _StorageObjectType ON _StorageObjectType.StorageObjectType = StorageObjectType  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = StorageObjEquipmentNumber  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = StorageObjectFunctionalLoc  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = ManufacturerCountry  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnitOfMeasure ON _VolumeUnitOfMeasure.UnitOfMeasure = TankVolumeUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MassUnitOfMeasure ON _MassUnitOfMeasure.UnitOfMeasure = TankMassUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LengthUnitOfMeasure ON _LengthUnitOfMeasure.UnitOfMeasure = TankLengthUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _FlowRateUnitOfMeasure ON _FlowRateUnitOfMeasure.UnitOfMeasure = FlowRateUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TimeUnitOfMeasure ON _TimeUnitOfMeasure.UnitOfMeasure = TankTimeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TemperatureUnitOfMeasure ON _TemperatureUnitOfMeasure.UnitOfMeasure = TankTemperatureUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DensityUnitOfMeasure ON _DensityUnitOfMeasure.UnitOfMeasure = DensityUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumePerHeightUnitOfMeasure ON _VolumePerHeightUnitOfMeasure.UnitOfMeasure = VolumePerHeightUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_OIL_ConversionDensityTypeVH AS _ConversionDensityType ON _ConversionDensityType.ConversionGroupsDensityType = OilDensityType  -- association [1..1]
LEFT OUTER JOIN I_OIL_StopGaugeCalcRoutine AS _StopGaugeCalcRoutine ON _StopGaugeCalcRoutine.StopGaugeCalculationRoutine = StopGaugeCalculationRoutine  -- association [1..1]
;