I_CASecurityDepositReqDoc

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_CASecurityDepositReqDoc.
-- 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_CASecurityDepositReqDoc AS
SELECT
  RequestDoc.CASecurityDeposit AS CASecurityDeposit,
  RequestDoc.CADocumentNumber AS CADocumentNumber,
  RequestDoc._SecurityDeposit.CAAuthorizationGroup AS CAAuthorizationGroup,
  RequestDocStatus.CASecDepDocBPItemStatus AS CASecDepDocBPItemStatus,
  _CAScrtyDepDocBPItemStatusT.CAScrtyDepDocBPItemStatusText AS CASecDepDocBPItemStatusText,
  RequestDoc.CASecurityDepositRequestReason AS CASecurityDepositRequestReason,
  _CASecurityDepositReqRsnText.CASecurityDepositReqReasonText AS CASecurityDepositReqReasonText,
  RequestAmt.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  RequestAmt.AmountInRefundCurrency AS AmountInRefundCurrency,
  RequestAmt.CAPaymentAmountInPaytCurrency AS CAPaymentAmountInPaytCurrency,
  RequestAmt.CAReleasedAmtInPaymentCurrency AS CAReleasedAmtInPaymentCurrency,
  RequestAmt.CAReversedAmtInTransCurrency AS CAReversedAmtInTransCurrency,
  RequestAmt.CAInterestAmtInPaymentCurrency AS CAInterestAmtInPaymentCurrency,
  cast((RequestAmt.CAAmountInTransactionCurrency - RequestAmt.CAReversedAmtInTransCurrency) as request_kk) AS CAScrtyDepReqDocRequestAmount,
  RequestAmt.TransactionCurrency AS TransactionCurrency,
  RequestAmt.PaymentCurrency AS PaymentCurrency,
  RequestAmt.RefundCurrency AS RefundCurrency,
  DocHeader.CreatedByUser AS CreatedByUser,
  cast(DocHeader.CreationDate as erdat) AS CreationDate,
  cast(DocHeader.CreationTime as crtime_kk) AS CreationTime,
  DocHeader.CAPostingDate AS CAPostingDate,
  RequestAmt._TransactionCurrency AS _TransactionCurrency,
  RequestAmt._RefundCurrency AS _RefundCurrency,
  RequestAmt._PaymentCurrency AS _PaymentCurrency
LEFT OUTER JOIN P_CACalculateSecDepReqStatus AS RequestDocStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CAScrtyDepReqCalculateAmount AS RequestAmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CADocumentHeader AS DocHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CAScrtyDepDocumentFlow AS _CAScrtyDepDocumentFlow ON CASecurityDeposit = _CAScrtyDepDocumentFlow.CASecurityDeposit AND CADocumentNumber = _CAScrtyDepDocumentFlow.CADocumentNumber  -- association [1..*]
LEFT OUTER JOIN I_CASecurityDepositReqRsnText AS _CASecurityDepositReqRsnText ON CASecurityDepositRequestReason = _CASecurityDepositReqRsnText.CASecurityDepositRequestReason AND _CASecurityDepositReqRsnText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CAScrtyDepDocBPItemStatusT AS _CAScrtyDepDocBPItemStatusT ON CASecDepDocBPItemStatus = _CAScrtyDepDocBPItemStatusT.CAScrtyDepDocBPItemStatus AND _CAScrtyDepDocBPItemStatusT.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
;