P_MaintOrderDuration

DDL: P_MAINTORDERDURATION SQL: PMAINTORDDURN Type: view BASIC Package: IWO1

used for AMDP method (Table function) for durations

P_MaintOrderDuration is a Basic CDS View that provides data about "used for AMDP method (Table function) for durations" in SAP S/4HANA. It reads from 3 data sources (afih, afko, aufk) and exposes 27 fields with key field MaintenanceOrder. Part of development package IWO1.

3 data source(s) 27 fields

Data Sources (3)

SourceAliasJoin Type
afih afih from
afko afko left_outer
aufk aufk inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTORDDURN view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder afih aufnr
OrderCategory aufk autyp
OrderType aufk auart
MaintenancePlanningPlant afih iwerk
FactoryCalendar _MaintenancePlanningPlant FactoryCalendar
PlannedStartDate afko gstrp
PlannedStartTime afko gsuzp
PlannedEndDate afko gltrp
PlannedEndTime afko gluzp
ScheduledBasicStartDate afko gstrs
ScheduledBasicStartTime afko gsuzs
ScheduledBasicEndDate afko gltrs
ScheduledBasicEndTime afko gluzs
ScheduledReleaseDate afko ftrms
ActualStartDate afko gstri
ActualStartTime afko gsuzi
ActualEndDate afko gltri
ActualReleasedDate afko ftrmi
ConfirmedEndDate afko getri
ConfirmedEndTime afko geuzi
ScheduledFcstdReleaseDate afko ftrps
TotalCommitmentDate afko gsbtr
LastScheduledDate afko trmdt
pdat1endasPlannedReleaseDate
PlannedCompletionDate aufk pdat2
TechnicalCompletionDate aufk idat2
_MaintenancePlanningPlant _MaintenancePlanningPlant 
@AbapCatalog.sqlViewName: 'PMAINTORDDURN'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true

define view P_MaintOrderDuration
// used for AMDP method (Table Function) determine_order_durations

  as select from afih as afih
      inner join aufk as aufk on aufk.aufnr = afih.aufnr
        left outer join afko as afko on afko.aufnr = aufk.aufnr

  association[1..1] to I_Plant as _MaintenancePlanningPlant on $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant
{
      // Key

  key afih.aufnr as MaintenanceOrder,

      // Category and Type

      aufk.autyp as  OrderCategory,
      aufk.auart as  OrderType,      

      // Assignments

      afih.iwerk as MaintenancePlanningPlant,
      _MaintenancePlanningPlant.FactoryCalendar as FactoryCalendar,    
      //afpo.pwerk as MRPPlant,


      // Dates

      afko.gstrp                                        as  PlannedStartDate,
      afko.gsuzp                                        as  PlannedStartTime,
      afko.gltrp                                        as  PlannedEndDate,
      afko.gluzp                                        as  PlannedEndTime,
      afko.gstrs                                        as  ScheduledBasicStartDate,
      afko.gsuzs                                        as  ScheduledBasicStartTime,
      afko.gltrs                                        as  ScheduledBasicEndDate,
      afko.gluzs                                        as  ScheduledBasicEndTime,
      afko.ftrms                                        as  ScheduledReleaseDate,
      afko.gstri                                        as  ActualStartDate,
      afko.gsuzi                                        as  ActualStartTime,
      afko.gltri                                        as  ActualEndDate,
      afko.ftrmi                                        as  ActualReleasedDate,
      afko.getri                                        as  ConfirmedEndDate,
      afko.geuzi                                        as  ConfirmedEndTime,
      afko.gstps                                        as  ScheduledForecastedStartDate,
      afko.gsups                                        as  ScheduledForecastedStartTime,
      afko.gltps                                        as  ScheduledForecastedEndDate,
      afko.glups                                        as  ScheduledForecastedEndTime,
      afko.ftrps                                        as  ScheduledFcstdReleaseDate,
      afko.gstpp                                        as  ForecastedStartDate,
      afko.gsupp                                        as  ForecastedStartTime,
      afko.gltpp                                        as  ForecastedEndDate,
      afko.glupp                                        as  ForecastedEndTime,
      afko.gsbtr                                        as  TotalCommitmentDate,
      afko.trmdt                                        as  LastScheduledDate,
      case aufk.pdat1
        when '' then afko.ftrmp
        else aufk.pdat1
      end                                               as  PlannedReleaseDate,
      aufk.pdat2                                        as  PlannedCompletionDate,
      aufk.idat2                                        as  TechnicalCompletionDate,      
      
      // Associations

      _MaintenancePlanningPlant
}
  where ( aufk.autyp = '30' );   //Maintenance Orders only

Learn More