What is C_EmployeeBusinessUserTP in SAP S/4HANA?

C_EmployeeBusinessUserTP is a consumption CDS view in SAP S/4HANA. Employee Business User TP - Consumption View It contains 60 fields.

Which tables does C_EmployeeBusinessUserTP read from?

C_EmployeeBusinessUserTP reads data from: I_BusinessUserTP.

What VDM layer is C_EmployeeBusinessUserTP?

C_EmployeeBusinessUserTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_EmployeeBusinessUserTP

DDL: C_EMPLOYEEBUSINESSUSERTP SQL: CEMPLBUSUSERTP Type: view CONSUMPTION Package: FS4_BPU_ODATA

60 Fields 1 Data Sources 1 Associations

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 60 fields with key field BusinessPartnerUUID. It has 1 association to related views. Part of development package FS4_BPU_ODATA.

Data Sources (1)

Source	Alias	Join Type
I_BusinessUserTP	I_BusinessUserTP	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	C_BPUsrChangeDocument	_ChangeDoc	`$projection.BusinessPartnerUUID = _ChangeDoc.BusinessPartnerUUID`

Annotations (15)

Name	Value	Level
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 (60)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartnerUUID		BusinessPartnerUUID	UUID
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerRoleCategory		BusinessPartnerRoleCategory
	BusinessPartnerRole		BusinessPartnerRole	BP Role
	PersonNumber		PersonNumber	Person Number
	EmployeeExternalID		PersonExternalID	Logical System
	FormOfAddress		FormOfAddress	Title Key
	FormOfAddressName	_FormOfAddressText	FormOfAddressName	Title
	FirstName		FirstName	First Name
	LastName		LastName	Last Name
	ValidityStartDate		ValidityStartDate	Validity Start Date
	ValidityEndDate		ValidityEndDate	ValidTo
	IsMarkedForArchiving		IsMarkedForArchiving	Archiving Flag
	UserID		UserID	User Name
	UserName		UserName	User who owns item
	UserDescription		UserDescription	Full Name
	EmailAddress		EmailAddress	E-Mail Address
	CorrespondenceLanguage		CorrespondenceLanguage	Language
	CorrespondenceLanguageName	_CorrespondenceLanguage	LanguageName	Name
	DestinationLocationCountry		DestinationLocationCountry	Country/Region
	DestinationLocationCountryName	_DestinationLocationCountry	CountryName	Country
	PhoneNumber		PhoneNumber	Telephone no.
	PhoneNumberExtension		PhoneNumberExtension	Extension
	MblPhoneDestinationLocCountry		MblPhoneDestinationLocCountry
	MblPhoneDestinationCountryName	_MblPhoneDestinationLocCountry	CountryName	Country
	MobilePhoneNumber		MobilePhoneNumber	Telephone
	FaxNumberCountry		FaxNumberCountry	Country/Region
	FaxAreaCodeSubscriberNumber		FaxAreaCodeSubscriberNumber	Fax
	FaxExtensionNumber		FaxExtensionNumber	Extension
	Building		Building	Building code
	RoomNumber		RoomNumber	Room Number
	Department		Department	Department
	FunctionalTitleName		FunctionalTitleName
	AdditionalLastName		AdditionalLastName	Other Last Name
	LastNamePrefix		LastNamePrefix	Prefix Key
	LastNameSecondPrefix		LastNameSecondPrefix	2nd prefix
	BirthName		BirthName	Name at Birth
	NickName		NickName	Nickname
	MiddleName		MiddleName	Middle Name
	AcademicTitle		AcademicTitle	Academic Title
	AcademicTitleName	_AcademicTitle1	AcademicTitleName	Academic Title
	AcademicSecondTitle		AcademicSecondTitle
	AcademicTitle2Name	_AcademicTitle2	AcademicTitleName	Academic Title
	NameSupplement		NameSupplement
	Initials		Initials	Initials
	PersonFullName		PersonFullName	Full Name
	NameFormat		NameFormat	Name Format
	NameFormatDescription	_NameFormatText	NameFormatDescription
	NameCountry		NameCountry	Country/Region
	CountryFreeText	_NameCountryText	CountryName	Country
	SearchTerm1		SearchTerm1	Search Term 1
	SearchTerm2		SearchTerm2	Search Term 2
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	CreationDateTime		CreationDateTime	Timestamp
	CreatedByUser		CreatedByUser	User Name
	LastChangeDateTime		LastChangeDateTime	Timestamp
	LastChangedByUser		LastChangedByUser	User Name
	IsBusinessPurposeCompleted		IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet		DataControllerSet	Data Ctrlr. Set
	BPAddressChangeDocObject	_ChangeDoc	BPAddressChangeDocObject

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_EmployeeBusinessUserTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CEMPLBUSUSERTP

CREATE VIEW C_EmployeeBusinessUserTP AS
SELECT
  BusinessPartnerUUID,
  BusinessPartner,
  BusinessPartnerRoleCategory,
  BusinessPartnerRole,
  PersonNumber,
  PersonExternalID AS EmployeeExternalID,
  FormOfAddress,
  _FormOfAddressText.FormOfAddressName AS FormOfAddressName,
  FirstName,
  LastName,
  ValidityStartDate,
  ValidityEndDate,
  IsMarkedForArchiving,
  UserID,
  UserName,
  UserDescription,
  EmailAddress,
  CorrespondenceLanguage,
  _CorrespondenceLanguage.LanguageName AS CorrespondenceLanguageName,
  DestinationLocationCountry,
  _DestinationLocationCountry.CountryName AS DestinationLocationCountryName,
  PhoneNumber,
  PhoneNumberExtension,
  MblPhoneDestinationLocCountry,
  _MblPhoneDestinationLocCountry.CountryName AS MblPhoneDestinationCountryName,
  MobilePhoneNumber,
  FaxNumberCountry,
  FaxAreaCodeSubscriberNumber,
  FaxExtensionNumber,
  Building,
  RoomNumber,
  Department,
  FunctionalTitleName,
  AdditionalLastName,
  LastNamePrefix,
  LastNameSecondPrefix,
  BirthName,
  NickName,
  MiddleName,
  AcademicTitle,
  _AcademicTitle1.AcademicTitleName AS AcademicTitleName,
  AcademicSecondTitle,
  _AcademicTitle2.AcademicTitleName AS AcademicTitle2Name,
  NameSupplement,
  Initials,
  PersonFullName,
  NameFormat,
  _NameFormatText.NameFormatDescription AS NameFormatDescription,
  NameCountry,
  _NameCountryText.CountryName AS CountryFreeText,
  SearchTerm1,
  SearchTerm2,
  AuthorizationGroup,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  IsBusinessPurposeCompleted,
  DataControllerSet,
  _ChangeDoc.BPAddressChangeDocObject AS BPAddressChangeDocObject
FROM I_BusinessUserTP
LEFT OUTER JOIN C_BPUsrChangeDocument AS _ChangeDoc ON BusinessPartnerUUID = _ChangeDoc.BusinessPartnerUUID  -- association [1..1]
;

Depth:

C_EmployeeBusinessUserTP view

I_BusinessUserTP view