I_UserSubstitute

DDL: I_USERSUBSTITUTE SQL: IHRUS_D2 Type: view BASIC

User Substitutes

I_UserSubstitute is a Basic CDS View that provides data about "User Substitutes" in SAP S/4HANA. It reads from 1 data source (hrus_d2) and exposes 7 fields with key fields UserID, UserSubstituteIdentifier, ValidityStartDate. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
hrus_d2 hrus_d2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessUserBasic _BusinessUser $projection.UserID = _BusinessUser.UserID
[0..1] I_BusinessUserBasic _BusinessUserSubstitute $projection.UserSubstituteIdentifier = _BusinessUserSubstitute.UserID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IHRUS_D2 view
EndUserText.label User Substitutes view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY UserID us_name
KEY UserSubstituteIdentifier rep_name
KEY ValidityStartDate begda
ValidityEndDate endda
UserSubstitutionIsActive active
_BusinessUser _BusinessUser
_BusinessUserSubstitute _BusinessUserSubstitute 
@AbapCatalog.sqlViewName: 'IHRUS_D2'
@EndUserText.label: 'User Substitutes'
@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.dataMaintenance: #DISPLAY_ONLY
@AccessControl.authorizationCheck: #CHECK

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S

@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]
                                     
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/ 
define view I_UserSubstitute as select from hrus_d2 
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    association [0..1] to I_BusinessUserBasic  as _BusinessUser           on $projection.UserID           = _BusinessUser.UserID           
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/ 
    association [0..1] to I_BusinessUserBasic  as _BusinessUserSubstitute on $projection.UserSubstituteIdentifier = _BusinessUserSubstitute.UserID
{
  key us_name  as UserID,
  key rep_name as UserSubstituteIdentifier,
      @Semantics.businessDate.from
  key begda    as ValidityStartDate,
      @Semantics.businessDate.to
      endda    as ValidityEndDate,  
      active   as UserSubstitutionIsActive,
      
      _BusinessUser,
      _BusinessUserSubstitute
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRUS_D2"
],
"ASSOCIATED":
[
"I_BUSINESSUSERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More