I_TrvlExpnRcptProductData

DDL: I_TRVLEXPNRCPTPRODUCTDATA Type: view_entity BASIC
13 Fields 2 Data Sources

Travel Expense Receipt Product

I_TrvlExpnRcptProductData is a Basic CDS View that provides data about "Travel Expense Receipt Product" in SAP S/4HANA. It reads from 2 data sources (ptrv_recproduct, ptrv_product) and exposes 13 fields with key fields PersonnelNumber, TravelTripNumber, PeriodNumberOfTrip, PeriodSequentialNumber, TravelExpenseDocument.

Data Sources (2)

SourceAliasJoin Type
ptrv_recproduct TrvlExpnProduct from
ptrv_product TrvlExpnProductDetail inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Travel Expense Receipt Product view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber ptrv_recproduct pernr Personnel no.
KEY TravelTripNumber ptrv_recproduct reinr Trip Number
KEY PeriodNumberOfTrip ptrv_recproduct perio Time unit
KEY PeriodSequentialNumber ptrv_recproduct pdvrs Sequence Number
KEY TravelExpenseDocument ptrv_recproduct belnr SD Document
KEY ParticipantSequenceNumber ptrv_recproduct lfdnr Tax sequence
TravelExpenseProductIdentifier
TravelExpenseProductName ptrv_product product_name Product Name
TravelExpenseProductCategory ptrv_product product_cat Prod. Category
TravelExpenseProductDrugCode ptrv_product prd_drug_code Nat. Drug Code
ProductValidStartDate
ProductValidEndDate
TravelExpenseProductIsObsolete ptrv_product prd_obsolete_flag Obsolete

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_TrvlExpnRcptProductData.
-- 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_TrvlExpnRcptProductData AS
SELECT
  TrvlExpnProduct.pernr AS PersonnelNumber,
  TrvlExpnProduct.reinr AS TravelTripNumber,
  TrvlExpnProduct.perio AS PeriodNumberOfTrip,
  TrvlExpnProduct.pdvrs AS PeriodSequentialNumber,
  TrvlExpnProduct.belnr AS TravelExpenseDocument,
  TrvlExpnProduct.lfdnr AS ParticipantSequenceNumber,
  cast( TrvlExpnProductDetail.product_id as vdm_trvlexpnprodidfr preserving type ) AS TravelExpenseProductIdentifier,
  TrvlExpnProductDetail.product_name AS TravelExpenseProductName,
  TrvlExpnProductDetail.product_cat AS TravelExpenseProductCategory,
  TrvlExpnProductDetail.prd_drug_code AS TravelExpenseProductDrugCode,
  cast( TrvlExpnProductDetail.date_origin as vdm_prodvalidstartdate preserving type ) AS ProductValidStartDate,
  cast( TrvlExpnProductDetail.date_expiration as vdm_prodvalidenddate preserving type ) AS ProductValidEndDate,
  TrvlExpnProductDetail.prd_obsolete_flag AS TravelExpenseProductIsObsolete
FROM ptrv_recproduct AS TrvlExpnProduct
INNER JOIN ptrv_product AS TrvlExpnProductDetail ON /* join condition not captured in parsed metadata */
;

Learn More