I_Tendering

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_Tendering.
-- 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_Tendering AS
SELECT
  cast(db_key as /scmtms/vdm_tend_uuid preserving type) AS TenderingUUID,
  cast(parent_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  cast(rel_torq_uuid as /scmtms/vdm_tor_ref_db_key preserving type ) AS RefTransportationOrderUUID,
  cast(tend_seq_nr as /scmtms/vdm_tend_sqnc_number preserving type ) AS TenderingSequenceNumber,
  tend_process_res AS TenderingProcessResult,
  cast(lifecycle as /scmtms/tend_lifecycle_status preserving type ) AS TenderingLifeCycleStatus,
  cast(created_by as /scmtms/vdm_tend_crted_by_user preserving type ) AS TenderingCreatedByUser,
  cast(changed_by as /scmtms/vdm_tend_chgd_by_user preserving type ) AS TenderingChangedByUser,
  cast(start_datetime as /scmtms/vdm_tend_start_dtetime preserving type) AS TenderingStartDateTime,
  cast(end_datetime as /scmtms/vdm_tend_end_datetime preserving type) AS TenderingEndDateTime,
  tend_manager AS TenderingManager,
  cast(cast( lowest_price_prop as abap.dec(31,6)) * 10000 as /scmtms/vdm_tend_lowest_amount ) AS TenderingLowestProposedAmount,
  cast(lowest_price_prop_curr as /scmtms/vdm_tend_lowestamtcrcy preserving type ) AS TenderingLowestProposedAmtCrcy
FROM /scmtms/d_torten
LEFT OUTER JOIN I_TenderingStep AS _TenderingStep ON TenderingUUID = _TenderingStep.TenderingUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrder AS _RefTransportationOrder ON RefTransportationOrderUUID = _RefTransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TenderingProcessResult AS _TenderingProcessResult ON TenderingProcessResult = _TenderingProcessResult.TenderingProcessResult  -- association [0..1]
LEFT OUTER JOIN I_TenderingLifeCycleStatus AS _TenderingLifeCycleStatus ON TenderingLifeCycleStatus = _TenderingLifeCycleStatus.TenderingLifeCycleStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _TenderingCreatedByUser ON TenderingCreatedByUser = _TenderingCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _TenderingChangedByUser ON TenderingChangedByUser = _TenderingChangedByUser.UserID  -- association [0..1]
;