What is C_ReceiptArranger in SAP S/4HANA?

C_ReceiptArranger is a consumption CDS view in SAP S/4HANA. Travel Expense Receipt It contains 122 fields.

Which tables does C_ReceiptArranger read from?

C_ReceiptArranger reads data from: I_TravelExpenseReceipt.

What VDM layer is C_ReceiptArranger?

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

C_ReceiptArranger

DDL: C_RECEIPTARRANGER Type: view_entity CONSUMPTION

122 Fields 1 Data Sources

Travel Expense Receipt

C_ReceiptArranger is a Consumption CDS View that provides data about "Travel Expense Receipt" in SAP S/4HANA. It reads from 1 data source (I_TravelExpenseReceipt) and exposes 122 fields with key fields PersonnelNumber, TravelTripNumber, TravelReqUUID, SeqReqUUID, TravelExpenseDocument.

Data Sources (1)

Source	Alias	Join Type
I_TravelExpenseReceipt	I_TravelExpenseReceipt	projection

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Travel Expense Receipt	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
AbapCatalog.extensibility.extensible	true	view
AbapCatalog.extensibility.allowNewDatasources	true	view
AbapCatalog.extensibility.elementSuffix	RPT	view
AbapCatalog.extensibility.quota.maximumFields	350	view
AbapCatalog.extensibility.quota.maximumBytes	2240	view

Fields (122)

Key	Field	Source Field	Description
KEY	PersonnelNumber	PersonnelNumber	Personnel No.
KEY	TravelTripNumber	TravelTripNumber	Trip Number
KEY	TravelReqUUID	TravelReqUUID	UUID
KEY	SeqReqUUID	SeqReqUUID	UUID
KEY	TravelExpenseDocument	TravelExpenseDocument	Document Number
	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
	TaxCodeName	TaxCodeName	Tax Code Name
	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
	PaymentTransactionKey	PaymentTransactionKey	Transaction Key
	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
	TripTypeEnterpriseName	TripTypeEnterpriseName	Trip Type Enterprise Name
	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
	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
	OriginalReceiptAmount	OriginalReceiptAmount	Original Receipt Amount
	TotalItemizedReceiptAmount	TotalItemizedReceiptAmount	Total Itemized Receipts
	PrivateExpenseAmount	PrivateExpenseAmount	Amount
	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
	TrvlCostAssgmtAmtOrPctg	TrvlCostAssgmtAmtOrPctg	Amt/Percent
	TrvlExpnRcptImgLnkText	TrvlExpnRcptImgLnkText	UUID Archive
	SAPObjectNodeType	SAPObjectNodeType	SONT Name
	RcptsLoclLastChgdDteTme	RcptsLoclLastChgdDteTme	Changed On
	DestinationAssignment	DestinationAssignment	Destination Assignment

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_ReceiptArranger.
-- 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_ReceiptArranger 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,
  SAPObjectNodeType,
  RcptsLoclLastChgdDteTme,
  DestinationAssignment
FROM I_TravelExpenseReceipt
;

Depth:

C_ReceiptArranger view_entity

I_TravelExpenseReceipt view_entity