C_TravelExpenseReceipt

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_TravelExpenseReceipt.
-- 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_TravelExpenseReceipt AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  TravelReqUUID,
  SeqReqUUID,
  TravelExpenseDocument,
  TravelExpnSequentialNumber,
  TravelExpenseType,
  TravelExpenseCategory,
  TravelExpenseHasPaperReceipt,
  IndividualReceiptAmount,
  ReceiptAmountCurrencyCode,
  TravelExchangeRate,
  CurrencyUnitFromRatio,
  CurrencyUnitToRatio,
  IndividualReceiptDate,
  PaymentAmount,
  PaymentCurrency,
  TaxCode,
  TaxCodeName,
  TaxJurisdiction,
  ReceiptShortText,
  Country,
  TripRegion,
  ServiceFromDate,
  ServiceToDate,
  NumberOfDays,
  TotalNumberOfBreakfasts,
  TrvlExpnReceiptDescription,
  WorkLocationName,
  BusinessPurposeDescription,
  BusinessPartnerText,
  CreditCardCompanyCode,
  CreditCardReceiptDocNmbr,
  CreditCardTransactionDesc,
  CreditCardNumber,
  PaymentTransactionKey,
  ProviderCategoryCode,
  TrvlExpnProviderCode,
  PaperReceiptDocumentNumber,
  NumberOfEmployees,
  NmbrOfEmployeesOfBP,
  NumberOfAdditionalGuests,
  PaymentIsMadeByCompany,
  ServiceProviderCode,
  LimitForExceedingTrvlExpnType,
  ProtectionIndicatorType,
  TravelExpenseReferenceDocument,
  ReceiptIsChecked,
  TripTypeEnterprise,
  TripTypeEnterpriseName,
  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,
  TaxJurisdictionCodeName,
  CountryRegionName,
  CreditCardCompanyName,
  ProviderCategoryName,
  TravelExpenseProviderName,
  ServiceProviderName,
  OriginalReceiptAmount,
  TotalItemizedReceiptAmount,
  PrivateExpenseAmount,
  ReceiptOriginType,
  ReceiptOriginName,
  ReceiptIsItemized,
  TravelExpenseTypeCategoryCode,
  TravelExpenseTypeCategoryName,
  ServiceTaxTypeName,
  SubServiceTaxName,
  AirlineName,
  TrvlCostAssgmtAmtOrPctg,
  TrvlExpnRcptImgLnkText,
  RcptsLoclLastChgdDteTme,
  DestinationAssignment,
  TravelCountryRegion,
  virtual TripDestination : vdm_destination AS virtualTripDestinationvdm_destination,
  virtual TrvlExpnRcptAttachmentMode : char1 AS virtualTrvlExpnRcptAttachmentModechar1,
  virtual RcptTaxAmountIsHidden : abap_boolean AS virtualRcptTaxAmountIsHiddenabap_boolean,
  virtual ReceiptNameIsHidden : abap_boolean AS virtualReceiptNameIsHiddenabap_boolean,
  virtual RcptAirlineIsHidden : abap_boolean AS virtualRcptAirlineIsHiddenabap_boolean,
  virtual PaidByCoTrvlExpnType : spkzl AS virtualPaidByCoTrvlExpnTypespkzl,
  virtual PayBackTrvlExpnType : spkzl AS virtualPayBackTrvlExpnTypespkzl,
  virtual PayBackTrvlExpnTypeDesc : text_spkzl AS virtualPayBackTrvlExpnTypeDesctext_spkzl
FROM I_TravelExpenseReceipt
;