I_MstrProjItemList

DDL: I_MSTRPROJITEMLIST SQL: IMSTRPROJITEM Type: view BASIC

Master Project Item List

I_MstrProjItemList is a Basic CDS View that provides data about "Master Project Item List" in SAP S/4HANA. It reads from 2 data sources (I_MasterProject, I_MasterProjectItem) and exposes 29 fields. It has 1 association to related views.

2 data source(s) 29 fields

Data Sources (2)

SourceAliasJoin Type
I_MasterProject MasterProject from
I_MasterProjectItem MasterProjectItem inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MasterProjectCurrency _Currency $projection.MasterProjectUUID = _Currency.MasterProjectUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMSTRPROJITEM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Project Item List view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

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
ProjectUUID I_MasterProject ProjectUUID
MasterProjectItemUUID I_MasterProjectItem MasterProjectItemUUID
MasterProjectItemObjectType I_MasterProjectItem MasterProjectItemObjectType
MasterProjectItem I_MasterProjectItem MasterProjectItem
CreatedByUser I_MasterProjectItem CreatedByUser
CreationDateTime I_MasterProjectItem CreationDateTime
LastChangedByUser I_MasterProjectItem LastChangedByUser
LastChangeDateTime I_MasterProjectItem LastChangeDateTime
CurrencyendasCurrency
MstrProjCutOffDate I_MasterProject MstrProjCutOffDate
PostingPeriod 
@AbapCatalog.sqlViewName: 'IMSTRPROJITEM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Item List'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MstrProjItemList
  as select from I_MasterProject     as MasterProject
    inner join   I_MasterProjectItem as MasterProjectItem on MasterProjectItem.MasterProjectUUID = MasterProject.MasterProjectUUID
    association [1..1] to I_MasterProjectCurrency as _Currency on $projection.MasterProjectUUID = _Currency.MasterProjectUUID
{
  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,
 // MasterProject.MasterProjectUUID_E,

  MasterProject.ProjectUUID,
  MasterProjectItem.MasterProjectItemUUID,
  // MasterProjectItem.MstrProjParentkeyOfItem,

  MasterProjectItem.MasterProjectItemObjectType,
  MasterProjectItem.MasterProjectItem,
  MasterProjectItem.CreatedByUser,
  MasterProjectItem.CreationDateTime,
  MasterProjectItem.LastChangedByUser,
  MasterProjectItem.LastChangeDateTime,
  case when MasterProject.Currency = ''
  then _Currency.Currency
  else
  MasterProject.Currency
  end as Currency,
  MasterProject.MstrProjCutOffDate,
  concat( substring(MasterProject.MstrProjCutOffDate, 1, 4), concat('0',substring(MasterProject.MstrProjCutOffDate, 5, 2))) as PostingPeriod
  //concat(0,substring(MasterProject.MstrProjCutOffDate, 5, 2))

} 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECT",
"I_MASTERPROJECTCURRENCY",
"I_MASTERPROJECTITEM"
],
"ASSOCIATED":
[
"I_MASTERPROJECTCURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More