I_TrvlExpnPerDiemDeductionData

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_TrvlExpnPerDiemDeductionData.
-- 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_TrvlExpnPerDiemDeductionData AS
SELECT
  pernr AS PersonnelNumber,
  reinr AS TravelTripNumber,
  hdvrs AS TravelExpnSequentialNumber,
  ded_date AS PerDiemDeductionDate,
  cast ( break_de as vdm_break_de preserving type ) AS PerDiemBreakfastIsDeducted,
  cast ( break_de_time as vdm_break_de_time preserving type ) AS PerDiemBreakfastDeductionTime,
  cast ( lunch_de as vdm_lunch_de preserving type ) AS PerDiemLunchIsDeducted,
  cast ( lunch_de_time as vdm_lunch_de_time preserving type ) AS PerDiemLunchDeductionTime,
  cast ( dinne_de as vdm_dinner_de preserving type ) AS PerDiemDinnerIsDeducted,
  cast ( dinne_de_time as vdm_dinne_de_time preserving type ) AS PerDiemDinnerDeductionTime,
  cast ( night_de as vdm_night_de preserving type ) AS PerDiemOvernightIsDeducted,
  cast ( night_de_time as vdm_night_de_time preserving type ) AS PerDiemOvernightDeductionTime,
  cast ( lu_coupn as vdm_lu_coupon preserving type ) AS PerDiemMealCouponIsDeducted,
  cast ( break_pik as vdm_break_pik preserving type ) AS PerDiemPaytForBrkfstIsDdctd,
  cast ( lunch_pik as vdm_lunch_pik preserving type ) AS PerDiemPaytForLunchIsDdctd,
  cast ( dinne_pik as vdm_dinne_pik preserving type ) AS PerDiemPaytForDinnerIsDdctd,
  brft_rec_no AS PerDiemBreakfastRecordNumber,
  lnch_rec_no AS PerDiemLunchRecordNumber,
  dinn_rec_no AS PerDiemDinnerRecordNumber
FROM trvs4_perdiem
LEFT OUTER JOIN E_TrvlExpnPerDiemDeductionData AS _ExtensionPerDiem ON PersonnelNumber = _ExtensionPerDiem.PersonnelNumber AND TravelTripNumber = _ExtensionPerDiem.TravelTripNumber AND TravelExpnSequentialNumber = _ExtensionPerDiem.TravelExpnSequentialNumber AND PerDiemDeductionDate = _ExtensionPerDiem.PerDiemDeductionDate  -- association [0..1]
;