C_MfgBPWorkCenterAssgmt

DDL: C_MFGBPWORKCENTERASSGMT SQL: CMFGBPWCASSGMT Type: view CONSUMPTION

Work Center assignment

C_MfgBPWorkCenterAssgmt is a Consumption CDS View that provides data about "Work Center assignment" in SAP S/4HANA. It reads from 1 data source (I_MfgBPWrkCtrAssgmtTP) and exposes 20 fields with key fields MfgBusinessPartner, WorkCenter, Plant. It has 4 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgBPWrkCtrAssgmtTP _MfgBPWrkCtrAssgmt from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_WorkCenterBySemanticKey _WorkCenter _MfgBPWrkCtrAssgmt.Plant = _WorkCenter.Plant and _MfgBPWrkCtrAssgmt.WorkCenter = _WorkCenter.WorkCenter
[0..1] I_WorkCenterText _WorkCenterText _WorkCenter.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode and _WorkCenterText.Language = $session.system_language
[0..1] I_MfgValidityStatusText _ValidityStatus $projection.MfgValidityStatus = _ValidityStatus.MfgValidityStatus and _ValidityStatus.Language = $session.system_language
[1..1] C_MfgOperatorDetail _Detail $projection.MfgBusinessPartner = _Detail.MfgBusinessPartner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMFGBPWCASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Work Center assignment view
AccessControl.personalData.blocking #REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MfgBusinessPartner I_MfgBPWrkCtrAssgmtTP MfgBusinessPartner
KEY WorkCenter I_MfgBPWrkCtrAssgmtTP WorkCenter
KEY Plant I_MfgBPWrkCtrAssgmtTP Plant
PlantName
ValidityStartDate I_MfgBPWrkCtrAssgmtTP ValidityStartDate Valid from
ValidityEndDate I_MfgBPWrkCtrAssgmtTP ValidityEndDate Valid to
IsDefaultMfgWrkCtr I_MfgBPWrkCtrAssgmtTP IsDefaultMfgWrkCtr
CreatedByUser I_MfgBPWrkCtrAssgmtTP CreatedByUser
CreationDateTime I_MfgBPWrkCtrAssgmtTP CreationDateTime
LastChangeDateTime I_MfgBPWrkCtrAssgmtTP LastChangeDateTime
LastChangedByUser I_MfgBPWrkCtrAssgmtTP LastChangedByUser
IsBusinessPurposeCompleted I_MfgBPWrkCtrAssgmtTP IsBusinessPurposeCompleted
AuthorizationGroup I_MfgBPWrkCtrAssgmtTP AuthorizationGroup
_ValidityStatus _ValidityStatus
_WorkCenterText _WorkCenterText
WorkCenterInternalID _WorkCenter WorkCenterInternalID
WorkCenterTypeCode _WorkCenter WorkCenterTypeCode
BusinessPartner
_Detail _Detail
_BusinessPartner 
@AbapCatalog.sqlViewName: 'CMFGBPWCASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Work Center assignment'
//@Search.searchable: true

@ObjectModel.semanticKey: ['Plant']
@AccessControl.personalData.blocking: #REQUIRED

define view C_MfgBPWorkCenterAssgmt
  as select from I_MfgBPWrkCtrAssgmtTP as _MfgBPWrkCtrAssgmt
  association [0..1] to I_WorkCenterBySemanticKey as _WorkCenter     on  _MfgBPWrkCtrAssgmt.Plant      = _WorkCenter.Plant
                                                                     and _MfgBPWrkCtrAssgmt.WorkCenter = _WorkCenter.WorkCenter
  association [0..1] to I_WorkCenterText          as _WorkCenterText on  _WorkCenter.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID
                                                                     and _WorkCenter.WorkCenterTypeCode   = _WorkCenterText.WorkCenterTypeCode
                                                                     and _WorkCenterText.Language         = $session.system_language
  association [0..1] to I_MfgValidityStatusText   as _ValidityStatus on  $projection.MfgValidityStatus = _ValidityStatus.MfgValidityStatus
                                                                     and _ValidityStatus.Language      = $session.system_language
  association [1..1] to C_MfgOperatorDetail       as _Detail         on  $projection.MfgBusinessPartner = _Detail.MfgBusinessPartner

{
          @ObjectModel.foreignKey.association: '_Detail'
          @UI.hidden: true
  key     _MfgBPWrkCtrAssgmt.MfgBusinessPartner,

          @UI.lineItem: [{ position: 20 }]
          @UI.textArrangement: #TEXT_FIRST
          @ObjectModel.text.association: '_WorkCenterText'
  key     _MfgBPWrkCtrAssgmt.WorkCenter,

          @UI.lineItem: [{ position: 10 }]
          @UI.textArrangement: #TEXT_FIRST
          @ObjectModel.text.element: ['PlantName']
  key     _MfgBPWrkCtrAssgmt.Plant,

          @UI.hidden: true
          _WorkCenter._Plant.PlantName         as PlantName,

          @UI.lineItem: [{ position: 40 }]
          @EndUserText.label: 'Valid from'
          _MfgBPWrkCtrAssgmt.ValidityStartDate as ValidityStartDate,

          @UI.lineItem: [{ position: 50 }]
          @EndUserText.label: 'Valid to'
          _MfgBPWrkCtrAssgmt.ValidityEndDate   as ValidityEndDate,

          @ObjectModel.foreignKey.association: '_ValidityStatus'
          @UI: { lineItem: [{ position: 60 }],
                 textArrangement: #TEXT_ONLY}
          @EndUserText.label: 'Validity Status'
          @ObjectModel.virtualElement: true
          @ObjectModel.readOnly: true
          @ObjectModel.text.association: '_ValidityStatus'
          cast( case
             when ValidityEndDate < $session.system_date
             or ValidityStartDate > $session.system_date
               then   '2' //Inactive

             when ValidityEndDate >= $session.system_date
                 then  '1'  //Active

          end as mpe_validity_status)          as MfgValidityStatus,

          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.IsDefaultMfgWrkCtr,
          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.CreatedByUser,
          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.CreationDateTime,
          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.LastChangeDateTime,
          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.LastChangedByUser,
          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.IsBusinessPurposeCompleted,
          @UI.hidden: true
          _MfgBPWrkCtrAssgmt.AuthorizationGroup,
          @UI.hidden: true
          _ValidityStatus,
          @UI.hidden: true
          _WorkCenterText,
          @UI.hidden: true
          _WorkCenter.WorkCenterInternalID,
          @UI.hidden: true
          _WorkCenter.WorkCenterTypeCode,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _MfgBPWrkCtrAssgmt._MfgBP.BusinessPartner,
          @ObjectModel.association.type: [#TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT]
          _Detail,
          _MfgBPWrkCtrAssgmt._MfgBP._BusinessPartner

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGBPWRKCTRASSGMTTP",
"I_MFGBUSINESSPARTNERTP",
"I_PLANT",
"I_WORKCENTERBYSEMANTICKEY"
],
"ASSOCIATED":
[
"C_MFGOPERATORDETAIL",
"I_BUSINESSPARTNER",
"I_MFGVALIDITYSTATUSTEXT",
"I_WORKCENTERBYSEMANTICKEY",
"I_WORKCENTERTEXT"
],
"BASE":
[
"I_MFGBUSINESSPARTNERTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More