I_ShopFloorItemAtOpActy

Shop Floor Item At Operation Activity | view: IMPESFIATOA | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
ShopFloorItem ID of Serialized Material
OpActyNtwkInstance FK Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SASStatusCategory Status Category Show values
SASStatusCriticality Level of Status Criticality Show values
AssemblySqncCheckIsRequired Assembly Sequence for Components Required Show values
OpActyIsSeldForRtactvPostg Retroactive Processing Show values
OpActyNtwkSegmentType OA Segment Type (Setup, Produce, or Teardown) Show values
OpActyHasAssgdProdnRsceTools Boolean Variable (X = True, - = False, Space = Unknown) Show values
ShopFloorItemProductionStatus Serialized Material Production Status Show values
UserIsLaboredOn Boolean Variable (X = True, - = False, Space = Unknown) Show values
LaborTrackingIsRequired Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
ShopFloorItemExternalID Shop Floor Item Number (External Identifier)
SerialNumber Serial Number GERNR
ManufacturingOrder Order number AUFNR
ManufacturingOrderItem Order item number CO_POSNR
Material Material Number MATNR
OrderInternalID Routing number of operations in the order AUFPL
OrderOperationInternalID General counter for order CO_APLZL
OpActyNtwkVersionCounter Object Version Number
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
WorkCenterTypeCode null
WorkCenter Work Center ARBPL
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OpActyNtwkElementElement Identifies an Operation Activity Network Element MPE_OAN_ELEMENT_ID
OpActyNtwkElementElmntVersCntr Number of the Operation Activity Network Element Version
WorkInstruction Work Instruction ID MPE_WI_ID
WorkInstructionVersionCounter Work Instruction Version No MPE_WI_VERSION_NO
SASStatusName Serial Number Status Description MPE_OBJECT_DESCRIPTION_TYPE
Master Data Relations Join Conditions
Internal Object Identifier
  • Client
  • Internal Object Identifier
  • Object Version Number
  • I_SHOPFLOORITEMATOPACTY.MANDT == MPE_OAN.MANDT
  • I_SHOPFLOORITEMATOPACTY.OPERATIONACTIVITYNETWORK == MPE_OAN.ID
  • I_SHOPFLOORITEMATOPACTY.OPACTYNTWKVERSIONCOUNTER == MPE_OAN.VERSION_NO
Control key
  • Client
  • ?
  • Control key
  • I_SHOPFLOORITEMATOPACTY.MANDT == T430.MANDT
  • I_SHOPFLOORITEMATOPACTY.[column in domain "PLNAW"] == T430.PLNAW
  • I_SHOPFLOORITEMATOPACTY.OPERATIONCONTROLPROFILE == T430.STEUS
Plant
  • Client
  • Plant
  • I_SHOPFLOORITEMATOPACTY.MANDT == T001W.MANDT
  • I_SHOPFLOORITEMATOPACTY.PRODUCTIONPLANT == T001W.WERKS
Status and Action Schema
  • Client
  • Status and Action Schema
Serial Number Status
  • Client
  • Serial Number Status
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • I_SHOPFLOORITEMATOPACTY.MANDT == CRID.MANDT
  • I_SHOPFLOORITEMATOPACTY.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_SHOPFLOORITEMATOPACTY.WORKCENTERINTERNALID == CRID.OBJID