How many fields does C_SalesDocumentContactPerson have?

C_SalesDocumentContactPerson has 13 fields. Key fields: SalesDocument, PartnerFunction, ContactPerson, BusinessPartnerPerson.

C_SalesDocumentContactPerson

Q: Which tables does C_SalesDocumentContactPerson use?

C_SalesDocumentContactPerson reads from 3 data source(s): I_CustomerContact, I_SalesDocumentBasic, I_SDDocumentContactPerson.

DDL: C_SALESDOCUMENTCONTACTPERSON SQL: CSDOCSCNTCTPERSN Type: view CONSUMPTION

Sales Doc w. Cust-Expd Price Cntct Persn

C_SalesDocumentContactPerson is a Consumption CDS View that provides data about "Sales Doc w. Cust-Expd Price Cntct Persn" in SAP S/4HANA. It reads from 3 data sources (I_CustomerContact, I_SalesDocumentBasic, I_SDDocumentContactPerson) and exposes 13 fields with key fields SalesDocument, PartnerFunction, ContactPerson, BusinessPartnerPerson. It has 3 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_CustomerContact	ContactPerson	inner
I_SalesDocumentBasic	SalesDocument	inner
I_SDDocumentContactPerson	SDDocumentContactPerson	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_SalesDocument	_SalesDocument	`$projection.SalesDocument = _SalesDocument.SalesDocument`
[0..1]	I_PartnerFunction	_PartnerFunction	`$projection.PartnerFunction = _PartnerFunction.PartnerFunction`
[1..1]	I_BusinessPartner	_BusinessPartnerPerson	`_BusinessPartnerPerson.BusinessPartner = $projection.BusinessPartnerPerson`

Annotations (10)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	CSDOCSCNTCTPERSN	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Sales Doc w. Cust-Expd Price Cntct Persn	view

Fields (13)

Key	Field	Source Table	Source Field
KEY	SalesDocument
KEY	PartnerFunction	I_SDDocumentContactPerson	PartnerFunction
KEY	ContactPerson	I_SDDocumentContactPerson	ContactPerson
KEY	BusinessPartnerPerson	I_CustomerContact	BusinessPartnerPerson
	BusinessPartnerFullName
	ContactPersonFunctionName
	EmailAddress	I_CustomerContact	EmailAddress
	MobilePhoneNumber	I_CustomerContact	MobilePhoneNumber
	InternationalMobilePhoneNumber	I_CustomerContact	InternationalMobilePhoneNumber
	InternationalPhoneNumber	I_CustomerContact	InternationalPhoneNumber
	_SalesDocument		_SalesDocument
	_PartnerFunction		_PartnerFunction
	_BusinessPartnerPerson		_BusinessPartnerPerson

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CSDOCSCNTCTPERSN'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:#CHECK
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Sales Doc w. Cust-Expd Price Cntct Persn'
define view C_SalesDocumentContactPerson
  as select from I_SDDocumentContactPerson as SDDocumentContactPerson

    inner join   I_SalesDocumentBasic      as SalesDocument         on SDDocumentContactPerson.SDDocument = SalesDocument.SalesDocument

    inner join   I_CustomerContact         as ContactPerson         on SDDocumentContactPerson.ContactPerson = ContactPerson.CustomerContact

  association [1..1] to I_SalesDocument   as _SalesDocument         on $projection.SalesDocument = _SalesDocument.SalesDocument
  association [0..1] to I_PartnerFunction as _PartnerFunction       on $projection.PartnerFunction = _PartnerFunction.PartnerFunction
  association [1..1] to I_BusinessPartner as _BusinessPartnerPerson on _BusinessPartnerPerson.BusinessPartner = $projection.BusinessPartnerPerson

{
                      @Consumption.valueHelpDefinition: [{ entity: { name:'I_SalesDocumentStdVH', element: 'SalesDocument' }}]
                      @ObjectModel.foreignKey.association: '_SalesDocument'
  key                 cast(SDDocumentContactPerson.SDDocument as vbeln_va preserving type) as SalesDocument,

                      @ObjectModel.foreignKey.association: '_PartnerFunction'
  key                 SDDocumentContactPerson.PartnerFunction,

  key                 SDDocumentContactPerson.ContactPerson,
                      @Consumption.valueHelpDefinition: [{ entity:  { name:'I_BusinessPartnerVH', element: 'BusinessPartner' }}]

                      @ObjectModel.foreignKey.association: '_BusinessPartnerPerson'
  key                 ContactPerson.BusinessPartnerPerson,

                      ContactPerson._BusinessPartnerPerson.BusinessPartnerFullName,

                      @Semantics:   { organization.role: true }
                      ContactPerson._ContactPersonFunction._Text[1: Language = $session.system_language].ContactPersonFunctionName,

                      @Semantics:   { eMail: {address: true, type:  [ #PREF, #WORK ] } }
                      ContactPerson.EmailAddress,

                      @Semantics.telephone.type: [#WORK, #PREF]
                      ContactPerson.MobilePhoneNumber,

                      @Semantics.telephone.type: [#WORK, #PREF]
                      ContactPerson.InternationalMobilePhoneNumber,

                      @Semantics.telephone.type: #WORK
                      ContactPerson.InternationalPhoneNumber,

                      _SalesDocument,
                      _PartnerFunction,
                      _BusinessPartnerPerson

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CONTACTPERSONFUNCTION",
"I_CONTACTPERSONFUNCTIONT",
"I_CUSTOMERCONTACT",
"I_SALESDOCUMENTBASIC",
"I_SDDOCUMENTCONTACTPERSON"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_PARTNERFUNCTION",
"I_SALESDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_SalesDocumentContactPerson view