What is C_MaintWrkCtrAssignedPersonVH in SAP S/4HANA?

C_MaintWrkCtrAssignedPersonVH is a consumption CDS view in SAP S/4HANA. Value Help for Maint. Work Center Person It contains 85 fields.

Which tables does C_MaintWrkCtrAssignedPersonVH read from?

C_MaintWrkCtrAssignedPersonVH reads data from: I_HrRelation, I_HrRelation, I_HrRelation, I_HrRelation, I_HrRelation and more.

What VDM layer is C_MaintWrkCtrAssignedPersonVH?

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

C_MaintWrkCtrAssignedPersonVH

DDL: C_MAINTWRKCTRASSIGNEDPERSONVH SQL: CEAMWRKCTRPERSVH Type: view CONSUMPTION

85 Fields 10 Data Sources

Value Help for Maint. Work Center Person

C_MaintWrkCtrAssignedPersonVH is a Consumption CDS View that provides data about "Value Help for Maint. Work Center Person" in SAP S/4HANA. It reads from 10 data sources and exposes 85 fields with key fields WorkCenterInternalID, PersonWorkAgreement, PersonWorkAgreement, PersonWorkAgreement, PersonWorkAgreement.

Data Sources (10)

Source	Alias	Join Type
I_HrRelation	_capacity	inner
I_HrRelation	_capacity	inner
I_HrRelation	_orgunit	inner
I_HrRelation	_person	inner
I_HrRelation	_position	inner
I_HrRelation	_position	inner
I_HrRelation	_workcenter_rel	from
I_WorkCenterCapacity	_workcentercap	union
I_WorkCenterCapacity	_workcentercap	union
I_MaintenanceWorkCenterOrgUnit	_WorkCenterOrgUnit	union

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CEAMWRKCTRPERSVH	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Value Help for Maint. Work Center Person	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.representativeKey	WorkCenterInternalID	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (85)

Key	Field	Source Table	Source Field	Description
KEY	WorkCenterInternalID
KEY	PersonWorkAgreement
	WorkCenter	_workcenter	WorkCenter	Work Center
	Plant	_workcenter	Plant	Valuation Area
	BusinessPartner	_businesspartner	BusinessPartner	Issuing Authority
	FirstName	_businesspartner	FirstName	First Name
	LastName	_businesspartner	LastName	Last Name
	PersonFullName	_businesspartner	PersonFullName	Full Name
	WorkCenterCategoryCode	_workcenter	WorkCenterCategoryCode
	AuthorizationGroup	_businesspartner	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	_businesspartner	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	_businesspartner	DataControllerSet	Data Ctrlr. Set
	DataController1	_businesspartner	DataController1	Data Controller
	DataController2	_businesspartner	DataController2	Data Controller
	DataController3	_businesspartner	DataController3	Data Controller
	DataController4	_businesspartner	DataController4	Data Controller
	DataController5	_businesspartner	DataController5	Data Controller
	DataController6	_businesspartner	DataController6	Data Controller
	DataController7	_businesspartner	DataController7	Data Controller
	DataController8	_businesspartner	DataController8	Data Controller
	DataController9	_businesspartner	DataController9	Data Controller
	WorkCenterInternalID
KEY	PersonWorkAgreement
	WorkCenter	I_MaintenanceWorkCenterOrgUnit	WorkCenter	Work Center
	Plant	I_MaintenanceWorkCenterOrgUnit	Plant	Valuation Area
	BusinessPartner	_businesspartner	BusinessPartner	Issuing Authority
	FirstName	_businesspartner	FirstName	First Name
	LastName	_businesspartner	LastName	Last Name
	PersonFullName	_businesspartner	PersonFullName	Full Name
	WorkCenterCategoryCode
	AuthorizationGroup	_businesspartner	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	_businesspartner	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	_businesspartner	DataControllerSet	Data Ctrlr. Set
	DataController1	_businesspartner	DataController1	Data Controller
	DataController2	_businesspartner	DataController2	Data Controller
	DataController3	_businesspartner	DataController3	Data Controller
	DataController4	_businesspartner	DataController4	Data Controller
	DataController5	_businesspartner	DataController5	Data Controller
	DataController6	_businesspartner	DataController6	Data Controller
	DataController7	_businesspartner	DataController7	Data Controller
	DataController8	_businesspartner	DataController8	Data Controller
	DataController9	_businesspartner	DataController9	Data Controller
	WorkCenterInternalID
