I_QltyInProcmtUserStatus

DDL: I_QLTYINPROCMTUSERSTATUS SQL: IQINFUSRSTS Type: view COMPOSITE Package: VDM_QM_PLANNING

Quality Info Record Status

I_QltyInProcmtUserStatus is a Composite CDS View that provides data about "Quality Info Record Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 11 fields with key fields Material, QltyInProcmtIntID, StatusCode. It has 4 associations to related views. Part of development package VDM_QM_PLANNING.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Associations (4)

CardinalityTargetAliasCondition
[1] I_QualityInProcurement _QualityInProcurement $projection.QltyInProcmtIntID = _QualityInProcurement.QltyInProcmtIntID and $projection.Material = _QualityInProcurement.Material
[1] I_UserStatusText _UserStatusText $projection.StatusCode = _UserStatusText.UserStatus and $projection.StatusProfile = _UserStatusText.StatusProfile and _UserStatusText.Language = $session.system_language
[0..1] I_StatusCode _StatusCode $projection.StatusCode = _StatusCode.StatusCode and $projection.StatusProfile = _StatusCode.StatusProfile
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IQINFUSRSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quality Info Record Status view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey QltyInProcmtIntID view
ObjectModel.compositionRoot true view
ObjectModel.sapObjectNodeType.name PurgQltyInfoRecdStatus view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material I_QualityInProcurement Material
KEY QltyInProcmtIntID I_QualityInProcurement QltyInProcmtIntID
KEY StatusCode I_StatusObjectActiveStatus StatusCode
StatusProfile I_QualityInProcurement StatusProfile
StatusObject I_StatusObjectActiveStatus StatusObject
UserStatusName _UserStatusText UserStatusName
_StatusObject I_StatusObjectActiveStatus _StatusObject
_QualityInProcurement _QualityInProcurement
_UserStatusText _UserStatusText
_StatusCode _StatusCode
_Material _Material 
@AbapCatalog.sqlViewName: 'IQINFUSRSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Quality Info Record Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.supportedCapabilities:
 [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.representativeKey: 'QltyInProcmtIntID'
@ObjectModel.compositionRoot: true
@ObjectModel.sapObjectNodeType.name: 'PurgQltyInfoRecdStatus'
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
}
define view I_QltyInProcmtUserStatus
  as select from           I_StatusObjectActiveStatus
    left outer to one join I_QualityInProcurement on I_QualityInProcurement.ControllingObject = I_StatusObjectActiveStatus.StatusObject

  association [1]    to I_QualityInProcurement as _QualityInProcurement on  $projection.QltyInProcmtIntID = _QualityInProcurement.QltyInProcmtIntID
                                                                        and $projection.Material          = _QualityInProcurement.Material
  association [1]    to I_UserStatusText       as _UserStatusText       on  $projection.StatusCode    = _UserStatusText.UserStatus
                                                                        and $projection.StatusProfile = _UserStatusText.StatusProfile
                                                                        and _UserStatusText.Language  = $session.system_language
  association [0..1] to I_StatusCode           as _StatusCode           on  $projection.StatusCode    = _StatusCode.StatusCode
                                                                        and $projection.StatusProfile = _StatusCode.StatusProfile
  association [1..1] to I_Material             as _Material             on  $projection.Material = _Material.Material
{
            @ObjectModel.foreignKey.association: '_Material'
  key       I_QualityInProcurement.Material,
  key       I_QualityInProcurement.QltyInProcmtIntID,
            @ObjectModel.foreignKey.association: '_StatusCode'
  key       I_StatusObjectActiveStatus.StatusCode,
            I_QualityInProcurement.StatusProfile,
            I_StatusObjectActiveStatus.StatusObject,
            _UserStatusText.UserStatusName,

            I_StatusObjectActiveStatus._StatusObject,
            _QualityInProcurement,
            _UserStatusText,
            _StatusCode,
            _Material
}
where
  I_StatusObjectActiveStatus.StatusObject like 'QI%'

Learn More