R_TravelExpenseAdvanceDraft

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 R_TravelExpenseAdvanceDraft.
-- 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 R_TravelExpenseAdvanceDraft AS
SELECT
  AdvanceDraft.personnelnumber AS PersonnelNumber,
  AdvanceDraft.traveltripnumber AS TravelTripNumber,
  AdvanceDraft.travelrequuid AS TravelReqUUID,
  AdvanceDraft.seqrequuid AS SeqReqUUID,
  AdvanceDraft.travelrequestsequencenumber AS TravelRequestSequenceNumber,
  AdvanceDraft.travelexpnsequentialnumber AS TravelExpnSequentialNumber,
  AdvanceDraft.advanceisdisplayonly AS AdvanceIsDisplayOnly,
  AdvanceDraft.trvladvncamtinadvnccrcy AS TrvlAdvncAmtInAdvncCrcy,
  AdvanceDraft.advancecurrency AS AdvanceCurrency,
  AdvanceDraft.travelrequestexchangerate AS TravelRequestExchangeRate,
  AdvanceDraft.currencyunitfromratio AS CurrencyUnitFromRatio,
  AdvanceDraft.currencyunittoratio AS CurrencyUnitToRatio,
  AdvanceDraft.paymentamount AS PaymentAmount,
  AdvanceDraft.paymentcurrency AS PaymentCurrency,
  AdvanceDraft.advanceisincash AS AdvanceIsInCash,
  AdvanceDraft.paymentdate AS PaymentDate,
  AdvanceDraft.advancecurrencyname AS AdvanceCurrencyName,
  AdvanceDraft.paymentcurrencyname AS PaymentCurrencyName,
  AdvanceDraft.lastchangedatetime AS LastChangeDateTime,
  AdvanceDraft.advnclocllastchgddtetme AS AdvncLoclLastChgdDteTme,
  AdvanceDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  AdvanceDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  AdvanceDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  AdvanceDraft.draftentityoperationcode AS DraftEntityOperationCode,
  AdvanceDraft.hasactiveentity AS HasActiveEntity
FROM trvs4_e_adv_d AS AdvanceDraft
LEFT OUTER JOIN E_TravelExpenseAdvanceDraft AS _ExtensionAdvance ON PersonnelNumber = _ExtensionAdvance.PersonnelNumber AND TravelTripNumber = _ExtensionAdvance.TravelTripNumber AND TravelReqUUID = _ExtensionAdvance.TravelReqUUID AND SeqReqUUID = _ExtensionAdvance.SeqReqUUID AND TravelRequestSequenceNumber = _ExtensionAdvance.TravelRequestSequenceNumber  -- association [1..1]
;