I_DataExchangeInstructionKeys

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_DataExchangeInstructionKeys.
-- 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.
-- SQL view name: IINSTRNKEYS

CREATE VIEW I_DataExchangeInstructionKeys AS
SELECT
  cast(banks as bank1) AS BankCountryKey,
  cast(zlsch as farp_schzw_bseg) AS PaymentMethod,
  cast(dtaws as farp_dtaws) AS DataExchangeInstructionKey,
  cast(dtws1 as farp_dtat16) AS DataExchangeInstruction1,
  cast(dtws2 as farp_dtat17) AS DataExchangeInstruction2,
  cast(dtws3 as farp_dtat18) AS DataExchangeInstruction3,
  cast(dtws4 as farp_dtat19) AS DataExchangeInstruction4,
  cast(dtzus as farp_dtat20) AS DataExchangeInstrnAddlInfo,
  cast(dtkvs as farp_dtat21) AS DataExchangeCostAllocation,
  cast(dtkza as farp_dtat22) AS DataExchangePaymentType,
  cast(ediza as farp_paiart) AS PaytInstructionPaymentMethod,
  cast(edime as farp_paimed) AS PaymentOrderTransmissionMedium,
  cast(dtwsc as farp_dtwsc) AS DataExchInstrnApplicationArea,
  dturg AS IsUrgentPayment
FROM t015w
LEFT OUTER JOIN I_DataExchInstructionKeysText AS _Text ON _Text.BankCountryKey = BankCountryKey AND _Text.PaymentMethod = PaymentMethod AND _Text.DataExchangeInstructionKey = DataExchangeInstructionKey  -- association [1..*]
;