I_SFIOpActyInspCharcsAggrg

Insp Chars for SFI in MFG Order | view: ISFIOPACTYPIC | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
ShopFloorItem ID of Serialized Material
OrderOperationInternalID General counter for order
InspectionCharacteristic Inspection Characteristic Number
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty Manufacturing Order Planned Total Quantity
Column Name Description
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded Show values
InspSpecIsQuantitative Is Quantitative Characteristic Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecIsSelectedSetRequired Reference to Characteristic Attribute Required Show values
InspSpecRecordingType Recording Type Show values
InspSpecHasControlChart SPC Characteristic Show values
Column Name Description Domain name
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Operation Short Text TEXT40
OpActyNtwkElementElement Identifies an Operation Activity Network Element MPE_OAN_ELEMENT_ID
OpActyNtwkElementElmntVersCntr Number of the Operation Activity Network Element Version
OpActyNtwkInstance Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
OpActyNtwkElementExternalID Operation Activity Number MPE_OAN_ELEMENT_NUMBER_EXT
OperationActivityName Operation Activity Description MPE_OAN_OBJECT_DESCRIPTION
ManufacturingOrder Manufacturing Order ID AUFNR
InspectionLot Inspection Lot Number QPLOS
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspectionResultText Inspection Description for Sample Result QKURZTEXT
OpActyCharacteristicItem Characteristic Item Number MPE_ITEM_NO
OpActyCharcDivnSqnc Division Sequence Number MPE_SEQUENCE_NO
OpActyCharcGrpSqnc Group Column Number MPE_SEQUENCE_NO
InspCharcGrpDesc Characteristic Group Description TEXT40
InspCharcGrpDivnDesc Division Description TEXT40
ReferenceDesignatorValue Reference Designator CHAR128
Master Data Relations Join Conditions
Master Inspection Characteristic
  • Client
  • Master Inspection Characteristic
  • ?
  • ?
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == QPMK.MANDT
  • I_SFIOPACTYINSPCHARCSAGGRG.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • I_SFIOPACTYINSPCHARCSAGGRG.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • I_SFIOPACTYINSPCHARCSAGGRG.[column in domain "QZAEHLER"] == QPMK.ZAEHLER
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == T006.MANDT
  • I_SFIOPACTYINSPCHARCSAGGRG.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Manufacturing Order Type
  • Manufacturing Order Type
  • Client
  • I_SFIOPACTYINSPCHARCSAGGRG.MANUFACTURINGORDERTYPE == T003O.AUART
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == T003O.CLIENT
Material Number
  • Client
  • Material Number
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == MARA.MANDT
  • I_SFIOPACTYINSPCHARCSAGGRG.MATERIAL == MARA.MATNR
Production Plant
  • Client
  • Production Plant
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == T001W.MANDT
  • I_SFIOPACTYINSPCHARCSAGGRG.PRODUCTIONPLANT == T001W.WERKS
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • I_SFIOPACTYINSPCHARCSAGGRG.PRODUCTIONUNIT == T006.MSEHI
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == T006.MANDT
SPC Criterion
  • Client
  • SPC Criterion
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == QPSP.MANDT
  • I_SFIOPACTYINSPCHARCSAGGRG.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • I_SFIOPACTYINSPCHARCSAGGRG.MANDT == T006.MANDT
  • I_SFIOPACTYINSPCHARCSAGGRG.QUANTITYUNIT == T006.MSEHI