- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Basic Data (PP-BD)
- Capacity Planning and Finite Sequencing (PP-CFS)
- Capacity Requirements Planning (PP-CRP)
- Demand-Driven Replenishment (PP-DD)
- Enterprise Services (PP-ES)
- Fiori UI for Production Planning and Control (PP-FIO)
- Integration with Manufacturing Execution Systems (PP-MES)
- KANBAN (PP-KAB)
- Manufacturing Engineering Cockpit (PP-PEO)
- Material Requirements Planning (PP-MRP)
- Predictive MRP (PP-PMR)
- Production Orders (PP-SFC)
- Production Planning (PP-MP)
- Production Planning for Process Industries (PP-PI)
- Repetitive Manufacturing (PP-REM)
- Virtual Data Model in PP (PP-VDM)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_ProcgExecOperationActivity
Operation Activity
| view: CMPEOAEXEC
| Extraction:
Not supported
| Component: Shop Floor Execution
Tables used:
QAMV, AFKO, MPE_COMP_OAI, MPE_OAC, MPE_OAC_ACTION, MPE_OA_I_SAS_STS, MPE_OAI_LBR_ACTN, MPE_OAN_INSTANCE, MPE_OA_INSTANCE, MPE_PRT_OAI, AFPO, RESB, MPE_SFI_STATUS, AFVC, AFVU, AFVV, T002, T002T, AUFK, MPE_BUYOFF_CYCLE, MARA, MAKT, MPE_QUAL_E_MAT, MPE_OA_QUAL, MPE_QUAL_E_WC, MPE_WI, MPE_WI_CONTENT, MPE_WI_VERSION, MPE_OA_BUYOFF, MPE_OA_CA, MPE_GROUP_T, MPE_OA_WI, MPE_OA, MPE_OAN, MPE_OA_T, T430, CRTX, MPE_SAS_STATUS, MPE_SAS_STATUS_T, CRHD, MPE_OAN_ELEMENT, MPE_OAN_GROUP_EL
- 🔑 Keys (2)
- 💰 Amounts
- ∑ Quantities (7)
- 📅 Dates
- ☰ Categorical (27)
- Other (51)
- 🔗 Relations (7)
Column Name | Description | |
---|---|---|
OpActyNtwkInstance FK | Operation Activity Network: Instance ID | |
OpActyNtwkElement | Internal OAN Element Number |
Column Name | Description |
---|
Column Name | Description | |
---|---|---|
📏 Unit of measure for activity (OperationUnit): | ||
OpPlannedTotalQuantity | Operation Total Quantity | |
📏 Operation Activity Unit of Measure (ProductionUnit): | ||
ConfirmationScrapQuantity | Total Quantity of Scrap Confirmed during Processing | |
ConfirmationSkippedQuantity | Total Skipped Quantity Confirmed | |
ConfirmationYieldQuantity | Total Confirmed Yield | |
OpPlannedYieldQuantity | Operation Activity Expected Yield | |
OpPlannedScrapQuantity | Operation Activity Expected Scrap | |
OperationExecutionAvailableQty | Quantity Available for Execution |
Column Name | Description |
---|
Column Name | Description | |
---|---|---|
OpActyNtwkSegmentType | OA Segment Type (Setup, Produce, or Teardown) | Show values |
OperationIsReworkOperation | Indicator: Rework operation | Show values |
OpActyIsSeldForRtactvPostg | Retroactive Processing | Show values |
SASStatusCategory | Status Category | Show values |
SASStatusCriticality | Level of Status Criticality | Show values |
AssemblySqncCheckIsRequired | Assembly Sequence for Components Required | Show values |
ProdnProcgIsFlexible | Processing Mode | Show values |
OpActyConfIsSFIBased | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyChgAlertAcknIsRequired | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasAssignedComponents | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasAssgdWorkInstructions | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasAssgdProdnRsceTools | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasAssgdInspCharcs | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasMandatoryInspCharcs | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
MfgQualificationIsRequired | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
MfgExecDocReasonCodeIsExisting | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
MfgExecDocNoteIsExisting | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
MfgExecActionLogIsExisting | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasMandatoryComponents | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
MfgBuyOffCycleIsExisting | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
OpActyHasAssgdBuyOffs | Boolean Variable (X = True, - = False, Space = Unknown) | 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 |
MfgWorkInstructionMode | Work Instruction mode | Show values |
ChangeImpactRelevanceFlagIsSet | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | Show values |
OperationActivityIsImpacted | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | Show values |
Column Name | Description | Domain name | |
---|---|---|---|
OANElementDisplaySqncNumber | Position of Element in Operation Activity Network | ||
OpActyNtwkSegmentTypeText | OA Segment Type Name (Setup, Produce, or Teardown) | TEXT60 | |
OpActyNtwkElementExternalID | Element Number | MPE_OAN_ELEMENT_NUMBER_EXT | |
OperationActivityName | Operation Activity Description | MPE_OAN_OBJECT_DESCRIPTION | |
OperationActivityNetworkGroup | Identifies an Operation Activity Network Element | MPE_OAN_ELEMENT_ID | |
OpActyNtwkGroupVersionCounter | Number of the Operation Activity Network Element Version | ||
OpActyNtwkGroupExternalID | Operation Activity Group Number | MPE_OAN_ELEMENT_NUMBER_EXT | |
OpActyNtwkGroupName | Object Description | MPE_OAN_OBJECT_DESCRIPTION | |
ManufacturingOrderOperation | Manufacturing Order Operation | VORNR | |
MfgOrderOperationText | Operation Short Text | TEXT40 | |
OrderInternalID | Routing number of operations in the order | AUFPL | |
OrderOperationInternalID | General counter for order | CO_APLZL | |
WorkCenterTypeCode | null | ||
WorkCenter | Work Center | ARBPL | |
WorkCenterText | Work Center Text | TEXT40 | |
ManufacturingOrder | Order Number | AUFNR | |
Reservation | Number of reservation/dependent requirements | RSNUM | |
StatusAndActionSchema | Status and Action Schema | MPE_OBJECT_NAME_TYPE | |
StatusAndActionSchemaStatus | Operation Activity Status | MPE_OBJECT_NAME_TYPE | |
SASStatusName | Operation Activity Status Description | MPE_OBJECT_DESCRIPTION_TYPE | |
OperationActivity | Identifies an Operation Activity | MPE_OAN_ELEMENT_ID | |
OperationActyVersionCounter | Number of an Operation Actiivity Version | ||
MaterialName | Material Description | TEXT40 | |
ProdnProcgFlexibilityIndName | Short Text for Fixed Values | DDTEXT | |
NumberOfActiveShopFloorItems | null | ||
OriginalChgAlertCount | Change Alert Count | MPE_CA_COUNT | |
OpActyExpdExecDurnInSeconds | Expected Execution Time of an Operation Activity (Seconds) | ||
OpActyExpdExecLaborDurnInSecs | Expected Labor Time (s) to Execute an Operation Activity | ||
BillOfMaterial | Bill of Material | STNUM | |
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 | |
WorkInstruction | Work Instruction ID | MPE_WI_ID | |
WorkInstructionVersionCounter | Work Instruction Version No | MPE_WI_VERSION_NO | |
MfgWorkInstructionContent | Work Instruction Content | MPE_WI_CONT | |
EffectivityParameterVariant | Parameter Variant/Standard Variant | TECHS | |
ProductConfiguration | Product Configuration | CUOBJ | |
EffectivityParameterDesc | Effectivity Parameter Description | CHAR256 | |
EffctyTypeCnctntdParamDesc | Effectivity Parameter Description | CHAR256 | |
ChangeRecord | Change Record ID | /PLMB/CR_ID | |
NetChangeAnalysisPath | null | ||
InspectionLot | Inspection Lot Number | QPLOS |
Master Data Relations | Join Conditions |
---|---|
BOM Usage
| |
Material Number for Order
| |
Unit of measure for activity
| |
Production Plant
| |
Plant
| |
Object ID of the resource
|