C_OperationActivityPlndMatlRet

Operation Activity Component | view: CMPEOAPLNDMATRET | Extraction: Not supported | Component: Shop Floor Execution
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 of Component
Plant FK Plant
Column Name Description
Column Name Description
📏 Unit of entry (EntryUnit):
MfgOrderComponentUsageQuantity Usage Quantity per Order Unit of Measure
RequiredQuantity Requirement Quantity of Component
MaterialComponentQuantity Returned Quantity
📏 Base Unit of Measure (BaseUnit):
RequiredQuantityInBaseUnit Planned Quantity in Base Unit of Measure
ResvnItmWithdrawnQtyInBaseUnit Returned Quantity in Base Unit of Measure
📏 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
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
MatlCompIsMarkedForBackflush Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsBulkMaterialComponent 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
MatlCompAssembleControl Component Assembly Control for Shop Floor Order Show values
CompDisassemblyPermanence Permanence of Disassembly 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
ManufacturingOrder Order number AUFNR
ProductionPlant Plant
MaterialName Material Description TEXT40
AssemblySequenceNumber Assembly Sequence for the Components NUMC4
ComponentAssemblyCriticality null
VarblSizeCompFrmtdFormulaVal Variable-Size Item Formula TEXT128
MatlCompAssembleControlName Short Text for Fixed Values DDTEXT
CompDisassemblyPermanenceName Short Text for Fixed Values DDTEXT
BillOfMaterialItemCategoryDesc Item Category Description TEXT30
MfgRefStrucItmRefDesignator ID of Manufacturing Reference Structure Designator MPE_MRS_DESIGNATOR
MfgRefStrucItmRefDsgntrDesc Description of Manufacturing Reference Structure Designator TEXT100
MfgRefStrucItmRefDsgntrName Manufacturing Reference Structure Designator TEXT100
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
BOMItem Bill of Material Item KNTNR
BOMItemInternalChangeCount Internal counter CIM_COUNT
BillOfOperationsType Task List Type PLNTY
BillOfOperationsGroup Key for Task List Group PLNNR
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
OperationActivity Identifies an Operation Activity MPE_OAN_ELEMENT_ID
OperationActyVersionCounter Number of an Operation Actiivity Version
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT
  • C_OPERATIONACTIVITYPLNDMATLRET.BASEUNIT == T006.MSEHI
Bill of Material Item Category
  • Bill of Material Item Category
  • Client
  • C_OPERATIONACTIVITYPLNDMATLRET.BOMITEMCATEGORY == T418.POSTP
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T418.MANDT
Formula Key for Variable-Size Items
  • Formula Key for Variable-Size Items
  • Client
  • C_OPERATIONACTIVITYPLNDMATLRET.FORMULAKEY == T418F.RFORM
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T418F.MANDT
Material Number of Component
  • Material Number of Component
  • Client
  • C_OPERATIONACTIVITYPLNDMATLRET.MATERIAL == MARA.MATNR
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • Plant
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T001W.MANDT
  • C_OPERATIONACTIVITYPLNDMATLRET.PRODUCTIONPLANT == T001W.WERKS
  • C_OPERATIONACTIVITYPLNDMATLRET.PLANT == T001W.WERKS
Serial Number Profile
  • Client
  • Serial Number Profile
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T377P.MANDT
  • C_OPERATIONACTIVITYPLNDMATLRET.SERIALNUMBERPROFILE == T377P.SERAIL
Storage Location
  • Client
  • Plant
  • Plant
  • Storage Location
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T001L.MANDT
  • C_OPERATIONACTIVITYPLNDMATLRET.PRODUCTIONPLANT == T001L.WERKS
  • C_OPERATIONACTIVITYPLNDMATLRET.PLANT == T001L.WERKS
  • C_OPERATIONACTIVITYPLNDMATLRET.STORAGELOCATION == T001L.LGORT
Unit of Measure for Variable-Size Components
  • Client
  • Unit of Measure for Variable-Size Components
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT
  • C_OPERATIONACTIVITYPLNDMATLRET.VARIABLESIZECOMPONENTUNIT == T006.MSEHI
Unit of measure for sizes 1 to 3
  • Client
  • Unit of measure for sizes 1 to 3
  • C_OPERATIONACTIVITYPLNDMATLRET.MANDT == T006.MANDT
  • C_OPERATIONACTIVITYPLNDMATLRET.VARIABLESIZEDIMENSIONUNIT == T006.MSEHI