I_TravelAddlDestination

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_TravelAddlDestination.
-- 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_TravelAddlDestination AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  DestinationAssignment,
  DestinationType,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS SeqReqUUID,
  TravelExpnSequentialNumber,
  TripBeginsOnDate,
  TripBeginsAtTime,
  AddressNumber,
  CityName,
  DistrictName,
  PostalCode,
  CityCodeName,
  TravelCommunityCityName,
  TravelCommunityDistrictName,
  TravelCommunityPostCode,
  StreetName,
  HouseNumber,
  Country,
  Region,
  MealsPerDiemHasTxn,
  MealsPerDiemHasMnlTxn,
  AcmdtnPerDiemHasMnlTxn,
  TripDestTypeName,
  CountryRegionName,
  TripTypeStatutoryName,
  TripTypeEnterpriseName,
  AddlDestTypeOfTripActyName,
  AbsenceTypeName,
  AllowanceTypeName,
  TrvlReqSprtnAllwncName,
  SleepAtHomeName,
  DurnOfPrvtTripBreakName,
  TripReasonText,
  TripDestination,
  coalesce( cast(_TravelActivityPlanningVH.TripActivityTypeName as vdm_plan_activity_name preserving type ), ' ' ) AS TripActivityTypeName,
  TripRegion,
  AddlDestSleepAtHome,
  AddlDestDurnOfPrvtTripBreak,
  NrOfPerDiemNights,
  AddlDestAbsenceType,
  AddlDestAllowanceType,
  TrvlReqSprtnAllwnc,
  AcmdtnIsChargeable,
  TripDestinationLong,
  TripItineraryNumber,
  cast(tstmp_current_utctimestamp() as vdm_lastchangedon ) AS LastChangeDateTime,
  cast(0.0000000 as abp_lastchange_tstmpl) AS AddlDestLoclLastChgdDteTme,
  TravelCountryRegion
FROM I_TravelAddlDestData
LEFT OUTER JOIN I_TravelActivityPlanningVH AS _TravelActivityPlanningVH ON I_TravelAddlDestData.TripActivityType = _TravelActivityPlanningVH.TravelRequestTripActivityType  -- association [0..1]
LEFT OUTER JOIN C_TravelCountryRegionVH AS _TravelCountryRegionVH ON TravelCountryRegion = _TravelCountryRegionVH.TripRegionCountry AND PersonnelNumber = _TravelCountryRegionVH.PersonnelNumber AND TravelTripNumber = _TravelCountryRegionVH.TravelTripNumber AND TravelReqUUID = _TravelCountryRegionVH.TravelReqUUID  -- association [0..1]
LEFT OUTER JOIN E_TravelAddlDestData AS _ExtensionAddlDest ON PersonnelNumber = _ExtensionAddlDest.PersonnelNumber AND TravelTripNumber = _ExtensionAddlDest.TravelTripNumber AND TravelExpnSequentialNumber = _ExtensionAddlDest.TravelExpnSequentialNumber AND DestinationAssignment = _ExtensionAddlDest.DestinationAssignment AND DestinationType = _ExtensionAddlDest.DestinationType AND 'PL' = _ExtensionAddlDest.TripSchema  -- association [0..1]
;