P_MAINTORDERBASICDATA

DDL: P_MAINTORDERBASICDATA SQL: PMAINTORDER Type: view COMPOSITE

P_MAINTORDERBASICDATA is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 12 fields with key field MaintenanceOrder. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrder I_MaintenanceOrder from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
[1..1] I_EnterpriseProject _EnterpriseProject $projection.projectinternalid = _EnterpriseProject.ProjectInternalID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTORDER view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
OrderDescription MaintenanceOrderDesc
MaintenanceOrderInternalID MaintenanceOrderInternalID
MaintenanceOrderCategory MaintenanceOrderCategory
WBSElementObject _WBSElement WBSElementObject
WBSElementInternalID WBSElementInternalID
project
ProjectObject
CompanyCode _WBSElement CompanyCode
ProfitCenter _WBSElement ProfitCenter
_EnterpriseProject _EnterpriseProject
_WBSElement _WBSElement 
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More