R_WorkforcePersonTag

DDL: R_WORKFORCEPERSONTAG Type: view_entity COMPOSITE Package: WFD_WORKER_FACTSHEET_BL

Skill Tag for Workforce Person

R_WorkforcePersonTag is a Composite CDS View that provides data about "Skill Tag for Workforce Person" in SAP S/4HANA. It reads from 1 data source (I_EmployeeskillTags) and exposes 11 fields with key field WorkforcePersonTagUUID. It has 1 association to related views. Part of development package WFD_WORKER_FACTSHEET_BL.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_EmployeeskillTags SkillTag from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BP _BP.BusinessPartner = _keymap.BusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Skill Tag for Workforce Person view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonTagUUID I_EmployeeskillTags EmployeeSkillTagID
PersonUUID _BP BusinessPartnerUUID
PersonnelNumber I_EmployeeskillTags PersonnelNumber
WorkforcePersonTagTypeValue I_EmployeeskillTags EmployeeSkillTagType
WorkforcePersonTagText I_EmployeeskillTags EmployeeSkillTagName
SystemOfRecordID I_EmployeeskillTags SystemOfRecordID
LastChangeDateTime I_EmployeeskillTags LastChangeDate
LastChangedByUser I_EmployeeskillTags LastChangedByUser
_CreatedByUser I_EmployeeskillTags _CreatedByUser
LastChangedByUserFullName
_WorkforcePerson _WorkforcePerson 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@EndUserText.label: 'Skill Tag for Workforce Person'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view entity R_WorkforcePersonTag
  as select from           I_EmployeeskillTags    as SkillTag
    left outer to one join  I_WorkerCentralPerson as _keymap on _keymap.CentralPerson = SkillTag.PersonnelNumber
    association [1..1] to I_BusinessPartner                 as _BP              on _BP.BusinessPartner = _keymap.BusinessPartner
//    association [1..1] to I_BusinessPartner                 as _BP              on _BP.BusinessPartner = WorkAssignmentKeymap.BusinessPartner

  association to parent R_WorkforcePersonFactSheet as _WorkforcePerson on $projection.PersonUUID = _WorkforcePerson.PersonUUID


{
  key   SkillTag.EmployeeSkillTagID                                     as WorkforcePersonTagUUID,
        _BP.BusinessPartnerUUID                                         as PersonUUID,
        SkillTag.PersonnelNumber                                        as PersonnelNumber,
        SkillTag.EmployeeSkillTagType                                   as WorkforcePersonTagTypeValue,
        SkillTag.EmployeeSkillTagName                                   as WorkforcePersonTagText,
        SkillTag.SystemOfRecordID                                       as SystemOfRecordID,
        SkillTag.LastChangeDate                                         as LastChangeDateTime,
        SkillTag.LastChangedByUser,
        //  PersIdentifier.PersonExternalID,

        /* Associations */
        SkillTag._CreatedByUser,
        cast( SkillTag._CreatedByUser.UserDescription as suidtechdesc ) as LastChangedByUserFullName,
        _WorkforcePerson
}
where
  SkillTag.EmployeeSkillTagType = 'U'

  
//    as select from           I_EmployeeskillTags as SkillTag

//    left outer to one join I_HrRelation        as RelationCP_BP  on  RelationCP_BP.HumRsceObjectId            = SkillTag.PersonnelNumber

//                                                                 and RelationCP_BP.HumRsceRelshpSpecification = 'B'

//                                                                 and RelationCP_BP.HumRsceRelationship        = '207'

//                                                                 and RelationCP_BP.EndDate                    = '99991231'

//    left outer to one join I_WorkforcePerson   as PersIdentifier on RelationCP_BP.HumRsceRelatedObjectId = PersIdentifier.Person

//

//  association to parent R_WorkforcePersonFactSheet as _WorkforcePerson on $projection.PersonUUID = _WorkforcePerson.PersonUUID

//{

//  key   SkillTag.EmployeeSkillTagID                                     as WorkforcePersonTagUUID,

//        PersIdentifier.BusinessPartnerUUID                              as PersonUUID,

//        SkillTag.PersonnelNumber                                        as PersonnelNumber,

//        SkillTag.EmployeeSkillTagType                                   as WorkforcePersonTagTypeValue,

//        SkillTag.EmployeeSkillTagName                                   as WorkforcePersonTagText,

//        SkillTag.SystemOfRecordID                                       as SystemOfRecordID,

//        SkillTag.LastChangeDate                                         as LastChangeDateTime,

//        SkillTag.LastChangedByUser,

//        /* Associations */

//        SkillTag._CreatedByUser,

//        cast( SkillTag._CreatedByUser.UserDescription as suidtechdesc ) as LastChangedByUserFullName,

//        _WorkforcePerson

//}

//where

//  SkillTag.EmployeeSkillTagType = 'U'

Learn More