P_MaintTaskListSearch

DDL: P_MAINTTASKLISTSEARCH SQL: PMAINTTASKLIST Type: view COMPOSITE Package: BSESH_PM

Maintenance Tasklist anchor view for CDS search model

P_MaintTaskListSearch is a Composite CDS View that provides data about "Maintenance Tasklist anchor view for CDS search model" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceTaskList) and exposes 60 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter. Part of development package BSESH_PM.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceTaskList I_MaintenanceTaskList from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTTASKLIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey TaskListGroupCounter view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY TaskListType TaskListType
KEY TaskListGroup TaskListGroup
KEY TaskListGroupCounter TaskListGroupCounter
TaskListDesc TaskListDesc
MaintenanceStrategy MaintenanceStrategy
Plant Plant
ResponsiblePlannerGroup ResponsiblePlannerGroup
WorkCenterTypeCode WorkCenterTypeCode
WorkCenterInternalID WorkCenterInternalID
TaskListStatus TaskListStatus
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
ChangeNumber ChangeNumber
Assembly Assembly
OperationSystemCondition OperationSystemCondition
ReferenceElement ReferenceElement
TaskListUsage TaskListUsage
InspSubsetFieldCombination InspSubsetFieldCombination
InspExternalNumberingOfValues InspExternalNumberingOfValues
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc
TechnicalObject TechnicalObject
TaskListObjectKey TaskListObjectKey
SafetyRelevantObject SafetyRelevantObject
ControllingArea ControllingArea
BillOfOperationIsConfigurable BillOfOperationIsConfigurable
IsDeleted IsDeleted
IsMarkedForDeletion IsMarkedForDeletion
Equipment Equipment
FunctionalLocation FunctionalLocation
FunctionalLocationLabelName FunctionalLocationLabelName
TaskListVersionCounter TaskListVersionCounter
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
CreationDate CreationDate
BillOfOperationsUsage BillOfOperationsUsage
MaintenancePlanningPlant MaintenancePlanningPlant
TaskListIsHierarchical TaskListIsHierarchical
LastChangeDateTime LastChangeDateTime
_ConfigurableIndicator _ConfigurableIndicator
_ControllingArea _ControllingArea
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_InspExtNumbering _InspExtNumbering
_InspSubsetFieldCombination _InspSubsetFieldCombination
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenanceStrategy _MaintenanceStrategy
_OperationSystemCondition _OperationSystemCondition
_Plant _Plant
_PMReferenceElement _PMReferenceElement
_ResponsiblePlannerGroup _ResponsiblePlannerGroup
_SafetyRelevance _SafetyRelevance
_TaskListGroup _TaskListGroup
_TaskListGroupCounter _TaskListGroupCounter
_TaskListStatus _TaskListStatus
_TaskListType _TaskListType
_TaskListUsage _TaskListUsage
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc
_WorkCenter _WorkCenter
//Maintenance Tasklist anchor view for CDS search model

@AbapCatalog.sqlViewName: 'PMAINTTASKLIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'TaskListGroupCounter'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MaintTaskListSearch as select from I_MaintenanceTaskList 
{
    key TaskListType, 
    key TaskListGroup, 
    key TaskListGroupCounter, 
    TaskListDesc, 
    MaintenanceStrategy, 
    Plant, 
    ResponsiblePlannerGroup, 
    WorkCenterTypeCode, 
    WorkCenterInternalID, 
    TaskListStatus, 
    ValidityStartDate, 
    ValidityEndDate, 
    ChangeNumber, 
    Assembly, 
    OperationSystemCondition, 
    ReferenceElement, 
    TaskListUsage, 
    InspSubsetFieldCombination, 
    InspExternalNumberingOfValues, 
    TechObjIsEquipOrFuncnlLoc, 
    TechnicalObject, 
    TaskListObjectKey, 
    SafetyRelevantObject, 
    ControllingArea, 
    BillOfOperationIsConfigurable, 
    IsDeleted, 
    IsMarkedForDeletion, 
    Equipment, 
    FunctionalLocation, 
    FunctionalLocationLabelName, 
    TaskListVersionCounter, 
    LastChangeDate, 
    LastChangedByUser, 
    CreatedByUser, 
    CreationDate, 
    BillOfOperationsUsage, 
    MaintenancePlanningPlant, 
    TaskListIsHierarchical, 
    LastChangeDateTime, 
    /* Associations */ 
    _ConfigurableIndicator, 
    _ControllingArea, 
    _Equipment, 
    _FunctionalLocation, 
    _InspExtNumbering, 
    _InspSubsetFieldCombination, 
    _MaintenancePlanningPlant, 
    _MaintenanceStrategy, 
    //_MaintTaskListOperation, path not executable in join condition - don't use

    _OperationSystemCondition, 
    _Plant, 
    _PMReferenceElement, 
    _ResponsiblePlannerGroup, 
    _SafetyRelevance, 
    _TaskListGroup, 
    _TaskListGroupCounter, 
    _TaskListStatus, 
    _TaskListType, 
    _TaskListUsage, 
    _TechnicalObject, 
    _TechObjIsEquipOrFuncnlLoc, 
    _WorkCenter
}