P_MFGPROCGEXECBATCH

CDS View

MPE Batch

P_MFGPROCGEXECBATCH is a CDS View in S/4HANA. MPE Batch. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgProcgExecBatch view from COMPOSITE Batch in Manufacturing Processing Execution

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY Material Material 1
KEY Plant Plant 1 
@AbapCatalog.sqlViewName: 'PMPEBATCH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true

// Preselct all batches (Plant and CrossPlant)

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view P_MfgProcgExecBatch as

  select from I_BatchCrossPlant as mch1
  association [0..1] to I_Plant as _Plant on  $projection.Plant = _Plant.Plant
{
      @ObjectModel.foreignKey.association: '_Plant'
  key cast('    ' as werks_d preserving type) as Plant,
      @ObjectModel.foreignKey.association: '_Material'
  key mch1.Material,
  key mch1.Batch,
  
      '1' as DefinitionOfBatchLevel, 
      
      // Associations

      _Plant,
      _Material
} 
where mch1.BatchIsMarkedForDeletion    = ' '
  and mch1.MatlBatchIsInRstrcdUseStock = ' '
  
union all

  select from I_BatchPlant as mchb
{
      @ObjectModel.foreignKey.association: '_Plant'
  key mchb.Plant,
      @ObjectModel.foreignKey.association: '_Material'
  key mchb.Material,
  key mchb.Batch,
  
      '0' as DefinitionOfBatchLevel,

      // Associations

      _Plant,
      _Material
}
where mchb.BatchIsMarkedForDeletion    = ' '
  and mchb.MatlBatchIsInRstrcdUseStock = ' ';

Learn More