I_MaintSchedulingParameters

DDL: I_MAINTSCHEDULINGPARAMETERS SQL: IMTSCHEDPARAMS Type: view BASIC

Maintenance Scheduling Parameters

I_MaintSchedulingParameters is a Basic CDS View that provides data about "Maintenance Scheduling Parameters" in SAP S/4HANA. It reads from 1 data source (t350w) and exposes 4 fields with key fields Plant, MaintenanceOrderType.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t350w t350w from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMTSCHEDPARAMS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Scheduling Parameters view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Plant t350w iwerk
KEY MaintenanceOrderType t350w auart
AdjustmentOfBasicDates
BasicStartMaxNrOfDaysInPast 
@AbapCatalog.sqlViewName: 'IMTSCHEDPARAMS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Scheduling Parameters'

@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S

define view I_MaintSchedulingParameters
  as select from           t350w
    left outer to one join tcx00 as tcx00         on  tcx00.werks = t350w.iwerk
                                                  and tcx00.aufta = t350w.auart
                                                  and tcx00.auftg = '5'
                                                  and tcx00.vagrp = '*'
    left outer to one join tcx00 as tcx00_generic on  tcx00_generic.werks = t350w.iwerk
                                                  and tcx00_generic.aufta = '*'
                                                  and tcx00_generic.auftg = '5'
                                                  and tcx00_generic.vagrp = '*'
{
  key t350w.iwerk                                 as Plant,
  key t350w.auart                                 as MaintenanceOrderType,

      coalesce(tcx00.dadj2, tcx00_generic.dadj2)  as AdjustmentOfBasicDates,
      coalesce(tcx00.stverg, tcx00_generic.stverg) as BasicStartMaxNrOfDaysInPast
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T350W",
"TCX00"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More