C_ReceiptProductArranger

DDL: C_RECEIPTPRODUCTARRANGER Type: view_entity CONSUMPTION
17 Fields 1 Data Sources

Travel Expense Receipt Product

C_ReceiptProductArranger is a Consumption CDS View that provides data about "Travel Expense Receipt Product" in SAP S/4HANA. It reads from 1 data source (I_TravelExpenseReceiptProduct) and exposes 17 fields with key fields PersonnelNumber, TravelTripNumber, PeriodNumberOfTrip, PeriodSequentialNumber, TravelExpenseDocument.

Data Sources (1)

SourceAliasJoin Type
I_TravelExpenseReceiptProduct I_TravelExpenseReceiptProduct projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Travel Expense Receipt Product 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
UI.createHidden true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonnelNumber Personnel No.
KEY TravelTripNumber TravelTripNumber Trip Number
KEY PeriodNumberOfTrip PeriodNumberOfTrip Period Number
KEY PeriodSequentialNumber PeriodSequentialNumber Sequence Number
KEY TravelExpenseDocument TravelExpenseDocument Document Number
KEY ParticipantSequenceNumber ParticipantSequenceNumber
KEY TravelReqUUID TravelReqUUID UUID
KEY SeqReqUUID SeqReqUUID UUID
KEY TravelExpenseReceiptProdUUID TravelExpenseReceiptProdUUID
TravelExpenseProductIdentifier TravelExpenseProductIdentifier
TravelExpenseProductName TravelExpenseProductName
TravelExpenseProductCategory TravelExpenseProductCategory
TravelExpenseProductDrugCode TravelExpenseProductDrugCode
ProductValidStartDate ProductValidStartDate Valid From
ProductValidEndDate ProductValidEndDate Valid to
TravelExpenseProductIsObsolete TravelExpenseProductIsObsolete
RcptsProdLoclLastChgdDteTme RcptsProdLoclLastChgdDteTme

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_ReceiptProductArranger.
-- 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_ReceiptProductArranger AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  PeriodNumberOfTrip,
  PeriodSequentialNumber,
  TravelExpenseDocument,
  ParticipantSequenceNumber,
  TravelReqUUID,
  SeqReqUUID,
  TravelExpenseReceiptProdUUID,
  TravelExpenseProductIdentifier,
  TravelExpenseProductName,
  TravelExpenseProductCategory,
  TravelExpenseProductDrugCode,
  ProductValidStartDate,
  ProductValidEndDate,
  TravelExpenseProductIsObsolete,
  RcptsProdLoclLastChgdDteTme
FROM I_TravelExpenseReceiptProduct
;

Learn More