WFD_WorkForceAssignment

DDL: WFD_WORKFORCEASSIGNMENT SQL: WFD_ASSGMT Type: view
7 Fields 1 Data Sources 2 Associations

Workforce Domain - Assignments

WFD_WorkForceAssignment is a CDS View that provides data about "Workforce Domain - Assignments" in SAP S/4HANA. It reads from 1 data source (P_WorkforceAssignment) and exposes 7 fields with key field WorkforceAssignmentID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_WorkforceAssignment P_WorkforceAssignment from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_WorkforceKeyMapping _mapping $projection.WorkforceAssignmentID = _mapping.WorkforceAssignmentID
[1..*] WFD_WorkForceAssignmentDetails _details

Annotations (8)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignmentID WorkforceAssignmentID WorkForce Assgmt ID
WorkforceAssgmtStartDate WorkforceAssgmtStartDate Valn start date
WorkforceAssgmtEndDate WorkforceAssgmtEndDate Valn End date
BusinessPartner BusinessPartner Issuing Authority
ExtWorkforceAssgmtUUID ExtWorkforceAssgmtUUID Ext Workforce Assgmt
_details _details
_mapping _mapping

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_WorkForceAssignment.
-- 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_ASSGMT

CREATE VIEW WFD_WorkForceAssignment AS
SELECT
  WorkforceAssignmentID,
  WorkforceAssgmtStartDate,
  WorkforceAssgmtEndDate,
  BusinessPartner,
  ExtWorkforceAssgmtUUID
FROM P_WorkforceAssignment
LEFT OUTER JOIN P_WorkforceKeyMapping AS _mapping ON WorkforceAssignmentID = _mapping.WorkforceAssignmentID  -- association [0..1]
LEFT OUTER JOIN WFD_WorkForceAssignmentDetails AS _details ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More