I_ManageProjectForEndItem

DDL: I_MANAGEPROJECTFORENDITEM SQL: IMANAGEPROJECT Type: view COMPOSITE

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.

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