P_MaintenancePlanSearch

DDL: P_MAINTENANCEPLANSEARCH SQL: PMAINTPLANSEARCH Type: view BASIC

P_MaintenancePlanSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanBasic) and exposes 56 fields with key field MaintenancePlan. It has 3 associations to related views.

1 data source(s) 56 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanBasic I_MaintenancePlanBasic from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KeyDate sydate

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.MaintenancePlan = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'MPLA' and _LongText.TextObjectType = 'LTXT'
[0..*] I_ClfnObjectCharcValForKeyDate _CharValueAssignment $projection.MaintenancePlan = _CharValueAssignment.ClfnObjectID and _CharValueAssignment.ClfnObjectTable = 'MPLA'
[0..*] I_ClfnObjectClassForKeyDate _ClassAssignment $projection.MaintenancePlan = _ClassAssignment.ClfnObjectID and _ClassAssignment.ClfnObjectTable = 'MPLA'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTPLANSEARCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaintenancePlan view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan
MaintenancePlanDesc MaintenancePlanDesc
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
MaintenanceStrategy MaintenanceStrategy
SchedulingDuration SchedulingDuration
Equipment Equipment
FunctionalLocation FunctionalLocation
Customer Customer
NumberOfMaintenanceItems NumberOfMaintenanceItems
Language I_MaintenancePlanBasic Language
CycleModificationRatio CycleModificationRatio
MaintPlanSchedgIndicator I_MaintenancePlanBasic MaintPlanSchedgIndicator
CallHorizonPercent CallHorizonPercent
CallHorizonInDays CallHorizonInDays
AuthorizationGroup AuthorizationGroup
MaintenancePlanInternalID MaintenancePlanInternalID
MaintenanceCall MaintenanceCall
MaintenancePlanCategory MaintenancePlanCategory
SchedulingDurationUnit SchedulingDurationUnit
BasicStartDate BasicStartDate
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib
FactoryCalendar FactoryCalendar
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls
LastChangeDateTime LastChangeDateTime
LateCompletionShiftInPercent LateCompletionShiftInPercent
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent
LateCompletionTolerancePercent LateCompletionTolerancePercent
EarlyCompletionTolerancePct EarlyCompletionTolerancePct
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType
MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue
SchedulingStartDate SchedulingStartDate
SchedulingStartTime SchedulingStartTime
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue
SchedulingEndDate SchedulingEndDate
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd
_Customer _Customer
_Equipment _Equipment
_FactoryCalendar _FactoryCalendar
_FunctionalLocationLabel _FunctionalLocationLabel
_MaintenancePlanCycle _MaintenancePlanCycle
_MaintenanceItem _MaintenanceItem
_MaintenancePlanCatParam _MaintenancePlanCatParam
_MaintenanceStrategy _MaintenanceStrategy
_MaintPlanCallHistory _MaintPlanCallHistory
_MaintenanceCall _MaintenanceCall
_SchedulingIndicator _SchedulingIndicator
_StatusObjectActiveStatus _StatusObjectActiveStatus
_LongText _LongText
_CharValueAssignment _CharValueAssignment
_ClassAssignment _ClassAssignment 
//Anchor View for Maintenance Plan CDS Search

@AbapCatalog.sqlViewName: 'PMAINTPLANSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_LongText']
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MaintenancePlan'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MaintenancePlanSearch
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : abap.lang,
     @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_MaintenancePlanBasic
  association [0..*] to I_TextObjectPlainLongText      as _LongText            on  $projection.MaintenancePlan  = _LongText.TextObjectKey
                                                                               and _LongText.TextObjectCategory = 'MPLA'
                                                                               and _LongText.TextObjectType     = 'LTXT'
  association [0..*] to I_ClfnObjectCharcValForKeyDate as _CharValueAssignment on  $projection.MaintenancePlan          = _CharValueAssignment.ClfnObjectID
                                                                               and _CharValueAssignment.ClfnObjectTable = 'MPLA'
  association [0..*] to I_ClfnObjectClassForKeyDate    as _ClassAssignment     on  $projection.MaintenancePlan      = _ClassAssignment.ClfnObjectID
                                                                               and _ClassAssignment.ClfnObjectTable = 'MPLA'
{

  key MaintenancePlan,
      MaintenancePlanDesc,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      MaintenanceStrategy,
      SchedulingDuration,
      Equipment,
      FunctionalLocation,
      Customer,
      NumberOfMaintenanceItems,
      I_MaintenancePlanBasic.Language,
      CycleModificationRatio,
      I_MaintenancePlanBasic.MaintPlanSchedgIndicator,
      // _SchedulingIndicator.MaintPlanSchedgIndDesc,

      CallHorizonPercent,
      CallHorizonInDays,
      AuthorizationGroup,
      MaintenancePlanInternalID,
      MaintenanceCall,
      MaintenancePlanCategory,
      SchedulingDurationUnit,
      BasicStartDate,
      MaintPlanFreeDefinedAttrib,
      FactoryCalendar,
      MaintPlanIsLockedAgainstCalls,
      LastChangeDateTime,
      LateCompletionShiftInPercent,
      EarlyCompletionShiftInPercent,
      LateCompletionTolerancePercent,
      EarlyCompletionTolerancePct,
      MaintenanceCallHorizonCalcType,
      MaintPlanLogicalOperatorCode ,
      MultipleCounterPlanShiftFactor,
      MaintPlanStartCntrReadingValue ,
      SchedulingStartDate,
      SchedulingStartTime,
      MaintPlanEndCntrReadingValue ,
      SchedulingEndDate,
      MaintenanceLeadFloatInDays,
      PrdcssrCallObjCompltnIsRqd,
      /* Associations */
      //I_MaintenancePlan

      _Customer,
      _Equipment,
      _FactoryCalendar,
      _FunctionalLocationLabel,
      //_MaintenanceCycle,

      _MaintenancePlanCycle,
      _MaintenanceItem,
      _MaintenancePlanCatParam,
      _MaintenanceStrategy,
      _MaintPlanCallHistory,
      _MaintenanceCall,
      _SchedulingIndicator,
      _StatusObjectActiveStatus,
      _LongText,
      _CharValueAssignment,
      _ClassAssignment
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEPLANBASIC"
],
"ASSOCIATED":
[
"I_CLFNOBJECTCHARCVALFORKEYDATE",
"I_CLFNOBJECTCLASSFORKEYDATE",
"I_CUSTOMER",
"I_EQUIPMENT",
"I_FACTORYCALENDAR",
"I_FUNCTIONALLOCATIONLABEL",
"I_MAINTENANCECALL",
"I_MAINTENANCEITEM",
"I_MAINTENANCEPLANCATPARAM",
"I_MAINTENANCEPLANCYCLE",
"I_MAINTENANCESTRATEGY",
"I_MAINTPLANCALLHISTORY",
"I_MAINTPLANSCHEDGIND",
"I_STATUSOBJECTACTIVESTATUS",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[
"I_MAINTENANCEPLANBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More