KEY	PersonWorkAgreement
	WorkCenter	_workcenter	WorkCenter	Work Center
	Plant	_workcenter	Plant	Valuation Area
	BusinessPartner	_businesspartner	BusinessPartner	Issuing Authority
	FirstName	_businesspartner	FirstName	First Name
	LastName	_businesspartner	LastName	Last Name
	PersonFullName	_businesspartner	PersonFullName	Full Name
	WorkCenterCategoryCode	_workcenter	WorkCenterCategoryCode
	AuthorizationGroup	_businesspartner	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	_businesspartner	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	_businesspartner	DataControllerSet	Data Ctrlr. Set
	DataController1	_businesspartner	DataController1	Data Controller
	DataController2	_businesspartner	DataController2	Data Controller
	DataController3	_businesspartner	DataController3	Data Controller
	DataController4	_businesspartner	DataController4	Data Controller
	DataController5	_businesspartner	DataController5	Data Controller
	DataController6	_businesspartner	DataController6	Data Controller
	DataController7	_businesspartner	DataController7	Data Controller
	DataController8	_businesspartner	DataController8	Data Controller
	DataController9	_businesspartner	DataController9	Data Controller
	WorkCenterInternalID
KEY	PersonWorkAgreement
	WorkCenter	_workcenter	WorkCenter	Work Center
	Plant	_workcenter	Plant	Valuation Area
	BusinessPartner	_businesspartner	BusinessPartner	Issuing Authority
	FirstName	_businesspartner	FirstName	First Name
	LastName	_businesspartner	LastName	Last Name
	PersonFullName	_businesspartner	PersonFullName	Full Name
	WorkCenterCategoryCode	_workcenter	WorkCenterCategoryCode
	AuthorizationGroup	_businesspartner	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	_businesspartner	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	_businesspartner	DataControllerSet	Data Ctrlr. Set
	DataController1	_businesspartner	DataController1	Data Controller
	DataController2	_businesspartner	DataController2	Data Controller
	DataController3	_businesspartner	DataController3	Data Controller
	DataController4	_businesspartner	DataController4	Data Controller
	DataController5	_businesspartner	DataController5	Data Controller
	DataController6	_businesspartner	DataController6	Data Controller
	DataController7	_businesspartner	DataController7	Data Controller
	DataController8	_businesspartner	DataController8	Data Controller
	DataController9	_businesspartner	DataController9	Data Controller
	DataController10	_businesspartner	DataController10	Data Controller

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_MaintWrkCtrAssignedPersonVH.
-- 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: CEAMWRKCTRPERSVH

CREATE VIEW C_MaintWrkCtrAssignedPersonVH AS
SELECT
  cast( _workcenter_rel.HumRsceObjectId as cr_objid preserving type ) AS WorkCenterInternalID,
  cast( _person.HumRsceRelatedObjectId as persno ) AS PersonWorkAgreement,
  _workcenter.WorkCenter AS WorkCenter,
  _workcenter.Plant AS Plant,
  _businesspartner.BusinessPartner AS BusinessPartner,
  _businesspartner.FirstName AS FirstName,
  _businesspartner.LastName AS LastName,
  _businesspartner.PersonFullName AS PersonFullName,
  _workcenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _businesspartner.AuthorizationGroup AS AuthorizationGroup,
  _businesspartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _businesspartner.DataControllerSet AS DataControllerSet,
  _businesspartner.DataController1 AS DataController1,
  _businesspartner.DataController2 AS DataController2,
  _businesspartner.DataController3 AS DataController3,
  _businesspartner.DataController4 AS DataController4,
  _businesspartner.DataController5 AS DataController5,
  _businesspartner.DataController6 AS DataController6,
  _businesspartner.DataController7 AS DataController7,
  _businesspartner.DataController8 AS DataController8,
  _businesspartner.DataController9 AS DataController9,
  _businesspartner.DataController10 AS DataController10
FROM I_HrRelation AS _workcenter_rel
INNER JOIN I_HrRelation AS _person ON /* join condition not captured in parsed metadata */
INNER JOIN I_HrRelation AS _orgunit ON /* join condition not captured in parsed metadata */
INNER JOIN I_HrRelation AS _position ON /* join condition not captured in parsed metadata */
INNER JOIN I_HrRelation AS _capacity ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_MaintenanceWorkCenterOrgUnit, I_WorkCenterCapacity
;

Depth:

C_MaintWrkCtrAssignedPersonVH view