P_MaintOrderConfirmationSearch

Anchor View for Maintenance Order Confirmation Search | view: PMAINTCONFSEARCH | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFRU_TEXTESH_SR_LTXTAFRUAFVCT001W
Column Name Description
MaintOrderConf Completion confirmation number for the operation
MaintOrderConfCntrValue Confirmation counter
Column Name Description
Column Name Description
ActualWorkQuantity Actual work
ActualDuration Actual Duration for Confirmation
ConfirmationYieldQuantity Yield to be Confirmed
ConfirmationScrapQuantity Scrap to Be Confirmed
RemainingWorkQuantity Remaining work
ConfirmationReworkQuantity Current Confirmation Rework Quantity
Column Name Description
MaintOrderConfirmationEntryDte Entry Date of Confirmation
LastChangeDate Date of Last Change
PostingDate Posting Date
OperationConfirmedStartDate Confirmed Start Date of Execution
OperationConfirmedStartTime Confirmed Time for 'Start Execution'
OperationConfirmedEndDate Confirmed Finish Date of Execution
OperationConfirmedEndTime Confirmed Time for 'Finish Execution'
ActyConfFcstdEndDate Forecast finish date of operation from confirmation
ActyConfFcstdEndTime Forecast End Time of Operation from Confirmation
MaintOrderConfirmationEntryTme Confirmation Entry Time
ConfirmationExternalEntryDate External date of entry for confirmation
ConfirmationExternalEntryTime External time of entry for confirmation
Column Name Description
LongTextExists Checkbox Show values
IsFinalConfirmation Checkbox Show values
OpenReservationsIsCleared Clear Open Reservations Show values
NoFurtherWorkQuantityIsExpd Indicator: No Remaining Work Expected Show values
IsReversed Indicator: Document was reversed Show values
IsReversal Checkbox Show values
Column Name Description Domain name
EnteredByUser User who Entered the Confirmation USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
WorkCenterInternalID Object ID NUM08
ConfirmationText Confirmation text TEXT40
EmployeeWageType Wage type LOART
PersonnelNumber Personnel number PERNR
MaintenanceOrderOperation Operation/Activity Number VORNR
MaintenanceOrderSubOperation Operation/Activity Number VORNR
EnteredByExternalUser External creator of confirmation USNAM
PlainLongText Long Text
Master Data Relations Join Conditions
Accounting Indicator
  • Client
  • Accounting Indicator
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == TBMOT.MANDT
  • P_MAINTORDERCONFIRMATIONSEARCH.ACCOUNTINGINDICATORCODE == TBMOT.BEMOT
Activity Type for Confirmation
  • Activity Type for Confirmation
  • ?
  • Client
  • Posting Date
  • P_MAINTORDERCONFIRMATIONSEARCH.ACTIVITYTYPE == CSLA.LSTAR
  • P_MAINTORDERCONFIRMATIONSEARCH.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == CSLA.MANDT
  • P_MAINTORDERCONFIRMATIONSEARCH.POSTINGDATE == CSLA.DATBI
Unit for Actual Dur.
  • Unit for actual duration
  • Client
  • P_MAINTORDERCONFIRMATIONSEARCH.ACTUALDURATIONUNIT == T006.MSEHI
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == T006.MANDT
Unit for work
  • Unit for work
  • Client
  • P_MAINTORDERCONFIRMATIONSEARCH.ACTUALWORKQUANTITYUNIT == T006.MSEHI
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == T006.MANDT
Unit of Operation
  • Confirmation Unit of Measure
  • Client
  • P_MAINTORDERCONFIRMATIONSEARCH.CONFIRMATIONUNIT == T006.MSEHI
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == T006.MANDT
Calendar ID P_MAINTORDERCONFIRMATIONSEARCH.FACTORYCALENDAR == TFACD.IDENT
Language of Confirmation Text P_MAINTORDERCONFIRMATIONSEARCH.LANGUAGE == T002.SPRAS
Order Number
  • Order Number
  • Client
  • P_MAINTORDERCONFIRMATIONSEARCH.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == AUFK.MANDT
Plant
  • Client
  • Plant
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == T001W.MANDT
  • P_MAINTORDERCONFIRMATIONSEARCH.PLANT == T001W.WERKS
Unit of Measure for Remaining Work
  • Client
  • Unit of Measure for Remaining Work
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == T006.MANDT
  • P_MAINTORDERCONFIRMATIONSEARCH.REMAININGWORKQUANTITYUNIT == T006.MSEHI
Scrap Reason
  • Reason for Variance
  • Client
  • Plant
  • P_MAINTORDERCONFIRMATIONSEARCH.VARIANCEREASONCODE == TRUG.GRUND
  • P_MAINTORDERCONFIRMATIONSEARCH.MANDT == TRUG.MANDT
  • P_MAINTORDERCONFIRMATIONSEARCH.PLANT == TRUG.WERKS