Which CDS Views use I_WORKFORCEPERSON?

I_WORKFORCEPERSON is used by 47 CDS view(s), including: C_BillgProcDocWrkFlwRcpntVH, C_EngmtProjTeamSrchHelp, C_PersnWrkAgrmtCtrlgForOPg, C_PersnWrkAgrmtDetForOPg, C_PersnWrkAgrmtProjForOPg, C_PersnWrkAgrmtTagForOPg, C_ProjDmndResourceContactCard, C_SlsDocWrkFlwRecipientVH, C_SlsPriceWorkflowRecipientVH, C_SupplierActivityOVP.

How many fields does I_WORKFORCEPERSON have?

I_WORKFORCEPERSON has 22 fields. Key fields: Person, PersonExternalID.

I_WORKFORCEPERSON

CDS View

Workforce Person Details

I_WORKFORCEPERSON is a CDS View in S/4HANA. Workforce Person Details. It contains 22 fields. 47 CDS views read from this table.

CDS Views using this table (47)

View	Type	Join	VDM	Description
C_BillgProcDocWrkFlwRcpntVH	view	inner	CONSUMPTION	Billg Proc. Doc. WF Recipient Value Help
C_EngmtProjTeamSrchHelp	view	inner	CONSUMPTION	Search Help For JAM
C_PersnWrkAgrmtCtrlgForOPg	view	from	CONSUMPTION	Person Work Agreement Controlling Details for Object Page
C_PersnWrkAgrmtDetForOPg	view	from	CONSUMPTION	Person Work Agreement Details for Object Page
C_PersnWrkAgrmtProjForOPg	view	from	CONSUMPTION	Person Work Agreement Project Details for Object Page
C_PersnWrkAgrmtTagForOPg	view	left_outer	CONSUMPTION	Person Work Agreement Tag Details for Object Page
C_ProjDmndResourceContactCard	view	inner	CONSUMPTION	Contact Card for Person Work Agreement
C_SlsDocWrkFlwRecipientVH	view	inner	CONSUMPTION	Sales Document Work Flow Recipient VH
C_SlsPriceWorkflowRecipientVH	view	inner	CONSUMPTION	Sales Price Workflow Recipient
C_SupplierActivityOVP	view	left_outer	CONSUMPTION	Supplier Activity Overview Page
I_MstrProjActlCostQty	view	left_outer	COMPOSITE	Commercial Project Actual Input Cost Qty
I_MstrProjActlStatisticKeyFig	view	left_outer	COMPOSITE	Commercial Project Output SKF Actuals
I_MstrProjEmplWthAddr	view	from	COMPOSITE	Master Project Employee With Address
I_MstrProjUser	view	inner	COMPOSITE	Master Project User
I_MstrProjWorkForcePerson	view	from	COMPOSITE	Master Project Workforce Person Details
I_PersnWrkAgrmtValueHelp	view_entity	inner	COMPOSITE	Work Agreements of a Workforce Person
I_PersWrkAgrmtAllSrchHelp	view	inner	COMPOSITE	Search Help for all WorkAgreements
I_PersWrkAgrmtSrchHelp	view	inner	COMPOSITE	Search Help for WorkAgreements
I_PersWrkAgrmtSrchHelp_1	view	inner	COMPOSITE	Search Help for WorkAgreements
I_ProbSolvingPrtcpntPersnInfo	view	from	COMPOSITE	Prob.-Solving Proc. Prtcpnt Person Info
I_ProjectMgrOrgDet	view	inner	COMPOSITE	Retrieve project details for the session user
I_Projwipdetpernrvaluehelp	view	left_outer	COMPOSITE	Employee Value Help
I_SrcgProjPotentialContact	view_entity	union	COMPOSITE	Potential Contact for Sourcing Project
I_SrcgProjPotentialContact	view_entity	from	COMPOSITE	Potential Contact for Sourcing Project
I_SrvcEntrShtRespUsrValueHelp	view	inner	COMPOSITE	SES Responsible User Value Help
I_WorkforcePersonDet	view	from	COMPOSITE	Retrive Workforce Person Details
I_WorkForcePersonPayt	view	from	COMPOSITE	Workforce Person Payment Details for Object Page
P_EngmntProjStfngSrchByPerson	view	inner	CONSUMPTION
P_EngmntProjStfngSrchByRole	view	inner	CONSUMPTION
P_EngmntProjStfngSrchBySkill	view	inner	CONSUMPTION
P_InvoiceWorkFlowRecipient	view	from	COMPOSITE	People Picker for Invoice Approver
P_RSHResource	view	inner	COMPOSITE
P_SI_SalesEmployeeVH	view	from	COMPOSITE
S_CENCTRWORKFLOWRECIPIENTVH	view	inner		People Picker for Central Contract Approver
S_CENPOWORKFLOWRECIPIENTVH	view	inner		Centrally Managed Purchase Order User
S_CTRWORKFLOWRECIPIENTVH	view	inner		People Picker for Contract Approver
S_EAMWorkflowRecipientVH	view	inner		People Picker For Order Approver
S_POWorkFlowRecipientVH	view	inner		People Picker for Purchase Order Approver
S_PRWORKFLOWRECIPIENTVH	view	inner		People picker for PR approver
S_QTNWORKFLOWRECIPIENTVH	view	inner		People Picker for Quotation Approver
S_RFQWORKFLOWRECIPIENTVH	view	inner		People Picker for RFQ Approver
S_RPLPRWORKFLOWRECIPIENTVH	view	inner		Centrally Managed Pur Reqn User
S_SAWORKFLOWRECIPIENTVH	view	inner		People Picker for Scheduling Agreement Approver
S_SESWorkflowRecipientVH	view	inner		People Picker for Service Entry Sheet Approver
S_SrcgProjWorkflowRecipientVH	view	inner		People Picker for Sourcing Project Approver
S_SrcgSuplrListWrkflwRcvrVH	view	inner		Sourcing Supplier List Purchaser RespUsr
S_SuplrConfWorkFlowRecipientVH	view	inner		People Picker for Supplier Confirmation Approver

