I_TravelExpenseMileageTP

DDL: I_TRAVELEXPENSEMILEAGETP Type: view_entity TRANSACTIONAL
60 Fields 1 Data Sources

Travel Expense Mileage - TP

I_TravelExpenseMileageTP is a Transactional CDS View that provides data about "Travel Expense Mileage - TP" in SAP S/4HANA. It reads from 1 data source (I_TravelExpenseMileage) and exposes 60 fields with key fields PersonnelNumber, TravelTripNumber, TravelReqUUID, SeqReqUUID, TravelMileageSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
I_TravelExpenseMileage I_TravelExpenseMileage projection

Annotations (13)

NameValueLevelField
EndUserText.label Travel Expense Mileage - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MIL view
AbapCatalog.extensibility.quota.maximumFields 350 view
AbapCatalog.extensibility.quota.maximumBytes 2240 view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonnelNumber Personnel No.
KEY TravelTripNumber TravelTripNumber Trip Number
KEY TravelReqUUID TravelReqUUID UUID
KEY SeqReqUUID SeqReqUUID UUID
KEY TravelMileageSequenceNumber TravelMileageSequenceNumber Sequence Number of Miles/Kilometers Distribution
TravelExpnSequentialNumber TravelExpnSequentialNumber Sequential Number
TravelMileageDate TravelMileageDate Date
TotalMilesRate TotalMilesRate Total Distance
DomesticMilesRate DomesticMilesRate Domes.M/Km
TravelVehicleLicensePlate TravelVehicleLicensePlate License Plate
TravelVehicleMake TravelVehicleMake Veh.Make/Model
NumberOfPassenger NumberOfPassenger No. Passengers
TravelBaggageWeight TravelBaggageWeight Luggage Weight
AdditionalFlatRateIsApplicable AdditionalFlatRateIsApplicable Additional Flat Rate:Enterprise Specific
VehicleType VehicleType Vehicle Type
TravelVehicleClass TravelVehicleClass Vehicle Class
Country Country Venue: Ctry/Reg
TripTypeEnterprise TripTypeEnterprise Trip Type, Company-Specific
TripTypeEnterpriseName TripTypeEnterpriseName Trip Type Enterprise Name
TripStartingLocationName TripStartingLocationName From
TripEndLocationName TripEndLocationName To
TravelMileageEditorText TravelMileageEditorText Editor
TravelComputedDistanceRate TravelComputedDistanceRate Distance in M/Km
DepartureCityName DepartureCityName City
DeparturePostalCode DeparturePostalCode Postal Code
DepartureStreetName DepartureStreetName Street
DepartureHouseNumber DepartureHouseNumber House Number
DepartureCountry DepartureCountry Departure Country / Region
DepartureRegion DepartureRegion State
ArrivalCityName ArrivalCityName City
ArrivalPostalCode ArrivalPostalCode Postal Code
ArrivalStreetName ArrivalStreetName Street
ArrivalHouseNumber ArrivalHouseNumber House Number
ArrivalCountry ArrivalCountry Country / Region
ArrivalRegion ArrivalRegion State
TravelWeightUnit TravelWeightUnit Weight Unit
TravelVehicleTypeName TravelVehicleTypeName Vehicle Type Name
TravelVehicleClassName TravelVehicleClassName Vehicle Class Name
TrvlExpnTotalReimbursementAmt TrvlExpnTotalReimbursementAmt Total Reimbursement
Currency Currency Valuation Crcy
DepartureCountryName DepartureCountryName Name Country / Region
TravelDistanceUnit TravelDistanceUnit Distance Unit
ArrivalCountryName ArrivalCountryName Name Country / Region
TrvlAdditionalInformationText TrvlAdditionalInformationText Additional Info
TrvlMlgeDepartureAddressNumber TrvlMlgeDepartureAddressNumber Address Number
TrvlMlgeArrivalAddressNumber TrvlMlgeArrivalAddressNumber Address Number
TrvlMlgeIsIndAutomDetmFuelPr TrvlMlgeIsIndAutomDetmFuelPr Automatic Price
TrvlMlgeFuelPricePerUnitAmount TrvlMlgeFuelPricePerUnitAmount Price per Unit
TravelMileageFuelPriceCurrency TravelMileageFuelPriceCurrency Currency
TrvlMlgeDeptDistrictName TrvlMlgeDeptDistrictName District
TrvlMlgeArrivalDistrictName TrvlMlgeArrivalDistrictName District
TrvlMlgeIsIndKilometerDisplay TrvlMlgeIsIndKilometerDisplay Km Display Only
TrvlMlgeDeptCityLocationCode TrvlMlgeDeptCityLocationCode Location Code
TrvlMlgeArrvlCityLocationCode TrvlMlgeArrvlCityLocationCode Location Code
TrvlMlgeIsIndicatorRoundTrip TrvlMlgeIsIndicatorRoundTrip Round Trip
TrvlMlgeTestingProcedureOfFuel TrvlMlgeTestingProcedureOfFuel Consumption Type
TripRegion TripRegion Trip Region
LastChangeDateTime LastChangeDateTime Timestamp
MlgeLoclLastChgdDteTme MlgeLoclLastChgdDteTme Changed On
DestinationAssignment DestinationAssignment Destination Assignment

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_TravelExpenseMileageTP.
-- 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_TravelExpenseMileageTP AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  TravelReqUUID,
  SeqReqUUID,
  TravelMileageSequenceNumber,
  TravelExpnSequentialNumber,
  TravelMileageDate,
  TotalMilesRate,
  DomesticMilesRate,
  TravelVehicleLicensePlate,
  TravelVehicleMake,
  NumberOfPassenger,
  TravelBaggageWeight,
  AdditionalFlatRateIsApplicable,
  VehicleType,
  TravelVehicleClass,
  Country,
  TripTypeEnterprise,
  TripTypeEnterpriseName,
  TripStartingLocationName,
  TripEndLocationName,
  TravelMileageEditorText,
  TravelComputedDistanceRate,
  DepartureCityName,
  DeparturePostalCode,
  DepartureStreetName,
  DepartureHouseNumber,
  DepartureCountry,
  DepartureRegion,
  ArrivalCityName,
  ArrivalPostalCode,
  ArrivalStreetName,
  ArrivalHouseNumber,
  ArrivalCountry,
  ArrivalRegion,
  TravelWeightUnit,
  TravelVehicleTypeName,
  TravelVehicleClassName,
  TrvlExpnTotalReimbursementAmt,
  Currency,
  DepartureCountryName,
  TravelDistanceUnit,
  ArrivalCountryName,
  TrvlAdditionalInformationText,
  TrvlMlgeDepartureAddressNumber,
  TrvlMlgeArrivalAddressNumber,
  TrvlMlgeIsIndAutomDetmFuelPr,
  TrvlMlgeFuelPricePerUnitAmount,
  TravelMileageFuelPriceCurrency,
  TrvlMlgeDeptDistrictName,
  TrvlMlgeArrivalDistrictName,
  TrvlMlgeIsIndKilometerDisplay,
  TrvlMlgeDeptCityLocationCode,
  TrvlMlgeArrvlCityLocationCode,
  TrvlMlgeIsIndicatorRoundTrip,
  TrvlMlgeTestingProcedureOfFuel,
  TripRegion,
  LastChangeDateTime,
  MlgeLoclLastChgdDteTme,
  DestinationAssignment
FROM I_TravelExpenseMileage
;

Learn More