I_MaintPlanMaintCallTP

DDL: I_MAINTPLANMAINTCALLTP SQL: IMNTPLNMNTCALLTP Type: view TRANSACTIONAL

Maintenance Calls for Maint. Plan (Transactional Processing)

I_MaintPlanMaintCallTP is a Transactional CDS View that provides data about "Maintenance Calls for Maint. Plan (Transactional Processing)" in SAP S/4HANA. It reads from 1 data source (I_MaintPlanMaintCall) and exposes 25 fields with key fields MaintenancePlan, MaintenancePlanCallNumber. It has 1 association to related views.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintPlanMaintCall I_MaintPlanMaintCall from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintenancePlanTP _MaintenancePlanTP _MaintenancePlanTP.MaintenancePlan = $projection.MaintenancePlan

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMNTPLNMNTCALLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Calls for Maint. Plan (Transactional Processing) view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.writeActivePersistence IMNTPLNMNTCALLTP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan
KEY MaintenancePlanCallNumber MaintenancePlanCallNumber
SchedulingType SchedulingType
SchedulingStatus SchedulingStatus
MeasuringPoint MeasuringPoint
MaintenanceTaskPerformanceUnit MaintenanceTaskPerformanceUnit
MaintenanceCallNextPlannedDate MaintenanceCallNextPlannedDate
MaintenanceCallDate MaintenanceCallDate
CompletionDate CompletionDate
CompletionTime CompletionTime
CycleSetSequence CycleSetSequence
MaintCallCompltnCntrRdng MaintCallCompltnCntrRdng
MaintCallNextPlndCntrRdng MaintCallNextPlndCntrRdng
MaintenanceCallIsOutstanding MaintenanceCallIsOutstanding
MaintCallIsInvokedOnPlndDate MaintCallIsInvokedOnPlndDate
MaintCallHorizonIsNotReached MaintCallHorizonIsNotReached
ReleasedByUserName ReleasedByUserName
UserDescription UserDescription
MaintPlnCnctntdDuePackagesTxt MaintPlnCnctntdDuePackagesTxt
MaintPlanLastScheduledDate MaintPlanLastScheduledDate
_MaintenancePlan _MaintenancePlan
_SchedulingType _SchedulingType
_MaintTaskPerformanceUnit _MaintTaskPerformanceUnit
_ReleasedByUserName _ReleasedByUserName
_MaintenancePlanTP _MaintenancePlanTP 
@AbapCatalog.sqlViewName: 'IMNTPLNMNTCALLTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Calls for Maint. Plan (Transactional Processing)'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
   representativeKey: [ 'MaintenancePlanCallNumber' ],
   semanticKey:  [ 'MaintenancePlan','MaintenancePlanCallNumber' ],
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #M,
   usageType.dataClass: #MASTER,
   writeActivePersistence:         'IMNTPLNMNTCALLTP'
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view I_MaintPlanMaintCallTP
  as select from I_MaintPlanMaintCall
  association [1..1] to I_MaintenancePlanTP as _MaintenancePlanTP on _MaintenancePlanTP.MaintenancePlan = $projection.MaintenancePlan
{
  key MaintenancePlan,
  key MaintenancePlanCallNumber,
      SchedulingType,
      SchedulingStatus,
      MeasuringPoint,
      MaintenanceTaskPerformanceUnit,
      MaintenanceCallNextPlannedDate,
      MaintenanceCallDate,
      CompletionDate,
      CompletionTime,
      CycleSetSequence,
      MaintCallCompltnCntrRdng,
      MaintCallNextPlndCntrRdng,
      MaintenanceCallIsOutstanding,
      MaintCallIsInvokedOnPlndDate,
      MaintCallHorizonIsNotReached,
      @ObjectModel.readOnly: #EXTERNAL_CALCULATION
      ReleasedByUserName,
      UserDescription,
      @ObjectModel.readOnly: #EXTERNAL_CALCULATION
      MaintPlnCnctntdDuePackagesTxt,
      @ObjectModel.readOnly: #EXTERNAL_CALCULATION
      case CompletionDate
        when '00000000' then ''
        else cast ( DATS_DAYS_BETWEEN(MaintenanceCallNextPlannedDate, CompletionDate) as abap.sstring(11) )
      end as MaintCallCompltnDateVariance,
      MaintPlanLastScheduledDate,
      /* Associations - locally defined */
      _MaintenancePlan,
      _SchedulingType,
      _MaintTaskPerformanceUnit,
      _ReleasedByUserName,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _MaintenancePlanTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTPLANMAINTCALL"
],
"ASSOCIATED":
[
"I_MAINTCALLSCHEDULINGTYPE",
"I_MAINTENANCEPLAN",
"I_MAINTENANCEPLANTP",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_MAINTPLANMAINTCALL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More