I_CAScrtyDepRequestProcess

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_CAScrtyDepRequestProcess.
-- 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_CAScrtyDepRequestProcess AS
SELECT
  ScrtyDepReq.CASecurityDeposit AS CASecurityDeposit,
  ScrtyDepReq.CADocumentNumber AS CADocumentNumber,
  ScrtyDepReq.CASecurityDepositDocument AS CASecurityDepositDocument,
  ScrtyDepReq._SecurityDeposit.CAAuthorizationGroup AS CAAuthorizationGroup,
  ScrtyDepReq.CASecurityDepositDocCategory AS CASecurityDepositDocCategory,
  ScrtyDepReq.CASecurityDepDocCatCriticality AS CASecurityDepDocCatCriticality,
  _CAScrtyDepDocCategoryText[1: Language=$session.system_language].CASecurityDepositDocCatText AS CASecurityDepositDocCatText,
  cast( abs(ScrtyDepReq.CAAmountInTransactionCurrency) as secdep_doc_amt_kk preserving type ) AS CAAmountInTransactionCurrency,
  cast( abs(ScrtyDepReq.CAReleasedAmtInPaymentCurrency) as rel_part_kk preserving type ) AS CAReleasedAmtInPaymentCurrency,
  ScrtyDepReq.TransactionCurrency AS TransactionCurrency,
  ScrtyDepReq.PaymentCurrency AS PaymentCurrency,
  DocHeader.CreatedByUser AS CreatedByUser,
  cast(DocHeader.CreationDate as erdat) AS CreationDate,
  cast(DocHeader.CreationTime as crtime_kk) AS CreationTime,
  ScrtyDepReq._TransactionCurrency AS _TransactionCurrency,
  ScrtyDepReq._PaymentCurrency AS _PaymentCurrency
FROM P_CAScrtyDepReqDocumentAmounts AS ScrtyDepReq
LEFT OUTER JOIN I_CADocumentHeader AS DocHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS User ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CAScrtyDepDocCategoryText AS _CAScrtyDepDocCategoryText ON CASecurityDepositDocCategory = _CAScrtyDepDocCategoryText.CASecurityDepositDocCategory  -- association [1..*]
LEFT OUTER JOIN I_CASecurityDepositMgmtTP AS _CASecurityDepositMgmtTP ON CASecurityDeposit = _CASecurityDepositMgmtTP.CASecurityDeposit  -- association [1]
;