I_MaintSchedulingParameters

DDL: I_MAINTSCHEDULINGPARAMETERS SQL: IMTSCHEDPARAMS Type: view BASIC
4 Fields 1 Data Sources

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.

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 Planning Plant
KEY MaintenanceOrderType t350w auart Sales Doc. Type
AdjustmentOfBasicDates
BasicStartMaxNrOfDaysInPast

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MaintSchedulingParameters.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMTSCHEDPARAMS

CREATE VIEW I_MaintSchedulingParameters AS
SELECT
  t350w.iwerk AS Plant,
  t350w.auart AS MaintenanceOrderType,
  coalesce(tcx00.dadj2, tcx00_generic.dadj2) AS AdjustmentOfBasicDates,
  coalesce(tcx00.stverg, tcx00_generic.stverg) AS BasicStartMaxNrOfDaysInPast
FROM t350w
;

Learn More