R_CASecurityDepositTP

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 R_CASecurityDepositTP.
-- 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 R_CASecurityDepositTP AS
SELECT
  CASecurityDeposit,
  CAAuthorizationGroup,
  CASecurityDepositRequestReason,
  _CASecurityDepositReqRsnText.CASecurityDepositReqReasonText AS CASecurityDepositReqReasonText,
  _ContractAccountPartner.BusinessPartner AS BusinessPartner,
  cast( _ContractAccountPartner._BusinessPartner.BusinessPartnerFullName as char0128) AS BusinessPartnerFullName,
  _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS StreetName,
  _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS HomeTown,
  _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  _ContractAccountPartner._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  CAContract,
  CASubApplication,
  CASecurityDepositIsReversed,
  CASecurityDepositReversalRsn,
  _CASecurityDepositRvslRsnText.CASecurityDepositRvslRsnText AS CASecurityDepositRvslRsnText,
  CASecurityDepositExtReference,
  CASecurityDepositStartDate,
  CASecurityDepositReturnDate,
  TransactionCurrency,
  PaymentCurrency,
  RefundCurrency,
  CASecurityDepositRequestAmount,
  CAReleasedAmtInPaymentCurrency,
  CAPaymentAmountInPaytCurrency,
  AmountInRefundCurrency,
  CAReversedAmtInTransCurrency,
  CAInterestCode,
  _InterestCode._Text[1: Language=$session.system_language].CAInterestCodeName AS CAInterestCodeName,
  CASecurityDepositIsReleased,
  CreationDate,
  CAScrtyDepCreationDteTme,
  CreatedByUser,
  CreatedByUserDescription,
  LastChangedDate,
  CAScrtyDepLastChangeDteTme,
  LastChangedByUser,
  LastChangedByUserDescription
FROM I_CASecurityDepositMgmt
LEFT OUTER JOIN R_CAScrtyDepRequestDetailTP AS _CAScrtyDepRequestDetail ON /* condition not available in parsed metadata */  -- association [1..*]
;