What is I_CashBankContactPerson in SAP S/4HANA?

I_CashBankContactPerson is a composite CDS view in SAP S/4HANA. Cash Bank Contact Person It contains 39 fields.

Which tables does I_CashBankContactPerson read from?

I_CashBankContactPerson reads data from: I_RiskBusinessPartner.

What VDM layer is I_CashBankContactPerson?

I_CashBankContactPerson is classified as a Composite view that combines data from multiple basic views.

I_CashBankContactPerson

DDL: I_CASHBANKCONTACTPERSON Type: view_entity COMPOSITE Package: FCLM_MANAGEBANKS

39 Fields 1 Data Sources 5 Associations

Cash Bank Contact Person

I_CashBankContactPerson is a Composite CDS View that provides data about "Cash Bank Contact Person" in SAP S/4HANA. It reads from 1 data source (I_RiskBusinessPartner) and exposes 39 fields with key fields BusinessPartner, BankContactPerson, RelationshipNumber, BankCountry, BankInternalID. It has 5 associations to related views. Part of development package FCLM_MANAGEBANKS.

Data Sources (1)

Source	Alias	Join Type
I_RiskBusinessPartner	RiskPartner	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	I_BPContactToFuncAndDept	_HasContactPerson	`_HasContactPerson.BusinessPartnerCompany = RiskPartner.BusinessPartnerNumber`
[0..1]	I_Bank_2	_Bank	`$projection.BankCountry = _Bank.BankCountry and $projection.BankInternalID = _Bank.BankInternalID`
[0..1]	I_CountryText	_CountryText	`$projection.BankCountry = _CountryText.Country and _CountryText.Language = $session.system_language`
[0..1]	I_CountryText	_AddressCountryText	`$projection.AddressCountry = _AddressCountryText.Country and _AddressCountryText.Language = $session.system_language`
[0..1]	I_BusinessPartnerRoleText	_BusinessPartnerRoleText	`$projection.BusinessPartnerRole = _BusinessPartnerRoleText.BusinessPartnerRole and _BusinessPartnerRoleText.Language = $session.system_language`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Cash Bank Contact Person	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view

Fields (39)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	I_RiskBusinessPartner	BusinessPartnerNumber	With Partner
KEY	BankContactPerson	_HasContactPerson	BusinessPartnerPerson	Busn. Partner
KEY	RelationshipNumber	_HasContactPerson	RelationshipNumber	BP Rel. Number
KEY	BankCountry	I_RiskBusinessPartner	BankCountry	Bank Ctry/Rgn. Key
KEY	BankInternalID	I_RiskBusinessPartner	BankInternalID	Bank Key
	IsBusinessPurposeCompleted
	BankName	_Bank	BankName	Bank Name
	BankCountryName	_CountryText	CountryName	Country
	AddressID
	FormOfAddress
	FirstName
	LastName
	BirthDate
	BPContactPersonFunction	_HasContactPerson	BPContactPersonFunction
	ContactPersonDepartment	_HasContactPerson	ContactPersonDepartment	Department
	BusinessPartnerRole
	BusinessPartnerRoleShortName
	PersonNumber
	PhoneNumber
	MobileNumber
	FaxAreaCodeSubscriberNumber
	EmailAddress
	AddressCountry
	Region
	StreetName
	HouseNumber
	CityName
	PostalCode
	Building
	Floor
	RoomNumber
	ContactPersonFunctionName
	ContactPersonDepartmentName
	BusinessPartnerFullName
	BankContactPersonName
	CntctPersnIsBusPrpsCompleted
	_AddressCountryText		_AddressCountryText
	_BusinessPartnerRoleText		_BusinessPartnerRoleText
	_Bank		_Bank

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_CashBankContactPerson.
-- 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_CashBankContactPerson AS
SELECT
  RiskPartner.BusinessPartnerNumber AS BusinessPartner,
  _HasContactPerson.BusinessPartnerPerson AS BankContactPerson,
  _HasContactPerson.RelationshipNumber AS RelationshipNumber,
  RiskPartner.BankCountry AS BankCountry,
  RiskPartner.BankInternalID AS BankInternalID,
  RiskPartner._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Bank.BankName AS BankName,
  _CountryText.CountryName AS BankCountryName,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress.AddressID AS AddressID,
  _HasContactPerson._BusinessPartnerPerson.FormOfAddress AS FormOfAddress,
  _HasContactPerson._BusinessPartnerPerson.FirstName AS FirstName,
  _HasContactPerson._BusinessPartnerPerson.LastName AS LastName,
  _HasContactPerson._BusinessPartnerPerson.BirthDate AS BirthDate,
  _HasContactPerson.BPContactPersonFunction AS BPContactPersonFunction,
  _HasContactPerson.ContactPersonDepartment AS ContactPersonDepartment,
  _HasContactPerson._BusinessPartnerPerson._BusinessPartnerRole[1:BusinessPartnerRole = 'BUP001'].BusinessPartnerRole AS BusinessPartnerRole,
  _HasContactPerson._BusinessPartnerPerson._BusinessPartnerRole[1:BusinessPartnerRole = 'BUP001']._BusinessPartnerRole._BusinessPartnerRoleText[1:Language = $session.system_language].BusinessPartnerRoleShortName AS BusinessPartnerRoleShortName,
  _HasContactPerson._BPContact._BusinessPartnerPerson.PersonNumber AS PersonNumber,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobileNumber,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS AddressCountry,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.Region AS Region,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS StreetName,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS CityName,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.Building AS Building,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.Floor AS Floor,
  _HasContactPerson._BPContact._BusinessPartnerPerson._CurrentDefaultAddress._AddressDefaultRepresentation.RoomNumber AS RoomNumber,
  _HasContactPerson._ContactPersonFunctionText[1:Language = $session.system_language].ContactPersonFunctionName AS ContactPersonFunctionName,
  _HasContactPerson._ContactPersonDepartmentText[1:Language = $session.system_language].ContactPersonDepartmentName AS ContactPersonDepartmentName,
  _HasContactPerson._BusinessPartnerCompany.BusinessPartnerFullName AS BusinessPartnerFullName,
  _HasContactPerson._BusinessPartnerPerson.BusinessPartnerFullName AS BankContactPersonName,
  _HasContactPerson._BusinessPartnerPerson.IsBusinessPurposeCompleted AS CntctPersnIsBusPrpsCompleted
FROM I_RiskBusinessPartner AS RiskPartner
LEFT OUTER JOIN I_BPContactToFuncAndDept AS _HasContactPerson ON _HasContactPerson.BusinessPartnerCompany = RiskPartner.BusinessPartnerNumber  -- association [1..1]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND BankInternalID = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON BankCountry = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _AddressCountryText ON AddressCountry = _AddressCountryText.Country AND _AddressCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRoleText AS _BusinessPartnerRoleText ON BusinessPartnerRole = _BusinessPartnerRoleText.BusinessPartnerRole AND _BusinessPartnerRoleText.Language = $session.system_language  -- association [0..1]
;

Depth:

I_CashBankContactPerson view_entity

I_RiskBusinessPartner view

C_CashBankContactPerson view_entity
C_CashBankContactPersonVH view_entity