I_UserSubstitute

DDL: I_USERSUBSTITUTE SQL: IHRUS_D2 Type: view BASIC Package: SP00

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 8 fields with key fields UserID, UserSubstituteIdentifier, ValidityStartDate. It has 2 associations to related views. Part of development package SP00.

1 data source(s) 8 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 (8)

KeyFieldSource TableSource FieldDescription
KEY UserID us_name
KEY UserSubstituteIdentifier rep_name
KEY ValidityStartDate begda
ValidityEndDate endda
UserSubstitutionIsActive active
SubstituteProfile reppr
_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]
@Consumption.dbHints: [ 'USE_HEX_PLAN' ] 
                                     
/*+[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,
      reppr    as SubstituteProfile,
      
      _BusinessUser,
      _BusinessUserSubstitute
}

Learn More