What is I_DCBBusinessPartnerWithRole in SAP S/4HANA?

I_DCBBusinessPartnerWithRole is a composite CDS view in SAP S/4HANA. Business Partner With Role It contains 70 fields.

Which tables does I_DCBBusinessPartnerWithRole read from?

I_DCBBusinessPartnerWithRole reads data from: I_DCBBusinessPartner, I_BusinessPartner_to_BP_Role, I_DCBBusinessPartnerRole.

What VDM layer is I_DCBBusinessPartnerWithRole?

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

I_DCBBusinessPartnerWithRole

DDL: I_DCBBUSINESSPARTNERWITHROLE SQL: IDCBBPWROLE Type: view COMPOSITE

70 Fields 3 Data Sources

Business Partner With Role

I_DCBBusinessPartnerWithRole is a Composite CDS View that provides data about "Business Partner With Role" in SAP S/4HANA. It reads from 3 data sources (I_DCBBusinessPartner, I_BusinessPartner_to_BP_Role, I_DCBBusinessPartnerRole) and exposes 70 fields with key fields DCBBusinessPartnerRole, BusinessPartner.

Data Sources (3)

Source	Alias	Join Type
I_DCBBusinessPartner	_BusinessPartner	inner
I_BusinessPartner_to_BP_Role	_BusinessPartnerRoleExt	inner
I_DCBBusinessPartnerRole	_DealBusinessPartnerRole	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	IDCBBPWROLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Business Partner With Role	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#XL	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#COMPOSITE	view

Fields (70)

