R_TravelRequestServicesDraft

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_TravelRequestServicesDraft.
-- 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_TravelRequestServicesDraft AS
SELECT
  ServicesDraft.personnelnumber AS PersonnelNumber,
  ServicesDraft.traveltripnumber AS TravelTripNumber,
  ServicesDraft.travelrequuid AS TravelReqUUID,
  ServicesDraft.seqrequuid AS SeqReqUUID,
  ServicesDraft.travelservicerequestnumber AS TravelServiceRequestNumber,
  ServicesDraft.travelexpnsequentialnumber AS TravelExpnSequentialNumber,
  ServicesDraft.travelitemtype AS TravelItemType,
  ServicesDraft.tripservicetypename AS TripServiceTypeName,
  ServicesDraft.travelitemtypefordisplay AS TravelItemTypeForDisplay,
  ServicesDraft.tripsegmentbegindate AS TripSegmentBeginDate,
  ServicesDraft.tripsegmentstarttime AS TripSegmentStartTime,
  ServicesDraft.tripsegmentenddate AS TripSegmentEndDate,
  ServicesDraft.tripsegmentendtime AS TripSegmentEndTime,
  ServicesDraft.tripstartinglocationname AS TripStartingLocationName,
  ServicesDraft.departurecountry AS DepartureCountry,
  ServicesDraft.departurecountryname AS DepartureCountryName,
  ServicesDraft.tripendlocationname AS TripEndLocationName,
  ServicesDraft.destinationcountry AS DestinationCountry,
  ServicesDraft.destinationcountryname AS DestinationCountryName,
  ServicesDraft.trvlreqhasarrivalordeptr AS TrvlReqHasArrivalOrDeptr,
  ServicesDraft.salesoffcdetn AS SalesOffcDetn,
  ServicesDraft.othertravelservicecode AS OtherTravelServiceCode,
  ServicesDraft.iatadeparturelocation AS IATADepartureLocation,
  ServicesDraft.iatadestinationlocation AS IATADestinationLocation,
  ServicesDraft.otherservicestatus AS OtherServiceStatus,
  ServicesDraft.trvlreqothsrvcconfnmbr AS TrvlReqOthSrvcConfNmbr,
  ServicesDraft.tripreqpriceintravelcurrency AS TripReqPriceInTravelCurrency,
  ServicesDraft.triprequestcurrency AS TripRequestCurrency,
  ServicesDraft.travelrequestcomment AS TravelRequestComment,
  ServicesDraft.lastchangedatetime AS LastChangeDateTime,
  ServicesDraft.trvlsrvcslocllastchgddtetme AS TrvlSrvcsLoclLastChgdDteTme,
  ServicesDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  ServicesDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  ServicesDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  ServicesDraft.draftentityoperationcode AS DraftEntityOperationCode,
  ServicesDraft.hasactiveentity AS HasActiveEntity
FROM trvs4_srvreq_d AS ServicesDraft
LEFT OUTER JOIN E_TravelRequestServicesDraft AS _ExtensionTrvlServices ON PersonnelNumber = _ExtensionTrvlServices.PersonnelNumber AND TravelTripNumber = _ExtensionTrvlServices.TravelTripNumber AND TravelReqUUID = _ExtensionTrvlServices.TravelReqUUID AND SeqReqUUID = _ExtensionTrvlServices.SeqReqUUID AND TravelServiceRequestNumber = _ExtensionTrvlServices.TravelServiceRequestNumber  -- association [1..1]
;