R_TravelExpenseDraft

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_TravelExpenseDraft.
-- 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_TravelExpenseDraft AS
SELECT
  ExpenseDraft.personnelnumber AS PersonnelNumber,
  ExpenseDraft.traveltripnumber AS TravelTripNumber,
  ExpenseDraft.travelrequuid AS TravelReqUUID,
  ExpenseDraft.travelexpnsequentialnumber AS TravelExpnSequentialNumber,
  ExpenseDraft.periodsequentialnumber AS PeriodSequentialNumber,
  ExpenseDraft.tripdeparturedate AS TripDepartureDate,
  ExpenseDraft.departurebegintime AS DepartureBeginTime,
  ExpenseDraft.triparrivaldate AS TripArrivalDate,
  ExpenseDraft.arrivalendtime AS ArrivalEndTime,
  ExpenseDraft.tripreasontext AS TripReasonText,
  ExpenseDraft.tripdestination AS TripDestination,
  ExpenseDraft.country AS Country,
  ExpenseDraft.maindestinationregion AS MainDestinationRegion,
  ExpenseDraft.domesticdeptdate AS DomesticDeptDate,
  ExpenseDraft.travelexpenseoutboundtime AS TravelExpenseOutBoundTime,
  ExpenseDraft.domesticarrvldate AS DomesticArrvlDate,
  ExpenseDraft.triprettime AS TripRetTime,
  ExpenseDraft.tripctryreg AS TripCtryReg,
  ExpenseDraft.triptypeenterprise AS TripTypeEnterprise,
  ExpenseDraft.tripschema AS TripSchema,
  ExpenseDraft.triptypestatutory AS TripTypeStatutory,
  ExpenseDraft.typeoftripactivityvalue AS TypeOfTripActivityValue,
  ExpenseDraft.mealsperdiem AS MealsPerDiem,
  ExpenseDraft.accommodationhasperdiem AS AccommodationHasPerDiem,
  ExpenseDraft.nrofovernightperdiemnights AS NrOfOvernightPerDiemNights,
  ExpenseDraft.trvlexpnhasmealsperdiemreducn AS TrvlExpnHasMealsPerDiemReducn,
  ExpenseDraft.maxnrofperdiemnights AS MaxNrOfPerDiemNights,
  ExpenseDraft.tripactivitytype AS TripActivityType,
  ExpenseDraft.estimatedcost AS EstimatedCost,
  ExpenseDraft.estimatedcostcrcy AS EstimatedCostCrcy,
  ExpenseDraft.paymentcurrency AS PaymentCurrency,
  ExpenseDraft.travelrequestisexists AS TravelRequestIsExists,
  ExpenseDraft.travelplanisexists AS TravelPlanIsExists,
  ExpenseDraft.triphasexpenses AS TripHasExpenses,
  ExpenseDraft.tripprintstatusvalue AS TripPrintStatusValue,
  ExpenseDraft.trvlexpnapprovalstatus AS TrvlExpnApprovalStatus,
  ExpenseDraft.settlmtstatus AS SettlmtStatus,
  ExpenseDraft.trvlexpnhasfinancetransf AS TrvlExpnHasFinanceTransf,
  ExpenseDraft.humrscepayrolltransfer AS HumRscePayrollTransfer,
  ExpenseDraft.datamdmexchistransf AS DataMdmExchIsTransf,
  ExpenseDraft.countrygroup AS CountryGroup,
  ExpenseDraft.tripprovisionvariant AS TripProvisionVariant,
  ExpenseDraft.tripsettlementdate AS TripSettlementDate,
  ExpenseDraft.tripsettlementtime AS TripSettlementTime,
  ExpenseDraft.postingsequencenumber AS PostingSequenceNumber,
  ExpenseDraft.trvlexpnhasmilesperacctg AS TrvlExpnHasMilesPerAcctg,
  ExpenseDraft.tripislocked AS TripIsLocked,
  ExpenseDraft.lastchangedate AS LastChangeDate,
  ExpenseDraft.lastchangedattime AS LastChangedAtTime,
  ExpenseDraft.changedbyname AS ChangedByName,
  ExpenseDraft.changereportname AS ChangeReportName,
  ExpenseDraft.movingcostsrefundvalue AS MovingCostsRefundValue,
  ExpenseDraft.adminofficemovelabel AS AdminOfficeMoveLabel,
  ExpenseDraft.diffntendoftrvlallwncdte AS DiffntEndOfTrvlAllwncDte,
  ExpenseDraft.departurework AS DepartureWork,
  ExpenseDraft.arrivalwork AS ArrivalWork,
  ExpenseDraft.returnworkplacevalue AS ReturnWorkplaceValue,
  ExpenseDraft.trvlexpnnmbrforcorrespgwrk AS TrvlExpnNmbrForCorrespgWrk,
  ExpenseDraft.assocdbustripnrofret AS AssocdBusTripNrOfRet,
  ExpenseDraft.departureperioddate AS DeparturePeriodDate,
  ExpenseDraft.tripbeginsattime AS TripBeginsAtTime,
  ExpenseDraft.arrivalperioddate AS ArrivalPeriodDate,
  ExpenseDraft.tripendsattime AS TripEndsAtTime,
  ExpenseDraft.perdiemsprtnallwnctxndte AS PerDiemSprtnAllwncTxnDte,
  ExpenseDraft.separationallwnctxnstartdate AS SeparationAllwncTxnStartDate,
  ExpenseDraft.trvlexpnallwnclvl1dte AS TrvlExpnAllwncLvl1Dte,
  ExpenseDraft.trvlexpnallwnclvl2dte AS TrvlExpnAllwncLvl2Dte,
  ExpenseDraft.workstartdate AS WorkStartDate,
  ExpenseDraft.workcommencestime AS WorkCommencesTime,
  ExpenseDraft.workenddate AS WorkEndDate,
  ExpenseDraft.workendstime AS WorkEndsTime,
  ExpenseDraft.assocdsuperiorsprtnallwnc AS AssocdSuperiorSprtnAllwnc,
  ExpenseDraft.homehasseparationallwnctxn AS HomeHasSeparationAllwncTxn,
  ExpenseDraft.trvlexpnnrofdaysoutbandret AS TrvlExpnNrOfDaysOutbAndRet,
  ExpenseDraft.trvlexpnnrofdaysoutborret AS TrvlExpnNrOfDaysOutbOrRet,
  ExpenseDraft.distancetoworkplacevalue AS DistanceToWorkPlaceValue,
  ExpenseDraft.mealsisgratuitousformonth AS MealsIsGratuitousForMonth,
  ExpenseDraft.acmdtnisgratuitousformnth AS AcmdtnIsGratuitousForMnth,
  ExpenseDraft.trvlexpensereimbursementgroup AS TrvlExpenseReimbursementGroup,
  ExpenseDraft.bustripisapproved AS BusTripIsApproved,
  ExpenseDraft.fulltripreimbmtisrequested AS FullTripReimbmtIsRequested,
  ExpenseDraft.significantofclhasintrst AS SignificantOfclHasIntrst,
  ExpenseDraft.maxtripsgmtreimbmtisincrd AS MaxTripSgmtReimbmtIsIncrd,
  ExpenseDraft.trvlexpnhasreimbursement AS TrvlExpnHasReimbursement,
  ExpenseDraft.shortdistancetowplcvalue AS ShortDistanceToWplcValue,
  ExpenseDraft.statryexclsnperdisexpired AS StatryExclsnPerdIsExpired,
  ExpenseDraft.trvlexpnhasprvttripbrk AS TrvlExpnHasPrvtTripBrk,
  ExpenseDraft.mealsperdiemhastxn AS MealsPerDiemHasTxn,
  ExpenseDraft.mealsperdiemhasmnltxn AS MealsPerDiemHasMnlTxn,
  ExpenseDraft.acmdtnperdiemhasmnltxn AS AcmdtnPerDiemHasMnlTxn,
  ExpenseDraft.referencedate AS ReferenceDate,
  ExpenseDraft.travelexpenseamountisrounded AS TravelExpenseAmountIsRounded,
  ExpenseDraft.trvlexpnestdcostfrmplnamt AS TrvlExpnEstdCostFrmPlnAmt,
  ExpenseDraft.trvlexpnestdcostfrmreqamt AS TrvlExpnEstdCostFrmReqAmt,
  ExpenseDraft.reasonfordifferencetext AS ReasonForDifferenceText,
  ExpenseDraft.dailyallwncislmtdto180 AS DailyAllwncIsLmtdTo180,
  ExpenseDraft.wholetriphastaxation AS WholeTripHasTaxation,
  ExpenseDraft.periodnumberoftrip AS PeriodNumberOfTrip,
  ExpenseDraft.periodtype AS PeriodType,
  ExpenseDraft.newadminofficename AS NewAdminOfficeName,
  ExpenseDraft.addressdeparturename AS AddressDepartureName,
  ExpenseDraft.addressarrivalname AS AddressArrivalName,
  ExpenseDraft.currentdutycountry AS CurrentDutyCountry,
  ExpenseDraft.currentdutyregion AS CurrentDutyRegion,
  ExpenseDraft.sprtnallwncrelocnmbr AS SprtnAllwncRelocNmbr,
  ExpenseDraft.kitchenamenities AS KitchenAmenities,
  ExpenseDraft.numberofpersons AS NumberOfPersons,
  ExpenseDraft.triptypeenterprisename AS TripTypeEnterpriseName,
  ExpenseDraft.tripactivitytypename AS TripActivityTypeName,
  ExpenseDraft.countrygroupname AS CountryGroupName,
  ExpenseDraft.travelstatuscriticality AS TravelStatusCriticality,
  ExpenseDraft.travelexpensepostingdate AS TravelExpensePostingDate,
  ExpenseDraft.travelexpensestatuscriticality AS TravelExpenseStatusCriticality,
  ExpenseDraft.travelexpensestatus AS TravelExpenseStatus,
  ExpenseDraft.travelstatus AS TravelStatus,
  ExpenseDraft.companycode AS CompanyCode,
  ExpenseDraft.costcenter AS CostCenter,
  ExpenseDraft.personworkagrmtauthzngrpg AS PersonWorkAgrmtAuthznGrpg,
  ExpenseDraft.trvlexpnemplgrpg AS TrvlExpnEmplGrpg,
  ExpenseDraft.trvlexpnreimbmtgrpstatry AS TrvlExpnReimbmtGrpStatry,
  ExpenseDraft.trvlexpnreimbmtgrpent AS TrvlExpnReimbmtGrpEnt,
  ExpenseDraft.personnelarea AS PersonnelArea,
  ExpenseDraft.tripauthznfctrval AS TripAuthznFctrVal,
  ExpenseDraft.destinationassignment AS DestinationAssignment,
  ExpenseDraft.cityname AS CityName,
  ExpenseDraft.streetname AS StreetName,
  ExpenseDraft.postalcode AS PostalCode,
  ExpenseDraft.districtname AS DistrictName,
  ExpenseDraft.housenumber AS HouseNumber,
  ExpenseDraft.travelcommunitycityname AS TravelCommunityCityName,
  ExpenseDraft.travelcommunitydistrictname AS TravelCommunityDistrictName,
  ExpenseDraft.travelcommunitypostcode AS TravelCommunityPostCode,
  ExpenseDraft.travellocationcode AS TravelLocationCode,
  ExpenseDraft.travelemployeename AS TravelEmployeeName,
  ExpenseDraft.travelemployeeuseridentifier AS TravelEmployeeUserIdentifier,
  ExpenseDraft.trvlexpnstartdatetime AS TrvlExpnStartDateTime,
  ExpenseDraft.starttimezone AS StartTimeZone,
  ExpenseDraft.trvlexpnenddatetime AS TrvlExpnEndDateTime,
  ExpenseDraft.endtimezone AS EndTimeZone,
  ExpenseDraft.travelexpenseeditortext AS TravelExpenseEditorText,
  ExpenseDraft.lastchangedatetime AS LastChangeDateTime,
  ExpenseDraft.locallastchangedatetime AS LocalLastChangeDateTime,
  ExpenseDraft.travelexpensecreatedby AS TravelExpenseCreatedBy,
  ExpenseDraft.travelexpenselastchangedby AS TravelExpenseLastChangedBy,
  ExpenseDraft.travelexpenseismodified AS TravelExpenseIsModified,
  ExpenseDraft.trvlexpnreimbursementamount AS TrvlExpnReimbursementAmount,
  ExpenseDraft.travelexpensetotalamount AS TravelExpenseTotalAmount,
  ExpenseDraft.mealsperdiemreimbmtamount AS MealsPerDiemReimbmtAmount,
  ExpenseDraft.acmdtnperdiemreimbmtamount AS AcmdtnPerDiemReimbmtAmount,
  ExpenseDraft.travelcountryregion AS TravelCountryRegion,
  ExpenseDraft.travelcountryregiongroup AS TravelCountryRegionGroup,
  ExpenseDraft.trvlexpnamountexceedingtext AS TrvlExpnAmountExceedingText,
  ExpenseDraft.landingdestctrydate AS LandingDestCtryDate,
  ExpenseDraft.landingatdesttime AS LandingAtDestTime,
  ExpenseDraft.departureabroaddate AS DepartureAbroadDate,
  ExpenseDraft.departureabroadtime AS DepartureAbroadTime,
  ExpenseDraft.abroadlandingischeck AS AbroadLandingIsCheck,
  ExpenseDraft.authoritycheckpersnumbervalue AS AuthorityCheckPersNumberValue,
  ExpenseDraft.travelexpenseattachmentkey AS TravelExpenseAttachmentKey,
  ExpenseDraft.sapobjectnodetype AS SAPObjectNodeType,
  ExpenseDraft.reasonfordifflistishidden AS ReasonForDiffListIsHidden,
  ExpenseDraft.trvlexpnapprovername AS TrvlExpnApproverName,
  ExpenseDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  ExpenseDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  ExpenseDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  ExpenseDraft.draftentityoperationcode AS DraftEntityOperationCode,
  ExpenseDraft.hasactiveentity AS HasActiveEntity,
  ExpenseDraft.accommodationhasperdiem_h AS AccommodationHasPerDiem_H,
  ExpenseDraft.acmdtnisgratuitousformnth_h AS AcmdtnIsGratuitousForMnth_H,
  ExpenseDraft.acmdtnperdiemhasmnltxn_h AS AcmdtnPerDiemHasMnlTxn_H,
  ExpenseDraft.addressarrivalname_h AS AddressArrivalName_H,
  ExpenseDraft.addressdeparturename_h AS AddressDepartureName_H,
  ExpenseDraft.arrivalendtime_h AS ArrivalEndTime_H,
  ExpenseDraft.arrivalwork_h AS ArrivalWork_H,
  ExpenseDraft.cityname_h AS CityName_H,
  ExpenseDraft.currentdutycountry_h AS CurrentDutyCountry_H,
  ExpenseDraft.currentdutyregion_h AS CurrentDutyRegion_H,
  ExpenseDraft.dailyallwncislmtdto180_h AS DailyAllwncIsLmtdTo180_H,
  ExpenseDraft.departurebegintime_h AS DepartureBeginTime_H,
  ExpenseDraft.departurework_h AS DepartureWork_H,
  ExpenseDraft.distancetoworkplacevalue_h AS DistanceToWorkPlaceValue_H,
  ExpenseDraft.districtname_h AS DistrictName_H,
  ExpenseDraft.domesticarrvldate_h AS DomesticArrvlDate_H,
  ExpenseDraft.domesticdeptdate_h AS DomesticDeptDate_H,
  ExpenseDraft.fulltripreimbmtisrequested_h AS FullTripReimbmtIsRequested_H,
  ExpenseDraft.homehasseparationallwnctxn_h AS HomeHasSeparationAllwncTxn_H,
  ExpenseDraft.housenumber_h AS HouseNumber_H,
  ExpenseDraft.kitchenamenities_h AS KitchenAmenities_H,
  ExpenseDraft.maxtripsgmtreimbmtisincrd_h AS MaxTripSgmtReimbmtIsIncrd_H,
  ExpenseDraft.mealsisgratuitousformonth_h AS MealsIsGratuitousForMonth_H,
  ExpenseDraft.mealsperdiem_h AS MealsPerDiem_H,
  ExpenseDraft.mealsperdiemhasmnltxn_h AS MealsPerDiemHasMnlTxn_H,
  ExpenseDraft.mealsperdiemhastxn_h AS MealsPerDiemHasTxn_H,
  ExpenseDraft.movingcostsrefundvalue_h AS MovingCostsRefundValue_H,
  ExpenseDraft.nrofovernightperdiemnights_h AS NrOfOvernightPerDiemNights_H,
  ExpenseDraft.numberofpersons_h AS NumberOfPersons_H,
  ExpenseDraft.postalcode_h AS PostalCode_H,
  ExpenseDraft.reasonfordifferencetext_h AS ReasonForDifferenceText_H,
  ExpenseDraft.referencedate_h AS ReferenceDate_H,
  ExpenseDraft.returnworkplacevalue_h AS ReturnWorkplaceValue_H,
  ExpenseDraft.shortdistancetowplcvalue_h AS ShortDistanceToWplcValue_H,
  ExpenseDraft.significantofclhasintrst_h AS SignificantOfclHasIntrst_H,
  ExpenseDraft.streetname_h AS StreetName_H,
  ExpenseDraft.travelcountryregion_h AS TravelCountryRegion_H,
  ExpenseDraft.travelcountryregiongroup_h AS TravelCountryRegionGroup_H,
  ExpenseDraft.travelexpenseeditortext_h AS TravelExpenseEditorText_H,
  ExpenseDraft.travelexpenseoutboundtime_h AS TravelExpenseOutBoundTime_H,
  ExpenseDraft.travellocationcode_h AS TravelLocationCode_H,
  ExpenseDraft.tripactivitytype_h AS TripActivityType_H,
  ExpenseDraft.triparrivaldate_h AS TripArrivalDate_H,
  ExpenseDraft.tripbeginsattime_h AS TripBeginsAtTime_H,
  ExpenseDraft.tripdeparturedate_h AS TripDepartureDate_H,
  ExpenseDraft.tripdestination_h AS TripDestination_H,
  ExpenseDraft.tripendsattime_h AS TripEndsAtTime_H,
  ExpenseDraft.tripreasontext_h AS TripReasonText_H,
  ExpenseDraft.triprettime_h AS TripRetTime_H,
  ExpenseDraft.triptypeenterprise_h AS TripTypeEnterprise_H,
  ExpenseDraft.triptypestatutory_h AS TripTypeStatutory_H,
  ExpenseDraft.typeoftripactivityvalue_h AS TypeOfTripActivityValue_H,
  ExpenseDraft.workcommencestime_h AS WorkCommencesTime_H,
  ExpenseDraft.workenddate_h AS WorkEndDate_H,
  ExpenseDraft.workendstime_h AS WorkEndsTime_H,
  ExpenseDraft.workstartdate_h AS WorkStartDate_H,
  ExpenseDraft.landingdestctrydate_h AS LandingDestCtryDate_H,
  ExpenseDraft.landingatdesttime_h AS LandingAtDestTime_H,
  ExpenseDraft.departureabroaddate_h AS DepartureAbroadDate_H,
  ExpenseDraft.departureabroadtime_h AS DepartureAbroadTime_H,
  ExpenseDraft.abroadlandingischeck_h AS AbroadLandingIsCheck_H
FROM trvs4_expense_d AS ExpenseDraft
LEFT OUTER JOIN E_TravelExpenseDraft AS _ExtensionTravelExpense ON PersonnelNumber = _ExtensionTravelExpense.PersonnelNumber AND TravelTripNumber = _ExtensionTravelExpense.TravelTripNumber AND TravelReqUUID = _ExtensionTravelExpense.TravelReqUUID  -- association [1..1]
;