Key	Field	Source Table	Source Field	Description
KEY	DCBBusinessPartnerRole	I_DCBBusinessPartnerRole	DCBBusinessPartnerRole	Deal capture field
KEY	BusinessPartner	I_DCBBusinessPartner	BusinessPartner	Issuing Authority
	BusinessPartnerCategory	I_DCBBusinessPartner	BusinessPartnerCategory	Partner Cat.
	AuthorizationGroup	I_DCBBusinessPartner	AuthorizationGroup	AuthorizGroup
	BusinessPartnerUUID	I_DCBBusinessPartner	BusinessPartnerUUID	UUID
	PersonNumber	I_DCBBusinessPartner	PersonNumber	Person Number
	BusinessPartnerName	I_DCBBusinessPartner	BusinessPartnerName	Extracted Customer Name
	BusinessPartnerFullName	I_DCBBusinessPartner	BusinessPartnerFullName	Broker Name
	CreatedByUser	I_DCBBusinessPartner	CreatedByUser	User Name
	CreationDate	I_DCBBusinessPartner	CreationDate	Time Stamp
	CreationTime	I_DCBBusinessPartner	CreationTime	Time of Change
	LastChangedByUser	I_DCBBusinessPartner	LastChangedByUser	User Name
	LastChangeDate	I_DCBBusinessPartner	LastChangeDate	Time Stamp
	LastChangeTime	I_DCBBusinessPartner	LastChangeTime	Time changed
	IsBusinessPurposeCompleted	I_DCBBusinessPartner	IsBusinessPurposeCompleted	Purpose Completed
	FirstName	I_DCBBusinessPartner	FirstName	First Name
	LastName	I_DCBBusinessPartner	LastName	Last Name
	OrganizationBPName1	I_DCBBusinessPartner	OrganizationBPName1	Name 1
	OrganizationBPName2	I_DCBBusinessPartner	OrganizationBPName2	Name 2
	OrganizationBPName3	I_DCBBusinessPartner	OrganizationBPName3	Name 3
	OrganizationBPName4	I_DCBBusinessPartner	OrganizationBPName4	Name 4
	InternationalLocationNumber1	I_DCBBusinessPartner	InternationalLocationNumber1	Location no. 1
	InternationalLocationNumber2	I_DCBBusinessPartner	InternationalLocationNumber2	Location no. 2
	InternationalLocationNumber3	I_DCBBusinessPartner	InternationalLocationNumber3	Check digit
	LegalForm	I_DCBBusinessPartner	LegalForm	Legal form
	OrganizationFoundationDate	I_DCBBusinessPartner	OrganizationFoundationDate	Date founded
	OrganizationLiquidationDate	I_DCBBusinessPartner	OrganizationLiquidationDate	Liquidation
	IsNaturalPerson	I_DCBBusinessPartner	IsNaturalPerson	Natural person
	IsFemale	I_DCBBusinessPartner	IsFemale	Female
	IsMale	I_DCBBusinessPartner	IsMale	Male
	IsSexUnknown	I_DCBBusinessPartner	IsSexUnknown	Unknown
	FormOfAddress	I_DCBBusinessPartner	FormOfAddress	Title Key
	AcademicTitle	I_DCBBusinessPartner	AcademicTitle	Academic Title
	NameFormat	I_DCBBusinessPartner	NameFormat	Name Format
	NameCountry	I_DCBBusinessPartner	NameCountry	Country/Region
	BusinessPartnerGrouping	I_DCBBusinessPartner	BusinessPartnerGrouping	Grouping
	BusinessPartnerType	I_DCBBusinessPartner	BusinessPartnerType	Undefined range (can be used for patch levels)
	MiddleName	I_DCBBusinessPartner	MiddleName	Middle Name
	AdditionalLastName	I_DCBBusinessPartner	AdditionalLastName	Other Last Name
	GroupBusinessPartnerName1	I_DCBBusinessPartner	GroupBusinessPartnerName1	Name 1
	GroupBusinessPartnerName2	I_DCBBusinessPartner	GroupBusinessPartnerName2	Name 2
	CorrespondenceLanguage	I_DCBBusinessPartner	CorrespondenceLanguage	Language
	Language	I_DCBBusinessPartner	Language	Report Text Language
	SearchTerm1	I_DCBBusinessPartner	SearchTerm1	Search Term 1
	SearchTerm2	I_DCBBusinessPartner	SearchTerm2	Search Term 2
	IndependentAddressID	I_DCBBusinessPartner	IndependentAddressID	Address Number
	ValidTo	I_BusinessPartner_to_BP_Role	ValidTo	Vers.Valid To
	BusinessPartnerRole	I_BusinessPartner_to_BP_Role	BusinessPartnerRole	BP Role
	DataControllerSet	I_DCBBusinessPartner	DataControllerSet	Data Ctrlr. Set
	DataController1	I_DCBBusinessPartner	DataController1	Data Controller
	DataController2	I_DCBBusinessPartner	DataController2	Data Controller
	DataController3	I_DCBBusinessPartner	DataController3	Data Controller
	DataController4	I_DCBBusinessPartner	DataController4	Data Controller
	DataController5	I_DCBBusinessPartner	DataController5	Data Controller
	DataController6	I_DCBBusinessPartner	DataController6	Data Controller
	DataController7	I_DCBBusinessPartner	DataController7	Data Controller
	DataController8	I_DCBBusinessPartner	DataController8	Data Controller
	DataController9	I_DCBBusinessPartner	DataController9	Data Controller
	DataController10	I_DCBBusinessPartner	DataController10	Data Controller
	_AddressIndependentEmail	I_DCBBusinessPartner	_AddressIndependentEmail
	_AddressIndependentFax	I_DCBBusinessPartner	_AddressIndependentFax
	_AddressIndependentMobile	I_DCBBusinessPartner	_AddressIndependentMobile
	_AddressIndependentPhone	I_DCBBusinessPartner	_AddressIndependentPhone
	_BusinessPartnerRole	I_DCBBusinessPartner	_BusinessPartnerRole
	_CreatedByUser	I_DCBBusinessPartner	_CreatedByUser
	_CurrentDefaultAddress	I_DCBBusinessPartner	_CurrentDefaultAddress
	_DefaultAddress	I_DCBBusinessPartner	_DefaultAddress
	_LastChangedByUser	I_DCBBusinessPartner	_LastChangedByUser
	_AcademicTitleValueHelp	I_DCBBusinessPartner	_AcademicTitleValueHelp
	_AddressHomepageURL	I_DCBBusinessPartner	_AddressHomepageURL

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_DCBBusinessPartnerWithRole.
-- 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: IDCBBPWROLE

