I_CASecurityDepositMgmt

DDL: I_CASECURITYDEPOSITMGMT Type: view_entity COMPOSITE
46 Fields 2 Data Sources 4 Associations

Security Deposit Management

I_CASecurityDepositMgmt is a Composite CDS View that provides data about "Security Deposit Management" in SAP S/4HANA. It reads from 2 data sources (I_CASecurityDeposit, P_CAScrtyDepCalculateAmount) and exposes 46 fields with key field CASecurityDeposit. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CASecurityDeposit SecurityDeposit from
P_CAScrtyDepCalculateAmount SecurityDepositAmount left_outer

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_CASecurityDepositContract _SecurityDepositContract $projection.CASecurityDeposit = _SecurityDepositContract.CASecurityDeposit
[1..1] I_CASecurityDepositReqRsnText _CASecurityDepositReqRsnText $projection.CASecurityDepositRequestReason = _CASecurityDepositReqRsnText.CASecurityDepositRequestReason and _CASecurityDepositReqRsnText.Language = $session.system_language
[1..1] I_CASecurityDepositRvslRsnText _CASecurityDepositRvslRsnText $projection.CASecurityDepositReversalRsn = _CASecurityDepositRvslRsnText.CASecurityDepositReversalRsn and _CASecurityDepositRvslRsnText.Language = $session.system_language
[1..*] I_CASecurityDepositReqDoc _CASecurityDepositReqDoc

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Security Deposit Management view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY CASecurityDeposit I_CASecurityDeposit CASecurityDeposit XSRF
ContractAccount I_CASecurityDeposit ContractAccount Contract Acct
BusinessPartner I_CASecurityDeposit BusinessPartner Issuing Authority
BusinessPartnerFullName
AddressID
CAContract _SecurityDepositContract CAContract Contract
CASubApplication _SecurityDepositContract CASubApplication Subapplication
CAApplicationArea I_CASecurityDeposit CAApplicationArea ApplicationArea
CASecurityDepositIsReversed I_CASecurityDeposit CASecurityDepositIsReversed Reversed
CASecurityDepositReversalRsn I_CASecurityDeposit CASecurityDepositReversalRsn Reversal Reason
CASecurityDepositRequestReason I_CASecurityDeposit CASecurityDepositRequestReason Sp.Tax Code Reason
CASecurityDepositExtReference I_CASecurityDeposit CASecurityDepositExtReference Ext. Reference
CASecurityDepositStartDate I_CASecurityDeposit CASecurityDepositStartDate Start Date
CASecurityDepositReturnDate I_CASecurityDeposit CASecurityDepositReturnDate Return Date
TransactionCurrency P_CAScrtyDepCalculateAmount TransactionCurrency Transaction Currency
PaymentCurrency P_CAScrtyDepCalculateAmount PaymentCurrency Payment Currency
RefundCurrency P_CAScrtyDepCalculateAmount RefundCurrency
CASecurityDepositRequestAmount
CAReleasedAmtInPaymentCurrency P_CAScrtyDepCalculateAmount CAReleasedAmtInPaymentCurrency
CAPaymentAmountInPaytCurrency P_CAScrtyDepCalculateAmount CAPaymentAmountInPaytCurrency
AmountInRefundCurrency P_CAScrtyDepCalculateAmount AmountInRefundCurrency
CAReversedAmtInTransCurrency P_CAScrtyDepCalculateAmount CAReversedAmtInTransCurrency
CAInterestAmtInPaymentCurrency P_CAScrtyDepCalculateAmount CAInterestAmtInPaymentCurrency
CAPaymentFormNumber I_CASecurityDeposit CAPaymentFormNumber Payment Form
CAAuthorizationGroup I_CASecurityDeposit CAAuthorizationGroup AuthorizGroup
CAInterestCode I_CASecurityDeposit CAInterestCode Interest key
CASecurityDepositIsReleased I_CASecurityDeposit CASecurityDepositIsReleased Released
CompanyCode I_CASecurityDeposit CompanyCode Receiver Company Code
CreationDate I_CASecurityDeposit CreationDate Time Stamp
CreatedByUser I_CASecurityDeposit CreatedByUser User Name
LastChangedDate I_CASecurityDeposit LastChangedDate Created On
LastChangedByUser I_CASecurityDeposit LastChangedByUser User Name
CAScrtyDepCreationDteTme _CASecurityDepositOpTime CAScrtyDepCreationDteTme
CAScrtyDepLastChangeDteTme _CASecurityDepositOpTime CAScrtyDepLastChangeDteTme
_ContractAccountHeader I_CASecurityDeposit _ContractAccountHeader
_ContractAccountPartner I_CASecurityDeposit _ContractAccountPartner
_BusinessPartner I_CASecurityDeposit _BusinessPartner
_CASecurityDepositReqDoc _CASecurityDepositReqDoc
_CASecurityDepositReqRsnText _CASecurityDepositReqRsnText
_CASecurityDepositRvslRsnText _CASecurityDepositRvslRsnText
_TransactionCurrency P_CAScrtyDepCalculateAmount _TransactionCurrency
_PaymentCurrency P_CAScrtyDepCalculateAmount _PaymentCurrency
_RefundCurrency P_CAScrtyDepCalculateAmount _RefundCurrency
_InterestCode I_CASecurityDeposit _InterestCode
_CASecurityDepositRequestRsn I_CASecurityDeposit _CASecurityDepositRequestRsn
_CASecurityDepositReversalRsn I_CASecurityDeposit _CASecurityDepositReversalRsn

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_CASecurityDepositMgmt.
-- 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_CASecurityDepositMgmt AS
SELECT
  SecurityDeposit.CASecurityDeposit AS CASecurityDeposit,
  SecurityDeposit.ContractAccount AS ContractAccount,
  SecurityDeposit.BusinessPartner AS BusinessPartner,
  cast(SecurityDeposit._BusinessPartner.BusinessPartnerFullName as char0128) AS BusinessPartnerFullName,
  SecurityDeposit._BusinessPartner._CurrentDefaultAddress.AddressID AS AddressID,
  _SecurityDepositContract.CAContract AS CAContract,
  _SecurityDepositContract.CASubApplication AS CASubApplication,
  SecurityDeposit.CAApplicationArea AS CAApplicationArea,
  SecurityDeposit.CASecurityDepositIsReversed AS CASecurityDepositIsReversed,
  SecurityDeposit.CASecurityDepositReversalRsn AS CASecurityDepositReversalRsn,
  SecurityDeposit.CASecurityDepositRequestReason AS CASecurityDepositRequestReason,
  SecurityDeposit.CASecurityDepositExtReference AS CASecurityDepositExtReference,
  SecurityDeposit.CASecurityDepositStartDate AS CASecurityDepositStartDate,
  SecurityDeposit.CASecurityDepositReturnDate AS CASecurityDepositReturnDate,
  SecurityDepositAmount.TransactionCurrency AS TransactionCurrency,
  SecurityDepositAmount.PaymentCurrency AS PaymentCurrency,
  SecurityDepositAmount.RefundCurrency AS RefundCurrency,
  cast((SecurityDepositAmount.CAAmountInTransactionCurrency - SecurityDepositAmount.CAReversedAmtInTransCurrency) as request_kk) AS CASecurityDepositRequestAmount,
  SecurityDepositAmount.CAReleasedAmtInPaymentCurrency AS CAReleasedAmtInPaymentCurrency,
  SecurityDepositAmount.CAPaymentAmountInPaytCurrency AS CAPaymentAmountInPaytCurrency,
  SecurityDepositAmount.AmountInRefundCurrency AS AmountInRefundCurrency,
  SecurityDepositAmount.CAReversedAmtInTransCurrency AS CAReversedAmtInTransCurrency,
  SecurityDepositAmount.CAInterestAmtInPaymentCurrency AS CAInterestAmtInPaymentCurrency,
  SecurityDeposit.CAPaymentFormNumber AS CAPaymentFormNumber,
  SecurityDeposit.CAAuthorizationGroup AS CAAuthorizationGroup,
  SecurityDeposit.CAInterestCode AS CAInterestCode,
  SecurityDeposit.CASecurityDepositIsReleased AS CASecurityDepositIsReleased,
  SecurityDeposit.CompanyCode AS CompanyCode,
  SecurityDeposit.CreationDate AS CreationDate,
  SecurityDeposit.CreatedByUser AS CreatedByUser,
  SecurityDeposit.LastChangedDate AS LastChangedDate,
  SecurityDeposit.LastChangedByUser AS LastChangedByUser,
  _CASecurityDepositOpTime.CAScrtyDepCreationDteTme AS CAScrtyDepCreationDteTme,
  _CASecurityDepositOpTime.CAScrtyDepLastChangeDteTme AS CAScrtyDepLastChangeDteTme,
  SecurityDeposit._ContractAccountHeader AS _ContractAccountHeader,
  SecurityDeposit._ContractAccountPartner AS _ContractAccountPartner,
  SecurityDeposit._BusinessPartner AS _BusinessPartner,
  SecurityDepositAmount._TransactionCurrency AS _TransactionCurrency,
  SecurityDepositAmount._PaymentCurrency AS _PaymentCurrency,
  SecurityDepositAmount._RefundCurrency AS _RefundCurrency,
  SecurityDeposit._InterestCode AS _InterestCode,
  SecurityDeposit._CASecurityDepositRequestRsn AS _CASecurityDepositRequestRsn,
  SecurityDeposit._CASecurityDepositReversalRsn AS _CASecurityDepositReversalRsn
FROM I_CASecurityDeposit AS SecurityDeposit
LEFT OUTER JOIN P_CAScrtyDepCalculateAmount AS SecurityDepositAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CASecurityDepositContract AS _SecurityDepositContract ON CASecurityDeposit = _SecurityDepositContract.CASecurityDeposit  -- 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_CASecurityDepositRvslRsnText AS _CASecurityDepositRvslRsnText ON CASecurityDepositReversalRsn = _CASecurityDepositRvslRsnText.CASecurityDepositReversalRsn AND _CASecurityDepositRvslRsnText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CASecurityDepositReqDoc AS _CASecurityDepositReqDoc ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More