I_OperationActivityPlndMatlRet

Operation Activity Planned Material Return | view: IMPEOAPLNDMATRET | Extraction: Not supported | Component: Shop Floor Execution
Tables used: MPE_COMP_OAIRESBTCS03
Column Name Description
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
📏 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
IsBulkMaterialComponent Boolean Variable (X = True, - = False, Space = Unknown) 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
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
OrderInternalID Routing number of operations in the order AUFPL
OrderOperationInternalID Internal counter CIM_COUNT
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
BillOfMaterialInternalID Bill of Material STNUM
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
  • I_OPERATIONACTIVITYPLNDMATLRET.BASEUNIT == T006.MSEHI
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT
Bill of Material Item Category
  • Bill of Material Item Category
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.BOMITEMCATEGORY == T418.POSTP
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T418.MANDT
Formula Key for Variable-Size Items
  • Client
  • Formula Key for Variable-Size Items
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T418F.MANDT
  • I_OPERATIONACTIVITYPLNDMATLRET.FORMULAKEY == T418F.RFORM
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.MANUFACTURINGORDER == AUFK.AUFNR
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == AUFK.MANDT
Material Number
  • Material Number
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.MATERIAL == MARA.MATNR
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == MARA.MANDT
Plant
  • Plant
  • Plant
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.PLANT == T001W.WERKS
  • I_OPERATIONACTIVITYPLNDMATLRET.PRODUCTIONPLANT == T001W.WERKS
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T001W.MANDT
Storage Location
  • Storage Location
  • Plant
  • Plant
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.STORAGELOCATION == T001L.LGORT
  • I_OPERATIONACTIVITYPLNDMATLRET.PLANT == T001L.WERKS
  • I_OPERATIONACTIVITYPLNDMATLRET.PRODUCTIONPLANT == T001L.WERKS
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T001L.MANDT
Unit of Measure for Variable-Size Components
  • Client
  • Unit of Measure for Variable-Size Components
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT
  • I_OPERATIONACTIVITYPLNDMATLRET.VARIABLESIZECOMPONENTUNIT == T006.MSEHI
Unit of measure for sizes 1 to 3
  • Unit of measure for sizes 1 to 3
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.VARIABLESIZEDIMENSIONUNIT == T006.MSEHI
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT
Unit of measure for variable-size items
  • Unit of measure for variable-size items
  • Client
  • I_OPERATIONACTIVITYPLNDMATLRET.VARIABLESIZEITEMUNIT == T006.MSEHI
  • I_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT