I_PhysInvtryGaugeRdng

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_PhysInvtryGaugeRdng.
-- 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: IPHYINVGR

CREATE VIEW I_PhysInvtryGaugeRdng AS
SELECT
  PhysInvtryGR.StorageObjSgmntNmbr AS StorageObjSgmntNmbr,
  OpenTankDipTime,
  EventsInSiloTankDip,
  tstmp_to_dats( cast( OpenTankDipTime as abap.dec( 15, 0 )), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as PostingDate AS clientNULLasPostingDate,
  ReltdBookStkTankDipQty,
  OilLinearVolCnvrsnSetNmbr,
  StorageLocIndex.Plant AS Plant,
  StorageLocIndex.Location AS Location,
  StorageLocIndex.SequenceNumber AS SequenceNumber,
  MatAssign.Material AS Material,
  MatlDesc.MaterialDescription AS MaterialDescription,
  MatAssign.UnitOfMeasureGroup AS UnitOfMeasureGroup,
  MatAssign.ConversionGroup AS ConversionGroup,
  RecalibrationIndex,
  TankDipTotalHeight,
  TankDipTotalHeightUoM,
  TankDipWaterHeight,
  TankDipWaterHeightUoM,
  TankDipQtyStkKeepingUnit,
  BaseUnit,
  LinearVolMaterialQty,
  LinearVolWaterQty,
  DippingMethodInnageUllage,
  LinearVolCnvrsnUom,
  DipGUID,
  OilTankDipCreateDate,
  OilTankDipCreateTime,
  CreatedByUser,
  OilTankDipChangeDate,
  OilTankDipChangeTime,
  OilTankDipChangedByUser,
  IsTankDipBlocked,
  IsDeleted,
  TankDipTotalHeightFLTP,
  TankDipWaterHeightFLTP,
  TankDipTotalHeightString,
  TankDipWaterHeightString,
  IsReconciliationCompletion,
  OilTimeStampDisplay,
  StartDate,
  OpenTankDipTimeDcml,
  CurrentSystemUTCDateTime
FROM I_PhysInvtryGaugeRdngFld AS PhysInvtryGR
INNER JOIN I_StorageLocationIndex AS StorageLocIndex ON /* join condition not captured in parsed metadata */
INNER JOIN I_TimeDepdntMatlAssign AS MatAssign ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDescription AS MatlDesc ON /* join condition not captured in parsed metadata */
;