CREATE VIEW I_DCBBusinessPartnerWithRole AS
SELECT
  _DealBusinessPartnerRole.DCBBusinessPartnerRole AS DCBBusinessPartnerRole,
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _BusinessPartner.PersonNumber AS PersonNumber,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _BusinessPartner.CreatedByUser AS CreatedByUser,
  _BusinessPartner.CreationDate AS CreationDate,
  _BusinessPartner.CreationTime AS CreationTime,
  _BusinessPartner.LastChangedByUser AS LastChangedByUser,
  _BusinessPartner.LastChangeDate AS LastChangeDate,
  _BusinessPartner.LastChangeTime AS LastChangeTime,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _BusinessPartner.InternationalLocationNumber1 AS InternationalLocationNumber1,
  _BusinessPartner.InternationalLocationNumber2 AS InternationalLocationNumber2,
  _BusinessPartner.InternationalLocationNumber3 AS InternationalLocationNumber3,
  _BusinessPartner.LegalForm AS LegalForm,
  _BusinessPartner.OrganizationFoundationDate AS OrganizationFoundationDate,
  _BusinessPartner.OrganizationLiquidationDate AS OrganizationLiquidationDate,
  _BusinessPartner.IsNaturalPerson AS IsNaturalPerson,
  _BusinessPartner.IsFemale AS IsFemale,
  _BusinessPartner.IsMale AS IsMale,
  _BusinessPartner.IsSexUnknown AS IsSexUnknown,
  _BusinessPartner.FormOfAddress AS FormOfAddress,
  _BusinessPartner.AcademicTitle AS AcademicTitle,
  _BusinessPartner.NameFormat AS NameFormat,
  _BusinessPartner.NameCountry AS NameCountry,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  _BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _BusinessPartner.MiddleName AS MiddleName,
  _BusinessPartner.AdditionalLastName AS AdditionalLastName,
  _BusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _BusinessPartner.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _BusinessPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  _BusinessPartner.Language AS Language,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner.IndependentAddressID AS IndependentAddressID,
  _BusinessPartnerRoleExt.ValidTo AS ValidTo,
  _BusinessPartnerRoleExt.BusinessPartnerRole AS BusinessPartnerRole,
  _BusinessPartner.DataControllerSet AS DataControllerSet,
  _BusinessPartner.DataController1 AS DataController1,
  _BusinessPartner.DataController2 AS DataController2,
  _BusinessPartner.DataController3 AS DataController3,
  _BusinessPartner.DataController4 AS DataController4,
  _BusinessPartner.DataController5 AS DataController5,
  _BusinessPartner.DataController6 AS DataController6,
  _BusinessPartner.DataController7 AS DataController7,
  _BusinessPartner.DataController8 AS DataController8,
  _BusinessPartner.DataController9 AS DataController9,
  _BusinessPartner.DataController10 AS DataController10,
  _BusinessPartner._AddressIndependentEmail AS _AddressIndependentEmail,
  _BusinessPartner._AddressIndependentFax AS _AddressIndependentFax,
  _BusinessPartner._AddressIndependentMobile AS _AddressIndependentMobile,
  _BusinessPartner._AddressIndependentPhone AS _AddressIndependentPhone,
  _BusinessPartner._BusinessPartnerRole AS _BusinessPartnerRole,
  _BusinessPartner._CreatedByUser AS _CreatedByUser,
  _BusinessPartner._CurrentDefaultAddress AS _CurrentDefaultAddress,
  _BusinessPartner._DefaultAddress AS _DefaultAddress,
  _BusinessPartner._LastChangedByUser AS _LastChangedByUser,
  _BusinessPartner._AcademicTitleValueHelp AS _AcademicTitleValueHelp,
  _BusinessPartner._AddressHomepageURL AS _AddressHomepageURL
FROM I_DCBBusinessPartnerRole AS _DealBusinessPartnerRole
INNER JOIN I_BusinessPartner_to_BP_Role AS _BusinessPartnerRoleExt ON /* join condition not captured in parsed metadata */
INNER JOIN I_DCBBusinessPartner AS _BusinessPartner ON /* join condition not captured in parsed metadata */
;

Depth:

I_DCBBusinessPartnerWithRole view