I_MstrProjWorkForcePerson

DDL: I_MSTRPROJWORKFORCEPERSON SQL: IMPWFPERSON Type: view COMPOSITE
20 Fields 1 Data Sources

Master Project Workforce Person Details

I_MstrProjWorkForcePerson is a Composite CDS View that provides data about "Master Project Workforce Person Details" in SAP S/4HANA. It reads from 1 data source (I_WorkforcePerson) and exposes 20 fields with key field PersonnelNumber.

Data Sources (1)

SourceAliasJoin Type
I_WorkforcePerson BP from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPWFPERSON view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Master Project Workforce Person Details view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonWorkAgreement PersonWorkAgreement Personnel No.
Employee I_WorkforcePerson PersonExternalID Logical System
EmployeeInternalID I_WorkforcePerson Person Person/ Farm/ Field
ValidityStartDate status StartDate Valid From
ValidityEndDate status EndDate Term to
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
EmployeeFullName I_WorkforcePerson PersonFullName Full Name
FullName I_WorkforcePerson PersonFullName Full Name
BusinessPartnerUUID BusinessPartnerUUID UUID
DataControllerSet I_WorkforcePerson DataControllerSet Data Ctrlr. Set
DataController1 I_WorkforcePerson DataController1 Data Controller
DataController2 I_WorkforcePerson DataController2 Data Controller
DataController3 I_WorkforcePerson DataController3 Data Controller
DataController4 I_WorkforcePerson DataController4 Data Controller
DataController5 I_WorkforcePerson DataController5 Data Controller
DataController6 I_WorkforcePerson DataController6 Data Controller
DataController7 I_WorkforcePerson DataController7 Data Controller
DataController8 I_WorkforcePerson DataController8 Data Controller
DataController9 I_WorkforcePerson DataController9 Data Controller
DataController10 I_WorkforcePerson 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 I_MstrProjWorkForcePerson.
-- 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: IMPWFPERSON

CREATE VIEW I_MstrProjWorkForcePerson AS
SELECT
  PersonWorkAgreement.PersonWorkAgreement AS PersonnelNumber,
  BP.PersonExternalID AS Employee,
  BP.Person AS EmployeeInternalID,
  status.StartDate AS ValidityStartDate,
  status.EndDate AS ValidityEndDate,
  IsBusinessPurposeCompleted,
  BP.PersonFullName AS EmployeeFullName,
  BP.PersonFullName AS FullName,
  BusinessPartnerUUID,
  BP.DataControllerSet AS DataControllerSet,
  BP.DataController1 AS DataController1,
  BP.DataController2 AS DataController2,
  BP.DataController3 AS DataController3,
  BP.DataController4 AS DataController4,
  BP.DataController5 AS DataController5,
  BP.DataController6 AS DataController6,
  BP.DataController7 AS DataController7,
  BP.DataController8 AS DataController8,
  BP.DataController9 AS DataController9,
  BP.DataController10 AS DataController10
FROM I_WorkforcePerson AS BP
;

Learn More