I_MajorAssemblyProjectStatus

DDL: I_MAJORASSEMBLYPROJECTSTATUS SQL: IPROJECTSTATUS Type: view COMPOSITE

To get Project Status Description

I_MajorAssemblyProjectStatus is a Composite CDS View that provides data about "To get Project Status Description" in SAP S/4HANA. It reads from 1 data source (I_Project) and exposes 9 fields with key field ProjectObject.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_Project p from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPROJECTSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey ProjectObject view
EndUserText.label To get Project Status Description view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProjectObject I_Project ProjectObject
ObjectIsCreated
ObjectIsReleased
ObjectIsDeleted
ObjectIsPartiallyReleased
ObjectIsTechlyCompleted
ObjectIsClosed
ObjectIsMarkedForDeletion
ObjectIsMasterDataLocked 
@AbapCatalog.sqlViewName: 'IPROJECTSTATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType:{serviceQuality: #C, sizeCategory : #XL, dataClass: #MIXED }
@ObjectModel.representativeKey: 'ProjectObject'
@EndUserText.label: 'To get Project Status Description'
define view I_MajorAssemblyProjectStatus as select from I_Project as p
 left outer to one join I_StatusObjectStatusBasic as _isCreated      on _isCreated.StatusObject      = p.ProjectObject and _isCreated.StatusCode      = 'I0001' and _isCreated.StatusIsInactive   = ''// OrderIscreated

  left outer to one join I_StatusObjectStatusBasic as _isReleased     on _isReleased.StatusObject     = p.ProjectObject and _isReleased.StatusCode     = 'I0002' and  _isReleased.StatusIsInactive   = ''// OrderIsReleased

 //left outer to one join I_StatusObjectStatusBasic as _isConfirmed    on _isConfirmed.StatusObject    = p.ProjectObject and _isConfirmed.StatusCode    = 'I0009' // OrderIsConfirmed

 //left outer to one join I_StatusObjectStatusBasic as _isPartConf     on _isPartConf.StatusObject     = p.ProjectObject and _isPartConf.StatusCode     = 'I0010' // OrderIsPartiallyConfirmed

  left outer to one join I_StatusObjectStatusBasic as _isDeleted      on _isDeleted.StatusObject      = p.ProjectObject and _isDeleted.StatusCode      = 'I0013' and  _isDeleted.StatusIsInactive  = ''// OrderIsDeleted

  left outer to one join I_StatusObjectStatusBasic as _isPartRel      on _isPartRel.StatusObject      = p.ProjectObject and _isPartRel.StatusCode      = 'I0042' and  _isPartRel.StatusIsInactive  = ''// OrderIsPartiallyReleased

 //left outer to one join I_StatusObjectStatusBasic as _isLocked       on _isLocked.StatusObject       = p.ProjectObject and _isLocked.StatusCode       = 'I0043' // OrderIsLocked

  left outer to one join I_StatusObjectStatusBasic as _isTechCompl    on _isTechCompl.StatusObject    = p.ProjectObject and _isTechCompl.StatusCode    = 'I0045' and  _isTechCompl.StatusIsInactive   = ''// OrderIsTechnicallyCompleted

  left outer to one join I_StatusObjectStatusBasic as _isClosed       on _isClosed.StatusObject       = p.ProjectObject and _isClosed.StatusCode       = 'I0046' and  _isClosed.StatusIsInactive   = ''// OrderIsClosed

  left outer to one join I_StatusObjectStatusBasic as _isMarkedDel    on _isMarkedDel.StatusObject    = p.ProjectObject and _isMarkedDel.StatusCode    = 'I0076' and  _isMarkedDel.StatusIsInactive   = ''// OrderIsMarkedForDeletion

  left outer to one join I_StatusObjectStatusBasic as _isMastDataLock    on _isMastDataLock.StatusObject    = p.ProjectObject and _isMastDataLock.StatusCode    = 'I0065' and  _isMastDataLock.StatusIsInactive   = ''// OrderIsMarkedForDeletion



        {
              key p.ProjectObject,

     // Status


      case when _isCreated.StatusCode  is null then '' else 'X' end as ObjectIsCreated,
      case when _isReleased.StatusCode is null then '' else 'X' end as ObjectIsReleased,
     // case when _isConfirmed.StatusCode is null then '' else 'X' end as ObjectIsConfirmed,

      //case when _isPartConf.StatusCode is null then '' else 'X' end as ObjectIsPartiallyConfirmed,

      case when _isDeleted.StatusCode is null then '' else 'X' end as ObjectIsDeleted,
      case when _isPartRel.StatusCode is null then '' else 'X' end as ObjectIsPartiallyReleased,
      //case when _isLocked.StatusCode is null then '' else 'X' end as ObjectIsLocked,

      case when _isTechCompl.StatusCode is null then '' else 'X' end as ObjectIsTechlyCompleted,
      case when _isClosed.StatusCode is null then '' else 'X' end as ObjectIsClosed,
      case when _isMarkedDel.StatusCode is null then '' else 'X' end as ObjectIsMarkedForDeletion,
      case when _isMastDataLock.StatusCode is null then '' else 'X' end as ObjectIsMasterDataLocked

}

Learn More