P_MAINTORDERBASICDATA

CDS View

Maintenance order basic data

P_MAINTORDERBASICDATA is a CDS View in S/4HANA. Maintenance order basic data. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProjPMOCostLineItms view inner COMPOSITE Project Cost Line Items with PMO Costs

Fields (2)

KeyField CDS FieldsUsed in Views
MaintenanceOrder MaintenanceOrder 1
WBSElementInternalID WBSElementInternalID 1 
@AbapCatalog.sqlViewName: 'PMAINTORDER'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
define view P_MAINTORDERBASICDATA as select from I_MaintenanceOrder
association [1..1] to I_WBSElementBasicData as _WBSElement  on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
association [1..1] to I_EnterpriseProject as _EnterpriseProject on $projection.projectinternalid = _EnterpriseProject.ProjectInternalID
{

  key MaintenanceOrder,
  MaintenanceOrderDesc as OrderDescription,
  MaintenanceOrderInternalID,
  MaintenanceOrderCategory,
 _WBSElement.WBSElementObject as WBSElementObject,
 
 WBSElementInternalID,
 _WBSElement._Project.Project as project,
 _WBSElement._Project.ProjectInternalID as projectinternalid,
 _WBSElement._Project.ProjectObject as ProjectObject,

 _WBSElement.CompanyCode,
 _WBSElement.ProfitCenter,
 _EnterpriseProject,
 _WBSElement

}
where  _WBSElement.WBSElementObject is not  initial 
and MaintenanceOrderCategory = '30'

Learn More