Which CDS Views use I_WORKFORCEPERSON?

I_WORKFORCEPERSON is used by 49 CDS view(s), including: C_BdgtDocWrkFlwRcpntGrantStdVH, C_BillgProcDocWrkFlwRcpntVH, C_BudgetDocWrkFlwRcpntStdVH, C_EmrkdFndsWrkFlwRcpntValHelp, C_EngmtProjTeamSrchHelp, C_GrantWrkFlwRecipientVH, C_ProjBillgUserContactCard, C_ProjDmndResourceContactCard, C_SlsDocWrkFlwRecipientVH, C_SlsPriceWorkflowRecipientVH.

How many fields does I_WORKFORCEPERSON have?

I_WORKFORCEPERSON has 20 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 20 fields. 49 CDS views read from this table.

CDS Views using this table (49)

View	Type	Join	VDM	Description
C_BdgtDocWrkFlwRcpntGrantStdVH	view	inner	CONSUMPTION	Bdgt Doc WF Grant Recipt Val Assistance
C_BillgProcDocWrkFlwRcpntVH	view	inner	CONSUMPTION	Billg Proc. Doc. WF Recipient Value Help
C_BudgetDocWrkFlwRcpntStdVH	view	inner	CONSUMPTION	Budget Doc WF Recipient Val Assistance
C_EmrkdFndsWrkFlwRcpntValHelp	view	inner	CONSUMPTION	EF WorkFlow Recipient Value Assistance
C_EngmtProjTeamSrchHelp	view	inner	CONSUMPTION	Search Help For JAM
C_GrantWrkFlwRecipientVH	view	inner	CONSUMPTION	Grant WorkFlow Rcpnt Value Assistance
C_ProjBillgUserContactCard	view_entity	from	CONSUMPTION	Project Billing User Contact Card
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_EHSInvstgnActyOwner	view_entity	from	COMPOSITE	EHS Invstgn Acty Owner Workforce Person
I_EHSInvstgnActyResponsible	view_entity	from	COMPOSITE	EHS Invstgn Acty Resp Workforce Person
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_entity	from	COMPOSITE	Prob.-Solving Proc. Prtcpnt Person Info
I_ProjectMgrOrgDet	view	inner	COMPOSITE	Retrieve project details for the session user
I_Projwipdetpernrvaluehelp	view_entity	left_outer	COMPOSITE	Employee Value Help
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
I_WrkfrcPersnStdVH	view_entity	from	COMPOSITE	Workforce person
P_EngmntProjStfngSrchByPerson	view	inner	CONSUMPTION	Employee Person Search
P_EngmntProjStfngSrchByRole	view	inner	CONSUMPTION	Employee Role based search
P_EngmntProjStfngSrchBySkill	view	inner	CONSUMPTION	Employee Role Skill search
P_InvoiceWorkFlowRecipient	view	from	COMPOSITE	People Picker for Manage Workflow for Supplier Invoices
P_RSHResource	view	inner	COMPOSITE	RSH Resource
P_SI_SalesEmployeeVH	view	from	COMPOSITE	Sales Insight: SalesEmployee Value Help
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_entity	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 (20)

Key	Field	CDS Fields	Used in Views
KEY	Person	BusinessPartner,EmployeeInternalID,Person	12
KEY	PersonExternalID	Employee,PersonExternalID	8
	_BusinessPartner	_BusinessPartner	2
	AuthorizationGroup	AuthorizationGroup,PersonWorkAgrmtAuthznGrpg	11
	BusinessPartnerUUID	BusinessPartnerUUID	2
	DataController1	DataController1	9
	DataController10	DataController10	9
	DataController2	DataController2	9
	DataController3	DataController3	9
	DataController4	DataController4	9
	DataController5	DataController5	9
	DataController6	DataController6	9
	DataController7	DataController7	9
	DataController8	DataController8	9
	DataController9	DataController9	9
	DataControllerSet	DataControllerSet	10
	FirstName	FirstName	6
	IsBusinessPurposeCompleted	IsBusinessPurposeCompleted	18
	LastName	LastName	13
	PersonFullName	EmployeeFullName,FullName,PersonFullName	20

@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'
@ObjectModel.sapObjectNodeType.name:'WorkforcePerson'
@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'

@Consumption.dbHints:[ 'USE_HEX_PLAN' ] 
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 (49)

Fields (20)

Learn More