I_EHSAmountRoot

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_EHSAmountRoot.
-- 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: IEHSAMNROOT

CREATE VIEW I_EHSAmountRoot AS
SELECT
  EHSAmountUUID,
  cast( creationdatetime as ehfnd_datetime_cr preserving type ) AS CreationDateTime,
  cast( lastchangedatetime as ehfnd_datetime_ch preserving type ) AS LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  EHSAmountSourceUUID,
  EHSAmountSourceType,
  EHSSubjectType,
  EHSSubjectUUID,
  EHSAmountProcessUUID,
  EHSAmountUTCDateTime,
  EHSAmountValue,
  value AS EHSAmountValueAsText,
  UnitOfMeasure,
  _UnitText._Text[1: Language = $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
  cast(unitofmeasuredimension as dimid preserving type ) AS UnitOfMeasureDimension,
  EHSAmountCategory,
  EHSAmountSubjComponentType,
  EHSAmountSubjComponentUUID,
  EHSAmountIsMissing,
  EHSAmountIsFaulty,
  EHSAmountIsNotAvailable,
  EHSAmountIsReplaced,
  EHSAmountDeviationID,
  EHSAmountHasWarning,
  EHSAmountIsPreliminary,
  cast( ehsamountstatus as ehfnd_amns_status_code_nc preserving type ) AS EHSAmountStatus,
  ehsamountstatus AS EHSAmountStatusName,
  EHSAmountExternalSource,
  EHSAmtOutOfPrecisenessOptr,
  Note,
  EHSAmountMigrationSource,
  EHSDataAmountControllingObject
FROM ehfndv_amns_root
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_EHSAmountHistory AS _EHSAmountHistory ON EHSAmountUUID = _EHSAmountHistory.EHSAmountUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSAmountLimitFail AS _EHSAmountLimitFail ON EHSAmountUUID = _EHSAmountLimitFail.EHSAmountUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSAmountStatus AS _EHSAmountStatus ON EHSAmountStatus = _EHSAmountStatus.EHSAmountStatus  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitText ON UnitOfMeasure = _UnitText.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EHSAmountSourceType AS _EHSAmountSourceType ON EHSAmountSourceType = _EHSAmountSourceType.EHSAmountSourceType  -- association [0..1]
LEFT OUTER JOIN E_EHSDataAmount AS _Extension ON EHSAmountUUID = _Extension.EHSAmountUUID  -- association [1..1]
;