I_MfgBusinessPartnerTP

DDL: I_MFGBUSINESSPARTNERTP SQL: IMFGBPTP Type: view TRANSACTIONAL

Manufacturing Business Partner

I_MfgBusinessPartnerTP is a Transactional CDS View that provides data about "Manufacturing Business Partner" in SAP S/4HANA. It reads from 1 data source (I_MfgBusinessPartner) and exposes 18 fields with key field MfgBusinessPartner. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgBusinessPartner I_MfgBusinessPartner from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_MfgBPQualifnCertAssgmtTP _MfgBPCert $projection.MfgBusinessPartner = _MfgBPCert.MfgBusinessPartner
[1..*] I_MfgBPWrkCtrAssgmtTP _MfgBPWrkCtr $projection.MfgBusinessPartner = _MfgBPWrkCtr.MfgBusinessPartner
[1..1] I_WorkCenterBySemanticKey _WorkCenter $projection.WorkCenter = _WorkCenter.WorkCenter and $projection.Plant = _WorkCenter.Plant
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manufacturing Business Partner view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.writeActivePersistence mpev_usr_profile view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MfgBusinessPartner I_MfgBusinessPartner MfgBusinessPartner
UserDescription
WorkCenter I_MfgBusinessPartner WorkCenter
Plant I_MfgBusinessPartner Plant
CreatedByUser I_MfgBusinessPartner CreatedByUser
CreationDateTime I_MfgBusinessPartner CreationDateTime
LastChangeDateTime I_MfgBusinessPartner LastChangeDateTime
LastChangedByUser I_MfgBusinessPartner LastChangedByUser
UserID
IsBusinessPurposeCompleted I_MfgBusinessPartner IsBusinessPurposeCompleted
AuthorizationGroup I_MfgBusinessPartner AuthorizationGroup
BusinessPartnerUUID I_MfgBusinessPartner BusinessPartnerUUID
BusinessPartner I_MfgBusinessPartner BusinessPartner
_MfgBPCert _MfgBPCert
_MfgBPWrkCtr _MfgBPWrkCtr
_WorkCenter _WorkCenter
_Plant _Plant
_BusinessPartner I_MfgBusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'IMFGBPTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Manufacturing Business Partner'
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.modelCategory: #BUSINESS_OBJECT

@ObjectModel.writeActivePersistence: 'mpev_usr_profile'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: ['MfgBusinessPartner']

@ObjectModel.compositionRoot: true
@ObjectModel.transactionalProcessingEnabled: true

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

define view I_MfgBusinessPartnerTP
  as select from I_MfgBusinessPartner

  association [1..*] to I_MfgBPQualifnCertAssgmtTP as _MfgBPCert   on  $projection.MfgBusinessPartner = _MfgBPCert.MfgBusinessPartner
  association [1..*] to I_MfgBPWrkCtrAssgmtTP      as _MfgBPWrkCtr on  $projection.MfgBusinessPartner = _MfgBPWrkCtr.MfgBusinessPartner
  association [1..1] to I_WorkCenterBySemanticKey  as _WorkCenter  on  $projection.WorkCenter = _WorkCenter.WorkCenter
                                                                   and $projection.Plant      = _WorkCenter.Plant
  association [1..1] to I_Plant                    as _Plant       on  $projection.Plant = _Plant.Plant
{
  key I_MfgBusinessPartner.MfgBusinessPartner,
      @ObjectModel.readOnly: true
      I_MfgBusinessPartner._User.UserDescription,
      @ObjectModel.foreignKey.association: '_WorkCenter'
      I_MfgBusinessPartner.WorkCenter,
      @ObjectModel.foreignKey.association: '_Plant'
      I_MfgBusinessPartner.Plant,
      @Semantics.user.createdBy: true
      I_MfgBusinessPartner.CreatedByUser,
      I_MfgBusinessPartner.CreationDateTime,
      I_MfgBusinessPartner.LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      I_MfgBusinessPartner.LastChangedByUser,
      @ObjectModel.readOnly: true
      I_MfgBusinessPartner._User.UserID,
      // Field for DPP

      @ObjectModel.readOnly: true
      I_MfgBusinessPartner.IsBusinessPurposeCompleted,
      @ObjectModel.readOnly: true
      I_MfgBusinessPartner.AuthorizationGroup,
      I_MfgBusinessPartner.BusinessPartnerUUID,
      // Field for BP Data controller

      @Consumption.hidden:true
      @UI.hidden:true
      I_MfgBusinessPartner.BusinessPartner,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]
      _MfgBPCert,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]
      _MfgBPWrkCtr,
      _WorkCenter,
      _Plant,
      I_MfgBusinessPartner._BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGBUSINESSPARTNER",
"I_USER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_MFGBPQUALIFNCERTASSGMTTP",
"I_MFGBPWRKCTRASSGMTTP",
"I_PLANT",
"I_WORKCENTERBYSEMANTICKEY"
],
"BASE":
[
"I_MFGBUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/