I_PhysChmlViscosityDyn

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_PhysChmlViscosityDyn.
-- 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_PhysChmlViscosityDyn AS
SELECT
  cast(ViscosityDynamic.createdbyuser as ehfnd_bo_crea_uname preserving type ) AS CreatedByUser,
  cast(ViscosityDynamic.lastchangedbyuser as ehfnd_bo_lchg_uname preserving type ) AS LastChangedByUser,
  ViscosityDynamic.pcphysdynvscty20lowrqty AS PCPhysDynVscty20LowrQty,
  ViscosityDynamic.pcphysdynvscty20lowrqtytxt AS PCPhysDynVscty20LowrQtyTxt,
  ViscosityDynamic.pcphysdynvscty20uprqtyoptr AS PCPhysDynVscty20UprQtyOptr,
  ViscosityDynamic.pcphysdynvscty20uprqty AS PCPhysDynVscty20UprQty,
  ViscosityDynamic.pcphysdynvscty20uprqtytxt AS PCPhysDynVscty20UprQtyTxt,
  ViscosityDynamic.pcphysdynvscty23lowrqty AS PCPhysDynVscty23LowrQty,
  ViscosityDynamic.pcphysdynvscty23lowrqtytxt AS PCPhysDynVscty23LowrQtyTxt,
  ViscosityDynamic.pcphysdynvscty23uprqtyoptr AS PCPhysDynVscty23UprQtyOptr,
  ViscosityDynamic.pcphysdynvscty23uprqty AS PCPhysDynVscty23UprQty,
  ViscosityDynamic.pcphysdynvscty23uprqtytxt AS PCPhysDynVscty23UprQtyTxt
FROM ehfndv_phvisd AS ViscosityDynamic
LEFT OUTER JOIN I_PhysicalChemicalProperty AS _PhysChmlPrpty ON PhysChmlPrptyUUID = _PhysChmlPrpty.PhysChmlPrptyUUID  -- association [1..1]
LEFT OUTER JOIN I_PCPrptyOptrLowrLmt AS _OperatorLowrQty20 ON PCPhysDynVscty20LowrQtyOptr = _OperatorLowrQty20.PCPrptyLowrLmtOptr  -- association [0..1]
LEFT OUTER JOIN I_PCPrptyOptrUprLmt AS _OperatorUprQty20 ON PCPhysDynVscty20UprQtyOptr = _OperatorUprQty20.PCPrptyUprLmtOptr  -- association [0..1]
LEFT OUTER JOIN I_PCPrptyOptrLowrLmt AS _OperatorLowrQty23 ON PCPhysDynVscty23LowrQtyOptr = _OperatorLowrQty23.PCPrptyLowrLmtOptr  -- association [0..1]
LEFT OUTER JOIN I_PCPrptyOptrUprLmt AS _OperatorUprQty23 ON PCPhysDynVscty23UprQtyOptr = _OperatorUprQty23.PCPrptyUprLmtOptr  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PhysChmlViscosityDynQtyUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;