I_WorkforceAssignment

DDL: I_WORKFORCEASSIGNMENT SQL: IWORKFORCEASSGMT Type: view BASIC

Workforce Assignment

I_WorkforceAssignment is a Basic CDS View that provides data about "Workforce Assignment" in SAP S/4HANA. It reads from 1 data source (wfd_d_assgmt) and exposes 7 fields with key field WorkforceAssignment. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
wfd_d_assgmt Assgmt from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_WorkforceAssignmentDetails _Details $projection.WorkforceAssignment = _Details.WorkforceAssignment
[1] E_WorkforceAssignment _Extension $projection.WorkforceAssignment = _Extension.WorkforceAssignment

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IWORKFORCEASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey WorkforceAssignment view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Workforce Assignment view
Metadata.allowExtensions true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignment wfd_d_assgmt workforce_assgmt_id
WorkforceAssgmtStartDate start_date
WorkforceAssgmtEndDate end_date
BusinessPartner business_partner_id
WorkforceAssignmentExternalID ext_workforce_assgmt_uuid
IsContingentWorker is_contingent_worker
_Details _Details 
@AbapCatalog.sqlViewName: 'IWORKFORCEASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC
}
@ObjectModel: {
   compositionRoot:   true,
   representativeKey: 'WorkforceAssignment',
   semanticKey: ['WorkforceAssignment'],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #M
   }
}
@EndUserText.label: 'Workforce Assignment'
@Metadata.allowExtensions:true
define view I_WorkforceAssignment
  as select from wfd_d_assgmt as Assgmt
  association [0..*] to I_WorkforceAssignmentDetails as _Details   on $projection.WorkforceAssignment = _Details.WorkforceAssignment
  association [1]    to E_WorkforceAssignment        as _Extension on $projection.WorkforceAssignment = _Extension.WorkforceAssignment

{

  key Assgmt.workforce_assgmt_id as WorkforceAssignment,
      start_date                 as WorkforceAssgmtStartDate,
      end_date                   as WorkforceAssgmtEndDate,
      business_partner_id        as BusinessPartner,
      ext_workforce_assgmt_uuid  as WorkforceAssignmentExternalID,
      is_contingent_worker       as IsContingentWorker,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Details
}
where
  block_ind = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMT"
],
"ASSOCIATED":
[
"E_WORKFORCEASSIGNMENT",
"I_WORKFORCEASSIGNMENTDETAILS"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More