I_MFGORDERDEFECTRECORD

CDS View
70 Fields 2 CDS Views

Notification and defect

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

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 (70)

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
_DefectCodeText _DefectCodeText 1
_DefectDecisionVH _DefectDecisionVH 2
_DefectStatus _DefectStatus 2
_InspectionLot _InspectionLot 2
_LastChangedByUserContactCard _LastChangedByUserContactCard 2
_Notification _Notification 2
_NotifProcessingPhase _NotifProcessingPhase 2
_ProducedMaterial _ProducedMaterial 1
Batch Batch 1
BatchBySupplier BatchBySupplier 2
BillOfMaterialCategory BillOfMaterialCategory 2
BillOfMaterialInternalID BillOfMaterialInternalID 2
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 2
BillOfMaterialVariant BillOfMaterialVariant 2
BOMItemInstanceUUID BOMItemInstanceUUID 2
BOMItemInternalChangeCount BOMItemInternalChangeCount 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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Notification and defect
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDERDEFECTRECORD (
    DEFECTINTERNALID,
    NOTIFICATIONITEM,
    _CREATEDBYUSERCONTACTCARD,
    _DEFECTCATEGORY,
    _DEFECTCODE,
    _DEFECTCODECATALOG,
    _DEFECTCODEGROUP,
    _DEFECTCODETEXT,
    _DEFECTDECISIONVH,
    _DEFECTSTATUS,
    _INSPECTIONLOT,
    _LASTCHANGEDBYUSERCONTACTCARD,
    _NOTIFICATION,
    _NOTIFPROCESSINGPHASE,
    _PRODUCEDMATERIAL,
    BATCH,
    BATCHBYSUPPLIER,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALVARIANT,
    BOMITEMINSTANCEUUID,
    BOMITEMINTERNALCHANGECOUNT,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECT,
    DEFECTCATEGORY,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTISCREATEDAUTOMATICALLY,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTTEXT,
    EQUIPMENT,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERPLANT,
    MANUFACTURERSERIALNUMBER,
    MATERIAL,
    MFGDEFECTDECISION,
    MFGDEFECTDECISIONNAME,
    NOTIFICATION,
    NOTIFICATIONTEXT,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    OPACTYNTWKELEMENT,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    PLANT,
    PRODUCEDMATERIAL,
    PRODUCEDSERIALNUMBER,
    PRODUCTIONORDER,
    PRODUCTIONORDEROPACTYVERS,
    PRODUCTIONORDEROPERATIONACTY,
    SHOPFLOORITEM,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECTINTERNALID, NOTIFICATIONITEM)
);

Learn More