I_LglCntntMUserValueHelp

DDL: I_LGLCNTNTMUSERVALUEHELP SQL: ILCMUSRVH Type: view COMPOSITE

Composite view for User Value help

I_LglCntntMUserValueHelp is a Composite CDS View that provides data about "Composite view for User Value help" in SAP S/4HANA. It has 1 association to related views.

9 fields

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_LglCntntMUser _LglCntntMUser $projection.UserID = _LglCntntMUser.UserID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILCMUSRVH view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey UserID view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Composite view for User Value help view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UserID ContactCardID
Person Person
AddressID AddressID
FirstName FirstName
LastName LastName
FullName FullName
EmailAddress EmailAddress
Department Department
_LglCntntMUser _LglCntntMUser 
@AbapCatalog.sqlViewName: 'ILCMUSRVH'
@VDM.viewType: #COMPOSITE

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true


@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
//@ObjectModel.dataCategory: #VALUE_HELP

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations:  [ '_LglCntntMUser' ]
@ObjectModel.representativeKey: 'UserID'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Composite view for User Value help'
define view I_LglCntntMUserValueHelp
  as select distinct from I_LCMUserContactCard as _LCMUserContactCard

  //restricting to users with LCM_GEN profile

  association [0..1] to I_LglCntntMUser as _LglCntntMUser on $projection.UserID = _LglCntntMUser.UserID

{

  key
     ContactCardID as  UserID,

     Person,

     AddressID,

     FirstName,

     LastName,

     FullName,

     EmailAddress,

     Department,
     _LglCntntMUser

}
where
  _LCMUserContactCard.ContactCardID is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LCMUSERCONTACTCARD"
],
"ASSOCIATED":
[
"I_LGLCNTNTMUSER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More