I_TenderingStepEnrcd

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_TenderingStepEnrcd.
-- 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_TenderingStepEnrcd AS
SELECT
  TransportationOrderUUID,
  TenderingStepUUID,
  TenderingUUID,
  TenderingStepSequenceNumber,
  TenderingType,
  TndrgStepLifeCycleStatus,
  TenderingProcessMode,
  CarrierAssignmentMethod,
  TenderingPreferredCurrency,
  TndrgStepAbsltPriceLimitAmount AS TndrgStepAbsolutePriceLimit,
  RelativePriceLimitInPercent,
  cast(cast('MIN' as abap.unit(3)) as /scmtms/vdm_max_rsp_durn_unit preserving type) AS MaximumResponseDurationUnit,
  TrAlcAndBusShrIsUpdtdByRFQ,
  TenderingStepStartDateTime,
  cast(cast(substring(cast(TenderingStepStartDateTime as abap.char(17)), 1, 8) as abap.dats) as /scmtms/vdm_tend_stp_strt_dte preserving type) AS TenderingStepStartDate,
  TenderingStepEndDateTime
FROM I_TenderingStep
LEFT OUTER JOIN I_TenderingRequestEnrcd AS _TenderingRequestEnrcd ON TenderingStepUUID = _TenderingRequestEnrcd.TenderingStepUUID AND TransportationOrderUUID = _TenderingRequestEnrcd.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationOrderEnrcd AS _TransportationOrderEnrcd ON TransportationOrderUUID = _TransportationOrderEnrcd.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TenderingEnrcd AS _TenderingEnrcd ON TenderingUUID = _TenderingEnrcd.TenderingUUID AND TransportationOrderUUID = _TenderingEnrcd.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaximumResponseDurationUnit ON MaximumResponseDurationUnit = _MaximumResponseDurationUnit.UnitOfMeasure  -- association [0..1]
;