C_MRPController

DDL: C_MRPCONTROLLER SQL: CMRPCONTROLLER Type: view CONSUMPTION

MRP Controller

C_MRPController is a Consumption CDS View that provides data about "MRP Controller" in SAP S/4HANA. It reads from 1 data source (I_MRPController) and exposes 13 fields with key fields Plant, MRPController.

Data Sources (1)

SourceAliasJoin Type
I_MRPController I_MRPController from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMRPCONTROLLER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MRP Controller view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Plant I_MRPController Plant
KEY MRPController I_MRPController MRPController
MRPControllerName I_MRPController MRPControllerName
PlantName
MRPControllerPhoneNumber I_MRPController MRPControllerPhoneNumber
PurchasingGroup I_MRPController PurchasingGroup
BusinessArea I_MRPController BusinessArea
ProfitCenter I_MRPController ProfitCenter
UserID I_MRPController UserID
_BusinessArea I_MRPController _BusinessArea
_Plant I_MRPController _Plant
_PurchasingGroup I_MRPController _PurchasingGroup
_User I_MRPController _User
@AbapCatalog.sqlViewName: 'CMRPCONTROLLER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck: #CHECK
}
@EndUserText.label: 'MRP Controller'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@Search.searchable: true

@VDM.viewType: #CONSUMPTION

define view C_MRPController
   as select from I_MRPController
{

      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @UI.selectionField: [ { position: 10 } ]
      @UI.lineItem: [ { position: 10 } ]
  key I_MRPController.Plant,

      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @UI.selectionField: [ { position: 20 } ]
      @UI.lineItem: [ { position: 20 } ]
  key I_MRPController.MRPController,
      I_MRPController.MRPControllerName,
      I_MRPController._Plant.PlantName,
      I_MRPController.MRPControllerPhoneNumber,
      I_MRPController.PurchasingGroup,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_BusinessAreaStdVH', element: 'BusinessArea' } } ]
      I_MRPController.BusinessArea,
      I_MRPController.ProfitCenter,
      I_MRPController.UserID,

      /* Associations */
      I_MRPController._BusinessArea,
      I_MRPController._Plant,
      I_MRPController._PurchasingGroup,
      I_MRPController._User
}