I_LinearAssetManagementData

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_LinearAssetManagementData.
-- 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: ILAMDATA

CREATE VIEW I_LinearAssetManagementData AS
SELECT
  obart AS LinearDataObjectType,
  tabkey AS LinearDataObjectKey,
  _ObjectType._Text[1:Language=$session.system_language].LinearDataObjectTypeText AS LinearDataObjectTypeText,
  linear_unit AS LinearDataUnitOfMeasure,
  cast( unit_conversion( quantity => eaml_d_lfe_data.end_point, source_unit => cast( 'M' as abap.unit( 2 ) ), target_unit => eaml_d_lfe_data.linear_unit, error_handling => 'KEEP_UNCONVERTED' ) as abap.dec(11, 3) ) as LinearDataEndPoint AS dec113asLinearDataEndPoint,
  cast( unit_conversion( quantity => start_point, source_unit => cast( 'M' as abap.unit( 2 ) ), target_unit => linear_unit, error_handling => 'KEEP_UNCONVERTED' ) as abap.dec(11, 3) ) as LinearDataStartPoint AS dec113asLinearDataStartPoint,
  lrpid AS LinearReferencePattern,
  marker_start AS LinearDataStartMarker,
  marker_end AS LinearDataEndMarker,
  cast( unit_conversion( quantity => marker_dist_sta, source_unit => cast( 'M' as abap.unit( 2 ) ), target_unit => linear_unit, error_handling => 'KEEP_UNCONVERTED' ) as abap.dec(11, 3) ) as LinearDataStartMarkerDistance AS dec113asLinearDataStartMarkerDistance,
  cast( unit_conversion( quantity => marker_dist_end, source_unit => cast( 'M' as abap.unit( 2 ) ), target_unit => linear_unit, error_handling => 'KEEP_UNCONVERTED' ) as abap.dec(11, 3) ) as LinearDataEndMarkerDistance AS dec113asLinearDataEndMarkerDistance,
  marker_dist_unit AS LinearDataMarkerDistanceUnit,
  offset1_type AS LinearDataFirstOffsetType,
  cast( unit_conversion( quantity => offset1_value, source_unit => cast( 'M' as abap.unit( 2 ) ), target_unit => linear_unit, error_handling => 'KEEP_UNCONVERTED' ) as abap.dec(11, 3) ) as LinearDataFirstOffsetDistance AS dec113asLinearDataFirstOffsetDistance,
  offset1_unit AS LinearDataFirstOffsetUnit,
  offset2_type AS LinearDataSecondOffsetType,
  cast( unit_conversion( quantity => offset2_value, source_unit => cast( 'M' as abap.unit( 2 ) ), target_unit => linear_unit, error_handling => 'KEEP_UNCONVERTED' ) as abap.dec(11, 3) ) as LinearDataSecondOffsetDistance AS dec113asLinearDataSecondOffsetDistance,
  offset2_unit AS LinearDataSecondOffsetUnit
FROM eaml_d_lfe_data
LEFT OUTER JOIN I_LinearDataObjectType AS _ObjectType ON LinearDataObjectType = _ObjectType.LinearDataObjectType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LinearDataUnitOfMeasure ON LinearDataUnitOfMeasure = _LinearDataUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MarkerDistanceUnit ON LinearDataMarkerDistanceUnit = _MarkerDistanceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _FirstOffsetUnit ON LinearDataFirstOffsetUnit = _FirstOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SecondOffsetUnit ON LinearDataSecondOffsetUnit = _SecondOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_LinearAssetOffsetType AS _FirstOffsetTypeCode ON LinearDataFirstOffsetType = _FirstOffsetTypeCode.LinearDataOffsetTypeCode  -- association [0..1]
;