How many fields does I_PurContractPartnerFunctionVH have?

I_PurContractPartnerFunctionVH has 8 fields. Key fields: PurchasingDocumentType, PartnerSchema, PartnerFunction.

I_PurContractPartnerFunctionVH

Q: Which tables does I_PurContractPartnerFunctionVH use?

I_PurContractPartnerFunctionVH reads from 4 data source(s): I_PurchasingDocumentType, I_PartFuncByPartDetnProced, I_PartnerFunction, t161.

DDL: I_PURCONTRACTPARTNERFUNCTIONVH SQL: IPCPARTNFUNCTVH Type: view COMPOSITE Package: VDM_MM_PUR_CON

Pur. Contr. Partner Function Value Help

I_PurContractPartnerFunctionVH is a Composite CDS View that provides data about "Pur. Contr. Partner Function Value Help" in SAP S/4HANA. It reads from 4 data sources (I_PurchasingDocumentType, I_PartFuncByPartDetnProced, I_PartnerFunction, t161) and exposes 8 fields with key fields PurchasingDocumentType, PartnerSchema, PartnerFunction. It has 2 associations to related views. Part of development package VDM_MM_PUR_CON.

Data Sources (4)

Source	Alias	Join Type
I_PurchasingDocumentType	doctype	from
I_PartFuncByPartDetnProced	function	inner
I_PartnerFunction	functiondetail	inner
t161	schema	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_PartnerTypeText	_PartnerTypeText	`_PartnerTypeText.PurchasingDocumentPartnerType = $projection.PurchasingDocumentPartnerType and _PartnerTypeText.Language = $session.system_language`
[0..1]	I_PurchasingDocumentType	_PurchasingDocumentType	`_PurchasingDocumentType.PurchasingDocumentType = $projection.PurchasingDocumentType and _PurchasingDocumentType.PurchasingDocumentCategory = 'K'`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IPCPARTNFUNCTVH	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Pur. Contr. Partner Function Value Help	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
Search.searchable	true	view

Fields (8)

Key	Field	Source Table	Source Field	Description
KEY	PurchasingDocumentType	t161	bsart
KEY	PartnerSchema	t161	pargr
KEY	PartnerFunction	I_PartFuncByPartDetnProced	PartnerFunction
	PartnerFunctionLanguageDepdnt			Partner Function
	PartnerFunctionName
	PurchasingDocumentPartnerType	I_PartnerFunction	SDDocumentPartnerType
	PurgDocumentPartnerTypeName	_PartnerTypeText	PurgDocumentPartnerTypeName
	_PurchasingDocumentType		_PurchasingDocumentType

@AbapCatalog.sqlViewName: 'IPCPARTNFUNCTVH'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Pur. Contr. Partner Function Value Help'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true

define view I_PurContractPartnerFunctionVH
  as select from I_PurchasingDocumentType   as doctype
    inner join   t161                       as schema         on  schema.bstyp = doctype.PurchasingDocumentCategory
                                                              and schema.bsart = doctype.PurchasingDocumentType
    inner join   I_PartFuncByPartDetnProced as function       on schema.pargr = function.PartnerDeterminationProcedure
    inner join   I_PartnerFunction          as functiondetail on function.PartnerFunction = functiondetail.PartnerFunction
  association [0..1] to I_PartnerTypeText        as _PartnerTypeText        on  _PartnerTypeText.PurchasingDocumentPartnerType = $projection.PurchasingDocumentPartnerType
                                                                            and _PartnerTypeText.Language                      = $session.system_language

  association [0..1] to I_PurchasingDocumentType as _PurchasingDocumentType on  _PurchasingDocumentType.PurchasingDocumentType     = $projection.PurchasingDocumentType
                                                                            and _PurchasingDocumentType.PurchasingDocumentCategory = 'K'

{
      @ObjectModel.foreignKey.association: '_PurchasingDocumentType'
      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key schema.bsart                         as PurchasingDocumentType,

      @UI.hidden: true
  key schema.pargr                         as PartnerSchema,

      @ObjectModel.text.element: ['PartnerFunctionName']
      @Search: { defaultSearchElement: true, ranking: #HIGH }
      @UI.hidden: true
  key function.PartnerFunction             as PartnerFunction,

      @EndUserText.label: 'Partner Function'
      function._PartnerFunction._PartnerFunctionLangDepdnt[Language=$session.system_language].PartnerFunctionLanguageDepdnt,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      //_PartnerFunctionText.PartnerFunctionName,

      functiondetail._Text[Language=$session.system_language].PartnerFunctionName,

      @ObjectModel.text.element: ['PurgDocumentPartnerTypeName']
      @Search: { defaultSearchElement: true, ranking: #HIGH }
      functiondetail.SDDocumentPartnerType as PurchasingDocumentPartnerType,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      _PartnerTypeText.PurgDocumentPartnerTypeName,

      _PurchasingDocumentType

}
where
  schema.bstyp = 'K'

Depth:

I_PurContractPartnerFunctionVH view