I_CASecurityDepositHeader

DDL: I_CASECURITYDEPOSITHEADER SQL: ICASECDEPTHEADER Type: view COMPOSITE
14 Fields 2 Data Sources

OM - Security Deposit Header

I_CASecurityDepositHeader is a Composite CDS View that provides data about "OM - Security Deposit Header" in SAP S/4HANA. It reads from 2 data sources (I_CASecurityDeposit, I_CASecurityDepositContract) and exposes 14 fields with key fields CASecurityDeposit, BusinessPartner, CACorrespondence, CACorrespondenceType.

Data Sources (2)

SourceAliasJoin Type
I_CASecurityDeposit SecurityDeposit from
I_CASecurityDepositContract SecurityDepositContract inner

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICASECDEPTHEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label OM - Security Deposit Header view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CASecurityDeposit I_CASecurityDeposit CASecurityDeposit XSRF
KEY BusinessPartner _ContractAccountPartner BusinessPartner Issuing Authority
KEY CACorrespondence Correspndc CACorrespondence
KEY CACorrespondenceType Correspndc CACorrespondenceType Corresp. Type
ContractAccountName
ContractAccount I_CASecurityDeposit ContractAccount Contract Acct
CAContract I_CASecurityDepositContract CAContract Contract
CAAuthorizationGroup _ContractAccountPartner CAAuthorizationGroup AuthorizGroup
CorrespondenceIssueDate Correspndc CorrespondenceIssueDate
CompanyCode Correspndc CompanyCode Receiver Company Code
Language Correspndc Language Report Text Language
BusinessPartnerFullName
CityName1assecdep_home_town_kkasHomeTown
_BusinessPartner _ContractAccountPartner _BusinessPartner

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_CASecurityDepositHeader.
-- 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: ICASECDEPTHEADER
-- Parameters: P_Language : sylangu

CREATE VIEW I_CASecurityDepositHeader AS
SELECT
  SecurityDeposit.CASecurityDeposit AS CASecurityDeposit,
  _ContractAccountPartner.BusinessPartner AS BusinessPartner,
  Correspndc.CACorrespondence AS CACorrespondence,
  Correspndc.CACorrespondenceType AS CACorrespondenceType,
  Correspndc._ContrAcc.ContractAccountName AS ContractAccountName,
  SecurityDeposit.ContractAccount AS ContractAccount,
  SecurityDepositContract.CAContract AS CAContract,
  _ContractAccountPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  Correspndc.CorrespondenceIssueDate AS CorrespondenceIssueDate,
  Correspndc.CompanyCode AS CompanyCode,
  Correspndc.Language AS Language,
  cast( _ContractAccountPartner._BusinessPartner.BusinessPartnerFullName as char128 ) AS BusinessPartnerFullName,
  cast(concat_with_space( _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _ContractAccountPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1) as secdep_home_town_kk) as HomeTown AS CityName1assecdep_home_town_kkasHomeTown,
  _ContractAccountPartner._BusinessPartner AS _BusinessPartner
FROM I_CASecurityDeposit AS SecurityDeposit
INNER JOIN I_CASecurityDepositContract AS SecurityDepositContract ON /* join condition not captured in parsed metadata */
;

Learn More