C_EHSMyDataCollectionAmounts

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 C_EHSMyDataCollectionAmounts.
-- 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: CEHSAMNSMYDC

CREATE VIEW C_EHSMyDataCollectionAmounts AS
SELECT
  AmountRoot.EHSAmountUUID AS EHSAmountUUID,
  AmountRoot.EHSAmountUTCDateTime AS EHSAmountUTCDateTime,
  AmountRoot.UnitOfMeasureName AS UnitOfMeasureName,
  cast( AmountRoot.UnitOfMeasure as ehfnd_unit_code_nce preserving type ) AS UnitOfMeasure,
  AmountRoot._UnitText AS _UnitText,
  AmountRoot.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  AmountRoot.EHSSubjectType AS EHSSubjectType,
  AmountRoot.EHSSubjectUUID AS EHSSubjectUUID,
  AmountRoot.EHSAmountValue AS EHSAmountValue,
  AmountRoot.EHSAmountValueAsText AS EHSAmountValueAsText,
  cast('' as abap.char( 40 ) ) AS EHSAmountValueInAltvUoMAsText,
  AmountRoot.EHSAmountSourceUUID AS EHSAmountSourceUUID,
  AmountRoot.EHSAmountStatus AS EHSAmountStatus,
  AmountRoot._EHSAmountStatus AS _EHSAmountStatus,
  AmountRoot.Note AS EHSAmountRemarkText,
  AmountRoot.EHSAmountIsMissing AS EHSAmountIsMissing,
  AmountRoot.EHSAmountIsNotAvailable AS EHSAmountIsNotAvailable,
  _EHSMyDataCollection.EHSLocationUUID AS EHSLocationUUID,
  _EHSMyDataCollection._EHSLocation AS _EHSLocation,
  _EHSMyDataCollection.EHSSchedulePeriod AS EHSSchedulePeriod,
  _EHSMyDataCollection.DataUsagePeriodicity AS DataUsagePeriodicity,
  cast ( '' as abap.char( 100 ) ) AS EHSAmountDueText,
  cast ( 3 as abap.int1 ) AS EHSAmountDueCriticality,
  cast ( '' as abap.char( 100 ) ) AS EHSAmountPeriodText,
  cast ( '' as abap.char(2) ) AS EHSAmountNumberOfAttachments,
  _EHSMyDataCollection.EHSAltvUnitOfMeasurement AS EHSAltvUnitOfMeasurement
FROM I_EHSAmountRoot AS AmountRoot
LEFT OUTER JOIN I_EHSAmountIssueTypeText AS _EHSAmountIssueTypeText ON EHSAmountIssueType = _EHSAmountIssueTypeText.EHSAmountIssueType  -- association [0..*]
;