P_CAScrtyDepReqCalculateAmount

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_CAScrtyDepReqCalculateAmount.
-- 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: PCALREQAMT

CREATE VIEW P_CAScrtyDepReqCalculateAmount AS
SELECT
  DocumentAmt.CASecurityDeposit AS CASecurityDeposit,
  DocumentAmt.CADocumentNumber AS CADocumentNumber,
  cast( coalesce(abs(DocumentAmt.CAAmountInTransactionCurrency), 0) as secdep_doc_amt_kk preserving type ) AS CAAmountInTransactionCurrency,
  cast( coalesce(abs(PayTransAmt.CAPaidAmountInTransCurrency), 0) as paid_kk ) AS CAPaidAmountInTransCurrency,
  cast( coalesce(abs(PaidReleasedAmt.CAPaymentAmountInPaytCurrency), 0) as paid_kk ) AS CAPaymentAmountInPaytCurrency,
  cast( coalesce(abs(PaidReleasedAmt.CAReleasedAmtInPaymentCurrency), 0) as rel_part_kk preserving type ) AS CAReleasedAmtInPaymentCurrency,
  cast( coalesce(abs(ReversedAmt.CAReversedAmtInTransCurrency), 0) as secdep_reversed_amt_kk preserving type ) AS CAReversedAmtInTransCurrency,
  cast( coalesce(abs(ReturnAmount.AmountInRefundCurrency), 0) as secdep_return_amt_kk ) AS AmountInRefundCurrency,
  cast( coalesce(abs(InterestAmt.CAInterestAmtInPaymentCurrency), 0) as sec_interest_kk ) AS CAInterestAmtInPaymentCurrency,
  DocumentAmt.TransactionCurrency AS TransactionCurrency,
  PaidReleasedAmt.PaymentCurrency AS PaymentCurrency,
  ReturnAmount.RefundCurrency AS RefundCurrency
FROM P_CAScrtyDepReqCalDocAmt AS DocumentAmt
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _RefundCurrency ON RefundCurrency = _RefundCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [1..1]
;