WFD_WORKFORCEASSIGNMENTDETAILS

CDS View

Workforce Domain - Assignments Details

WFD_WORKFORCEASSIGNMENTDETAILS is a CDS View in S/4HANA. Workforce Domain - Assignments Details. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
WFD_PremK view from Workforce Domain - Sel view for PREMK

Fields (4)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssignmentID WorkforceAssignmentID 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1 
@AbapCatalog.sqlViewName: 'WFD_ASSGMTDET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workforce Domain - Assignments Details'

@ObjectModel.usageType.sizeCategory         : #XL   //inherited from P_WorkforceAssignment

@ObjectModel.usageType.serviceQuality       : #B    //inherited from P_WorkforceAssignment

@ObjectModel.usageType.dataClass            : #MIXED
define view WFD_WorkForceAssignmentDetails
  as select from P_WorkforceAssignmentDetails

  association to parent WFD_WorkForceAssignment as _assgmt on $projection.WorkforceAssignmentID = _assgmt.WorkforceAssignmentID
{
      //P_WorkforceAssignmentDetails

  key WorkforceAssignmentID,
  key WorkforceAssgmtStartDate,
      WorkforceAssgmtEndDate,
      Employmentstatus,
      EmploymentPercent,
      CompanyCode,
      CostCenter,
      ControllingArea,
      WeeklyWorkingHours,
      WeeklyWorkingDays,
      JobTitle,
      JobCode,
      MangerAssignmentID as ManagerAssignmentID,
      //      DepartmentName,

      //      Division,

      //      BusinessUnit,

      CountryISOCode,
      ManagerExternalAssignmentID,

      _assgmt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WORKFORCEASSIGNMENTDETAILS"
],
"ASSOCIATED":
[
"WFD_WORKFORCEASSIGNMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More