P_MDQualityBusinessRuleUser

DDL: P_MDQUALITYBUSINESSRULEUSER Type: view_entity BASIC

P_MDQualityBusinessRuleUser is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (usrbf2) and exposes 3 fields.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
usrbf2 _Users inner

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
bname usrbf2 bname
bname
auth usrbf2 auth 
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType: { dataClass: #MASTER, serviceQuality: #C, sizeCategory: #L }
@VDM.viewType: #BASIC
@VDM.private: true
define view entity P_MDQualityBusinessRuleUser
  as select distinct from usrbf2 as _Users
{
  _Users.bname,
  _Users.auth
}
where
  _Users.objct = 'MDQRM_RULE'

union

select distinct from usrefus
  inner join         usrbf2 as _Users on _Users.bname = usrefus.refuser
{
  _Users.bname,
  _Users.auth
}
where
  _Users.objct = 'MDQRM_RULE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USRBF2",
"USREFUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More