I_MaintenanceStrategy

DDL: I_MAINTENANCESTRATEGY SQL: IMAINTSTRAT Type: view BASIC

Maintenance Strategy

I_MaintenanceStrategy is a Basic CDS View that provides data about "Maintenance Strategy" in SAP S/4HANA. It reads from 1 data source (t351) and exposes 21 fields with key field MaintenanceStrategy. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t351 t351 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MaintenanceStrategyT _MaintenanceStrategyText _MaintenanceStrategyText.MaintenanceStrategy = $projection.MaintenanceStrategy
[0..1] I_UnitOfMeasure _MaintenanceStrategyUnit _MaintenanceStrategyUnit.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit
[0..1] I_FactoryCalendar _FactoryCalendar _FactoryCalendar.FactoryCalendar = $projection.FactoryCalendar

Annotations (16)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMAINTSTRAT view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Strategy view
ObjectModel.representativeKey MaintenanceStrategy view
ObjectModel.semanticKey MaintenanceStrategy view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
VDM.viewType #BASIC view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name MaintenanceStrategy view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceStrategy t351 strat
MaintenanceTaskPerformanceUnit t351 zeieh
MaintenanceStrategyActyUnit t351 leieh
MaintenanceStrategyCycTotDurn t351 zyk1g
MaintenanceStrategyCycDurn t351 zyk2g
MaintPackageMinimumStepValue t351 zyk1k
PerfBasedMaintPckgMinStepValue t351 zyk2k
NumberOfMaintenancePackages t351 anzp1 No. of Maintenance Packages
NumberOfPerfBasedMaintPackages t351 anzp2 No. of Maintenance Packages(Performance)
LateCompletionTolerancePercent t351 tole1
EarlyCompletionTolerancePct t351 tole2
LateCompletionShiftInPercent t351 vers1
EarlyCompletionShiftInPercent t351 vers2 Early Completion
MaintStrategySchedulingCode t351 termk
MaintenanceCallHorizonPercent t351 horiz
MaintenanceCallHorizonCalcType
FactoryCalendar t351 fabkl
AuthorizationGroup t351 authgr
_MaintenanceStrategyText _MaintenanceStrategyText
_MaintenanceStrategyUnit _MaintenanceStrategyUnit
_FactoryCalendar _FactoryCalendar
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMAINTSTRAT'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Strategy'
@ObjectModel.representativeKey: 'MaintenanceStrategy'
@ObjectModel.semanticKey: 'MaintenanceStrategy'
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #M,
   usageType.dataClass: #ORGANIZATIONAL
}
@VDM.viewType: #BASIC
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE,#EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: #VALUE_HELP_PROVIDER
@Analytics.dataExtraction.enabled: true
@ObjectModel.sapObjectNodeType.name: 'MaintenanceStrategy'

define view I_MaintenanceStrategy
  as select from t351

  association [0..*] to I_MaintenanceStrategyT as _MaintenanceStrategyText on _MaintenanceStrategyText.MaintenanceStrategy = $projection.MaintenanceStrategy

  association [0..1] to I_UnitOfMeasure        as _MaintenanceStrategyUnit on _MaintenanceStrategyUnit.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit

  association [0..1] to I_FactoryCalendar      as _FactoryCalendar         on _FactoryCalendar.FactoryCalendar = $projection.FactoryCalendar
{
      @ObjectModel.text.association: '_MaintenanceStrategyText'
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key t351.strat                                                                 as MaintenanceStrategy,

      @ObjectModel.foreignKey.association: '_MaintenanceStrategyUnit'
      t351.zeieh                                                                 as MaintenanceTaskPerformanceUnit,

      t351.leieh                                                                 as MaintenanceStrategyActyUnit,

      t351.zyk1g                                                                 as MaintenanceStrategyCycTotDurn,

      t351.zyk2g                                                                 as MaintenanceStrategyCycDurn, // same as zyk1g ?


      t351.zyk1k                                                                 as MaintPackageMinimumStepValue,

      t351.zyk2k                                                                 as PerfBasedMaintPckgMinStepValue,

      @EndUserText.label: 'No. of Maintenance Packages'
      t351.anzp1                                                                 as NumberOfMaintenancePackages,
      @EndUserText.label: 'No. of Maintenance Packages(Performance)'
      t351.anzp2                                                                 as NumberOfPerfBasedMaintPackages,

      t351.tole1                                                                 as LateCompletionTolerancePercent,

      t351.tole2                                                                 as EarlyCompletionTolerancePct,

      t351.vers1                                                                 as LateCompletionShiftInPercent,

      @EndUserText.label: 'Early Completion'
      t351.vers2                                                                 as EarlyCompletionShiftInPercent,
      //

      //      @EndUserText.label: 'Early Completion'

      //      t351.vers2                                                                 as EarlyCompletionShiftFactor,


      t351.termk                                                                 as MaintStrategySchedulingCode,

      t351.horiz                                                                 as MaintenanceCallHorizonPercent,

      cast(t351.horiz_qualifier as eam_cc_callhorizon_calc_type preserving type) as MaintenanceCallHorizonCalcType,

      @ObjectModel.foreignKey.association: '_FactoryCalendar'
      t351.fabkl                                                                 as FactoryCalendar,

      t351.authgr                                                                as AuthorizationGroup,

      // Association(s)

      _MaintenanceStrategyText,
      _MaintenanceStrategyUnit,
      _FactoryCalendar
}