I_PRAStorObjCalibrnSetHdr

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_PRAStorObjCalibrnSetHdr.
-- 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_PRAStorObjCalibrnSetHdr AS
SELECT
  slvnr_uuid AS TankStrappingHdrUUID,
  socnr_uuid AS TankStorageObjUUID,
  eff_from_dt AS TankStrappingEffctvFrmDate,
  eff_to_dt AS TankStrappingEffctvToDate,
  nrdec AS TankStrappingUoMNmbrOfDecimals,
  maxin AS OilTankMaximumInFlowQty,
  maxout AS OilTankMaximumOutFlowQty,
  waskz AS OilTankMaximumContaminantQty,
  waspc AS OilTankMaximumContaminantPct,
  expacorr AS ThermalExpansionIsSelected,
  roofcorr AS FloatingRoofCrrtnIsSelected,
  watrcorr AS WaterCorrectionIsSelected,
  ul_in_ind AS DippingMethodInnageUllage,
  iso_shell AS TankThrmlInsulationIsSelected,
  maxdp AS MaximumHeight,
  mindp AS MinimumHeight,
  unpkz AS UnpumpableQuantity,
  unppc AS UnpumpableQuantityInPct,
  flmas AS FloatingRoofWeight,
  expcoeff AS ThermalExpansionCoefficientVal,
  calfilhgt AS TankDipTotalHeight,
  caltemp AS OilTankCalibrationTemperature,
  caldens AS OilTankCalibrationLqdDens,
  calname AS OilTankCalibratorName,
  caldate AS OilTankCalibrationDate,
  min_fltroof AS MinimumFloatingRoofHeight,
  kapaz AS TankCapacity,
  inch_increment AS NumberOfInchesIncrements,
  volun AS MaterialVolumeUoM,
  masun AS MassUoMTank,
  lenun AS TankDipTotalHeightUoM,
  frtun AS FlowRateUnitOfMeasure,
  timun AS DisplayTimeUnit,
  tmpun AS UnitOfMeasureTemperatureUnit,
  dnsun AS UnitForDensity,
  spvun AS VolumePerHeightUnitOfMeasure,
  dntyp AS DensityType,
  local_last_changed_at AS PRALoclLastChgdAtDateTime
FROM oiu_oiislvcko AS PRAStorObjCalibrnSetHdr
LEFT OUTER JOIN I_PRAStorObjCharcsSgmtHdr AS _PRAStorObjCharcsSgmtHdr ON TankStorageObjUUID = _PRAStorObjCharcsSgmtHdr.TankStorageObjUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialVolumeUoM = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PRATankDippingMeth AS _PRATankDippingMeth ON DippingMethodInnageUllage = _PRATankDippingMeth.TankDippingMethod  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAMassUoMTank ON MassUoMTank = _PRAMassUoMTank.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRALengthUoM ON TankDipTotalHeightUoM = _PRALengthUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRATempUoM ON UnitOfMeasureTemperatureUnit = _PRATempUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAVolPerHgtUoM ON VolumePerHeightUnitOfMeasure = _PRAVolPerHgtUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRADenUoM ON UnitForDensity = _PRADenUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAFlowRateUoM ON FlowRateUnitOfMeasure = _PRAFlowRateUoM.UnitOfMeasure  -- association [0..1]
;