What is C_TrvlExpnPrvtExpnOrSpltRcpts in SAP S/4HANA?

C_TrvlExpnPrvtExpnOrSpltRcpts is a consumption CDS view in SAP S/4HANA. Trvl Expn Prvt Expn or Splt Rcpt It contains 129 fields.

Which tables does C_TrvlExpnPrvtExpnOrSpltRcpts read from?

C_TrvlExpnPrvtExpnOrSpltRcpts reads data from: I_TrvlExpnPrvtExpnOrSpltRcpts.

What VDM layer is C_TrvlExpnPrvtExpnOrSpltRcpts?

C_TrvlExpnPrvtExpnOrSpltRcpts is classified as a Consumption view optimized for specific business scenarios and reporting.

C_TrvlExpnPrvtExpnOrSpltRcpts

DDL: C_TRVLEXPNPRVTEXPNORSPLTRCPTS Type: view_entity CONSUMPTION

129 Fields 1 Data Sources 1 Associations

Trvl Expn Prvt Expn or Splt Rcpt

C_TrvlExpnPrvtExpnOrSpltRcpts is a Consumption CDS View that provides data about "Trvl Expn Prvt Expn or Splt Rcpt" in SAP S/4HANA. It reads from 1 data source (I_TrvlExpnPrvtExpnOrSpltRcpts) and exposes 129 fields with key fields PersonnelNumber, TravelTripNumber, TravelExpenseDocument, TravelReqUUID, SeqReqUUID. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_TrvlExpnPrvtExpnOrSpltRcpts	I_TrvlExpnPrvtExpnOrSpltRcpts	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	E_TravelExpenseReceiptData	_Extension	`$projection.PersonnelNumber = _Extension.PersonnelNumber and $projection.TravelTripNumber = _Extension.TravelTripNumber and $projection.TravelExpnSequentialNumber = _Extension.TravelExpnSequentialNumber and $projection.TravelExpenseDocument = _Extension.TravelExpenseDocument`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Trvl Expn Prvt Expn or Splt Rcpt	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#CONSUMPTION	view

Fields (129)

