I_TravelExpenseAddlDest

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_TravelExpenseAddlDest.
-- 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_TravelExpenseAddlDest AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  DestinationAssignment,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS SeqReqUUID,
  DestinationType,
  TravelExpnSequentialNumber,
  TripBeginsOnDate,
  TripBeginsAtTime,
  AddressNumber,
  CityName,
  DistrictName,
  PostalCode,
  TravelCommunityCityName,
  TravelCommunityPostCode,
  TravelCommunityDistrictName,
  CityCodeName,
  StreetName,
  HouseNumber,
  Country,
  Region,
  MealsPerDiemHasTxn,
  MealsPerDiemHasMnlTxn,
  AcmdtnPerDiemHasMnlTxn,
  TripDestTypeName,
  CountryRegionName,
  TripTypeStatutoryName,
  TripTypeEnterpriseName,
  AddlDestTypeOfTripActyName,
  AbsenceTypeName,
  AllowanceTypeName,
  TrvlReqSprtnAllwncName,
  SleepAtHomeName,
  DurnOfPrvtTripBreakName,
  TripReasonText,
  TripDestination,
  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,
  hextobin('00') AS AcmdtnIsChargeable_H,
  hextobin('00') AS AcmdtnPerDiemHasMnlTxn_H,
  hextobin('00') AS AddlDestAllowanceType_H,
  hextobin('00') AS AddlDestDurnOfPrvtTripBreak_H,
  hextobin('00') AS AddlDestSleepAtHome_H,
  hextobin('00') AS AddressNumber_H,
  hextobin('00') AS CityCodeName_H,
  hextobin('00') AS CityName_H,
  hextobin('00') AS DistrictName_H,
  hextobin('00') AS HouseNumber_H,
  hextobin('00') AS MealsPerDiemHasMnlTxn_H,
  hextobin('00') AS MealsPerDiemHasTxn_H,
  hextobin('00') AS PostalCode_H,
  hextobin('00') AS StreetName_H,
  hextobin('00') AS TravelCountryRegion_H,
  hextobin('00') AS TripActivityType_H,
  hextobin('00') AS TripBeginsAtTime_H,
  hextobin('00') AS TripBeginsOnDate_H,
  hextobin('00') AS TripDestination_H,
  hextobin('00') AS TripReasonText_H,
  hextobin('00') AS TripTypeEnterprise_H,
  hextobin('00') AS TripTypeStatutory_H,
  hextobin('00') AS TypeOfTripActivityValue_H
FROM I_TravelAddlDestData
LEFT OUTER JOIN C_TravelCountryRegionVH AS _TravelCountryRegionVH ON Country = _TravelCountryRegionVH.TripCountry AND TripRegion = _TravelCountryRegionVH.TripRegion AND PersonnelNumber = _TravelCountryRegionVH.PersonnelNumber AND TravelTripNumber = _TravelCountryRegionVH.TravelTripNumber AND TravelReqUUID = _TravelCountryRegionVH.TravelReqUUID  -- association [0..*]
LEFT OUTER JOIN I_RegionVH AS _RegionVH ON Country = _RegionVH.Country AND Region = _RegionVH.Region  -- association [0..*]
LEFT OUTER JOIN I_TravelActivityPlanningVH AS _TravelActivityPlanningVH ON I_TravelAddlDestData.TripActivityType = _TravelActivityPlanningVH.TravelRequestTripActivityType  -- association [0..*]
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  -- association [0..1]
LEFT OUTER JOIN I_TrvlExpnAddlDestCostAssgmt AS _TrvlExpnAddlDestCostAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
;