I_TravelExpense

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_TravelExpense.
-- 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_TravelExpense AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  TravelExpnSequentialNumber,
  PeriodSequentialNumber,
  TripDepartureDate,
  DepartureBeginTime,
  TripArrivalDate,
  ArrivalEndTime,
  TripReasonText,
  TripDestination,
  MainDestinationRegion,
  DomesticDeptDate,
  TravelExpenseOutBoundTime,
  DomesticArrvlDate,
  TripRetTime,
  TripSchema,
  MealsPerDiem,
  AccommodationHasPerDiem,
  NrOfOvernightPerDiemNights,
  TrvlExpnHasMealsPerDiemReducn,
  MaxNrOfPerDiemNights,
  EstimatedCost,
  EstimatedCostCrcy,
  PaymentCurrency,
  TravelRequestIsExists,
  TravelPlanIsExists,
  TripHasExpenses,
  TripPrintStatusValue,
  TrvlExpnApprovalStatus,
  SettlmtStatus,
  TrvlExpnHasFinanceTransf,
  HumRscePayrollTransfer,
  DataMdmExchIsTransf,
  CountryGroup,
  TripProvisionVariant,
  TripSettlementDate,
  TripSettlementTime,
  PostingSequenceNumber,
  TrvlExpnHasMilesPerAcctg,
  TripIsLocked,
  LastChangeDate,
  LastChangedAtTime,
  ChangedByName,
  ChangeReportName,
  MovingCostsRefundValue,
  AdminOfficeMoveLabel,
  DiffntEndOfTrvlAllwncDte,
  ReturnWorkplaceValue,
  TrvlExpnNmbrForCorrespgWrk,
  AssocdBusTripNrOfRet,
  DeparturePeriodDate,
  TripBeginsAtTime,
  ArrivalPeriodDate,
  TripEndsAtTime,
  PerDiemSprtnAllwncTxnDte,
  SeparationAllwncTxnStartDate,
  TrvlExpnAllwncLvl1Dte,
  TrvlExpnAllwncLvl2Dte,
  WorkStartDate,
  WorkCommencesTime,
  WorkEndDate,
  WorkEndsTime,
  AssocdSuperiorSprtnAllwnc,
  HomeHasSeparationAllwncTxn,
  TrvlExpnNrOfDaysOutbAndRet,
  TrvlExpnNrOfDaysOutbOrRet,
  DistanceToWorkPlaceValue,
  MealsIsGratuitousForMonth,
  AcmdtnIsGratuitousForMnth,
  TrvlExpenseReimbursementGroup,
  BusTripIsApproved,
  FullTripReimbmtIsRequested,
  SignificantOfclHasIntrst,
  MaxTripSgmtReimbmtIsIncrd,
  TrvlExpnHasReimbursement,
  ShortDistanceToWplcValue,
  StatryExclsnPerdIsExpired,
  TrvlExpnHasPrvtTripBrk,
  MealsPerDiemHasTxn,
  MealsPerDiemHasMnlTxn,
  AcmdtnPerDiemHasMnlTxn,
  ReferenceDate,
  TravelExpenseAmountIsRounded,
  TrvlExpnEstdCostFrmPlnAmt,
  TrvlExpnEstdCostFrmReqAmt,
  ReasonForDifferenceText,
  DailyAllwncIsLmtdTo180,
  WholeTripHasTaxation,
  PeriodNumberOfTrip,
  PeriodType,
  NewAdminOfficeName,
  AddressDepartureName,
  AddressArrivalName,
  CurrentDutyCountry,
  CurrentDutyRegion,
  SprtnAllwncRelocNmbr,
  KitchenAmenities,
  NumberOfPersons,
  TripTypeEnterpriseName,
  TripActivityTypeName,
  CountryGroupName,
  TripCtryReg,
  TravelCountryRegionGroup,
  TravelStatusCriticality,
  PostingDate.TravelExpensePostingDate AS TravelExpensePostingDate,
  TravelStatus,
  CompanyCode,
  CostCenter,
  PersonWorkAgrmtAuthznGrpg,
  TrvlExpnEmplGrpg,
  TrvlExpnReimbmtGrpStatry,
  TrvlExpnReimbmtGrpEnt,
  PersonnelArea,
  TripAuthznFctrVal,
  _TripChain.DestinationAssignment AS DestinationAssignment,
  _TripChain.CityName AS CityName,
  _TripChain.StreetName AS StreetName,
  _TripChain.PostalCode AS PostalCode,
  _TripChain.DistrictName AS DistrictName,
  _TripChain.HouseNumber AS HouseNumber,
  _TripChain.TravelLocationCode AS TravelLocationCode,
  _TripChain.CityName AS TravelCommunityCityName,
  _TripChain.PostalCode AS TravelCommunityPostCode,
  _TripChain.DistrictName AS TravelCommunityDistrictName,
  TravelEmployeeName,
  TravelEmployeeUserIdentifier,
  cast ( abap_system_timezone( $session.client,'NULL' ) as timezone preserving type ) AS StartTimeZone,
  cast ( abap_system_timezone( $session.client,'NULL' ) as timezone preserving type ) AS EndTimeZone,
  _TravelEditor.TravelRequestEditorText AS TravelExpenseEditorText,
  cast ( dats_tims_to_tstmp( LastChangeDate, LastChangedAtTime, 'UTC', $session.client, 'NULL') as vdm_lastchangedon ) AS LastChangeDateTime,
  cast(0.0000000 as abp_lastchange_tstmpl) AS LocalLastChangeDateTime,
  cast ( $session.user as syuname preserving type ) AS TravelExpenseCreatedBy,
  cast ( $session.user as syuname preserving type ) AS TravelExpenseLastChangedBy,
  cast ( 'X' as abap.char( 1 ) ) AS TravelExpenseIsModified,
  _TravelStatisticAmount.TrvlExpnReimbursementAmount AS TrvlExpnReimbursementAmount,
  _TravelStatisticAmount.TravelExpenseTotalAmount AS TravelExpenseTotalAmount,
  _TravelStatisticAmount.MealsPerDiemReimbmtAmount AS MealsPerDiemReimbmtAmount,
  _TravelStatisticAmount.AcmdtnPerDiemReimbmtAmount AS AcmdtnPerDiemReimbmtAmount
