I_TravelAdvancesData

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_TravelAdvancesData.
-- 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_TravelAdvancesData AS
SELECT
  pernr AS PersonnelNumber,
  reinr AS TravelTripNumber,
  hdvrs AS TravelExpnSequentialNumber,
  adv_number AS TravelRequestSequenceNumber,
  display_only AS AdvanceIsDisplayOnly,
  cast ( adv_amount as vdm_advamt preserving type) AS TrvlAdvncAmtInAdvncCrcy,
  cast ( adv_curr as vdm_advcrcy preserving type ) AS AdvanceCurrency,
  cast ( exch_rate as vdm_ukurs_curr preserving type ) AS TravelRequestExchangeRate,
  s_factor AS CurrencyUnitFromRatio,
  t_factor AS CurrencyUnitToRatio,
  cast ( pay_amount as vdm_pay_amount preserving type ) AS PaymentAmount,
  pay_curr AS PaymentCurrency,
  cast ( cash as vdm_cash preserving type ) AS AdvanceIsInCash,
  pay_date AS PaymentDate,
  adv_curr_name AS AdvanceCurrencyName,
  pay_curr_name AS PaymentCurrencyName
FROM trvs4_advance
LEFT OUTER JOIN E_TravelAdvancesData AS _ExtensionAdvance ON PersonnelNumber = _ExtensionAdvance.PersonnelNumber AND TravelTripNumber = _ExtensionAdvance.TravelTripNumber AND TravelExpnSequentialNumber = _ExtensionAdvance.TravelExpnSequentialNumber AND TravelRequestSequenceNumber = _ExtensionAdvance.TravelRequestSequenceNumber  -- association [0..1]
;