C_AURSAssignableUser

DDL: C_AURSASSIGNABLEUSER SQL: CAURSASSBLUSER Type: view CONSUMPTION

C_AURSAssignableUser is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_RetailStoreAssignableUser) and exposes 8 fields with key fields Store, UserID. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_RetailStoreAssignableUser I_RetailStoreAssignableUser from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_AURSStoreUser _UserAssignment $projection.UserID = _UserAssignment.AssignedUser
[0..1] I_UserContactCard _UserContactCard $projection.UserID = _UserContactCard.ContactCardID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CAURSASSBLUSER view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey Store view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Store Store
KEY UserID UserID
AssignedStore _UserAssignment Store
FirstName _UserContactCard FirstName
LastName _UserContactCard LastName
FullName _UserContactCard FullName
IsCurrentUser
_ParentStore _ParentStore 
@AbapCatalog.sqlViewName: 'CAURSASSBLUSER'

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    representativeKey: 'Store',
    usageType.serviceQuality: #D,
    usageType.sizeCategory: #L,
    usageType.dataClass: #MASTER
}
define view C_AURSAssignableUser
  as select from I_RetailStoreAssignableUser

  association        to parent C_AURSStore as _ParentStore     on $projection.Store = _ParentStore.Store
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association [0..1] to C_AURSStoreUser    as _UserAssignment  on $projection.UserID = _UserAssignment.AssignedUser
  association [0..1] to I_UserContactCard  as _UserContactCard on $projection.UserID = _UserContactCard.ContactCardID
{
  key Store,
  key UserID,

      _UserAssignment.Store                                                                  as AssignedStore,

      _UserContactCard.FirstName,
      _UserContactCard.LastName,
      _UserContactCard.FullName,

      cast(case when UserID = $session.user then 'X' else '' end as boolean preserving type) as IsCurrentUser,

      _ParentStore
}
where
     _UserAssignment.Store is null  // no existing assignment

  or _UserAssignment.Store != Store // existing assignment to other store

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_AURSSTOREUSER",
"I_RETAILSTOREASSIGNABLEUSER",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"C_AURSSTORE",
"C_AURSSTOREUSER",
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More