C_ShopFloorItemAtOpActy

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
📏 Operation Activity Unit of Measure (ProductionUnit):
ConfirmationScrapQuantity Total Scrap Quantity Confirmed
ConfirmationSkippedQuantity Total Skipped Quantity Confirmed
ConfirmationYieldQuantity Total Confirmed Yield
Column Name Description
Column Name Description
OperationIsReworkOperation Indicator: Rework operation Show values
OpActyNtwkSegmentType OA Segment Type (Setup, Produce, or Teardown) Show values
SASStatusCategory Status Category Show values
SASStatusCriticality Level of Status Criticality Show values
OpActyIsSeldForRtactvPostg Retroactive Processing Show values
AssemblySqncCheckIsRequired Assembly Sequence for Components Required Show values
OpActyChgAlertAcknIsRequired Boolean Variable (X = True, - = False, Space = Unknown) Show values
MfgBuyOffCycleIsExisting Boolean Variable (X = True, - = False, Space = Unknown) Show values
OpActyHasMandatoryComponents Boolean Variable (X = True, - = False, Space = Unknown) Show values
MfgWorkInstructionMode Work Instruction mode 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
BillOfMaterialCategory Bill of Material Category Code Show values
ProdnProcgIsFlexible Processing Mode Show values
Column Name Description Domain name
SerialNumber Serial Number GERNR
ShopFloorItemExternalID Shop Floor Item Number (External Identifier)
ManufacturingOrder Order Number AUFNR
ManufacturingOrderItem Order item number CO_POSNR
ManufacturingOrderOperation Operation
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
OrderInternalID Routing number of operations in the order AUFPL
OrderOperationInternalID General counter for order CO_APLZL
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OperationActivityName Operation Activity Description MPE_OAN_OBJECT_DESCRIPTION
SASStatusName Serial Number Status Description MPE_OBJECT_DESCRIPTION_TYPE
OpActyExpdExecDurnInSeconds Expected Execution Time of an Operation Activity (Seconds)
OpActyExpdExecLaborDurnInSecs Expected Labor Time (s) to Execute an Operation Activity
Material Material Number MATNR
MaterialName Material Description TEXT40
OpActyNtwkSegmentTypeText OA Segment Type Name (Setup, Produce, or Teardown) TEXT60
OperationActivity Identifies an Operation Activity Network Element MPE_OAN_ELEMENT_ID
OperationActyVersionCounter Number of the Operation Activity Network Element Version
OriginalChgAlertCount Change Alert Count MPE_CA_COUNT
WorkCenterTypeCode null
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
Quantity null
WorkInstruction Work Instruction ID MPE_WI_ID
WorkInstructionVersionCounter Work Instruction Version No MPE_WI_VERSION_NO
MfgWorkInstructionContent Work Instruction Content MPE_WI_CONT
BillOfMaterial Bill of Material
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialVersion BOM Version CS_VERSN
BillOfOperationsType Bill of Operations Type PLNTY
BillOfOperations Bill of Operations ID PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterialHeaderUUID Global identification of a BOM header change status SYSUUID
PhysicalDocument Physical document SDOK_DOCID
DocumentInfoRecordDocType Document Type DOKAR
DocumentInfoRecordDocNumber Document number DOKNR
DocumentInfoRecordDocPart Document Part DOKTL
DocumentInfoRecordDocVersion Document Version DOKVR
InspectionLot Inspection Lot Number QPLOS
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
ProductConfiguration Product Configuration CUOBJ
ProdnProcgFlexibilityIndName Short Text for Fixed Values DDTEXT
EffectivityParameterDesc Effectivity Parameter Description CHAR256
EffctyTypeCnctntdParamDesc Listing of the Effectivity Type Parameters CHAR256
Equipment Equipment Number EQUNR
Master Data Relations Join Conditions
BOM Usage
  • BOM Usage
  • Client
  • C_SHOPFLOORITEMATOPACTY.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
  • C_SHOPFLOORITEMATOPACTY.MANDT == T416.MANDT
Production Plant
  • Production Plant
  • Plant
  • Client
  • C_SHOPFLOORITEMATOPACTY.ORDERHEADERPRODUCTIONPLANT == T001W.WERKS
  • C_SHOPFLOORITEMATOPACTY.PRODUCTIONPLANT == T001W.WERKS
  • C_SHOPFLOORITEMATOPACTY.MANDT == T001W.MANDT
Plant
  • Production Plant
  • Plant
  • Client
  • C_SHOPFLOORITEMATOPACTY.ORDERHEADERPRODUCTIONPLANT == T001W.WERKS
  • C_SHOPFLOORITEMATOPACTY.PRODUCTIONPLANT == T001W.WERKS
  • C_SHOPFLOORITEMATOPACTY.MANDT == T001W.MANDT
Status and Action Schema
  • Status and Action Schema
  • Client
Serial Number Status
  • Serial Number Status
  • Client
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • C_SHOPFLOORITEMATOPACTY.WORKCENTERINTERNALID == CRID.OBJID
  • C_SHOPFLOORITEMATOPACTY.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_SHOPFLOORITEMATOPACTY.MANDT == CRID.MANDT