R_TrvlReqEstimatedCostDraft

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 R_TrvlReqEstimatedCostDraft.
-- 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 R_TrvlReqEstimatedCostDraft AS
SELECT
  EstimatedCostDraft.personnelnumber AS PersonnelNumber,
  EstimatedCostDraft.traveltripnumber AS TravelTripNumber,
  EstimatedCostDraft.travelrequuid AS TravelReqUUID,
  EstimatedCostDraft.seqrequuid AS SeqReqUUID,
  EstimatedCostDraft.travelmedium AS TravelMedium,
  EstimatedCostDraft.travelexpnsequentialnumber AS TravelExpnSequentialNumber,
  EstimatedCostDraft.travelmediumcategory AS TravelMediumCategory,
  EstimatedCostDraft.isreadonly AS IsReadOnly,
  EstimatedCostDraft.travelmediumtype AS TravelMediumType,
  EstimatedCostDraft.estimatedcost AS EstimatedCost,
  EstimatedCostDraft.currency AS Currency,
  EstimatedCostDraft.sumlineistotal AS SumLineIsTotal,
  EstimatedCostDraft.estimatedcostcategoryname AS EstimatedCostCategoryName,
  EstimatedCostDraft.estimatedcostisapproved AS EstimatedCostIsApproved,
  EstimatedCostDraft.estdcostsortsequencevalue AS EstdCostSortSequenceValue,
  EstimatedCostDraft.EstdCostSortAsIntegerValue AS EstdCostSortAsIntegerValue,
  EstimatedCostDraft.criticality AS Criticality,
  EstimatedCostDraft.lastchangedatetime AS LastChangeDateTime,
  EstimatedCostDraft.estdcostlocllastchgddtetme AS EstdCostLoclLastChgdDteTme,
  EstimatedCostDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  EstimatedCostDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  EstimatedCostDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  EstimatedCostDraft.draftentityoperationcode AS DraftEntityOperationCode,
  EstimatedCostDraft.hasactiveentity AS HasActiveEntity
FROM trvs4_estcost_d AS EstimatedCostDraft
LEFT OUTER JOIN E_TrvlReqEstimatedCostDraft AS _ExtensionEstCost ON PersonnelNumber = _ExtensionEstCost.PersonnelNumber AND TravelTripNumber = _ExtensionEstCost.TravelTripNumber AND TravelReqUUID = _ExtensionEstCost.TravelReqUUID AND SeqReqUUID = _ExtensionEstCost.SeqReqUUID AND TravelMedium = _ExtensionEstCost.TravelMedium  -- association [1..1]
;