P_MaintenancePlanSearch

DDL: P_MAINTENANCEPLANSEARCH SQL: PMAINTPLANSEARCH Type: view BASIC
56 Fields 1 Data Sources 3 Associations

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.

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 MaintenancePlan
MaintenancePlanDesc MaintenancePlanDesc MaintPlanText
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
MaintenanceStrategy MaintenanceStrategy Strategy Fields
SchedulingDuration SchedulingDuration SchedPeriod
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
Customer Customer Sold-to Party
NumberOfMaintenanceItems NumberOfMaintenanceItems No. items
Language I_MaintenancePlanBasic Language Report Text Language
CycleModificationRatio CycleModificationRatio CycModifFactor
MaintPlanSchedgIndicator I_MaintenancePlanBasic MaintPlanSchedgIndicator SchedIndic.
CallHorizonPercent CallHorizonPercent Horizon
CallHorizonInDays CallHorizonInDays Call horizon
AuthorizationGroup AuthorizationGroup AuthorizGroup
MaintenancePlanInternalID MaintenancePlanInternalID Val. Obj. No.
MaintenanceCall MaintenanceCall Call Number
MaintenancePlanCategory MaintenancePlanCategory MPlan cat.
SchedulingDurationUnit SchedulingDurationUnit UoM:HandlCap GR
BasicStartDate BasicStartDate Municipality
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib Sort field
FactoryCalendar FactoryCalendar Factory Calendar
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls Stock del. flag
LastChangeDateTime LastChangeDateTime Timestamp
LateCompletionShiftInPercent LateCompletionShiftInPercent Late Completion
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent EarlyCompletion
LateCompletionTolerancePercent LateCompletionTolerancePercent Upper Limit
EarlyCompletionTolerancePct EarlyCompletionTolerancePct Tolerance (-)
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType
MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode Operation type
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor Shift Fctr MCP
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue StrtCtrReadg
SchedulingStartDate SchedulingStartDate Valn start date
SchedulingStartTime SchedulingStartTime Time Stamp
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue End Counter
SchedulingEndDate SchedulingEndDate End Date for Sched.
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays Lead float
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd Compl.Requirmnt
_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

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 P_MaintenancePlanSearch.
-- 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: PMAINTPLANSEARCH
-- Parameters: P_Language : abap.lang, P_KeyDate : sydate

CREATE VIEW P_MaintenancePlanSearch AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceStrategy,
  SchedulingDuration,
  Equipment,
  FunctionalLocation,
  Customer,
  NumberOfMaintenanceItems,
  I_MaintenancePlanBasic.Language AS Language,
  CycleModificationRatio,
  I_MaintenancePlanBasic.MaintPlanSchedgIndicator AS MaintPlanSchedgIndicator,
  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
FROM I_MaintenancePlanBasic
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON MaintenancePlan = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'MPLA' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _CharValueAssignment ON MaintenancePlan = _CharValueAssignment.ClfnObjectID AND _CharValueAssignment.ClfnObjectTable = 'MPLA'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClassAssignment ON MaintenancePlan = _ClassAssignment.ClfnObjectID AND _ClassAssignment.ClfnObjectTable = 'MPLA'  -- association [0..*]
;

Learn More