I_SiloTankDip

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_SiloTankDip.
-- 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: ISILOTANDIP

CREATE VIEW I_SiloTankDip AS
SELECT
  v1.StorageObjSgmntNmbr AS StorageObjSgmntNmbr,
  v1.OpenTankDipTime AS OpenTankDipTime,
  v3.Material AS Material,
  v1.TankDipTotalHeight AS TankDipTotalHeight,
  v1.TankDipTotalHeightUoM AS TankDipTotalHeightUoM,
  v1.TankDipWaterHeight AS TankDipWaterHeight,
  v1.TankDipWaterHeightUoM AS TankDipWaterHeightUoM,
  v1.LinearVolMaterialQty AS LinearVolMaterialQty,
  v1.LinearVolWaterQty AS LinearVolWaterQty,
  v1.LinearVolCnvrsnUom AS LinearVolCnvrsnUom,
  cast('' as abap.unit(3)) AS NetStandardVolumeUoM,
  cast(0 as abap.quan( 13, 3 )) AS NetStandardVolume,
  cast('' as abap.unit(3 )) AS DryGrossVolumeUoM,
  cast(0 as abap.quan( 13, 3 )) AS DryGrossVolume,
  t2.dip_guid AS DipGUID,
  max( case when t2.par_name = 'OBSMTMETTP' then t2.par_char else '' end ) AS AmbientTemperature,
  max( case when t2.par_name = 'OBSMTMETTP' then t2.unit_char else '' end ) AS AmbientTemperatureUnit,
  max( case when t2.par_name = 'STDDEN' then t2.par_char else '' end ) AS StandardDensity,
  max( case when t2.par_name = 'STDDEN' then t2.unit_char else '' end ) AS StandardDensityUnit,
  max( case when t2.par_name = 'BSWCN' then t2.par_char else '' end ) AS BaseSedimentWater,
  max( case when t2.par_name = 'BSWCN' then t2.unit_char else '' end ) AS BaseSedimentWaterUnit,
  max( case when t2.par_name = 'EQ_LIQ_VOL' then fltp_to_dec(t2.par_fltp as abap.dec( 13,3 ) ) else 0 end ) AS VaporLiqVolume,
  max( case when t2.par_name = 'EQ_LIQ_VOL' then t2.unit_char else '' end ) AS VaporLiqVolumeUnit,
  max( case when t2.par_name = 'SHELLTEMP' then t2.par_char else '' end ) AS ShellTemperature,
  max( case when t2.par_name = 'SHELLTEMP' then t2.unit_char else '' end ) AS ShellTemperatureUnit
FROM I_PhysInvtryGaugeRdngFld AS v1
INNER JOIN I_SiloTankDipLatest AS v2 ON /* join condition not captured in parsed metadata */
INNER JOIN I_TimeDepdntMatlAssign AS v3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SiloTankMatlAssign AS v4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oii_dip_param AS t2 ON /* join condition not captured in parsed metadata */
;