Which tables does P_Bpcontacts_Data use?

P_Bpcontacts_Data reads from 1 data source(s): but000.

How many fields does P_Bpcontacts_Data have?

P_Bpcontacts_Data has 11 fields. Key fields: BusinessPartner, FormOfAddress.

P_Bpcontacts_Data

DDL: P_BPCONTACTS_DATA SQL: P_MD_BPC_DATA Type: view BASIC

P_Bpcontacts_Data is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (but000) and exposes 11 fields with key fields BusinessPartner, FormOfAddress. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
but000	but000	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..*]	I_PersonFormOfAddrT	_PersonFormOfAddressText	`$projection.FormOfAddress = _PersonFormOfAddressText.FormOfAddress`
[1..1]	but100	_Role	`$projection.BusinessPartner = _Role.partner`
[1..1]	tb037t	_AuthorizationGroupText	`$projection.AuthorizationGroup = _AuthorizationGroupText.augrp`

Annotations (3)

Name	Value	Level
AbapCatalog.sqlViewName	P_MD_BPC_DATA	view
VDM.private	true	view
VDM.viewType	#BASIC	view

Fields (11)

Key	Field	Source Table	Source Field
KEY	BusinessPartner	but000	partner
KEY	FormOfAddress	but000	title
	FirstName	but000	name_first
	LastName	but000	name_last
	PersonNumber	but000	persnumber
	AuthorizationGroup	but000	augrp
	IsBusinessPurposeCompleted	but000	xpcpt
	BirthDate	but000	birthdt
	_PersonFormOfAddressText		_PersonFormOfAddressText
	_Role		_Role
	_AuthorizationGroupText		_AuthorizationGroupText

@AbapCatalog.sqlViewName: 'P_MD_BPC_DATA'
@VDM.private: true
@VDM.viewType: #BASIC
define view P_Bpcontacts_Data as select from but000 
association [1..*] to I_PersonFormOfAddrT as _PersonFormOfAddressText on $projection.FormOfAddress = _PersonFormOfAddressText.FormOfAddress
association [1..1] to but100 as _Role on $projection.BusinessPartner = _Role.partner
association [1..1] to tb037t as _AuthorizationGroupText on $projection.AuthorizationGroup = _AuthorizationGroupText.augrp 
{
  key but000.partner as BusinessPartner,
  key but000.title as FormOfAddress,
  but000.name_first as FirstName,
  but000.name_last  as LastName,
  but000.persnumber as PersonNumber,
  but000.augrp as AuthorizationGroup,
  but000.xpcpt as  IsBusinessPurposeCompleted,
  but000.birthdt as BirthDate,
  
  _PersonFormOfAddressText,
  _Role,
  _AuthorizationGroupText
  
} //where _Role.rltyp = 'BUP001' removed since BUP001 role not required to create Contact Person relationship 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BUT000"
],
"ASSOCIATED":
[
"I_PERSONFORMOFADDRT",
"BUT100",
"TB037T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_Bpcontacts_Data view

but000