I_TravelAddlDestinationTP

DDL: I_TRAVELADDLDESTINATIONTP Type: view_entity TRANSACTIONAL
53 Fields 1 Data Sources

Additional Travel Destination - TP

I_TravelAddlDestinationTP is a Transactional CDS View that provides data about "Additional Travel Destination - TP" in SAP S/4HANA. It reads from 1 data source (I_TravelAddlDestination) and exposes 53 fields with key fields PersonnelNumber, TravelTripNumber, DestinationAssignment, DestinationType, TravelReqUUID.

Data Sources (1)

SourceAliasJoin Type
I_TravelAddlDestination I_TravelAddlDestination projection

Annotations (13)

NameValueLevelField
EndUserText.label Additional Travel Destination - 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 ADD 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 (53)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonnelNumber Personnel No.
KEY TravelTripNumber TravelTripNumber Trip Number
KEY DestinationAssignment DestinationAssignment Destination Assignment
KEY DestinationType DestinationType Destination type
KEY TravelReqUUID TravelReqUUID UUID
KEY SeqReqUUID SeqReqUUID UUID
TravelExpnSequentialNumber TravelExpnSequentialNumber Sequential Number
TripBeginsOnDate TripBeginsOnDate Start Date
TripBeginsAtTime TripBeginsAtTime Trip Begins At
AddressNumber AddressNumber Src Address No
CityName CityName Name
DistrictName DistrictName District
PostalCode PostalCode Postal Code
CityCodeName CityCodeName City Code
TravelCommunityCityName TravelCommunityCityName City
TravelCommunityDistrictName TravelCommunityDistrictName District
TravelCommunityPostCode TravelCommunityPostCode Postal Code
StreetName StreetName Text
HouseNumber HouseNumber House Number
Country Country Venue: Ctry/Reg
Region Region Venue Region
MealsPerDiemHasTxn MealsPerDiemHasTxn Auto Acmd Meals Tax
MealsPerDiemHasMnlTxn MealsPerDiemHasMnlTxn Manual Meals Taxation
AcmdtnPerDiemHasMnlTxn AcmdtnPerDiemHasMnlTxn Manual Acmd Taxation
TripDestTypeName TripDestTypeName Event in Itinerary
CountryRegionName CountryRegionName Country / Region
TripTypeStatutory TripTypeStatutory Trip Type, Statutory
TripTypeStatutoryName TripTypeStatutoryName Trip Type Statutory Name
TripTypeEnterprise TripTypeEnterprise Trip Type, Company-Specific
TripTypeEnterpriseName TripTypeEnterpriseName Trip Type Enterprise Name
TypeOfTripActivityValue TypeOfTripActivityValue Activity (Planning)
AddlDestTypeOfTripActyName AddlDestTypeOfTripActyName Trip Activity Type Name
AbsenceTypeName AbsenceTypeName Absence Type Name
AllowanceTypeName AllowanceTypeName Allowance Type Name
TrvlReqSprtnAllwncName TrvlReqSprtnAllwncName Spouse Separation Allowance Name
SleepAtHomeName SleepAtHomeName Sleep at Home Name
DurnOfPrvtTripBreakName DurnOfPrvtTripBreakName Duration of Private Trip Break Name
TripReasonText TripReasonText Reason
TripDestination TripDestination Destination
TripActivityType TripActivityType Activity (Planning)
TripActivityTypeName TripActivityTypeName Activity Name
TripRegion TripRegion Trip Region
AddlDestSleepAtHome AddlDestSleepAtHome Night at Home
AddlDestDurnOfPrvtTripBreak AddlDestDurnOfPrvtTripBreak Private Trip Break
NrOfPerDiemNights NrOfPerDiemNights PD Nights
AddlDestAbsenceType AddlDestAbsenceType Abs. Type
AddlDestAllowanceType AddlDestAllowanceType Allowance Type
TrvlReqSprtnAllwnc TrvlReqSprtnAllwnc Spouse
AcmdtnIsChargeable AcmdtnIsChargeable Chargeable Accommodations
TripDestinationLong TripDestinationLong Destination
TripItineraryNumber TripItineraryNumber Trip Segment Number
LastChangeDateTime LastChangeDateTime Timestamp
AddlDestLoclLastChgdDteTme AddlDestLoclLastChgdDteTme Changed On

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_TravelAddlDestinationTP.
-- 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_TravelAddlDestinationTP AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  DestinationAssignment,
  DestinationType,
  TravelReqUUID,
  SeqReqUUID,
  TravelExpnSequentialNumber,
  TripBeginsOnDate,
  TripBeginsAtTime,
  AddressNumber,
  CityName,
  DistrictName,
  PostalCode,
  CityCodeName,
  TravelCommunityCityName,
  TravelCommunityDistrictName,
  TravelCommunityPostCode,
  StreetName,
  HouseNumber,
  Country,
  Region,
  MealsPerDiemHasTxn,
  MealsPerDiemHasMnlTxn,
  AcmdtnPerDiemHasMnlTxn,
  TripDestTypeName,
  CountryRegionName,
  TripTypeStatutory,
  TripTypeStatutoryName,
  TripTypeEnterprise,
  TripTypeEnterpriseName,
  TypeOfTripActivityValue,
  AddlDestTypeOfTripActyName,
  AbsenceTypeName,
  AllowanceTypeName,
  TrvlReqSprtnAllwncName,
  SleepAtHomeName,
  DurnOfPrvtTripBreakName,
  TripReasonText,
  TripDestination,
  TripActivityType,
  TripActivityTypeName,
  TripRegion,
  AddlDestSleepAtHome,
  AddlDestDurnOfPrvtTripBreak,
  NrOfPerDiemNights,
  AddlDestAbsenceType,
  AddlDestAllowanceType,
  TrvlReqSprtnAllwnc,
  AcmdtnIsChargeable,
  TripDestinationLong,
  TripItineraryNumber,
  LastChangeDateTime,
  AddlDestLoclLastChgdDteTme
FROM I_TravelAddlDestination
;

Learn More