I_WorkForcePersonBPDets

DDL: I_WORKFORCEPERSONBPDETS SQL: IWRKFORCEBPDETS Type: view COMPOSITE Package: WFD_EMPLOYEE_FACTSHEET_BL

Workforce Person basic details

I_WorkForcePersonBPDets is a Composite CDS View that provides data about "Workforce Person basic details" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, P_WFPersonIdentification) and exposes 11 fields with key fields Person, PersonExternalID. It has 1 association to related views. Part of development package WFD_EMPLOYEE_FACTSHEET_BL.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner BP from
P_WFPersonIdentification PersIdentifier inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkplaceAddress _AddressInfo BP.BusinessPartnerUUID = _AddressInfo.BusinessPartnerUUID and _AddressInfo.ValidityStartDate <= $session.system_date and _AddressInfo.ValidityEndDate >= $session.system_date

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFORCEBPDETS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Workforce Person basic details view
VDM.lifecycle.status #DEPRECATED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Person I_BusinessPartner BusinessPartner
KEY PersonExternalID P_WFPersonIdentification BPIdentificationNumber
FirstName I_BusinessPartner FirstName
LastName I_BusinessPartner LastName
PersonFullName I_BusinessPartner PersonFullName
BusinessPartnerNicknameLabel I_BusinessPartner BusinessPartnerNicknameLabel
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID
AuthorizationGroup I_BusinessPartner AuthorizationGroup
DefaultEmailAddress _AddressInfo DefaultEmailAddress
MblNormalizedPhoneNumber _AddressInfo MblNormalizedPhoneNumber
NormalizedPhoneNumber _AddressInfo NormalizedPhoneNumber 
@AbapCatalog.sqlViewName: 'IWRKFORCEBPDETS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
}
@EndUserText.label: 'Workforce Person basic details'
@VDM.lifecycle.status: #DEPRECATED
define view I_WorkForcePersonBPDets
  as select from I_BusinessPartner        as BP
    inner join   P_WFPersonIdentification as PersIdentifier on BP.BusinessPartner = PersIdentifier.BusinessPartner
  association [0..1] to I_WorkplaceAddress as _AddressInfo on  BP.BusinessPartnerUUID         = _AddressInfo.BusinessPartnerUUID
                                                           and _AddressInfo.ValidityStartDate <= $session.system_date
                                                           and _AddressInfo.ValidityEndDate   >= $session.system_date
  //association [0..*] to I_ServicePerformerToSuplr as _ServicePerformerToSupplier on $projection.Person = _ServicePerformerToSupplier.Person

  //association [0..*] to I_BusinessPartnerToBPRole as _BusinessPartnerToBPRole    on $projection.Person = _BusinessPartnerToBPRole.BusinessPartner

{
  key BP.BusinessPartner                    as Person,
  key PersIdentifier.BPIdentificationNumber as PersonExternalID,
      BP.FirstName as FirstName,
      BP.LastName as LastName,
      BP.PersonFullName,
      BP.BusinessPartnerNicknameLabel,

            BP.BusinessPartnerUUID as BusinessPartnerUUID,
      //      BP.IsBusinessPurposeCompleted,

            BP.AuthorizationGroup as AuthorizationGroup,

      //      _AddressInfo.BusinessPartnerUUID,

      //      _AddressInfo

      _AddressInfo.DefaultEmailAddress      as DefaultEmailAddress,
      _AddressInfo.MblNormalizedPhoneNumber as MblNormalizedPhoneNumber,
      _AddressInfo.NormalizedPhoneNumber    as NormalizedPhoneNumber

}
where
  BP.BusinessPartnerCategory = '1'

Learn More