I_WorkForcePersonBPDetail

DDL: I_WORKFORCEPERSONBPDETAIL Type: view_entity COMPOSITE Package: WFD_BL_PERSISTENCE
8 Fields 1 Associations

Workforce Person BP Details

I_WorkForcePersonBPDetail is a Composite CDS View that provides data about "Workforce Person BP Details" in SAP S/4HANA. It has 1 association to related views. Part of development package WFD_BL_PERSISTENCE.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkForcePersonBPToSupplier _WorkForcePersonBPToSupplier $projection.BusinessPartner = _WorkForcePersonBPToSupplier.BusinessPartner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workforce Person BP Details view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner WorkforceKeyMapping BusinessPartner Issuing Authority
CentralPerson WorkforceKeyMapping CentralPerson
WorkforcePersonID WorkforceKeyMapping WorkerId ID Number
WorkforcePersonExternalID WorkforceKeyMapping PersonExternalID
FirstName BusinessUserBasic FirstName First Name
LastName BusinessUserBasic LastName Last Name
UserID BusinessUserBasic UserID User Name
Supplier _WorkForcePersonBPToSupplier Supplier Supplier

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_WorkForcePersonBPDetail.
-- 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.

CREATE VIEW I_WorkForcePersonBPDetail AS
SELECT
  WorkforceKeyMapping.BusinessPartner AS BusinessPartner,
  WorkforceKeyMapping.CentralPerson AS CentralPerson,
  WorkforceKeyMapping.WorkerId AS WorkforcePersonID,
  WorkforceKeyMapping.PersonExternalID AS WorkforcePersonExternalID,
  BusinessUserBasic.FirstName AS FirstName,
  BusinessUserBasic.LastName AS LastName,
  BusinessUserBasic.UserID AS UserID,
  _WorkForcePersonBPToSupplier.Supplier AS Supplier
LEFT OUTER JOIN I_WorkForcePersonBPToSupplier AS _WorkForcePersonBPToSupplier ON BusinessPartner = _WorkForcePersonBPToSupplier.BusinessPartner  -- association [1..1]
;

Learn More