I_CACashSecurityDepositRequest

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_CACashSecurityDepositRequest.
-- 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: ICASCRTYDEPREQ

CREATE VIEW I_CACashSecurityDepositRequest AS
SELECT
  security AS CASecurityDeposit,
  cast(opbel as opbel_gfn_kk preserving type ) AS CADocumentNumber,
  cast(reason as secdep_doc_request_reason_kk preserving type ) AS CASecurityDepositRequestReason,
  sec_start AS CASecurityDepositStartDate,
  sec_return AS CASecurityDepositReturnDate,
  rev_reason AS CASecurityDepositReversalRsn,
  nrzas AS CAPaymentFormNumber,
  cast (objtype as swo_objtyp preserving type ) AS BusinessObjectType
FROM fkk_sec_req
LEFT OUTER JOIN I_CASecurityDeposit AS _SecurityDeposit ON CASecurityDeposit = _SecurityDeposit.CASecurityDeposit  -- association [1..1]
LEFT OUTER JOIN I_CADocument AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CASecurityDepositReqRsn AS _CASecurityDepositRequestRsn ON CASecurityDepositRequestReason = _CASecurityDepositRequestRsn.CASecurityDepositRequestReason  -- association [1..1]
LEFT OUTER JOIN I_CASecurityDepositReversalRsn AS _CASecurityDepositReversalRsn ON CASecurityDepositReversalRsn = _CASecurityDepositReversalRsn.CASecurityDepositReversalRsn  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _BusinessObjType ON BusinessObjectType = _BusinessObjType.BusinessObjectType  -- association [1..1]
;