I_MFGBUSINESSPARTNER

CDS View

Manufacturing Business Partner

I_MFGBUSINESSPARTNER is a CDS View in S/4HANA. Manufacturing Business Partner. It contains 15 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 15 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MfgExecutionUserVH view_entity from CONSUMPTION Manufacturing execution user
C_MfgOperatorDetail view from CONSUMPTION Production Operator details
I_MfgBusinessPartnerTP view from TRANSACTIONAL Manufacturing Business Partner
P_OpActyAllManufacturingUsers view cross COMPOSITE
P_OpActyMainWrkCtrMfgUser view inner COMPOSITE

Fields (15)

KeyField CDS FieldsUsed in Views
KEY MfgBusinessPartner MfgBusinessPartner 3
_BusinessPartner _BusinessPartner 2
_WorkCenterBySemanticKey _WorkCenterBySemanticKey 2
AuthorizationGroup AuthorizationGroup 2
BusinessPartner BusinessPartner 2
BusinessPartnerUUID BusinessPartnerUUID 3
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
FirstName FirstName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LastName LastName 1
Plant Plant 3
WorkCenter WorkCenter 3 
@AbapCatalog.sqlViewName: 'IMFGBP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Manufacturing Business Partner'
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE


define view I_MfgBusinessPartner
  as select from P_MfgBusinessPartner
    inner join   I_BusinessPartner_to_BP_Role as BusinessPartnerRole on  P_MfgBusinessPartner.MfgBusinessPartner =  BusinessPartnerRole.BusinessPartner
                                                                     and BusinessPartnerRole.BusinessPartnerRole =  'BUP003'
                                                                     and P_MfgBusinessPartner.CurrentDateTime    <= BusinessPartnerRole.ValidTo
  association [1..1] to I_User                    as _User                    on  $projection.BusinessPartnerUUID = _User.BusinessPartnerUUID
  association [0..1] to I_WorkCenterBySemanticKey as _WorkCenterBySemanticKey on  $projection.WorkCenter = _WorkCenterBySemanticKey.WorkCenter
                                                                              and $projection.Plant      = _WorkCenterBySemanticKey.Plant


{

  key MfgBusinessPartner                                              as MfgBusinessPartner,
      WorkCenter                                                      as WorkCenter,
      Plant                                                           as Plant,
      CreatedByUser                                                   as CreatedByUser,
      CreationDateTime                                                as CreationDateTime,
      LastChangeDateTime                                              as LastChangeDateTime,
      LastChangedByUser                                               as LastChangedByUser,
      CurrentDateTime                                                 as CurrentDateTime,
      BusinessPartnerRole._BusinessPartner.BusinessPartnerUUID        as BusinessPartnerUUID,

      // Field for DPP

      BusinessPartnerRole._BusinessPartner.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
      BusinessPartnerRole._BusinessPartner.AuthorizationGroup         as AuthorizationGroup,

      BusinessPartnerRole._BusinessPartner.BusinessPartnerName,
      BusinessPartnerRole._BusinessPartner.FirstName,
      BusinessPartnerRole._BusinessPartner.LastName,
      BusinessPartnerRole.BusinessPartner,

      //Associations

      _User,
      _WorkCenterBySemanticKey,
      BusinessPartnerRole._BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNER_TO_BP_ROLE",
"P_MFGBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_USER",
"I_WORKCENTERBYSEMANTICKEY"
],
"BASE":
[
"I_BUSINESSPARTNER_TO_BP_ROLE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More