I_TravelExpenseReceiptTP

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_TravelExpenseReceiptTP.
-- 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_TravelExpenseReceiptTP AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  TravelReqUUID,
  SeqReqUUID,
  TravelExpenseDocument,
  TravelExpnSequentialNumber,
  TravelExpenseType,
  TravelExpenseCategory,
  TravelExpenseHasPaperReceipt,
  IndividualReceiptAmount,
  ReceiptAmountCurrencyCode,
  TravelExchangeRate,
  CurrencyUnitFromRatio,
  CurrencyUnitToRatio,
  IndividualReceiptDate,
  PaymentAmount,
  PaymentCurrency,
  TaxCode,
  TaxJurisdiction,
  ReceiptShortText,
  Country,
  TripRegion,
  ServiceFromDate,
  ServiceToDate,
  NumberOfDays,
  TotalNumberOfBreakfasts,
  TrvlExpnReceiptDescription,
  WorkLocationName,
  BusinessPurposeDescription,
  BusinessPartnerText,
  CreditCardCompanyCode,
  CreditCardReceiptDocNmbr,
  CreditCardTransactionDesc,
  CreditCardNumber,
  CreditCardTransactionUUID,
  PaymentTransactionKey,
  ProviderCategoryCode,
  TrvlExpnProviderCode,
  PaperReceiptDocumentNumber,
  NumberOfEmployees,
  NmbrOfEmployeesOfBP,
  NumberOfAdditionalGuests,
  PaymentIsMadeByCompany,
  ServiceProviderCode,
  LimitForExceedingTrvlExpnType,
  ProtectionIndicatorType,
  TravelExpenseReferenceDocument,
  ReceiptIsChecked,
  TripTypeEnterprise,
  ReceiptCheckResult,
  IndividualReceiptIsDspOnly,
  ReceiptEditorText,
  OriginalTravelExpenseType,
  PrivateShareTravelExpenseType,
  TotalNumberOfLunches,
  TotalNumberOfDinners,
  AcmdtnReimbmtReceiptIsApproved,
  MissingPaperReceiptType,
  TripBookedPrice,
  TripBookedPriceCurrency,
  DifferenceInTravelExpenseAmt,
  DifferenceAmountCurrency,
  DifferenceAmountReasonText,
  MaxDiffExceedingTrvlExpnType,
  OriginalReceiptInvoiceNumber,
  NumberOfInvoiceItems,
  TaxAmount,
  ServiceTaxTypeCode,
  ServiceTaxDescription,
  ServiceTaxRegistrationNumber,
  Name,
  StreetName,
  HouseNumber,
  PostalCode,
  CityName,
  ServiceTaxSubCode,
  ServiceTaxDescriptionLanguage,
  TaxAmountChange,
  FlightDepartureLocation,
  FlightArrivalLocation,
  Airline,
  AirCabinClass,
  AirTicketNumber,
  VehicleMileageValue,
  SupplierName,
  SupplierStreetName,
  SupplierCityName,
  SupplierStateName,
  SupplierCountryName,
  SupplierPostalCode,
  CustomerServiceTelephoneNumber,
  AcmdtnRcptWithCollectiveItems,
  MealsInclusionInAcmdtnReceipt,
  InvoiceToEmployer,
  BusinessRelatedCollectiveItem,
  TravelExpenseTypeName,
  TravelExpenseCategoryName,
  ReceiptAmountCurrencyCodeName,
  PaymentCurrencyCodeName,
  TaxCodeName,
  TaxJurisdictionCodeName,
  CountryRegionName,
  CreditCardCompanyName,
  ProviderCategoryName,
  TravelExpenseProviderName,
  ServiceProviderName,
  TripTypeEnterpriseName,
  TrvlExpnRcptImgLnkText,
  OriginalReceiptAmount,
  TotalItemizedReceiptAmount,
  PrivateExpenseAmount,
  ReceiptOriginType,
  ReceiptOriginName,
  ReceiptIsItemized,
  TravelExpenseTypeCategoryCode,
  TravelExpenseTypeCategoryName,
  ServiceTaxTypeName,
  SubServiceTaxName,
  AirlineName,
  TrvlCostAssgmtAmtOrPctg,
  TrvlExpnRecIsModified,
  RcptsLoclLastChgdDteTme,
  DestinationAssignment,
  RcptTravelExpenseTypeIsVisible,
  RcptTrvlExpnPaperRcptIsVisible,
  RcptTrvlExpnRcptAmtIsVisible,
  RcptTrvlExpnRcptRateIsVisible,
  RcptTrvlExpnRcptDateIsVisible,
  RcptTrvlExpnPayAmtIsVisible,
  RcptTrvlExpnPayCrcyIsVisible,
  RcptTrvlExpnShortTxtIsVisible,
  RcptTrvlExpnBizPrpsIsVisible,
  RcptTrvlExpnPaytCoIsVisible,
  RcptTrvlCrdtCardNmbrIsVisible,
  RcptTrvlCrdtCardDescIsVisible,
  RcptTrvlExpnRcptIsCheckVisible,
  RcptTrvlExpnRcptNmbrIsVisible,
  RcptTrvlExpnRcptItemIsVisible,
  RcptTrvlExpnVATAmtIsVisible,
  RcptTrvlVATSrvcCodeIsVisible,
  RcptTrvlVATSrvcDescIsVisible,
  RcptTrvlVATRegnNmbrIsVisible,
  RcptTrvlVATRegnTaxIsVisible,
  RcptTrvlExpnNameIsVisible,
  RcptTrvlExpnStreetIsVisible,
  RcptTrvlExpnHouseNmbrIsVisible,
  RcptTrvlExpnPostlCodeIsVisible,
  RcptTrvlExpnCityIsVisible,
  RcptTrvlExpnMblApplIsVisible,
  RcptTrvlAirportDeptrIsVisible,
  RcptTrvlAirportArrvlIsVisible,
  RcptTrvlExpnAirlineIsVisible,
  RcptTrvlExpnCabinClIsVisible,
  RcptTrvlTicketNmbrIsVisible,
  RcptTrvlCarOdometerIsVisible,
  RcptTrvlExpnSuplrNameIsVisible,
  RcptTrvlExpnSuplrStIsVisible,
  RcptTrvlExpnSuplrCityIsVisible,
  RcptTrvlSuplrStateIsVisible,
  RcptTrvlSuplrCntryIsVisible,
  RcptTrvlSuplrPostlIsVisible,
  RcptTrvlSuplrSrvcPhIsVisible,
  RcptTravelExpenseTypeIsInput,
  RcptTrvlExpnPaperRcptIsInput,
  RcptTrvlExpnRcptAmtIsInput,
  RcptTrvlExpnRcptRateIsInput,
  RcptTrvlExpnRcptDateIsInput,
  RcptTrvlExpnPayAmtIsInput,
  RcptTrvlExpnPayCrcyIsInput,
  RcptTrvlExpnShortTxtIsInput,
  RcptTrvlExpnBizPrpsIsInput,
  RcptTrvlExpnPaytCoIsInput,
  RcptTrvlCrdtCardNmbrIsInput,
  RcptTrvlCrdtCardDescIsInput,
  RcptTrvlExpnRcptIsCheckInput,
  RcptTrvlExpnRcptNmbrIsInput,
  RcptTrvlExpnRcptItemIsInput,
  RcptTrvlExpnVATAmtIsInput,
  RcptTrvlVATSrvcCodeIsInput,
  RcptTrvlVATSrvcDescIsInput,
  RcptTrvlVATRegnNmbrIsInput,
  RcptTrvlVATRegnTaxIsInput,
  RcptTrvlExpnNameIsInput,
  RcptTrvlExpnStreetIsInput,
  RcptTrvlExpnHouseNmbrIsInput,
  RcptTrvlExpnPostlCodeIsInput,
  RcptTrvlExpnCityIsInput,
  RcptTrvlExpnMblApplIsInput,
  RcptTrvlAirportDeptrIsInput,
  RcptTrvlAirportArrvlIsInput,
  RcptTrvlExpnAirlineIsInput,
  RcptTrvlExpnCabinClIsInput,
  RcptTrvlTicketNmbrIsInput,
  RcptTrvlCarOdometerIsInput,
  RcptTrvlExpnSuplrNameIsInput,
  RcptTrvlExpnSuplrStIsInput,
  RcptTrvlExpnSuplrCityIsInput,
  RcptTrvlSuplrStateIsInput,
  RcptTrvlSuplrCntryIsInput,
  RcptTrvlSuplrPostlCodeIsInput,
  RcptTrvlSuplrSrvcPhIsInput,
  RcptTrvlExpnTypeIsRequired,
  RcptTrvlExpnPaperRcptIsRqd,
  RcptTrvlExpnRcptAmtIsRqd,
  RcptTrvlExpnRcptRateIsRqd,
  RcptTrvlExpnRcptDateIsRqd,
  RcptTrvlExpnPayAmtIsRqd,
  RcptTrvlExpnPayCrcyIsRqd,
  RcptTrvlExpnShortTxtIsRqd,
  RcptTrvlExpnBizPrpsIsRqd,
  RcptTrvlExpnPaytCoIsRqd,
  RcptTrvlCrdtCardNmbrIsRqd,
  RcptTrvlCrdtCardDescIsRqd,
  RcptTrvlExpnRcptIsCheckRqd,
  RcptTrvlExpnRcptNmbrIsRqd,
  RcptTrvlExpnRcptItemIsRqd,
  RcptTrvlExpnVATAmtIsRqd,
  RcptTrvlVATSrvcCodeIsRqd,
  RcptTrvlVATSrvcDescIsRqd,
  RcptTrvlVATRegnNmbrIsRqd,
  RcptTrvlVATRegnTaxIsRqd,
  RcptTrvlExpnNameIsRqd,
  RcptTrvlExpnStreetIsRqd,
  RcptTrvlExpnHouseNmbrIsRqd,
  RcptTrvlExpnPostlCodeIsRqd,
  RcptTrvlExpnCityIsRqd,
  RcptTrvlExpnMblApplIsRqd,
  RcptTrvlAirportDeptrIsRqd,
  RcptTrvlAirportArrvlIsRqd,
  RcptTrvlExpnAirlineIsRqd,
  RcptTrvlExpnCabinClIsRqd,
  RcptTrvlTicketNmbrIsRqd,
  RcptTrvlCarOdometerIsRqd,
  RcptTrvlExpnSuplrNameIsRqd,
  RcptTrvlExpnSuplrStIsRqd,
  RcptTrvlExpnSuplrCityIsRqd,
  RcptTrvlSuplrStateIsRqd,
  RcptTrvlSuplrCntryIsRqd,
  RcptTrvlSuplrPostlCodeIsRqd,
  RcptTrvlSuplrSrvcPhIsRqd
FROM I_TravelExpenseReceipt
;