I_MstrProjItemListSimple

DDL: I_MSTRPROJITEMLISTSIMPLE SQL: IMPITMLSTSIMPLE Type: view COMPOSITE Package: VDM_CPM_WS

Simplified Master Project Items List

I_MstrProjItemListSimple is a Composite CDS View that provides data about "Simplified Master Project Items List" in SAP S/4HANA. It reads from 2 data sources (I_MasterProject, I_MasterProjectItem) and exposes 6 fields. Part of development package VDM_CPM_WS.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_MasterProject masterproject inner
I_MasterProjectItem masterprojitem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPITMLSTSIMPLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Simplified Master Project Items List view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProject MasterProjectUUID
ProjectUUID I_MasterProject ProjectUUID
MasterProject I_MasterProject MasterProject
MasterProjectItemUUID I_MasterProjectItem MasterProjectItemUUID
MasterProjectItemObjectType I_MasterProjectItem MasterProjectItemObjectType
MasterProjectItem I_MasterProjectItem MasterProjectItem 
@AbapCatalog.sqlViewName: 'IMPITMLSTSIMPLE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Simplified Master Project Items List'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_MstrProjItemListSimple as select from I_MasterProjectItem as masterprojitem
        inner join I_MasterProject     as masterproject   on masterprojitem.MasterProjectUUID = masterproject.MasterProjectUUID 
{
    masterproject.MasterProjectUUID,
    masterproject.ProjectUUID,
    masterproject.MasterProject,
/*    masterproject.MasterProjectName,
    masterproject.MasterProjectType,    
    masterproject.MasterProjectOrganization,
    masterproject.MasterProjectIsConfidential, */
    masterprojitem.MasterProjectItemUUID,
    masterprojitem.MasterProjectItemObjectType,
    masterprojitem.MasterProjectItem
    
}

Learn More