I_ProjSchedMaintOrderData

Project Schedule Data for Work Order | view: IPRSCMAINTORD | TRAN | Extraction: Not supported | Component: Structures
Tables used: AFKO, AUFK
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
PlannedStartDate Basic Start Date
PlannedEndDate Basic finish date
ScheduledBasicStartDate Scheduled start
ScheduledBasicEndDate Scheduled finish
ActualStartDate Actual start date
ActualEndDate Confirmed Order Finish Date
ForecastedStartDate Forecast start date
ForecastedEndDate Finish date (forecast)
ScheduledForecastedStartDate Scheduled forecast start
ScheduledForecastedEndDate Scheduled forecast finish
CreationDate Created On
LastChangeDate Change Date for Order Master
Column Name Description
ProdAvailyCheckPlanningType Basis for scheduling Show values
OrderCategory Order category Show values
IsMarkedForDeletion Deletion Flag Show values
Column Name Description Domain name
OrderInternalBillOfOperations Routing number of operations in the order AUFPL
OrderDescription Order Description TEXT40
SuperiorProjectNetwork Number of superior network AUFNR
SuperiorProjectNetworkIntID Routing number of operations in the order AUFPL
SuperiorNtwkActivityInternalID General counter for order CO_APLZL
MainWorkCenter Main work center for maintenance tasks ARBPL
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
PriorityCode Order priority CHAR1
CreatedByUser Entered By USNAM
MainWorkCenterPlant Plant associated with main work center WERKS
Master Data Relations Join Conditions
Scheduling type
  • Scheduling type
  • Client
  • I_PROJSCHEDMAINTORDERDATA.BASICSCHEDULINGTYPE == T482.TERMKZ
  • I_PROJSCHEDMAINTORDERDATA.MANDT == T482.MANDT
Business Area
  • Business Area
  • Client
  • I_PROJSCHEDMAINTORDERDATA.BUSINESSAREA == TGSB.GSBER
  • I_PROJSCHEDMAINTORDERDATA.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_PROJSCHEDMAINTORDERDATA.COMPANYCODE == T001.BUKRS
  • I_PROJSCHEDMAINTORDERDATA.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PROJSCHEDMAINTORDERDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROJSCHEDMAINTORDERDATA.MANDT == TKA01.MANDT
Cost Center for Basic Settlement
  • Controlling Area
  • Cost Center for Basic Settlement
  • Client
  • ?
  • I_PROJSCHEDMAINTORDERDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_PROJSCHEDMAINTORDERDATA.COSTCENTER == CSKS.KOSTL
  • I_PROJSCHEDMAINTORDERDATA.MANDT == CSKS.MANDT
  • I_PROJSCHEDMAINTORDERDATA.[column in domain "DATBI"] == CSKS.DATBI
Order Number
  • Order Number
  • Client
  • I_PROJSCHEDMAINTORDERDATA.MAINTENANCEORDER == AUFK.AUFNR
  • I_PROJSCHEDMAINTORDERDATA.MANDT == AUFK.MANDT
MRP Controller Group
  • Plant
  • Client
  • MRP controller for the order
  • I_PROJSCHEDMAINTORDERDATA.PLANT == T024D.WERKS
  • I_PROJSCHEDMAINTORDERDATA.MANDT == T024D.MANDT
  • I_PROJSCHEDMAINTORDERDATA.MRPCONTROLLER == T024D.DISPO
Order Type
  • Client
  • Order Type
  • I_PROJSCHEDMAINTORDERDATA.MANDT == T003O.CLIENT
  • I_PROJSCHEDMAINTORDERDATA.ORDERTYPE == T003O.AUART
Plant
  • Plant
  • Client
  • I_PROJSCHEDMAINTORDERDATA.PLANT == T001W.WERKS
  • I_PROJSCHEDMAINTORDERDATA.MANDT == T001W.MANDT
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • I_PROJSCHEDMAINTORDERDATA.CONTROLLINGAREA == CEPC.KOKRS
  • I_PROJSCHEDMAINTORDERDATA.MANDT == CEPC.MANDT
  • I_PROJSCHEDMAINTORDERDATA.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJSCHEDMAINTORDERDATA.PROFITCENTER == CEPC.PRCTR
Project definition
  • Project definition
  • Client
  • I_PROJSCHEDMAINTORDERDATA.PROJECTINTERNALID == PROJ.PSPNR
  • I_PROJSCHEDMAINTORDERDATA.MANDT == PROJ.MANDT
Responsible cost center
  • Controlling Area
  • Responsible cost center
  • Client
  • ?
  • I_PROJSCHEDMAINTORDERDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_PROJSCHEDMAINTORDERDATA.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_PROJSCHEDMAINTORDERDATA.MANDT == CSKS.MANDT
  • I_PROJSCHEDMAINTORDERDATA.[column in domain "DATBI"] == CSKS.DATBI