I_ManageProjectForEndItem

DDL: I_MANAGEPROJECTFORENDITEM SQL: IMANAGEPROJECT Type: view COMPOSITE Package: MPE_INSTALLATION

Project Details For End Item

I_ManageProjectForEndItem is a Composite CDS View that provides data about "Project Details For End Item" in SAP S/4HANA. It reads from 3 data sources (I_Material, I_Project, I_UnitizedMaterialType) and exposes 20 fields with key field Project. It has 3 associations to related views. Part of development package MPE_INSTALLATION.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
I_Material Material inner
I_Project ProjectBasicData inner
I_UnitizedMaterialType UnitizedType inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _Text $projection.Material = _Text.Material and _Text.Language = $session.system_language
[0..1] I_ProjectProfileCodeText _ProjectProfile $projection.ProjectProfileCode = _ProjectProfile.ProjectProfileCode and _ProjectProfile.Language = $session.system_language
[0..1] I_MajorAssemblyProjectStatus _status ProjectBasicData.ProjectObject = _status.ProjectObject

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMANAGEPROJECT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Project Details For End Item view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Project BomRel Project
Plant BomRel Plant
ParameterEffectivityValue BomRel ParameterEffectivityValue
BillOfMaterial BomRel BillOfMaterial
BillOfMaterialVariant BomRel BillOfMaterialVariant
BillOfMaterialVariantUsage BomRel BillOfMaterialVariantUsage
BillOfMaterialVersion BomRel BillOfMaterialVersion
VersionSelection BomRel VersionSelection
BOMExplosionDate BomRel BOMExplosionDate
MjrAssyBckgndProcgStatus BomRel MjrAssyBckgndProcgStatus
ProjectDescription
PlannedStartDate
PlannedEndDate
ProjectObject
ProjectProfileCode
ResponsiblePersonName I_Project ResponsiblePersonName
ResponsiblePerson I_Project ResponsiblePerson
ProjectProfileCodeText _ProjectProfile ProjectProfileCodeText
Material I_Material Material
MaterialDescription _Text MaterialName 
@AbapCatalog.sqlViewName: 'IMANAGEPROJECT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType:#COMPOSITE
@ClientHandling.type:#CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType:{serviceQuality: #D, sizeCategory : #XL, dataClass: #MIXED }
@EndUserText.label: 'Project Details For End Item'
define view I_ManageProjectForEndItem
 as select distinct from I_EndItmMjrAssyProjSystRelshp        as BomRel
  
   inner join I_Project                               as ProjectBasicData  on  BomRel.Project = ProjectBasicData.Project   
   inner join I_Material                              as Material on BomRel.Material = Material.Material
   inner join I_UnitizedMaterialType                  as UnitizedType  on Material.MaterialType = UnitizedType.MaterialType

   association [0..1] to I_MaterialText               as _Text              on   $projection.Material = _Text.Material  
                                                                            and _Text.Language =  $session.system_language                                                                                       
                                                                                                                                                     
   association [0..1] to I_ProjectProfileCodeText     as _ProjectProfile    on   $projection.ProjectProfileCode = _ProjectProfile.ProjectProfileCode  
                                                                            and _ProjectProfile.Language = $session.system_language
   
   association [0..1] to I_MajorAssemblyProjectStatus   as _status            on  ProjectBasicData.ProjectObject = _status.ProjectObject  
                                                                                                                                               
{
    
   
      key BomRel.Project as Project,
      
      BomRel.Plant,
      BomRel.ParameterEffectivityValue,
      BomRel.BillOfMaterial,
      BomRel.BillOfMaterialVariant,
      BomRel.BillOfMaterialVariantUsage,
      BomRel.BillOfMaterialVersion,
      BomRel.VersionSelection,
      BomRel.BOMExplosionDate,
      BomRel.MjrAssyBckgndProcgStatus,
        
      ProjectBasicData. ProjectDescription,
      ProjectBasicData. PlannedStartDate,
      ProjectBasicData. PlannedEndDate,
      ProjectBasicData. ProjectObject,
      ProjectBasicData. ProjectProfileCode,
      ProjectBasicData.ResponsiblePersonName,
      ProjectBasicData.ResponsiblePerson,
      
   
     _ProjectProfile.ProjectProfileCodeText,
    
      
        Material.Material        as Material,
      _Text.MaterialName       as MaterialDescription,
  
              
       
      cast( case _status.ObjectIsDeleted
        when 'X' then 'I0013'
        else case _status.ObjectIsClosed
        when 'X' then 'I0046'
        else case _status.ObjectIsTechlyCompleted
        when 'X' then 'I0045'
        else case _status.ObjectIsLocked
        when 'X' then 'I0043'
        else case _status.ObjectIsConfirmed
        when 'X' then 'I0009'
        else case _status.ObjectIsPartiallyConfirmed
        when 'X' then 'I0010'
        else case _status.ObjectIsReleased
        when 'X' then 'I0002'
        else case _status.ObjectIsPartiallyReleased
        when 'X' then 'I0042'    
        else  'I0001'
        end end end end end end end end  as j_istat preserving type)                  as SystemStatus
        
      
        
                 
         
}
where UnitizedType.ComplexAssemblyType = '1'

Learn More