Fields (22)

Key	Field	CDS Fields	Used in Views
KEY	Person	BusinessPartner,EmployeeInternalID,Person	9
KEY	PersonExternalID	Employee,EmployeeExtID,PersonExternalID	9
	_BusinessPartner	_BusinessPartner	2
	AdditionalLastName	AdditionalLastName	1
	AuthorizationGroup	AuthorizationGroup,PersonWorkAgrmtAuthznGrpg	10
	BusinessPartnerUUID	BusinessPartnerUUID	3
	DataController1	DataController1	6
	DataController10	DataController10	6
	DataController2	DataController2	6
	DataController3	DataController3	6
	DataController4	DataController4	6
	DataController5	DataController5	6
	DataController6	DataController6	6
	DataController7	DataController7	6
	DataController8	DataController8	6
	DataController9	DataController9	6
	DataControllerSet	DataControllerSet	6
	FirstName	FirstName	5
	IsBusinessPurposeCompleted	IsBusinessPurposeCompleted	18
	LastName	LastName	7
	MiddleName	MiddleName	1
	PersonFullName	EmployeeFullName,FullName,PersonFullName	15

@AbapCatalog.sqlViewName: 'IWFPERSON'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Workforce Person Details'
@Analytics.dataExtraction.enabled: true
@Analytics.dataCategory: #DIMENSION
@AbapCatalog.preserveKey:true
@Metadata.allowExtensions: true
@ObjectModel.representativeKey: 'Person'
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #ANALYTICAL_DIMENSION,
                                     #EXTRACTION_DATA_SOURCE]

// @AccessControl.personalData.blockingIndicator: 'IsBusinessPurposeCompleted' 

define view I_WorkforcePerson
  as select from I_BusinessPartner        as BP
    inner join   I_HrRelation             as relt           on  BP.BusinessPartner              = relt.HumRsceRelatedObjectId
                                                            and relt.ObjectType                 = 'CP' //CP - Central person

                                                            and relt.HumRsceRelshpSpecification = 'B'
                                                            and relt.HumRsceRelationship        = '207' //207    Is identical to

                                                            and relt.RelatedObjectType          = 'BP'
                                                            and relt.EndDate                    = '99991231'

    inner join   P_WFPersonIdentification as PersIdentifier on BP.BusinessPartner = PersIdentifier.BusinessPartner
  association [1..1] to I_BusinessPartner         as _BusinessPartner            on $projection.Person = _BusinessPartner.BusinessPartner
  association [0..*] to I_ServicePerformerToSuplr as _ServicePerformerToSupplier on $projection.Person = _ServicePerformerToSupplier.Person
  association [1..*] to I_PersonWorkAgreement     as _PersonWorkAgreement        on $projection.Person = _PersonWorkAgreement.Person
  association [1..*] to I_PersonWorkAgreement_1   as _PersonWorkAgreement_1      on $projection.Person = _PersonWorkAgreement_1.Person
  association [0..1] to I_WorkplaceAddress        as _WorkplaceAddress           on $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID
  association [0..*] to I_BusinessPartnerToBPRole as _BusinessPartnerToBPRole    on $projection.Person = _BusinessPartnerToBPRole.BusinessPartner
  association [0..1] to I_BusinessUser            as _BusinessUser               on $projection.Person = _BusinessUser.BusinessPartner
  association [0..1] to I_BusinessUserBasic       as _BusinessUserBasic          on $projection.Person = _BusinessUserBasic.BusinessPartner
  
{
      @ObjectModel.text.element: 'PersonFullName'
  key BP.BusinessPartner                      as Person,
      PersIdentifier.BPIdentificationNumber   as PersonExternalID,
      BP.FirstName,
      BP.LastName,
      BP.MiddleName,
      BP.AdditionalLastName,
      @Semantics.text: true
      BP.PersonFullName,
      BP.BusinessPartnerUUID,
      BP.AuthorizationGroup,
      BP.IsBusinessPurposeCompleted,
      
  /////// Start of Datacontroller 10+1 fields -  Not to be consumed by any other views//////////      

        
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController10,
        
 ////////////// End of Datacontroller 10+1 fields////////// 

      _BusinessPartner,
      _ServicePerformerToSupplier,
       @API.element.releaseState: #DEPRECATED
       @API.element.successor: '_PersonWorkAgreement_1'
      _PersonWorkAgreement,
      _PersonWorkAgreement_1,
      _WorkplaceAddress,
      _BusinessPartnerToBPRole,
       @API.element.releaseState: #DEPRECATED
       @API.element.successor: '_BusinessUserBasic'      
      _BusinessUser,
      _BusinessUserBasic
}
where
  BP.BusinessPartnerCategory = '1'

Depth:

I_WORKFORCEPERSON

CDS Views using this table (47)

Fields (22)

Learn More