I_WORKFORCEPERSON

CDS View
22 Fields 48 CDS Views

Workforce Person Details

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

CDS Views using this table (48)

ViewTypeJoinVDMDescription
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_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 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 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)

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Workforce Person Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKFORCEPERSON (
    PERSON,
    PERSONEXTERNALID,
    _BUSINESSPARTNER,
    ADDITIONALLASTNAME,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERUUID,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    MIDDLENAME,
    PERSONFULLNAME,
    PRIMARY KEY (PERSON, PERSONEXTERNALID)
);

Learn More