P_IssueChangeReq

DDL: P_ISSUECHANGEREQ SQL: PISSUECHANGREQ Type: view BASIC Package: VDM_CPM_WS

Issue and Change Request

P_IssueChangeReq is a Basic CDS View that provides data about "Issue and Change Request" in SAP S/4HANA. It reads from 2 data sources (P_RootNode, I_MasterProject) and exposes 20 fields. Part of development package VDM_CPM_WS.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
P_RootNode IssueRefNode inner
I_MasterProject MasterProject from

Annotations (6)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProject MasterProjectUUID
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
id P_RootNode id
issue_categoryICMthen1else0endasIssue 
@AbapCatalog.sqlViewName: 'PISSUECHANGREQ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
define view P_IssueChangeReq
  as select from I_MasterProject as MasterProject
    inner join   P_RootNode       as IssueRefNode on MasterProject.ProjectUUID = IssueRefNode.id
{

  MasterProject.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,
  IssueRefNode.id,
  IssueRefNode.issue_category,
  case
  when IssueRefNode.issue_category = 'ICH' then 1
  else 0
  end as ChangeRequest,
  case
  when IssueRefNode.issue_category = 'ICM' then 1
  else 0
  end as Issue
}
where
     IssueRefNode.issue_category = 'ICM'
  or IssueRefNode.issue_category = 'ICH'

Learn More