Key	Field	Source Field	Description
KEY	PersonnelNumber	PersonnelNumber	Personnel No.
KEY	TravelTripNumber	TravelTripNumber	Trip Number
KEY	TravelExpenseDocument	TravelExpenseDocument	Document Number
KEY	TravelReqUUID	TravelReqUUID	UUID
KEY	SeqReqUUID	SeqReqUUID	UUID
KEY	PrvtExpnOrSpltRcptsSeqReqUUID	PrvtExpnOrSpltRcptsSeqReqUUID
	TravelExpnSequentialNumber	TravelExpnSequentialNumber	Sequential Number
	TravelExpenseType	TravelExpenseType	Travel Exp.Type
	TravelExpenseCategory	TravelExpenseCategory	Expense Category
	TravelExpenseHasPaperReceipt	TravelExpenseHasPaperReceipt	Paper Receipt
	IndividualReceiptAmount	IndividualReceiptAmount	Receipt Amount
	ReceiptAmountCurrencyCode	ReceiptAmountCurrencyCode	Currency
	TravelExchangeRate	TravelExchangeRate	Exchange Rate
	CurrencyUnitFromRatio	CurrencyUnitFromRatio	Ratio (from)
	CurrencyUnitToRatio	CurrencyUnitToRatio	Ratio (to)
	IndividualReceiptDate	IndividualReceiptDate	Date
	PaymentAmount	PaymentAmount	Credit total
	PaymentCurrency	PaymentCurrency	Payment Currency
	TaxCode	TaxCode	Tax Code
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	ReceiptShortText	ReceiptShortText	Short Receipt Info
	Country	Country	Venue: Ctry/Reg
	TripRegion	TripRegion	Trip Region
	ServiceFromDate	ServiceFromDate	From Date
	ServiceToDate	ServiceToDate	To Date
	NumberOfDays	NumberOfDays	Number of Days
	TotalNumberOfBreakfasts	TotalNumberOfBreakfasts	No.Breakf.
	TrvlExpnReceiptDescription	TrvlExpnReceiptDescription	Receipt Description
	WorkLocationName	WorkLocationName	Work Location
	BusinessPurposeDescription	BusinessPurposeDescription	Bus. Purpose
	BusinessPartnerText	BusinessPartnerText	Business Partner
	CreditCardCompanyCode	CreditCardCompanyCode	Company
	CreditCardReceiptDocNmbr	CreditCardReceiptDocNmbr	Credit Card Receipt Document Number
	CreditCardTransactionDesc	CreditCardTransactionDesc	Credit Card Transaction Description
	CreditCardNumber	CreditCardNumber	Card Number
	ProviderCategoryCode	ProviderCategoryCode	Provider Category
	TrvlExpnProviderCode	TrvlExpnProviderCode	Provider Code
	PaperReceiptDocumentNumber	PaperReceiptDocumentNumber	Paper Document Number
	NumberOfEmployees	NumberOfEmployees	No. employees
	NmbrOfEmployeesOfBP	NmbrOfEmployeesOfBP	Partners
	NumberOfAdditionalGuests	NumberOfAdditionalGuests	Number of Guests
	PaymentIsMadeByCompany	PaymentIsMadeByCompany	Paid by Company
	ServiceProviderCode	ServiceProviderCode	ServiceProvider
	LimitForExceedingTrvlExpnType	LimitForExceedingTrvlExpnType	Limit exceeded
	ProtectionIndicatorType	ProtectionIndicatorType	ProtectInd
	TravelExpenseReferenceDocument	TravelExpenseReferenceDocument	Sub Document No
	ReceiptIsChecked	ReceiptIsChecked	Receipt Checked
	TripTypeEnterprise	TripTypeEnterprise	Trip Type, Company-Specific
	ReceiptCheckResult	ReceiptCheckResult	Receipt Check Result
	IndividualReceiptIsDspOnly	IndividualReceiptIsDspOnly	Receipt Display Only
	ReceiptEditorText	ReceiptEditorText	Editor
	OriginalTravelExpenseType	OriginalTravelExpenseType	Travel Exp.Type
	PrivateShareTravelExpenseType	PrivateShareTravelExpenseType	Expense Type Private
	TotalNumberOfLunches	TotalNumberOfLunches	Number of Lunches
	TotalNumberOfDinners	TotalNumberOfDinners	Number of Dinners
	AcmdtnReimbmtReceiptIsApproved	AcmdtnReimbmtReceiptIsApproved	Acmdtns Rcpt Aprvd
	MissingPaperReceiptType	MissingPaperReceiptType	Paper Receipt Missing
	TripBookedPrice	TripBookedPrice	Booked Price
	TripBookedPriceCurrency	TripBookedPriceCurrency	Booked Currency
	DifferenceInTravelExpenseAmt	DifferenceInTravelExpenseAmt	Variance Amount
	DifferenceAmountCurrency	DifferenceAmountCurrency	Difference Amt. Crcy
	DifferenceAmountReasonText	DifferenceAmountReasonText	Reason for Difference
	MaxDiffExceedingTrvlExpnType	MaxDiffExceedingTrvlExpnType	Max Difference Exceeded
	OriginalReceiptInvoiceNumber	OriginalReceiptInvoiceNumber	Original Rcpt Invc No.
	NumberOfInvoiceItems	NumberOfInvoiceItems	No. of Invoice Items
	TaxAmount	TaxAmount	Tax Amt in Rptg Crcy
	ServiceTaxTypeCode	ServiceTaxTypeCode	Services
	ServiceTaxDescription	ServiceTaxDescription	Goods and Services Desc
	ServiceTaxRegistrationNumber	ServiceTaxRegistrationNumber	VAT Registration No.
	Name	Name	Zone name
	StreetName	StreetName	Text
	HouseNumber	HouseNumber	House Number
	PostalCode	PostalCode	Postal Code
	CityName	CityName	Name
	ServiceTaxSubCode	ServiceTaxSubCode	Subcode
	ServiceTaxDescriptionLanguage	ServiceTaxDescriptionLanguage	Goods and Services Lang
	TaxAmountChange	TaxAmountChange	VAT Changed
	FlightDepartureLocation	FlightDepartureLocation	Departure IATA
	FlightArrivalLocation	FlightArrivalLocation	Arrival IATA
	Airline	Airline	Airline
	AirCabinClass	AirCabinClass	Cabin Class
	AirTicketNumber	AirTicketNumber	Ticket Number
	VehicleMileageValue	VehicleMileageValue	Mileage
	SupplierName	SupplierName	Supplier Name
	SupplierStreetName	SupplierStreetName	Arrival Street
	SupplierCityName	SupplierCityName	Supplier City
	SupplierStateName	SupplierStateName	District (US:County)
	SupplierCountryName	SupplierCountryName	Country / Region
	SupplierPostalCode	SupplierPostalCode	Arrival Postal Code
	CustomerServiceTelephoneNumber	CustomerServiceTelephoneNumber	Cust Service Phone No.
	AcmdtnRcptWithCollectiveItems	AcmdtnRcptWithCollectiveItems	Rcpt with Collective Itms
	MealsInclusionInAcmdtnReceipt	MealsInclusionInAcmdtnReceipt	Meals In Accommodation Receipt
	InvoiceToEmployer	InvoiceToEmployer	Invc Issued to Employer
	BusinessRelatedCollectiveItem	BusinessRelatedCollectiveItem	Collective Item - Business Only
	TravelExpenseTypeName	TravelExpenseTypeName	Expense Type
	TravelExpenseCategoryName	TravelExpenseCategoryName	Expense Category Name
	ReceiptAmountCurrencyCodeName	ReceiptAmountCurrencyCodeName	Long Text
	PaymentCurrencyCodeName	PaymentCurrencyCodeName	Long Text
	TaxCodeName	TaxCodeName	Tax Code Name
	TaxJurisdictionCodeName	TaxJurisdictionCodeName	Tax Jurisdiction Name
	CountryRegionName	CountryRegionName	Country / Region
	CreditCardCompanyName	CreditCardCompanyName	Credit Card Company
	ProviderCategoryName	ProviderCategoryName	Provider Category Name
	TravelExpenseProviderName	TravelExpenseProviderName	Provider Name
	ServiceProviderName	ServiceProviderName	Service Provider Name
	TripTypeEnterpriseName	TripTypeEnterpriseName	Trip Type Enterprise Name
	OriginalReceiptAmount	OriginalReceiptAmount	Original Receipt Amount
	TotalItemizedReceiptAmount	TotalItemizedReceiptAmount	Total Itemized Receipts
	ReceiptOriginType	ReceiptOriginType	Receipt Origin
	ReceiptOriginName	ReceiptOriginName	Origin
	ReceiptIsItemized	ReceiptIsItemized	Itemized
	TravelExpenseTypeCategoryCode	TravelExpenseTypeCategoryCode	Expense Category Code
	TravelExpenseTypeCategoryName	TravelExpenseTypeCategoryName	Category
	ServiceTaxTypeName	ServiceTaxTypeName	Service Tax Type Name
	SubServiceTaxName	SubServiceTaxName	Sub Service Tax Name
	AirlineName	AirlineName	Airline Name
	PrvtSpltLoclLastChgdDteTme	PrvtSpltLoclLastChgdDteTme
	TravelCountryRegion	TravelCountryRegion	Country / Region
	virtualSplitReceiptExpenseTypechar4
	virtualRcptTaxAmountIsHiddenabap_boolean
	virtualReceiptNameIsHiddenabap_boolean
	virtualRcptAirlineIsHiddenabap_boolean
	virtualTrvlExpnRcptAttachmentModechar1
	_TravelExpenseTypeVH	_TravelExpenseTypeVH
	_TravelTaxCodeVH	_TravelTaxCodeVH
	_TravelEnterpriseVH	_TravelEnterpriseVH
	_TrvlExpnServiceProviderVH	_TrvlExpnServiceProviderVH
	_TrvlExpnVATSubCodeVH	_TrvlExpnVATSubCodeVH
	_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_TrvlExpnPrvtExpnOrSpltRcpts.
