I_QltyInProcmtActiveStatus

DDL: I_QLTYINPROCMTACTIVESTATUS Type: view_entity COMPOSITE Package: VDM_QM_PLANNING

Status of Q-Info Record in Procurement

I_QltyInProcmtActiveStatus is a Composite CDS View that provides data about "Status of Q-Info Record in Procurement" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatus) and exposes 9 fields with key fields StatusObject, StatusCode. It has 2 associations to related views. Part of development package VDM_QM_PLANNING.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatus I_StatusObjectStatus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StatusCode _StatusCode $projection.StatusCode = _StatusCode.StatusCode and $projection.StatusProfile = _StatusCode.StatusProfile
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (9)

NameValueLevelField
EndUserText.label Status of Q-Info Record in Procurement view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey StatusCode view
Analytics.technicalName IQTYINPRACTSTAT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode
StatusProfile StatusProfile
IsUserStatus IsUserStatus
StatusIsActive StatusIsActive
StatusSequenceNumber _StatusCode StatusSequenceNumber
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_StatusCode _StatusCode 
@EndUserText.label: 'Status of Q-Info Record in Procurement'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: [ '_StatusObject' ]
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'StatusCode'
@Analytics.technicalName: 'IQTYINPRACTSTAT'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@Metadata.ignorePropagatedAnnotations: true

define view entity I_QltyInProcmtActiveStatus as select from I_StatusObjectStatus

association         to I_StatusObject   as _StatusObject    on  $projection.StatusObject = _StatusObject.StatusObject

association [0..1]  to I_StatusCode     as _StatusCode      on  $projection.StatusCode = _StatusCode.StatusCode and
                                                                $projection.StatusProfile = _StatusCode.StatusProfile

association [0..1]  to I_StatusProfile  as _StatusProfile   on  $projection.StatusProfile = _StatusProfile.StatusProfile


{
  @ObjectModel.foreignKey.association: '_StatusObject'
  key StatusObject,
  @ObjectModel.foreignKey.association: '_StatusCode'
  key StatusCode,
  @ObjectModel.foreignKey.association: '_StatusProfile'
  StatusProfile,
  @Semantics.booleanIndicator: true
  IsUserStatus,
  @Semantics.booleanIndicator: true
  StatusIsActive,
  _StatusCode.StatusSequenceNumber as StatusSequenceNumber,
    
  _StatusObject,
  _StatusProfile,
  _StatusCode
} where StatusObject like 'QI%' and StatusIsInactive = '' //and _StatusCode.StatusSequenceNumber <> '00'

Learn More