I_PurgDocumentPartnerVH

Q: Which tables does I_PurgDocumentPartnerVH use?

I_PurgDocumentPartnerVH reads from 2 data source(s): P_PurgDocPartnerSupplier, P_PurgDocPartnSupplierContact.

Q: How many fields does I_PurgDocumentPartnerVH have?

I_PurgDocumentPartnerVH has 57 fields. Key fields: PurchasingDocumentPartner, PurchasingDocumentPartnerType, PurchasingDocumentPartnerType.

DDL: I_PURGDOCUMENTPARTNERVH SQL: IPDPARTNERVH Type: view COMPOSITE

Purchasing Document Partner Value Help

I_PurgDocumentPartnerVH is a Composite CDS View that provides data about "Purchasing Document Partner Value Help" in SAP S/4HANA. It reads from 2 data sources (P_PurgDocPartnerSupplier, P_PurgDocPartnSupplierContact) and exposes 57 fields with key fields PurchasingDocumentPartner, PurchasingDocumentPartnerType, PurchasingDocumentPartnerType.

Data Sources (2)

Source	Alias	Join Type
P_PurgDocPartnerSupplier	P_PurgDocPartnerSupplier	from
P_PurgDocPartnSupplierContact	P_PurgDocPartnSupplierContact	union_all

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IPDPARTNERVH	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Purchasing Document Partner Value Help	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.dataCategory	#VALUE_HELP	view
Search.searchable	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (57)

Key	Field	Source Table	Source Field
KEY	PurchasingDocumentPartner	P_PurgDocPartnerSupplier	PurchasingDocumentPartner
KEY	PurchasingDocumentPartnerType	P_PurgDocPartnerSupplier	PurchasingDocumentPartnerType
	PurchasingDocumentPartnerName	P_PurgDocPartnerSupplier	PurchasingDocumentPartnerName
	AuthorizationGroup	P_PurgDocPartnerSupplier	AuthorizationGroup
	SupplierAccountGroup	P_PurgDocPartnerSupplier	SupplierAccountGroup
	BPPersonAuthorizationGroup
	IsBusinessPurposeCompleted		IsBusinessPurposeCompleted
	DataController1		DataController1
	DataController2		DataController2
	DataController3		DataController3
	DataController4		DataController4
	DataController5		DataController5
	DataController6		DataController6
	DataController7		DataController7
	DataController8		DataController8
	DataController9		DataController9
	DataController10		DataController10
	DataControllerSet		DataControllerSet
	BPPersonDataController1
	BPPersonDataController2
	BPPersonDataController3
	BPPersonDataController4
	BPPersonDataController5
	BPPersonDataController6
	BPPersonDataController7
	BPPersonDataController8
	BPPersonDataController9
	BPPersonDataController10
	PurchasingDocumentPartner
KEY	PurchasingDocumentPartnerType	P_PurgDocPartnSupplierContact	PurchasingDocumentPartnerType
	PurchasingDocumentPartnerName	P_PurgDocPartnSupplierContact	PurchasingDocumentPartnerName
	AuthorizationGroup	P_PurgDocPartnSupplierContact	AuthorizationGroup
	SupplierAccountGroup
	BPPersonAuthorizationGroup	P_PurgDocPartnSupplierContact	BPPersonAuthorizationGroup
	IsBusinessPurposeCompleted		IsBusinessPurposeCompleted
	DataController1		DataController1
	DataController2		DataController2
	DataController3		DataController3
	DataController4		DataController4
	DataController5		DataController5
	DataController6		DataController6
	DataController7		DataController7
	DataController8		DataController8
	DataController9		DataController9
	DataController10		DataController10
	DataControllerSet		DataControllerSet
	BPPersonDataController1		BPPersonDataController1
	BPPersonDataController2		BPPersonDataController2
	BPPersonDataController3		BPPersonDataController3
	BPPersonDataController4		BPPersonDataController4
	BPPersonDataController5		BPPersonDataController5
	BPPersonDataController6		BPPersonDataController6
	BPPersonDataController7		BPPersonDataController7
	BPPersonDataController8		BPPersonDataController8
	BPPersonDataController9		BPPersonDataController9
	BPPersonDataController10		BPPersonDataController10
	BPPersonDataControllerSet		BPPersonDataControllerSet

@AbapCatalog.sqlViewName: 'IPDPARTNERVH'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchasing Document Partner Value Help' //same as DDL description

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.dataCategory: #VALUE_HELP
//@ObjectModel.representativeKey: 'PurchasingDocumentPartner'

@Search.searchable: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

define view I_PurgDocumentPartnerVH
  as select from P_PurgDocPartnerSupplier
{
      @ObjectModel.text.element: [ 'PurchasingDocumentPartnerName' ]
      @Search: { defaultSearchElement: true }
  key P_PurgDocPartnerSupplier.PurchasingDocumentPartner,
  key P_PurgDocPartnerSupplier.PurchasingDocumentPartnerType,
      @Semantics.text
      P_PurgDocPartnerSupplier.PurchasingDocumentPartnerName,

      @UI.hidden: true
      P_PurgDocPartnerSupplier.AuthorizationGroup,
      @UI.hidden: true
      P_PurgDocPartnerSupplier.SupplierAccountGroup,
      @UI.hidden: true
      '' as BPPersonAuthorizationGroup,
      @UI.hidden: true
      IsBusinessPurposeCompleted,
      
      @Consumption.hidden: true
      @UI.hidden: true
      DataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      DataControllerSet,
      
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      cast( '' as bu_data_controller ) as BPPersonDataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      '' as BPPersonDataControllerSet

}
union all select from P_PurgDocPartnSupplierContact
{
      @ObjectModel.text.element: [ 'PurchasingDocumentPartnerName' ]
      @Search: { defaultSearchElement: true }
  key P_PurgDocPartnSupplierContact.PurchasingDocumentPartner,
  key P_PurgDocPartnSupplierContact.PurchasingDocumentPartnerType,
      @Semantics.text
      P_PurgDocPartnSupplierContact.PurchasingDocumentPartnerName,

      @UI.hidden: true
      P_PurgDocPartnSupplierContact.AuthorizationGroup,
      @UI.hidden: true
      '' as SupplierAccountGroup,
      @UI.hidden: true
      P_PurgDocPartnSupplierContact.BPPersonAuthorizationGroup,
      @UI.hidden: true
      IsBusinessPurposeCompleted,
      
      @Consumption.hidden: true
      @UI.hidden: true
      DataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      DataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      DataControllerSet,
      
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      BPPersonDataControllerSet
}
//where

//  ContactCardSemanticObjectType = 'SupplierContact'


// temporarily removed from cloud 1702 due to security issues


//union all select from P_PurgDocPartnerEmployee

//{

//      @ObjectModel.text.element: [ 'PurchasingDocumentPartnerName' ]

//  key P_PurgDocPartnerEmployee.PurchasingDocumentPartner,

//  key P_PurgDocPartnerEmployee.PurchasingDocumentPartnerType,

//      @Semantics.text

//      P_PurgDocPartnerEmployee.PurchasingDocumentPartnerName,

//

//      '' as Auth1,

//      '' as Auth2

//}

//where

//  StartDate <= $session.system_date

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURGDOCPARTNERSUPPLIER",
"P_PURGDOCPARTNSUPPLIERCONTACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_PurgDocumentPartnerVH view

P_PurgDocPartnerSupplier view
P_PurgDocPartnSupplierContact view