C_EmployeeBusinessUserTP

DDL: C_EMPLOYEEBUSINESSUSERTP SQL: CEMPLBUSUSERTP Type: view CONSUMPTION

Employee Business User TP - Consumption View

C_EmployeeBusinessUserTP is a Consumption CDS View that provides data about "Employee Business User TP - Consumption View" in SAP S/4HANA. It reads from 1 data source (I_BusinessUserTP) and exposes 58 fields with key field BusinessPartnerUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessUserTP I_BusinessUserTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_BPUsrChangeDocument _ChangeDoc $projection.BusinessPartnerUUID = _ChangeDoc.BusinessPartnerUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CEMPLBUSUSERTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Employee Business User TP - Consumption View view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID
BusinessPartner BusinessPartner
BusinessPartnerRoleCategory BusinessPartnerRoleCategory
BusinessPartnerRole BusinessPartnerRole
PersonNumber PersonNumber
EmployeeExternalID PersonExternalID
FormOfAddress FormOfAddress
FirstName FirstName
LastName LastName
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
IsMarkedForArchiving IsMarkedForArchiving
UserID UserID
UserName UserName
UserDescription UserDescription
EmailAddress EmailAddress
CorrespondenceLanguage CorrespondenceLanguage
DestinationLocationCountry DestinationLocationCountry
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
MblPhoneDestinationLocCountry MblPhoneDestinationLocCountry
MobilePhoneNumber MobilePhoneNumber
FaxNumberCountry FaxNumberCountry
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber
FaxExtensionNumber FaxExtensionNumber
Building Building
RoomNumber RoomNumber
Department Department
FunctionalTitleName FunctionalTitleName
AdditionalLastName AdditionalLastName
LastNamePrefix LastNamePrefix
LastNameSecondPrefix LastNameSecondPrefix
BirthName BirthName
NickName NickName
MiddleName MiddleName
AcademicTitle AcademicTitle
AcademicSecondTitle AcademicSecondTitle
NameSupplement NameSupplement
Initials Initials
PersonFullName PersonFullName
AuthorizationGroup AuthorizationGroup
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
BPAddressChangeDocObject _ChangeDoc BPAddressChangeDocObject
@AbapCatalog.sqlViewName: 'CEMPLBUSUSERTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #REQUIRED

