I_TrvlExpensePerDiemDeduction

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_TrvlExpensePerDiemDeduction.
-- 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_TrvlExpensePerDiemDeduction AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS SeqReqUUID,
  PerDiemDeductionDate,
  TravelExpnSequentialNumber,
  PerDiemBreakfastIsDeducted,
  PerDiemBreakfastDeductionTime,
  PerDiemLunchIsDeducted,
  PerDiemLunchDeductionTime,
  PerDiemDinnerIsDeducted,
  PerDiemDinnerDeductionTime,
  PerDiemOvernightIsDeducted,
  PerDiemOvernightDeductionTime,
  PerDiemMealCouponIsDeducted,
  PerDiemPaytForBrkfstIsDdctd,
  PerDiemPaytForLunchIsDdctd,
  PerDiemPaytForDinnerIsDdctd,
  PerDiemBreakfastRecordNumber,
  PerDiemLunchRecordNumber,
  PerDiemDinnerRecordNumber,
  cast(0.0000000 as abp_lastchange_tstmpl) AS PerDiemLoclLastChgdDteTme
FROM I_TrvlExpnPerDiemDeductionData
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]
;