I_MfgBuyOffProcessorTeamFunc

DDL: I_MFGBUYOFFPROCESSORTEAMFUNC SQL: IMFGBUYOFFPROCSR Type: view COMPOSITE Package: MPE_BUYOFF

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 2 data sources (I_BusinessPartner, I_RespyMgmtTeamMbrFunc) and exposes 20 fields with key fields RespyMgmtFunction, RespyMgmtTeamID, RespyMgmtBusinessPartner. It has 1 association to related views. Part of development package MPE_BUYOFF.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner inner
I_RespyMgmtTeamMbrFunc _TeamFunc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_User _User _User.UserID = $session.user and _BusinessPartner.BusinessPartnerUUID = _User.BusinessPartnerUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBUYOFFPROCSR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 (20)

KeyFieldSource TableSource FieldDescription
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
UserID _User UserID 
@AbapCatalog.sqlViewName: 'IMFGBUYOFFPROCSR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@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'

Learn More