I_MFGORDERDEFECTRECORD

CDS View

Notification and defect

I_MFGORDERDEFECTRECORD is a CDS View in S/4HANA. Notification and defect. It contains 65 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 65 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MfgOrderDefect view from CONSUMPTION Defect and notification
C_ShopFloorOrderDefect view from CONSUMPTION Defects for Shop Floor Order

Fields (65)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 2
KEY NotificationItem NotificationItem 2
_CreatedByUserContactCard _CreatedByUserContactCard 2
_DefectCategory _DefectCategory 2
_DefectCode _DefectCode 2
_DefectCodeCatalog _DefectCodeCatalog 2
_DefectCodeGroup _DefectCodeGroup 2
_DefectDecisionVH _DefectDecisionVH 2
_DefectStatus _DefectStatus 2
_InspectionLot _InspectionLot 2
_LastChangedByUserContactCard _LastChangedByUserContactCard 2
_Notification _Notification 2
_NotifProcessingPhase _NotifProcessingPhase 2
_OpActyNtwkInstance _OpActyNtwkInstance 1
_ProducedMaterial _ProducedMaterial 1
Batch Batch 1
BatchBySupplier BatchBySupplier 2
BOMItemInstanceUUID BOMItemInstanceUUID 2
ChangedDateTime ChangedDateTime 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
Defect Defect 2
DefectCategory DefectCategory 2
DefectCode DefectCode 2
DefectCodeCatalog DefectCodeCatalog 2
DefectCodeGroup DefectCodeGroup 2
DefectIsCreatedAutomatically DefectIsCreatedAutomatically 2
DefectiveQuantity DefectiveQuantity 2
DefectiveQuantityUnit DefectiveQuantityUnit 2
DefectiveSingleUnit DefectiveSingleUnit 2
DefectLifecycleStatus DefectLifecycleStatus 2
DefectText DefectText 2
Equipment Equipment 1
InspectionCharacteristic InspectionCharacteristic 2
InspectionLot InspectionLot 2
InspectionSubsetInternalID InspectionSubsetInternalID 1
InspPlanOperationInternalID InspPlanOperationInternalID 1
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
MainWorkCenter MainWorkCenter 2
MainWorkCenterPlant MainWorkCenterPlant 2
ManufacturerSerialNumber ManufacturerSerialNumber 2
Material Material 2
MfgDefectDecision MfgDefectDecision 2
MfgDefectDecisionName MfgDefectDecisionName 2
Notification Notification 2
NotificationText NotificationText 2
NotificationType NotificationType 2
NotifProcessingPhase NotifProcessingPhase 2
OpActyNtwkElement OpActyNtwkElement 2
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 2
OpActyNtwkInstance OpActyNtwkInstance 2
OrderInternalID OrderInternalID 1
Plant Plant 2
ProducedMaterial ProducedMaterial 2
ProducedSerialNumber ProducedSerialNumber 2
ProductionOrder ProductionOrder 2
ProductionOrderOpActyVers ProductionOrderOpActyVers 2
ProductionOrderOperationActy ProductionOrderOperationActy 2
ShopFloorItem ShopFloorItem 1
WorkCenterInternalID MainWorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 1 
@AbapCatalog.sqlViewName: 'IMFGORDDEFREC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Notification and defect'
@VDM.viewType: #COMPOSITE
@ObjectModel: {
    usageType: {
        dataClass: #MIXED,
        sizeCategory: #XL,
        serviceQuality: #D }
}
define view I_MfgOrderDefectRecord
  as select from           P_MfgOrderDefect  as NotificationItem
    left outer to one join I_Equipment       as Equipment on  NotificationItem.Material     = Equipment.Material
                                                          and NotificationItem.SerialNumber = Equipment.SerialNumber
    left outer to one join I_BatchCrossPlant as Batch     on  NotificationItem.Material = Batch.Material
                                                          and NotificationItem.Batch    = Batch.Batch
  //    left outer to one join P_OpActyComponentMRS         as OpActyComponentMRS         on  NotificationItem.OpActyNtwkInstance = OpActyComponentMRS.OpActyNtwkInstance

  //                                                                                      and NotificationItem.OpActyNtwkElement  = OpActyComponentMRS.OpActyNtwkElement

  //                                                                                      and NotificationItem.ShopFloorItem      = OpActyComponentMRS.ParentShopFloorItem

  //                                                                                      and NotificationItem.Material           = OpActyComponentMRS.Material

  //    left outer to one join I_MfgRefStrucItemWithDetails as MfgRefStrucItemWithDetails on  OpActyComponentMRS.MfgRefStructureItemDetailUUID = MfgRefStrucItemWithDetails.MfgRefStructureItemUUID

  //                                                                                      and OpActyComponentMRS.MfgRefStrucItmDetIsContextual = ''

  //    left outer to one join I_MfgRefHierItemWithDetails  as MfgRefHierItemWithDetails  on  OpActyComponentMRS.MfgRefStructureItemDetailUUID = MfgRefHierItemWithDetails.MfgRefHierarchyItemUUID

  //                                                                                      and OpActyComponentMRS.MfgRefStrucItmDetIsContextual = 'X'

  //    left outer to one join I_OpActyCompInstceAssignment as OpActyCompInstceAssignment on  OpActyComponentMRS.Reservation       = OpActyCompInstceAssignment.Reservation

  //                                                                                      and OpActyComponentMRS.ReservationItem   = OpActyCompInstceAssignment.ReservationItem

  //                                                                                      and OpActyComponentMRS.RecordType        = OpActyCompInstceAssignment.RecordType

  //                                                                                      and NotificationItem.BOMItemInstanceUUID = OpActyCompInstceAssignment.DgtlMockUpCharcsUUID


  association [0..1] to I_InspectionLot as _InspectionLot on $projection.InspectionLot = _InspectionLot.InspectionLot
{
  key NotificationItem.DefectInternalID,
  key NotificationItem.NotificationItem,
      NotificationItem.Notification,
      NotificationItem.Defect,
      NotificationItem.DefectCategory,
      NotificationItem.NotificationType,
      NotificationItem.CreatedByUser,
      NotificationItem.CreationDate,
      NotificationItem.LastChangedByUser,
      NotificationItem.LastChangeDate,
      NotificationItem.DefectText,
      NotificationItem.NotificationText,
      NotificationItem.DefectCodeCatalog,
      NotificationItem.DefectCodeGroup,
      NotificationItem.DefectCode,
      NotificationItem.DefectiveQuantity,
      NotificationItem.DefectiveQuantityUnit,
      NotificationItem.DefectIsCreatedAutomatically,
      NotificationItem.ProductionOrderOperationActy,
      NotificationItem.ProductionOrderOpActyVers,
      NotificationItem.OpActyNtwkElementExternalID,
      NotificationItem.OpActyNtwkInstance,
      NotificationItem.OpActyNtwkElement,
      NotificationItem.ProductionOrder,
      NotificationItem.OrderInternalID,
      NotificationItem.CreationTime,
      NotificationItem.LastChangeTime,
      NotificationItem.InspPlanOperationInternalID,
      NotificationItem.InspectionCharacteristic,
      NotificationItem.InspectionSubsetInternalID,
      NotificationItem.DefectiveSingleUnit,
      NotificationItem.ProducedMaterial,
      NotificationItem.ProducedSerialNumber,
      NotificationItem.Batch,
      NotificationItem.ShopFloorItem,
      case
        when NotificationItem.Defect is initial then
            Equipment.Equipment
        else
            NotificationItem.Equipment
      end                                as Equipment,
      NotificationItem.IsDeleted,
      NotificationItem.Material,
      NotificationItem.Plant,
      NotificationItem.InspectionLot,
      NotificationItem.ChangedDateTime,
      NotificationItem.NotifProcessingPhase,
      NotificationItem.DefectLifecycleStatus,
      NotificationItem.BOMItemInstanceUUID,
      NotificationItem.WorkCenterTypeCode,
      NotificationItem.WorkCenterInternalID,
      NotificationItem.MainWorkCenter,
      NotificationItem.MainWorkCenterPlant,
      NotificationItem.MfgDefectDecision,
      NotificationItem.MfgDefectDecisionName,
      @ObjectModel.readOnly: true
      Batch.BatchBySupplier,
      @ObjectModel.readOnly: true
      Equipment.ManufacturerSerialNumber as ManufacturerSerialNumber,
      //      @ObjectModel.readOnly: true

      //      case OpActyComponentMRS.MfgRefStrucItmDetIsContextual

      //        when 'X' then MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName

      //        else MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName

      //      end                                as MfgRefStrucItmRefDsgntrName,

      //

      //      case OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual

      //      when 'X' then case

      //       when OpActyCompInstceAssignment._MfgRefHierItemWithDetails.MfgRefStrucItmRefDesignator <> ''

      //       and  OpActyCompInstceAssignment._MfgRefHierItemWithDetails.MfgRefStrucItmRefDesignator is not null

      //       then OpActyCompInstceAssignment._MfgRefHierItemWithDetails.MfgRefStrucItmRefDesignator

      //       else OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue

      //      end

      //      else case

      //       when OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDesignator <> ''

      //       and  OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDesignator is not null

      //       then OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDesignator

      //       else OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue

      //      end

      //      end as ReferenceDesignatorValue,


      /* Associations */
      NotificationItem._CreatedByUserContactCard,
      NotificationItem._DefectCode,
      NotificationItem._DefectCodeCatalog,
      NotificationItem._DefectCodeGroup,
      NotificationItem._DefectStatus,
      NotificationItem._LastChangedByUserContactCard,
      NotificationItem._ProducedMaterial,
      NotificationItem._OpActyNtwkInstance,
      NotificationItem._NotifProcessingPhase,
      NotificationItem._Notification,
      NotificationItem._DefectCategory,
      NotificationItem._DefectDecisionVH,
      _InspectionLot
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BATCHCROSSPLANT",
"I_EQUIPMENT",
"P_MFGORDERDEFECT"
],
"ASSOCIATED":
[
"I_DEFECTCATEGORY",
"I_DEFECTSTATUS",
"I_INSPECTIONCATALOG",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_INSPECTIONLOT",
"I_MFGDEFECTDECISION",
"I_NOTIFICATION",
"I_NOTIFPROCESSINGPHASE",
"I_OPACTYNTWKINSTANCE",
"I_PRODUCT",
"I_USERCONTACTCARD"
],
"BASE":
[
"P_MFGORDERDEFECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More