I_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 I_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 I_TravelExpenseReceipt AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS 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,
  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,
  cast ( 'X' as abap.char( 1 ) ) AS TrvlExpnRecIsModified,
  cast(0.0000000 as abp_lastchange_tstmpl) AS RcptsLoclLastChgdDteTme,
  DestinationAssignment,
  TravelCountryRegion,
  RcptTravelExpenseTypeIsVisible,
  RcptTrvlExpnPaperRcptIsVisible,
  RcptTrvlExpnRcptAmtIsVisible,
  RcptTrvlExpnRcptCrcyIsVisible,
  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,
  RcptTrvlExpnRcptCrcyIsInput,
  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,
  RcptTrvlExpnRcptCrcyIsRqd,
  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,
  AcmdtnRcptWthCollvItms_H,
  AcmdtnReimbmtRcptIsAprvd_H,
  AirCabinClass_H,
  Airline_H,
  AirTicketNumber_H,
  BusinessPartnerText_H,
  BusinessPurposeDescription_H,
  BusinessReltdCollvItm_H,
  CityName_H,
  CustomerServiceTelNmbr_H,
  FlightArrivalLocation_H,
  FlightDepartureLocation_H,
  HouseNumber_H,
  IndividualReceiptAmount_H,
  ReceiptAmountCurrencyCode_H,
  IndividualReceiptDate_H,
  InvoiceToEmployer_H,
  MealsInclsnInAcmdtnRcpt_H,
  Name_H,
  NmbrOfEmployeesOfBP_H,
  NumberOfAdditionalGuests_H,
  NumberOfDays_H,
  NumberOfEmployees_H,
  NumberOfInvoiceItems_H,
  OriginalReceiptInvoiceNumber_H,
  PaperReceiptDocumentNumber_H,
  PaymentAmount_H,
  PaymentCurrency_H,
  PostalCode_H,
  ReceiptEditorText_H,
  ReceiptIsChecked_H,
  ReceiptShortText_H,
  ServiceFromDate_H,
  ServiceProviderCode_H,
  ServiceTaxDescLang_H,
  ServiceTaxRegistrationNumber_H,
  ServiceTaxSubCode_H,
  ServiceTaxTypeCode_H,
  ServiceToDate_H,
  StreetName_H,
  SupplierCityName_H,
  SupplierCountryName_H,
  SupplierName_H,
  SupplierPostalCode_H,
  SupplierStateName_H,
  SupplierStreetName_H,
  TaxAmount_H,
  TaxCode_H,
  TaxJurisdiction_H,
  TotalNumberOfBreakfasts_H,
  TotalNumberOfDinners_H,
  TotalNumberOfLunches_H,
  TravelCountryRegion_H,
  TravelExchangeRate_H,
  TravelExpenseHasPaperReceipt_H,
  TravelExpenseType_H,
  TripTypeEnterprise_H,
  TrvlExpnProviderCode_H,
  TrvlExpnReceiptDescription_H,
  VehicleMileageValue_H,
  WorkLocationName_H,
  RcptParticipantFacet_H,
  RcptProductFacet_H
FROM I_TravelExpenseReceiptData
LEFT OUTER JOIN C_TravelExpenseTypeValueHelp AS _TravelExpenseTypeVH ON TravelExpenseType = _TravelExpenseTypeVH.TravelExpenseType  -- association [0..1]
LEFT OUTER JOIN C_TravelTripEnterpriseTypeVH AS _TravelEnterpriseVH ON TripTypeEnterprise = _TravelEnterpriseVH.TripTypeEnterprise  -- association [0..1]
LEFT OUTER JOIN C_TravelTaxCodeVH AS _TravelTaxCodeVH ON TaxCode = _TravelTaxCodeVH.TaxCode  -- association [0..1]
LEFT OUTER JOIN C_TrvlExpnServiceProviderVH AS _TrvlExpnServiceProviderVH ON ServiceProviderCode = _TrvlExpnServiceProviderVH.ServiceProviderCode  -- association [0..1]
LEFT OUTER JOIN C_TrvlExpnVATRefundCodeVH AS _TrvlExpnVATRefundCodeVH ON ServiceTaxTypeCode = _TrvlExpnVATRefundCodeVH.ServiceTaxTypeCode  -- association [0..1]
LEFT OUTER JOIN C_TrvlExpnVATSubCodeVH AS _TrvlExpnVATSubCodeVH ON ServiceTaxSubCode = _TrvlExpnVATSubCodeVH.ServiceTaxSubCode  -- association [0..1]
LEFT OUTER JOIN I_TravelExpenseIATALocationVH AS _TravelExpenseIATALocationVH ON FlightDepartureLocation = _TravelExpenseIATALocationVH.IATALocationCode  -- association [0..1]
LEFT OUTER JOIN I_TravelExpenseIATALocationVH AS _TravelExpenseIATAArrivalLocVH ON FlightArrivalLocation = _TravelExpenseIATAArrivalLocVH.IATALocationCode  -- association [0..1]
LEFT OUTER JOIN C_TravelCountryRegionVH AS _TravelCountryRegionVH ON Country = _TravelCountryRegionVH.TripCountry  -- association [0..*]
LEFT OUTER JOIN E_TravelExpenseReceiptData AS _ExtensionReceipt ON PersonnelNumber = _ExtensionReceipt.PersonnelNumber AND TravelTripNumber = _ExtensionReceipt.TravelTripNumber AND TravelExpnSequentialNumber = _ExtensionReceipt.TravelExpnSequentialNumber AND TravelExpenseDocument = _ExtensionReceipt.TravelExpenseDocument  -- association [0..1]
LEFT OUTER JOIN I_TrvlExpnReceiptCostAssgmt AS _TrvlExpnReceiptCostAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TrvlExpnReceiptParticipant AS _TrvlExpnReceiptParticipant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TravelExpenseReceiptProduct AS _TravelExpenseReceiptProduct ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_TrvlExpnPrvtExpnOrSpltRcpts AS _TrvlExpnPrvtExpnOrSpltRcpts ON /* condition not available in parsed metadata */  -- association [0..*]
;