P_IL_IntradayCashTransfer01

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 P_IL_IntradayCashTransfer01.
-- 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.
-- Parameters: P_Date : datum, P_IL_CashNumberKey : gsfincsil_csnum, P_Currency : waers

CREATE VIEW P_IL_IntradayCashTransfer01 AS
SELECT
  cast('CashActivity' as gsfincsil_pmt_id ) AS IL_IdentifierCashPaymentItem,
  cast( min( Item.EntryTimestamp ) as timestampl preserving type ) AS EntryTimestamp,
  min( Item.IL_CashNumberKey ) AS IL_CashNumberKey,
  cast( 'CS' as gsfincsil_pmt ) AS IL_PaymentMethod,
  min( PaymentMethod ) AS PaymentMethod,
  -1 * sum( IL_PaytItmAmountInDocCrcy ) AS IL_PaytItmAmountInDocCrcy,
  Item.TransactionCurrency AS TransactionCurrency,
  min( Item.IL_PaymentStatus ) AS IL_PaymentStatus,
  Item.RefAccountingDocument AS RefAccountingDocument,
  Item.ReferenceCompanyCode AS ReferenceCompanyCode,
  Item.ReferenceFiscalYear AS ReferenceFiscalYear,
  min( Item.LastChangeDate ) AS LastChangeDate,
  min( Item.LastChangeTime ) AS LastChangeTime,
  min( Item.LastChangeByUser ) AS LastChangeByUser
FROM I_IL_PaymentItemLog AS Item
;