R_TravelRequestDraft

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_TravelRequestDraft.
-- 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_TravelRequestDraft AS
SELECT
  TravelRequestDraft.personnelnumber AS PersonnelNumber,
  TravelRequestDraft.traveltripnumber AS TravelTripNumber,
  TravelRequestDraft.travelrequuid AS TravelReqUUID,
  TravelRequestDraft.travelexpnsequentialnumber AS TravelExpnSequentialNumber,
  TravelRequestDraft.tripdeparturedate AS TripDepartureDate,
  TravelRequestDraft.departurebegintime AS DepartureBeginTime,
  TravelRequestDraft.triparrivaldate AS TripArrivalDate,
  TravelRequestDraft.arrivalendtime AS ArrivalEndTime,
  TravelRequestDraft.tripreasontext AS TripReasonText,
  TravelRequestDraft.tripdestination AS TripDestination,
  TravelRequestDraft.country AS Country,
  TravelRequestDraft.maindestinationregion AS MainDestinationRegion,
  TravelRequestDraft.domesticdeptdate AS DomesticDeptDate,
  TravelRequestDraft.travelrequestoutboundtime AS TravelRequestOutBoundTime,
  TravelRequestDraft.domesticarrvldate AS DomesticArrvlDate,
  TravelRequestDraft.triprettime AS TripRetTime,
  TravelRequestDraft.tripctryreg AS TripCtryReg,
  TravelRequestDraft.triptypeenterprise AS TripTypeEnterprise,
  TravelRequestDraft.tripschema AS TripSchema,
  TravelRequestDraft.triptypestatutory AS TripTypeStatutory,
  TravelRequestDraft.typeoftripactivityvalue AS TypeOfTripActivityValue,
  TravelRequestDraft.mealsperdiem AS MealsPerDiem,
  TravelRequestDraft.accommodationhasperdiem AS AccommodationHasPerDiem,
  TravelRequestDraft.nrofovernightperdiemnights AS NrOfOvernightPerDiemNights,
  TravelRequestDraft.maxnrofperdiemnights AS MaxNrOfPerDiemNights,
  TravelRequestDraft.tripactivitytype AS TripActivityType,
  TravelRequestDraft.estimatedcost AS EstimatedCost,
  TravelRequestDraft.estimatedcostcrcy AS EstimatedCostCrcy,
  TravelRequestDraft.paymentcurrency AS PaymentCurrency,
  TravelRequestDraft.travelrequestisexists AS TravelRequestIsExists,
  TravelRequestDraft.travelplanisexists AS TravelPlanIsExists,
  TravelRequestDraft.triphasexpenses AS TripHasExpenses,
  TravelRequestDraft.tripprintstatusvalue AS TripPrintStatusValue,
  TravelRequestDraft.trvlreqapprovalstatus AS TrvlReqApprovalStatus,
  TravelRequestDraft.settlmtstatus AS SettlmtStatus,
  TravelRequestDraft.trvlreqhasfinancetransf AS TrvlReqHasFinanceTransf,
  TravelRequestDraft.humrscepayrolltransfer AS HumRscePayrollTransfer,
  TravelRequestDraft.datamdmexchistransf AS DataMdmExchIsTransf,
  TravelRequestDraft.countrygroup AS CountryGroup,
  TravelRequestDraft.tripprovisionvariant AS TripProvisionVariant,
  TravelRequestDraft.tripsettlementdate AS TripSettlementDate,
  TravelRequestDraft.tripsettlementtime AS TripSettlementTime,
  TravelRequestDraft.postingsequencenumber AS PostingSequenceNumber,
  TravelRequestDraft.trvlreqhasmilesperacctg AS TrvlReqHasMilesPerAcctg,
  TravelRequestDraft.tripislocked AS TripIsLocked,
  TravelRequestDraft.lastchangedate AS LastChangeDate,
  TravelRequestDraft.lastchangedattime AS LastChangedAtTime,
  TravelRequestDraft.changedbyname AS ChangedByName,
  TravelRequestDraft.changereportname AS ChangeReportName,
  TravelRequestDraft.movingcostsrefundvalue AS MovingCostsRefundValue,
  TravelRequestDraft.adminofficemovelabel AS AdminOfficeMoveLabel,
  TravelRequestDraft.diffntendoftrvlallwncdte AS DiffntEndOfTrvlAllwncDte,
  TravelRequestDraft.departurework AS DepartureWork,
  TravelRequestDraft.arrivalwork AS ArrivalWork,
  TravelRequestDraft.returnworkplacevalue AS ReturnWorkplaceValue,
  TravelRequestDraft.trvlreqnmbrforcorrespgwrk AS TrvlReqNmbrForCorrespgWrk,
  TravelRequestDraft.assocdbustripnrofret AS AssocdBusTripNrOfRet,
  TravelRequestDraft.perdiemsprtnallwnctxndte AS PerDiemSprtnAllwncTxnDte,
  TravelRequestDraft.separationallwnctxnstartdate AS SeparationAllwncTxnStartDate,
  TravelRequestDraft.trvlreqallwnclvl1dte AS TrvlReqAllwncLvl1Dte,
  TravelRequestDraft.trvlreqallwnclvl2dte AS TrvlReqAllwncLvl2Dte,
  TravelRequestDraft.workstartdate AS WorkStartDate,
  TravelRequestDraft.workcommencestime AS WorkCommencesTime,
  TravelRequestDraft.workenddate AS WorkEndDate,
  TravelRequestDraft.workendstime AS WorkEndsTime,
  TravelRequestDraft.assocdsuperiorsprtnallwnc AS AssocdSuperiorSprtnAllwnc,
  TravelRequestDraft.homehasseparationallwnctxn AS HomeHasSeparationAllwncTxn,
  TravelRequestDraft.trvlreqnrofdaysoutbandret AS TrvlReqNrOfDaysOutbAndRet,
  TravelRequestDraft.trvlreqnrofdaysoutborret AS TrvlReqNrOfDaysOutbOrRet,
  TravelRequestDraft.distancetoworkplacevalue AS DistanceToWorkPlaceValue,
  TravelRequestDraft.mealsisgratuitousformonth AS MealsIsGratuitousForMonth,
  TravelRequestDraft.acmdtnisgratuitousformnth AS AcmdtnIsGratuitousForMnth,
  TravelRequestDraft.trvlrequestreimbursementgroup AS TrvlRequestReimbursementGroup,
  TravelRequestDraft.bustripisapproved AS BusTripIsApproved,
  TravelRequestDraft.fulltripreimbmtisrequested AS FullTripReimbmtIsRequested,
  TravelRequestDraft.significantofclhasintrst AS SignificantOfclHasIntrst,
  TravelRequestDraft.maxtripsgmtreimbmtisincrd AS MaxTripSgmtReimbmtIsIncrd,
  TravelRequestDraft.trvlreqhasreimbursement AS TrvlReqHasReimbursement,
  TravelRequestDraft.shortdistancetowplcvalue AS ShortDistanceToWplcValue,
  TravelRequestDraft.statryexclsnperdisexpired AS StatryExclsnPerdIsExpired,
  TravelRequestDraft.trvlreqhasprvttripbrk AS TrvlReqHasPrvtTripBrk,
  TravelRequestDraft.mealsperdiemhastxn AS MealsPerDiemHasTxn,
  TravelRequestDraft.mealsperdiemhasmnltxn AS MealsPerDiemHasMnlTxn,
  TravelRequestDraft.acmdtnperdiemhasmnltxn AS AcmdtnPerDiemHasMnlTxn,
  TravelRequestDraft.referencedate AS ReferenceDate,
  TravelRequestDraft.travelrequestamountisrounded AS TravelRequestAmountIsRounded,
  TravelRequestDraft.trvlreqestdcostfrmplnamt AS TrvlReqEstdCostFrmPlnAmt,
  TravelRequestDraft.trvlreqestdcostfrmreqamt AS TrvlReqEstdCostFrmReqAmt,
  TravelRequestDraft.reasonfordifferencetext AS ReasonForDifferenceText,
  TravelRequestDraft.dailyallwncislmtdto180 AS DailyAllwncIsLmtdTo180,
  TravelRequestDraft.wholetriphastaxation AS WholeTripHasTaxation,
  TravelRequestDraft.periodnumberoftrip AS PeriodNumberOfTrip,
  TravelRequestDraft.periodtype AS PeriodType,
  TravelRequestDraft.newadminofficename AS NewAdminOfficeName,
  TravelRequestDraft.addressdeparturename AS AddressDepartureName,
  TravelRequestDraft.addressarrivalname AS AddressArrivalName,
  TravelRequestDraft.currentdutycountry AS CurrentDutyCountry,
  TravelRequestDraft.currentdutyregion AS CurrentDutyRegion,
  TravelRequestDraft.sprtnallwncrelocnmbr AS SprtnAllwncRelocNmbr,
  TravelRequestDraft.kitchenamenities AS KitchenAmenities,
  TravelRequestDraft.numberofpersons AS NumberOfPersons,
  TravelRequestDraft.triptypeenterprisename AS TripTypeEnterpriseName,
  TravelRequestDraft.tripactivitytypename AS TripActivityTypeName,
  TravelRequestDraft.countrygroupname AS CountryGroupName,
  TravelRequestDraft.travelstatuscriticality AS TravelStatusCriticality,
  TravelRequestDraft.travelstatus AS TravelStatus,
  TravelRequestDraft.companycode AS CompanyCode,
  TravelRequestDraft.costcenter AS CostCenter,
  TravelRequestDraft.personworkagrmtauthzngrpg AS PersonWorkAgrmtAuthznGrpg,
  TravelRequestDraft.trvlreqemplgrpg AS TrvlReqEmplGrpg,
  TravelRequestDraft.trvlreqreimbmtgrpstatry AS TrvlReqReimbmtGrpStatry,
  TravelRequestDraft.trvlreqreimbmtgrpent AS TrvlReqReimbmtGrpEnt,
  TravelRequestDraft.personnelarea AS PersonnelArea,
  TravelRequestDraft.tripauthznfctrval AS TripAuthznFctrVal,
  TravelRequestDraft.cityname AS CityName,
  TravelRequestDraft.streetname AS StreetName,
  TravelRequestDraft.postalcode AS PostalCode,
  TravelRequestDraft.districtname AS DistrictName,
  TravelRequestDraft.travelcommunitycityname AS TravelCommunityCityName,
  TravelRequestDraft.travelcommunitypostcode AS TravelCommunityPostCode,
  TravelRequestDraft.travelcommunitydistrictname AS TravelCommunityDistrictName,
  TravelRequestDraft.travellocationcode AS TravelLocationCode,
  TravelRequestDraft.travelemployeename AS TravelEmployeeName,
  TravelRequestDraft.travelemployeeuseridentifier AS TravelEmployeeUserIdentifier,
  TravelRequestDraft.trvlreqareplanreq AS TrvlReqArePlanReq,
  TravelRequestDraft.travelversionnumber AS TravelVersionNumber,
  TravelRequestDraft.travelrequesteditortext AS TravelRequestEditorText,
  TravelRequestDraft.starttimezone AS StartTimeZone,
  TravelRequestDraft.endtimezone AS EndTimeZone,
  TravelRequestDraft.trvlreqstartdatetime AS TrvlReqStartDateTime,
  TravelRequestDraft.trvlreqenddatetime AS TrvlReqEndDateTime,
  TravelRequestDraft.lastchangedatetime AS LastChangeDateTime,
  TravelRequestDraft.locallastchangedatetime AS LocalLastChangeDateTime,
  TravelRequestDraft.travelrequestcreatedby AS TravelRequestCreatedBy,
  TravelRequestDraft.travelrequestlastchangedby AS TravelRequestLastChangedBy,
  TravelRequestDraft.travelrequestismodified AS TravelRequestIsModified,
  TravelRequestDraft.travelcountryregion AS TravelCountryRegion,
  TravelRequestDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  TravelRequestDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  TravelRequestDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  TravelRequestDraft.draftentityoperationcode AS DraftEntityOperationCode,
  TravelRequestDraft.hasactiveentity AS HasActiveEntity,
  TravelRequestDraft.authoritycheckpersnumbervalue AS AuthorityCheckPersNumberValue,
  TravelRequestDraft.numberofpassengerwithme AS NumberOfPassengerWithMe,
  TravelRequestDraft.pssngriscarriedbyothempl AS PssngrIsCarriedByOthEmpl,
  TravelRequestDraft.carpooldriver AS CarPoolDriver,
  TravelRequestDraft.travelrequestattachmentkey AS TravelRequestAttachmentkey,
  TravelRequestDraft.sapobjectnodetype AS SAPObjectNodeType
FROM trvs4_request_d AS TravelRequestDraft
LEFT OUTER JOIN E_TravelRequestDraft AS _ExtensionTravelRequest ON PersonnelNumber = _ExtensionTravelRequest.PersonnelNumber AND TravelTripNumber = _ExtensionTravelRequest.TravelTripNumber AND TravelReqUUID = _ExtensionTravelRequest.TravelReqUUID  -- association [1..1]
;