@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Employee Business User TP - Consumption View'

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions
@Search.searchable: true
@ObjectModel: {
    transactionalProcessingDelegated: true,
    compositionRoot: true,
    draftEnabled: true,

    createEnabled: true,
    deleteEnabled: 'EXTERNAL_CALCULATION',
    updateEnabled: 'EXTERNAL_CALCULATION',
    semanticKey: ['BusinessPartner']
}
define view C_EmployeeBusinessUserTP
  as select from I_BusinessUserTP
  association [1..1] to C_BPUsrChangeDocument as _ChangeDoc on $projection.BusinessPartnerUUID = _ChangeDoc.BusinessPartnerUUID
{
  key BusinessPartnerUUID,

      @Consumption.semanticObject: 'BusinessUser'
      BusinessPartner,
      
      BusinessPartnerRoleCategory,
      
      BusinessPartnerRole,

      PersonNumber,

      // Basic Data //

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.85}
      @EndUserText: { label: 'Employee ID', quickInfo: 'Employee ID' }
      PersonExternalID                    as EmployeeExternalID,

      @Consumption.valueHelpDefinition.entity : {name: 'C_BPUSRFormOfAddressVH', element: 'FormOfAddress'}
      @Consumption.filter: {hidden: true}
      FormOfAddress,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.85}
      FirstName,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.85}
      LastName,

      // Validity Period //

      @Consumption.filter: {hidden: true}
      ValidityStartDate,

      @Consumption.filter: {hidden: true}
      ValidityEndDate,

      @Consumption: {filter: {selectionType: #SINGLE, defaultValue: ' ' }}
      @EndUserText: { label: 'Selected for Archiving', quickInfo: 'Selected for Archiving' }
      IsMarkedForArchiving,

      // Business User //

      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.85}
      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'User ID', quickInfo: 'User ID' }
      @Consumption.valueHelpDefinition.entity : {name: 'C_BPUsrAssignmentVH', element: 'UserID'}
      UserID,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'User Name', quickInfo: 'User Name' }
      UserName,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'User Description', quickInfo: 'User Description' }
      UserDescription,

      // Contact //

      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.85}
      @Semantics.eMail.type:  #WORK
      @Semantics.eMail.address: true
      EmailAddress,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Correspondence Language', quickInfo: 'Correspondence Language' }
      @Consumption.valueHelpDefinition.entity : {name: 'I_Language', element: 'Language'}
      CorrespondenceLanguage,

      // Telephone //

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Country/Region Code', quickInfo: 'Country/Region Code' }
      @Consumption.valueHelpDefinition.entity : {name: 'I_CountryVH', element: 'Country'}
      DestinationLocationCountry,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Phone', quickInfo: 'Phone' }
      PhoneNumber,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Phone Extension', quickInfo: 'Phone Extension' }
      PhoneNumberExtension,

      // Mobile Phone //

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Country/Region Code', quickInfo: 'Country/Region Code' }
      @Consumption.valueHelpDefinition.entity : {name: 'I_CountryVH', element: 'Country'}
      MblPhoneDestinationLocCountry,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Mobile', quickInfo: 'Mobile' }
      MobilePhoneNumber,

      // Fax //

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Country/Region Code', quickInfo: 'Country/Region Code' }
      @Consumption.valueHelpDefinition.entity : {name: 'I_CountryVH', element: 'Country'}
      FaxNumberCountry,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Fax', quickInfo: 'Fax' }
      FaxAreaCodeSubscriberNumber,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Fax Extension', quickInfo: 'Fax Extension' }
      FaxExtensionNumber,

      // WorkPlace Data //

      @Consumption.filter: {hidden: true}
      Building,

      @Consumption.filter: {hidden: true}
      RoomNumber,

      @Consumption.filter: {hidden: true}
      Department,

      @Consumption.filter: {hidden: true}
      FunctionalTitleName,

      // Name Data //

      @Consumption.filter: {hidden: true}
      AdditionalLastName,

      @Consumption.filter: {hidden: true}
      @Consumption.valueHelpDefinition.entity: {name: 'I_BusPartPrefixName', element: 'LastNamePrefix' }
      LastNamePrefix,

      @Consumption.filter: {hidden: true}
      @Consumption.valueHelpDefinition.entity: {name: 'I_BusPartPrefixName', element: 'LastNamePrefix' }
      LastNameSecondPrefix,

      @Consumption.filter: {hidden: true}
      BirthName,

      @Consumption.filter: {hidden: true}
      NickName,

      @Consumption.filter: {hidden: true}
      MiddleName,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Academic Title', quickInfo: 'Academic Title' }
      @Consumption.valueHelpDefinition.entity : {name: 'I_AcademicTitleVH', element: 'AcademicTitle'}
      AcademicTitle,

      @Consumption.filter: {hidden: true}
      @EndUserText: { label: 'Academic Second Title', quickInfo: 'Academic Second Title' }
      @Consumption.valueHelpDefinition.entity : {name: 'I_AcademicTitleVH', element: 'AcademicTitle'}
      AcademicSecondTitle,

      @Consumption.filter: {hidden: true}
      @Consumption.valueHelpDefinition.entity: {name: 'I_BusPartSupplementName', element: 'BusinessPartnerSupplementName' }
      NameSupplement,

      @Consumption.filter: {hidden: true}
      Initials,

      @Consumption.filter: {hidden: true}
      @Semantics.name.fullName: true
      PersonFullName,

      // Other hidden fields //

      AuthorizationGroup,

      CreationDateTime,

      CreatedByUser,

      LastChangeDateTime,

      LastChangedByUser,

      IsBusinessPurposeCompleted,

      @Consumption.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      DataController1,
      @Consumption.hidden:true
      DataController2,
      @Consumption.hidden:true
      DataController3,
      @Consumption.hidden:true
      DataController4,
      @Consumption.hidden:true
      DataController5,
      @Consumption.hidden:true
      DataController6,
      @Consumption.hidden:true
      DataController7,
      @Consumption.hidden:true
      DataController8,
      @Consumption.hidden:true
      DataController9,
      @Consumption.hidden:true
      DataController10,
      
      @ObjectModel.readOnly: true
      _ChangeDoc.BPAddressChangeDocObject as BPAddressChangeDocObject 
      
      
}
where
  BusinessPartnerRoleCategory = 'BUP003'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_BPUSRCHANGEDOCUMENT",
"I_BUSINESSUSERTP"
],
"ASSOCIATED":
[
"C_BPUSRCHANGEDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/