C_TravelAddlDestination

DDL: C_TRAVELADDLDESTINATION Type: view_entity CONSUMPTION
55 Fields 1 Data Sources

Additional Travel Destination

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

Data Sources (1)

SourceAliasJoin Type
I_TravelAddlDestination I_TravelAddlDestination projection

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Additional Travel Destination view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources true view
AbapCatalog.extensibility.elementSuffix ADD view
AbapCatalog.extensibility.quota.maximumFields 238 view
AbapCatalog.extensibility.quota.maximumBytes 2240 view

Fields (55)

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
TravelCommunityPostCode TravelCommunityPostCode Postal Code
TravelCommunityDistrictName TravelCommunityDistrictName District
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
TravelCountryRegion TravelCountryRegion Country / Region
_TravelCountryRegionVH _TravelCountryRegionVH

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 C_TravelAddlDestination.
-- 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 C_TravelAddlDestination AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  DestinationAssignment,
  DestinationType,
  TravelReqUUID,
  SeqReqUUID,
  TravelExpnSequentialNumber,
  TripBeginsOnDate,
  TripBeginsAtTime,
  AddressNumber,
  CityName,
  DistrictName,
  PostalCode,
  CityCodeName,
  TravelCommunityCityName,
  TravelCommunityPostCode,
  TravelCommunityDistrictName,
  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,
  TravelCountryRegion
FROM I_TravelAddlDestination
;

Learn More