WFD_WorkForceAssignmentDetails

DDL: WFD_WORKFORCEASSIGNMENTDETAILS SQL: WFD_ASSGMTDET Type: view Package: WFD_FC_ACCESS_LAYER
16 Fields 1 Data Sources

Workforce Domain - Assignments Details

WFD_WorkForceAssignmentDetails is a CDS View that provides data about "Workforce Domain - Assignments Details" in SAP S/4HANA. It reads from 1 data source (P_WorkforceAssignmentDetails) and exposes 16 fields with key fields WorkforceAssignmentID, WorkforceAssgmtStartDate. Part of development package WFD_FC_ACCESS_LAYER.

Data Sources (1)

SourceAliasJoin Type
P_WorkforceAssignmentDetails P_WorkforceAssignmentDetails from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName WFD_ASSGMTDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workforce Domain - Assignments Details view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignmentID WorkforceAssignmentID WorkForce Assgmt ID
KEY WorkforceAssgmtStartDate WorkforceAssgmtStartDate Valn start date
WorkforceAssgmtEndDate WorkforceAssgmtEndDate Valn End date
Employmentstatus Employmentstatus Employment Status
EmploymentPercent EmploymentPercent Emplymt Percentage
CompanyCode CompanyCode Receiver Company Code
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
WeeklyWorkingHours WeeklyWorkingHours Working Hours
WeeklyWorkingDays WeeklyWorkingDays Working Days
JobTitle JobTitle Job Title
JobCode JobCode Job Code
ManagerAssignmentID MangerAssignmentID Manager Assgmt ID
CountryISOCode CountryISOCode Venue: Ctry/Reg
ManagerExternalAssignmentID ManagerExternalAssignmentID Manager External ID
_assgmt _assgmt

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 WFD_WorkForceAssignmentDetails.
-- 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.
-- SQL view name: WFD_ASSGMTDET

CREATE VIEW WFD_WorkForceAssignmentDetails AS
SELECT
  WorkforceAssignmentID,
  WorkforceAssgmtStartDate,
  WorkforceAssgmtEndDate,
  Employmentstatus,
  EmploymentPercent,
  CompanyCode,
  CostCenter,
  ControllingArea,
  WeeklyWorkingHours,
  WeeklyWorkingDays,
  JobTitle,
  JobCode,
  MangerAssignmentID AS ManagerAssignmentID,
  CountryISOCode,
  ManagerExternalAssignmentID
FROM P_WorkforceAssignmentDetails
;

Learn More