I_TravelReqFrameworkData

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_TravelReqFrameworkData.
-- 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_TravelReqFrameworkData AS
SELECT
  pernr AS PersonnelNumber,
  reinr AS TravelTripNumber,
  requestvrs AS TravelVersionNumber,
  plan_request AS TrvlReqArePlanReq,
  location_end AS TripDestination,
  country_end AS AddressCountry,
  request_reason AS TripReasonText,
  date_beg AS TravelBeginDate,
  time_beg AS TripSegmentStartTime,
  date_end AS TripSegmentEndDate,
  time_end AS TripSegmentEndTime,
  activity_type AS TypeOfTripActivityValue,
  cast(_TA20R1[1:spras = $session.system_language].name as vdm_plan_activity_name ) AS TripActivityTypeName,
  cast( estimated_cost as vdm_total_estimated_cost ) AS EstimatedCost,
  cast( currency as vdm_estdcostcrcy ) AS EstimatedCostCrcy,
  cast ( status as vdm_trip_status ) AS TravelStatus,
  dates AS LastChangeDate,
  times AS LastChangedAtTime,
  uname AS ChangedByName,
  repid AS ChangeReportName,
  depar AS DepartureWork,
  createdby AS CreatedByName,
  approvedby AS ApprovedByName,
  delivery_date AS DeliveryDate,
  delivery_loc AS DeliveryLocationName,
  delivery_area AS DeliveryAreaName,
  delivery_empl AS RecipientDelivery,
  arrival_work AS ArrivalWork,
  return_work AS ReturnWorkplaceValue,
  t_actype AS TripActivityType,
  perm_trip_appr AS BusTripIsApproved,
  tt_statu AS TripTypeStatutory,
  tt_comsp AS TripTypeEnterprise,
  gwe AS FullTripReimbmtIsRequested,
  edi AS SignificantOfclHasIntrst,
  carry_oth AS NumberOfPassengerWithMe,
  carried_by_oth AS PssngrIsCarriedByOthEmpl,
  datecow AS WorkStartDate,
  timecow AS WorkCommencesTime,
  dateeow AS WorkEndsDate,
  timeeow AS WorkEndsTime,
  incr_max_tripseg_reimb AS MaxTripSgmtReimbmtIsIncrd,
  addr_depar AS AddressDepartureName,
  addr_arrvl AS AddressArrivalName
FROM ftpt_req_head
LEFT OUTER JOIN ta20r1 AS _TA20R1 ON TypeOfTripActivityValue = _TA20R1.acticity  -- association [0..1]
LEFT OUTER JOIN E_TravelGeneralData AS _Extension ON PersonnelNumber = _Extension.PersonnelNumber AND TravelTripNumber = _Extension.TravelTripNumber AND TravelVersionNumber = _Extension.TravelVersionNumber AND TrvlReqArePlanReq = _Extension.TrvlRequestOrPlan  -- association [0..1]
;