I_MfgBuyOffProcessorTeamFunc

Q: Which tables does I_MfgBuyOffProcessorTeamFunc use?

I_MfgBuyOffProcessorTeamFunc reads from 4 data source(s): I_BusinessPartner, I_BusinessPartner, I_RespyMgmtTeamMbrFunc, I_RespyMgmtTeamMbrFunc.

Q: How many fields does I_MfgBuyOffProcessorTeamFunc have?

I_MfgBuyOffProcessorTeamFunc has 39 fields. Key fields: RespyMgmtFunction, RespyMgmtTeamID, RespyMgmtBusinessPartner, RespyMgmtTeamID, RespyMgmtBusinessPartner.

DDL: I_MFGBUYOFFPROCESSORTEAMFUNC SQL: IMFGBUYOFFPROCSR Type: view COMPOSITE

Buy Off Processor Team Function

I_MfgBuyOffProcessorTeamFunc is a Composite CDS View that provides data about "Buy Off Processor Team Function" in SAP S/4HANA. It reads from 4 data sources (I_BusinessPartner, I_BusinessPartner, I_RespyMgmtTeamMbrFunc, I_RespyMgmtTeamMbrFunc) and exposes 39 fields with key fields RespyMgmtFunction, RespyMgmtTeamID, RespyMgmtBusinessPartner, RespyMgmtTeamID, RespyMgmtBusinessPartner. It has 2 associations to related views.

Data Sources (4)

Source	Alias	Join Type
I_BusinessPartner	_BusinessPartner	inner
I_BusinessPartner	_BusinessPartner	inner
I_RespyMgmtTeamMbrFunc	_TeamFunc	from
I_RespyMgmtTeamMbrFunc	_TeamFunc	union

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_User	_User	`_User.UserID = $session.user and _BusinessPartner.BusinessPartnerUUID = _User.BusinessPartnerUUID`
[1..1]	I_RespyMgmtTeamHeader	_TeamHeader	`$projection.RespyMgmtTeamID = _TeamHeader.RespyMgmtTeamID`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IMFGBUYOFFPROCSR	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
EndUserText.label	Buy Off Processor Team Function	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (39)

Key	Field	Source Table	Source Field
KEY	RespyMgmtFunction		RespyMgmtFunction
KEY	RespyMgmtTeamID		RespyMgmtTeamID
KEY	RespyMgmtBusinessPartner		RespyMgmtBusinessPartner
	RespyMgmtTeamCategory	_Team	RespyMgmtTeamCategory
	RespyMgmtTeamType	_Team	RespyMgmtTeamType
	RespyMgmtTeamName	_Team	RespyMgmtTeamName
	DataController1	I_BusinessPartner	DataController1
	DataController2	I_BusinessPartner	DataController2
	DataController3	I_BusinessPartner	DataController3
	DataController4	I_BusinessPartner	DataController4
	DataController5	I_BusinessPartner	DataController5
	DataController6	I_BusinessPartner	DataController6
	DataController7	I_BusinessPartner	DataController7
	DataController8	I_BusinessPartner	DataController8
	DataController9	I_BusinessPartner	DataController9
	DataController10	I_BusinessPartner	DataController10
	DataControllerSet	I_BusinessPartner	DataControllerSet
	IsBusinessPurposeCompleted	I_BusinessPartner	IsBusinessPurposeCompleted
	AuthorizationGroup	I_BusinessPartner	AuthorizationGroup
	RespyMgmtTeamIDkeyRespyMgmtFunction
