ESH_N_MAINTORDCONFIRMATION

Anchor view -MAINTORDCONFIRMATION | view: ESH_L_MAINTORCNF | TRAN | Extraction: Not supported | Component: Plant Maintenance

Tables used: AFIH, AFKO, AFRU_TEXT, ESH_SR_LTXT, AFRU, AFVC, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, AUFK, T003O, T001W, CRTX, CRHD, ITOBCUST, IFLOUSR

🔑 Keys (2)
💰 Amounts
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (2)
Other (11)
🔗 Relations (14)

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

Column Name	Description
PostingDate	Posting Date
MaintOrderConfirmationEntryDte	Entry Date of Confirmation

Column Name	Description
OpenReservationsIsCleared	Clear Open Reservations	Show values
IsReversed	Indicator: Document was reversed	Show values

Column Name	Description	Domain name
OrderType	Order Type	AUFART
EquipmentName	Description of technical object	TEXT40
FuncnlLocPrimaryLabelName	Functional Location Label	ILOM_STRNO
FunctionalLocationName	Description of functional location	TEXT40
WorkCenterText	Work Center Text	TEXT40
WorkCenter	Work Center	ARBPL
PersonnelNumber	Personnel number	PERNR
EnteredByUser	User who Entered the Confirmation	USNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
ConfirmationText	Confirmation text	TEXT40
PlainLongText	Long Text

Master Data Relations \| to Other Relations ↓	Join Conditions
Activity Type for Confirmation Client Activity Type for Confirmation Posting Date Controlling Area	`ESH_N_MAINTORDCONFIRMATION.MANDT == CSLA.MANDT` `ESH_N_MAINTORDCONFIRMATION.ACTIVITYTYPE == CSLA.LSTAR` `ESH_N_MAINTORDCONFIRMATION.POSTINGDATE == CSLA.DATBI` `ESH_N_MAINTORDCONFIRMATION.CONTROLLINGAREA == CSLA.KOKRS`
Unit for Actual Dur. Client Unit for actual duration	`ESH_N_MAINTORDCONFIRMATION.MANDT == T006.MANDT` `ESH_N_MAINTORDCONFIRMATION.ACTUALDURATIONUNIT == T006.MSEHI`
Unit for work Client Unit for work	`ESH_N_MAINTORDCONFIRMATION.MANDT == T006.MANDT` `ESH_N_MAINTORDCONFIRMATION.ACTUALWORKQUANTITYUNIT == T006.MSEHI`
Assembly Client Assembly	`ESH_N_MAINTORDCONFIRMATION.MANDT == MARA.MANDT` `ESH_N_MAINTORDCONFIRMATION.ASSEMBLY == MARA.MATNR`
Unit of Operation Client Confirmation Unit of Measure	`ESH_N_MAINTORDCONFIRMATION.MANDT == T006.MANDT` `ESH_N_MAINTORDCONFIRMATION.CONFIRMATIONUNIT == T006.MSEHI`
Controlling Area Client Controlling Area	`ESH_N_MAINTORDCONFIRMATION.MANDT == TKA01.MANDT` `ESH_N_MAINTORDCONFIRMATION.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Cost Center Client ? Controlling Area	`ESH_N_MAINTORDCONFIRMATION.COSTCENTER == CSKS.KOSTL` `ESH_N_MAINTORDCONFIRMATION.MANDT == CSKS.MANDT` `ESH_N_MAINTORDCONFIRMATION.[column in domain "DATBI"] == CSKS.DATBI` `ESH_N_MAINTORDCONFIRMATION.CONTROLLINGAREA == CSKS.KOKRS`
Equipment Number Client Equipment Number	`ESH_N_MAINTORDCONFIRMATION.MANDT == EQUI.MANDT` `ESH_N_MAINTORDCONFIRMATION.EQUIPMENT == EQUI.EQUNR`
Order Number Order Number Client	`ESH_N_MAINTORDCONFIRMATION.MAINTENANCEORDER == AUFK.AUFNR` `ESH_N_MAINTORDCONFIRMATION.MANDT == AUFK.MANDT`
Plant Plant Client	`ESH_N_MAINTORDCONFIRMATION.PLANT == T001W.WERKS` `ESH_N_MAINTORDCONFIRMATION.MANDT == T001W.MANDT`
Scrap Reason Reason for Variance Plant Client	`ESH_N_MAINTORDCONFIRMATION.VARIANCEREASONCODE == TRUG.GRUND` `ESH_N_MAINTORDCONFIRMATION.PLANT == TRUG.WERKS` `ESH_N_MAINTORDCONFIRMATION.MANDT == TRUG.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Client Planner Group for Customer Service and Plant Maintenance	`ESH_N_MAINTORDCONFIRMATION.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `ESH_N_MAINTORDCONFIRMATION.MANDT == T024I.MANDT` `ESH_N_MAINTORDCONFIRMATION.MAINTENANCEPLANNERGROUP == T024I.INGRP`
Maintenance Planning Plant Maintenance Planning Plant Client	`ESH_N_MAINTORDCONFIRMATION.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `ESH_N_MAINTORDCONFIRMATION.MANDT == T399I.MANDT`