P_ShopFloorItemAtOpActyComp

SFI Planned Component at OA, Incl. Unplanned Assemblies | view: PMPESFIATOAC | 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
Reservation Number of reservation/dependent requirements
ReservationItem Item Number of Reservation / Dependent Requirements
RecordType Record type
Material FK Material Number
Plant FK Plant
Column Name Description
Column Name Description
MaterialComponentQuantity Consumed Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry with leading sign
📏 Unit of measure for sizes 1 to 3 (VariableSizeDimensionUnit):
VariableSizeDimension1 Size 1
VariableSizeDimension2 Size 2
VariableSizeDimension3 Size 3
📏 Unit of Measure for Variable-Size Components (VariableSizeComponentUnit):
VariableSizeComponentQuantity Variable-Size Item Quantity per PC
Column Name Description
Column Name Description
IsBulkMaterialComponent Indicator: bulk material Show values
GoodsMovementIsAllowed Goods movement for reservation allowed Show values
MatlCompIsMarkedForBackflush Boolean Variable (X = True, - = False, Space = Unknown) Show values
MatlCompDiscontinuationType Discontinuation Type Show values
MaterialCompIsVariableSized Variable-Sized Item Indicator Show values
BillOfMaterialCategory Bill of Material Category Code Show values
MfgRefStrucItmDetIsContextual Checkbox Show values
MatlCompInstceAssyIsRequired Instance assembly required Show values
Column Name Description Domain name
ProductionPlant Production Plant WERKS
AssemblySequenceNumber Assembly Sequence for the Components NUMC4
MfgOrderComponentUsageQuantity Usage quantity per order unit of measure ESMNG
MfgOrderComponentUsageNetQty Usage quantity per order unit of measure ESMNG
RequiredQuantity Usage quantity per order unit of measure ESMNG
RelatedReservation Number of reservation/dependent requirements RSNUM
RelatedReservationItem Item Number of Reservation / Dependent Requirements RSPOS
RelatedRecordType Record type RSART
RelatedOpActyNtwkInstance Operation Activity Network: Instance ID
RelatedOpActyNtwkElement Internal OAN Element Number
LeadingReservation Number of reservation/dependent requirements RSNUM
LeadingReservationItem Item Number of Reservation / Dependent Requirements RSPOS
LeadingReservationRecordType Record type RSART
LeadingOpActyNtwkInstance Operation Activity Network: Instance ID
LeadingOpActyNtwkElement Internal OAN Element Number
BillOfMaterial Bill of Material STNUM
BOMItem Bill of Material Item KNTNR
BOMItemInternalChangeCount Internal counter CIM_COUNT
BOOOpBOMItemInternalID No. for material comp. allocation to task list KNTNR
LogicalComponent Identifies a Logical Component MPE_LOG_COMP_COUNTER
MfgRefStrucBOMLeafAssgmtUUID MRS: Leaf Assignment UUID UUID
MfgRefStructureItemDetailUUID Technical UUID of MRS Item UUID
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_SHOPFLOORITEMATOPACTYCOMP.BASEUNIT == T006.MSEHI
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T006.MANDT
Bill of Material Item Category
  • Client
  • Bill of Material Item Category
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T418.MANDT
  • P_SHOPFLOORITEMATOPACTYCOMP.BOMITEMCATEGORY == T418.POSTP
Formula Key for Variable-Size Items
  • Formula Key for Variable-Size Items
  • Client
  • P_SHOPFLOORITEMATOPACTYCOMP.FORMULAKEY == T418F.RFORM
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T418F.MANDT
Material Number
  • Client
  • Material Number
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == MARA.MANDT
  • P_SHOPFLOORITEMATOPACTYCOMP.MATERIAL == MARA.MATNR
Plant
  • Production Plant
  • Plant
  • Client
  • P_SHOPFLOORITEMATOPACTYCOMP.PRODUCTIONPLANT == T001W.WERKS
  • P_SHOPFLOORITEMATOPACTYCOMP.PLANT == T001W.WERKS
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T001W.MANDT
Storage Location
  • Production Plant
  • Plant
  • Client
  • Storage Location
  • P_SHOPFLOORITEMATOPACTYCOMP.PRODUCTIONPLANT == T001L.WERKS
  • P_SHOPFLOORITEMATOPACTYCOMP.PLANT == T001L.WERKS
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T001L.MANDT
  • P_SHOPFLOORITEMATOPACTYCOMP.STORAGELOCATION == T001L.LGORT
Unit of Measure for Variable-Size Components
  • Unit of Measure for Variable-Size Components
  • Client
  • P_SHOPFLOORITEMATOPACTYCOMP.VARIABLESIZECOMPONENTUNIT == T006.MSEHI
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T006.MANDT
Unit of measure for sizes 1 to 3
  • Unit of measure for sizes 1 to 3
  • Client
  • P_SHOPFLOORITEMATOPACTYCOMP.VARIABLESIZEDIMENSIONUNIT == T006.MSEHI
  • P_SHOPFLOORITEMATOPACTYCOMP.MANDT == T006.MANDT