R_WorkAssignmentDetail_1

DDL: R_WORKASSIGNMENTDETAIL_1 Type: view_entity BASIC Package: WFD_INT_RAP
20 Fields 3 Data Sources

Work Assignment Details

R_WorkAssignmentDetail_1 is a Basic CDS View that provides data about "Work Assignment Details" in SAP S/4HANA. It reads from 3 data sources (P_WORKASSIGNMENT, P_WORKASSIGNMENTDETAILS, P_WORKASSIGNMENTKEYMAP) and exposes 20 fields with key fields WorkAssignment, WorkAssignmentStartDate. Part of development package WFD_INT_RAP.

Data Sources (3)

SourceAliasJoin Type
P_WORKASSIGNMENT Workassignment inner
P_WORKASSIGNMENTDETAILS WorkAssignmentDetails from
P_WORKASSIGNMENTKEYMAP WorkAssignmentKeymap inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Assignment Details view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment P_WORKASSIGNMENTDETAILS WorkAssignment WorkForce Assgmt ID
KEY WorkAssignmentStartDate P_WORKASSIGNMENTDETAILS WorkAssignmentStartDate Start Date
WorkAssignmentEndDate P_WORKASSIGNMENTDETAILS WorkAssignmentEndDate End Date
BusinessPartner P_WORKASSIGNMENTKEYMAP BusinessPartner Issuing Authority
WorkAssignmentExternalID P_WORKASSIGNMENTKEYMAP WorkAssignmentExternalID WFA Ext. ID
WorkforcePersonExternalID
WorkAssignmentStatus P_WORKASSIGNMENTDETAILS WorkAssignmentStatus Employment Status
EmploymentPercent P_WORKASSIGNMENTDETAILS EmploymentPercent Emplymt Percentage
CompanyCode P_WORKASSIGNMENTDETAILS CompanyCode Receiver Company Code
CostCenter P_WORKASSIGNMENTDETAILS CostCenter Cost Center
ControllingArea P_WORKASSIGNMENTDETAILS ControllingArea Controlling Area
WeeklyWorkingHours P_WORKASSIGNMENTDETAILS WeeklyWorkingHours Working Hours
WeeklyWorkingDays P_WORKASSIGNMENTDETAILS WeeklyWorkingDays Working Days
WorkAssignmentJobTitle P_WORKASSIGNMENTDETAILS WorkAssignmentJobTitle Job Title
WorkAssignmentJobCode P_WORKASSIGNMENTDETAILS WorkAssignmentJobCode Job Code
SupervisorWorkAssignmentID P_WORKASSIGNMENTDETAILS SupervisorWorkAssignmentID Manager Assgmt ID
Country2DigitISOCode P_WORKASSIGNMENTDETAILS Country2DigitISOCode Country/Region
SupervisorWorkAssignmentExtID P_WORKASSIGNMENTDETAILS SupervisorWorkAssignmentExtID Manager External ID
WorkforceAssignmentIsPrimary P_WORKASSIGNMENTDETAILS WorkforceAssignmentIsPrimary Checkbox
IsBlocked P_WORKASSIGNMENT IsBlocked Boolean Variable (X = True, - = False, Space = Unknown)

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 R_WorkAssignmentDetail_1.
-- 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.

CREATE VIEW R_WorkAssignmentDetail_1 AS
SELECT
  WorkAssignmentDetails.WorkAssignment AS WorkAssignment,
  WorkAssignmentDetails.WorkAssignmentStartDate AS WorkAssignmentStartDate,
  WorkAssignmentDetails.WorkAssignmentEndDate AS WorkAssignmentEndDate,
  WorkAssignmentKeymap.BusinessPartner AS BusinessPartner,
  WorkAssignmentKeymap.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  cast(upper(WorkAssignmentKeymap.WorkforcePersonExternalID) as wfd_person_id_external preserving type ) AS WorkforcePersonExternalID,
  WorkAssignmentDetails.WorkAssignmentStatus AS WorkAssignmentStatus,
  WorkAssignmentDetails.EmploymentPercent AS EmploymentPercent,
  WorkAssignmentDetails.CompanyCode AS CompanyCode,
  WorkAssignmentDetails.CostCenter AS CostCenter,
  WorkAssignmentDetails.ControllingArea AS ControllingArea,
  WorkAssignmentDetails.WeeklyWorkingHours AS WeeklyWorkingHours,
  WorkAssignmentDetails.WeeklyWorkingDays AS WeeklyWorkingDays,
  WorkAssignmentDetails.WorkAssignmentJobTitle AS WorkAssignmentJobTitle,
  WorkAssignmentDetails.WorkAssignmentJobCode AS WorkAssignmentJobCode,
  WorkAssignmentDetails.SupervisorWorkAssignmentID AS SupervisorWorkAssignmentID,
  WorkAssignmentDetails.Country2DigitISOCode AS Country2DigitISOCode,
  WorkAssignmentDetails.SupervisorWorkAssignmentExtID AS SupervisorWorkAssignmentExtID,
  WorkAssignmentDetails.WorkforceAssignmentIsPrimary AS WorkforceAssignmentIsPrimary,
  Workassignment.IsBlocked AS IsBlocked
FROM P_WORKASSIGNMENTDETAILS AS WorkAssignmentDetails
INNER JOIN P_WORKASSIGNMENTKEYMAP AS WorkAssignmentKeymap ON /* join condition not captured in parsed metadata */
INNER JOIN P_WORKASSIGNMENT AS Workassignment ON /* join condition not captured in parsed metadata */
;

Learn More