P_SFIAtOpActyPlndMatlRetQts

SFI at OA Planned Material Return with Quantities | view: PMPESFIOAPLDRETQ | Extraction: Not supported | Component: Shop Floor Execution
Tables used: MPE_COMP_ASSEMBL, MPE_COMP_OAI, MPE_SFI_STATUS, JEST, RESB, T418, MARC, T377P, TCS03, T377
Column Name Description
ShopFloorItem ID of Serialized Material
OpActyNtwkInstance 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 Returned 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
MaterialIsCoProduct Indicator: co-product Show values
MatlCompIsMarkedForBackflush Boolean Variable (X = True, - = False, Space = Unknown) Show values
GoodsMovementIsAllowed Goods movement for reservation allowed 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
PlannedInventoryUsabilityCode Stock Type Show values
SerialNumberIsRqdForGoodsIssue Boolean Variable (X = True, - = False, Space = Unknown) Show values
StockCheckMessageType Stock Check for Serial Numbers Show values
IsBatchManagementRequired Batch Management Requirement Indicator for Plant Show values
MatlCompAssembleControl Component Assembly Control for Shop Floor Order Show values
IsBulkMaterialComponent Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
ProductionPlant Plant WERKS
ManufacturingOrderItem Order item number CO_POSNR
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
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
BillOfMaterialVersion BOM Version CS_VERSN
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_SFIATOPACTYPLNDMATLRETQTS.BASEUNIT == T006.MSEHI
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T006.MANDT
Bill of Material Item Category
  • Client
  • Bill of Material Item Category
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T418.MANDT
  • P_SFIATOPACTYPLNDMATLRETQTS.BOMITEMCATEGORY == T418.POSTP
Formula Key for Variable-Size Items
  • Client
  • Formula Key for Variable-Size Items
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T418F.MANDT
  • P_SFIATOPACTYPLNDMATLRETQTS.FORMULAKEY == T418F.RFORM
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • P_SFIATOPACTYPLNDMATLRETQTS.MANUFACTURINGORDER == AUFK.AUFNR
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == MARA.MANDT
  • P_SFIATOPACTYPLNDMATLRETQTS.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Plant
  • Client
  • P_SFIATOPACTYPLNDMATLRETQTS.PLANT == T001W.WERKS
  • P_SFIATOPACTYPLNDMATLRETQTS.PRODUCTIONPLANT == T001W.WERKS
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T001W.MANDT
Serial Number Profile
  • Client
  • Serial Number Profile
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T377P.MANDT
  • P_SFIATOPACTYPLNDMATLRETQTS.SERIALNUMBERPROFILE == T377P.SERAIL
Storage Location
  • Storage Location
  • Plant
  • Plant
  • Client
  • P_SFIATOPACTYPLNDMATLRETQTS.STORAGELOCATION == T001L.LGORT
  • P_SFIATOPACTYPLNDMATLRETQTS.PLANT == T001L.WERKS
  • P_SFIATOPACTYPLNDMATLRETQTS.PRODUCTIONPLANT == T001L.WERKS
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T001L.MANDT
Unit of Measure for Variable-Size Components
  • Unit of Measure for Variable-Size Components
  • Client
  • P_SFIATOPACTYPLNDMATLRETQTS.VARIABLESIZECOMPONENTUNIT == T006.MSEHI
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T006.MANDT
Unit of measure for sizes 1 to 3
  • Unit of measure for sizes 1 to 3
  • Client
  • P_SFIATOPACTYPLNDMATLRETQTS.VARIABLESIZEDIMENSIONUNIT == T006.MSEHI
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T006.MANDT
Unit of measure for variable-size items
  • Client
  • Unit of measure for variable-size items
  • P_SFIATOPACTYPLNDMATLRETQTS.MANDT == T006.MANDT
  • P_SFIATOPACTYPLNDMATLRETQTS.VARIABLESIZEITEMUNIT == T006.MSEHI