FROM I_TravelExpenseGeneralData
LEFT OUTER JOIN C_TravelExpenseStatusValueHelp AS _TravelExpenseStatusText ON TravelExpenseStatus = _TravelExpenseStatusText.TravelStatus  -- association [0..1]
LEFT OUTER JOIN I_TravelCountryRegionText AS _TravelRequestCountryText ON TravelCountryRegion = _TravelRequestCountryText.TripRegionCountry AND TripProvisionVariant = _TravelRequestCountryText.TripProvisionVariant  -- association [0..1]
LEFT OUTER JOIN I_TravelCountryRegionVH AS _TravelRequestCountryRegion ON TravelCountryRegion = _TravelRequestCountryRegion.TripRegionCountry AND TripProvisionVariant = _TravelRequestCountryRegion.TripProvisionVariant  -- association [0..1]
LEFT OUTER JOIN I_TravelDepartureWorkStdVH AS _TravelDepartureWork ON DepartureWork = _TravelDepartureWork.DepartureWork  -- association [0..1]
LEFT OUTER JOIN I_TravelArrivalWorkStdVH AS _TravelArrivalWork ON ArrivalWork = _TravelArrivalWork.ArrivalWork  -- association [0..1]
LEFT OUTER JOIN C_TravelTripActivityTypeVH AS _TravelTripActivityType ON TripActivityType = _TravelTripActivityType.TripActivityType AND PersonnelNumber = _TravelTripActivityType.PersonnelNumber AND TripProvisionVariant = _TravelTripActivityType.TripProvisionVariant AND TripDepartureDate = _TravelTripActivityType.ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_TravelEditor AS _TravelEditor ON PersonnelNumber = _TravelEditor.PersonnelNumber AND TravelTripNumber = _TravelEditor.TravelTripNumber AND _TravelEditor.TripSchema <> 'PL'  -- association [0..1]
LEFT OUTER JOIN I_TravelStatisticAmount AS _TravelStatisticAmount ON PersonnelNumber = _TravelStatisticAmount.PersonnelNumber AND TravelTripNumber = _TravelStatisticAmount.TravelTripNumber AND PeriodNumberOfTrip = _TravelStatisticAmount.PeriodNumberOfTrip  -- association [0..1]
LEFT OUTER JOIN C_TravelTripEnterpriseTypeVH AS _TravelEnterpriseVH ON TripTypeEnterprise = _TravelEnterpriseVH.TripTypeEnterprise AND PersonnelNumber = _TravelEnterpriseVH.PersonnelNumber AND TripProvisionVariant = _TravelEnterpriseVH.TripProvisionVariant AND TripDepartureDate = _TravelEnterpriseVH.ValidityDate  -- association [0..1]
LEFT OUTER JOIN C_TravelStatutoryTypeVH AS _TravelStatutoryVH ON TripTypeStatutory = _TravelStatutoryVH.TripTypeStatutory AND PersonnelNumber = _TravelStatutoryVH.PersonnelNumber AND TripProvisionVariant = _TravelStatutoryVH.TripProvisionVariant AND TripDepartureDate = _TravelStatutoryVH.ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_TravelExpenseTripChain AS _TripChain ON PersonnelNumber = _TripChain.PersonnelNumber AND TravelTripNumber = _TripChain.TravelTripNumber AND PeriodNumberOfTrip = _TripChain.PeriodNumberOfTrip AND TravelExpnSequentialNumber = _TripChain.TravelExpnSequentialNumber  -- association [0..1]
LEFT OUTER JOIN C_TravelExpnsCreditCardBuffer AS _TravelExpnsCreditCardBuffer ON PersonnelNumber = _TravelExpnsCreditCardBuffer.PersonnelNumber AND TravelTripNumber = _TravelExpnsCreditCardBuffer.TravelTripNumber AND TravelReqUUID = _TravelExpnsCreditCardBuffer.TravelReqUUID  -- association [0..*]
LEFT OUTER JOIN C_TravelSchemaValueHelp AS _TravelSchemaValueHelp ON TripSchema = _TravelSchemaValueHelp.TripSchema  -- association [0..1]
LEFT OUTER JOIN I_TrvlExpnExceedingReasonVH AS _TrvlExpnExceedingReasonVH ON TripProvisionVariant = _TrvlExpnExceedingReasonVH.TripProvisionVariant  -- association [0..1]
LEFT OUTER JOIN I_TravelExpenseLastPostingDate AS PostingDate ON PersonnelNumber = PostingDate.PersonnelNumber AND TravelTripNumber = PostingDate.TravelTripNumber AND PeriodSequentialNumber = PostingDate.PeriodSequentialNumber AND PeriodNumberOfTrip = PostingDate.PeriodNumberOfTrip  -- association [0..1]
LEFT OUTER JOIN C_TravelProfileVH AS _TravelProfileVH ON PersonnelNumber = _TravelProfileVH.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_TravelActivityPlanningVH AS _TravelActivityPlanningVH ON TripActivityType = _TravelActivityPlanningVH.TravelRequestTripActivityType  -- association [0..*]
LEFT OUTER JOIN I_TravelEmployeeContactCard AS _TravelEmployeeContactCard ON TravelEmployeeUserIdentifier = _TravelEmployeeContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN E_TravelExpense AS _ExtensionTravelExpense ON PersonnelNumber = _ExtensionTravelExpense.PersonnelNumber AND TravelTripNumber = _ExtensionTravelExpense.TravelTripNumber AND TravelExpnSequentialNumber = _ExtensionTravelExpense.TravelExpnSequentialNumber  -- association [0..1]
LEFT OUTER JOIN I_HDMRelationTP AS _HDMRelation ON TravelExpenseAttachmentKey = _HDMRelation.LinkedSAPObjectKey AND SAPObjectNodeType = _HDMRelation.SAPObjectNodeType  -- association [0..*]
LEFT OUTER JOIN I_TravelExpenseAdvance AS _TravelExpenseAdvance ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TravelExpenseAddlDest AS _TravelExpenseAddlDest ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TravelExpenseCostAssignment AS _TravelExpenseCostAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TravelExpenseMileage AS _TravelExpenseMileage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TrvlExpensePerDiemDeduction AS _TravelExpensePerDiemDeduction ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TravelExpenseReceipt AS _TravelExpenseReceipt ON /* condition not available in parsed metadata */  -- association [0..*]
;