KEY	RespyMgmtTeamID	_SuperTeam	RespyMgmtTeamID
KEY	RespyMgmtBusinessPartner		RespyMgmtBusinessPartner
	RespyMgmtTeamCategory	_TeamHeader	RespyMgmtTeamCategory
	RespyMgmtTeamType	_TeamHeader	RespyMgmtTeamType
	RespyMgmtTeamName	_TeamHeader	RespyMgmtTeamName
	DataController1	I_BusinessPartner	DataController1
	DataController2	I_BusinessPartner	DataController2
	DataController3	I_BusinessPartner	DataController3
	DataController4	I_BusinessPartner	DataController4
	DataController5	I_BusinessPartner	DataController5
	DataController6	I_BusinessPartner	DataController6
	DataController7	I_BusinessPartner	DataController7
	DataController8	I_BusinessPartner	DataController8
	DataController9	I_BusinessPartner	DataController9
	DataController10	I_BusinessPartner	DataController10
	DataControllerSet	I_BusinessPartner	DataControllerSet
	IsBusinessPurposeCompleted	I_BusinessPartner	IsBusinessPurposeCompleted
	AuthorizationGroup	I_BusinessPartner	AuthorizationGroup
	UserID	_User	UserID

@AbapCatalog.sqlViewName: 'IMFGBUYOFFPROCSR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Buy Off Processor Team Function'
@AccessControl.personalData.blocking: #REQUIRED

define view I_MfgBuyOffProcessorTeamFunc
  as select from I_RespyMgmtTeamMbrFunc as _TeamFunc
    inner join   I_BusinessPartner      as _BusinessPartner on _BusinessPartner.BusinessPartner = _TeamFunc.RespyMgmtBusinessPartner
  association [1..1] to I_User as _User on  _User.UserID                         = $session.user
                                        and _BusinessPartner.BusinessPartnerUUID = _User.BusinessPartnerUUID
  //  association [1..1] to P_RespyMgmtTeamHeader as _TeamHeader on $projection.RespyMgmtTeamID = _TeamHeader.RespyMgmtTeamID

{
  key RespyMgmtFunction,
  key RespyMgmtTeamID,
  key RespyMgmtBusinessPartner,
      _Team.RespyMgmtTeamCategory,
      _Team.RespyMgmtTeamType,
      _Team.RespyMgmtTeamName,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController1,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController2,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController3,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController4,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController5,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController6,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController7,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController8,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController9,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController10,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataControllerSet,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.IsBusinessPurposeCompleted,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.AuthorizationGroup,
      _User.UserID
      /* Associations */
}
where
      _Team.RespyMgmtTeamCategory = 'EPO'
  and _Team.RespyMgmtTeamStatus   = '01'
union

select from  I_RespyMgmtTeamMbrFunc         as _TeamFunc
  inner join I_BusinessPartner              as _BusinessPartner on _BusinessPartner.BusinessPartner = _TeamFunc.RespyMgmtBusinessPartner
  join       I_RespyMgmtSuperTeamOfAllLevel as _SuperTeam       on _TeamFunc.RespyMgmtTeamID = _SuperTeam.RespyMgmtParentTeamID
association [1..1] to I_User                as _User       on  _User.UserID                         = $session.user
                                                           and _BusinessPartner.BusinessPartnerUUID = _User.BusinessPartnerUUID
association [1..1] to I_RespyMgmtTeamHeader as _TeamHeader on  $projection.RespyMgmtTeamID = _TeamHeader.RespyMgmtTeamID
{
  key RespyMgmtFunction,
  key _SuperTeam.RespyMgmtTeamID as RespyMgmtTeamID,
  key RespyMgmtBusinessPartner,
      _TeamHeader.RespyMgmtTeamCategory,
      _TeamHeader.RespyMgmtTeamType,
      _TeamHeader.RespyMgmtTeamName,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController1,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController2,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController3,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController4,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController5,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController6,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController7,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController8,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController9,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataController10,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.DataControllerSet,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.IsBusinessPurposeCompleted,
      @UI.hidden: true
      @Consumption.hidden: true
      _BusinessPartner.AuthorizationGroup,
      _User.UserID
      /* Associations */
}
where
      _Team.RespyMgmtTeamCategory = 'EPO'
  and _Team.RespyMgmtTeamStatus   = '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_RESPYMGMTSUPERTEAMOFALLLEVEL",
"I_RESPYMGMTTEAMHEADER",
"I_RESPYMGMTTEAMMBRFUNC",
"I_USER"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_MfgBuyOffProcessorTeamFunc view