-- 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_TrvlExpnPrvtExpnOrSpltRcpts AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  TravelExpenseDocument,
  TravelReqUUID,
  SeqReqUUID,
  PrvtExpnOrSpltRcptsSeqReqUUID,
  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,
  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,
  OriginalReceiptAmount,
  TotalItemizedReceiptAmount,
  ReceiptOriginType,
  ReceiptOriginName,
  ReceiptIsItemized,
  TravelExpenseTypeCategoryCode,
  TravelExpenseTypeCategoryName,
  ServiceTaxTypeName,
  SubServiceTaxName,
  AirlineName,
  PrvtSpltLoclLastChgdDteTme,
  TravelCountryRegion,
  virtual SplitReceiptExpenseType : char4 AS virtualSplitReceiptExpenseTypechar4,
  virtual RcptTaxAmountIsHidden : abap_boolean AS virtualRcptTaxAmountIsHiddenabap_boolean,
  virtual ReceiptNameIsHidden : abap_boolean AS virtualReceiptNameIsHiddenabap_boolean,
  virtual RcptAirlineIsHidden : abap_boolean AS virtualRcptAirlineIsHiddenabap_boolean,
  virtual TrvlExpnRcptAttachmentMode : char1 AS virtualTrvlExpnRcptAttachmentModechar1
FROM I_TrvlExpnPrvtExpnOrSpltRcpts
LEFT OUTER JOIN E_TravelExpenseReceiptData AS _Extension ON PersonnelNumber = _Extension.PersonnelNumber AND TravelTripNumber = _Extension.TravelTripNumber AND TravelExpnSequentialNumber = _Extension.TravelExpnSequentialNumber AND TravelExpenseDocument = _Extension.TravelExpenseDocument  -- association [0..1]
;

Depth:

C_TrvlExpnPrvtExpnOrSpltRcpts view_entity

I_TrvlExpnPrvtExpnOrSpltRcpts view_entity