P_AlertIssueChangeRequest

DDL: P_ALERTISSUECHANGEREQUEST SQL: PAISSCHGEREQ Type: view COMPOSITE

P_AlertIssueChangeRequest is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_RootNode, I_MasterProject) and exposes 19 fields.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
I_RootNode IssueRefNode inner
I_MasterProject MasterProject from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PAISSCHGEREQ view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (19)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProject ProjectUUID
MasterProject I_MasterProject MasterProject
MasterProjectName I_MasterProject MasterProjectName
MasterProjectType I_MasterProject MasterProjectType
MasterProjectStage I_MasterProject MasterProjectStage
StartDate I_MasterProject StartDate
EndDate I_MasterProject EndDate
Customer I_MasterProject Customer
MasterProjectOrganization I_MasterProject MasterProjectOrganization
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
Country I_MasterProject Country
Region I_MasterProject Region
WorkType I_MasterProject WorkType
Industry I_MasterProject Industry
ProjectRisk I_MasterProject ProjectRisk
FinancialRisk I_MasterProject FinancialRisk
TechnicalRisk I_MasterProject TechnicalRisk
OverallRisk I_MasterProject OverallRisk
UnitOfMeasure 
@AbapCatalog.sqlViewName: 'PAISSCHGEREQ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_AlertIssueChangeRequest
  as select from I_MasterProject as MasterProject
    inner join   I_RootNode      as IssueRefNode on MasterProject.ProjectUUID = IssueRefNode.MasterProjectUUID
{
  MasterProject.ProjectUUID                           as MasterProjectUUID,
  MasterProject.MasterProject,
  MasterProject.MasterProjectName,
  MasterProject.MasterProjectType,
  MasterProject.MasterProjectStage,
  MasterProject.StartDate,
  MasterProject.EndDate,
  MasterProject.Customer,
  MasterProject.MasterProjectOrganization,
  MasterProject.MasterProjectIsConfidential,
  MasterProject.Country,
  MasterProject.Region,
  MasterProject.WorkType,
  MasterProject.Industry,
  MasterProject.ProjectRisk,
  MasterProject.FinancialRisk,
  MasterProject.TechnicalRisk,
  MasterProject.OverallRisk,
  case
  when IssueRefNode.IssueCategory = 'ICH' then '0CR'
  when IssueRefNode.IssueCategory = 'ICM' then '0IS'
  end                                                         as MasterProjectAlert,
  cast(case
  when IssueRefNode.IssueCategory = 'ICH' then 1
  when IssueRefNode.IssueCategory = 'ICM' then 1
  else 0
  end as int4)                                                as MstrProjAlertValue,
  ' '                                                         as UnitOfMeasure
}
where
     IssueRefNode.IssueCategory = 'ICM'
  or IssueRefNode.IssueCategory = 'ICH' 
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECT",
"I_ROOTNODE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More