R_WorkAssignmentTP_1

DDL: R_WORKASSIGNMENTTP_1 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP
15 Fields 1 Data Sources 5 Associations

Work Assignments

R_WorkAssignmentTP_1 is a Transactional CDS View that provides data about "Work Assignments" in SAP S/4HANA. It reads from 1 data source (R_WorkAssignment_1) and exposes 15 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode. It has 5 associations to related views. Part of development package WFD_INT_RAP.

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignment_1 Workassignment from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_WorkAssignmentDetailTP_1 _JobDetails
[0..*] R_WrkAssgmtPaymentTP_1 _PaymentDetails
[0..*] R_WrkAssgmtSrvcCostLvlTP_1 _ServiceCostLevel
[0..*] R_WrkAssgmtWrkOrdDetTP _WorkOrderDetails
[0..*] R_WorkAssignmentAddressTP _AddressDetails

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Assignments view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID R_WorkAssignment_1 WorkforcePersonExternalID External Person ID
KEY WorkAssignmentExternalID R_WorkAssignment_1 WorkAssignmentExternalID WFA Ext. ID
KEY Country2DigitISOCode R_WorkAssignment_1 Country2DigitISOCode Country/Region
WorkAssignment R_WorkAssignment_1 WorkAssignment WorkForce Assgmt ID
WorkAssignmentStartDate R_WorkAssignment_1 WorkAssignmentStartDate Start Date
WorkAssignmentEndDate R_WorkAssignment_1 WorkAssignmentEndDate End Date
BusinessPartner R_WorkAssignment_1 BusinessPartner Issuing Authority
IsContingentWorker R_WorkAssignment_1 IsContingentWorker
IsBlocked R_WorkAssignment_1 IsBlocked Boolean Variable (X = True, - = False, Space = Unknown)
_WorkforcePerson _WorkforcePerson
_JobDetails _JobDetails
_ServiceCostLevel _ServiceCostLevel
_WorkOrderDetails _WorkOrderDetails
_PaymentDetails _PaymentDetails
_AddressDetails _AddressDetails

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_WorkAssignmentTP_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_WorkAssignmentTP_1 AS
SELECT
  Workassignment.WorkforcePersonExternalID AS WorkforcePersonExternalID,
  Workassignment.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  Workassignment.Country2DigitISOCode AS Country2DigitISOCode,
  Workassignment.WorkAssignment AS WorkAssignment,
  Workassignment.WorkAssignmentStartDate AS WorkAssignmentStartDate,
  Workassignment.WorkAssignmentEndDate AS WorkAssignmentEndDate,
  Workassignment.BusinessPartner AS BusinessPartner,
  Workassignment.IsContingentWorker AS IsContingentWorker,
  Workassignment.IsBlocked AS IsBlocked
FROM R_WorkAssignment_1 AS Workassignment
LEFT OUTER JOIN R_WorkAssignmentDetailTP_1 AS _JobDetails ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_WrkAssgmtPaymentTP_1 AS _PaymentDetails ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WrkAssgmtSrvcCostLvlTP_1 AS _ServiceCostLevel ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WrkAssgmtWrkOrdDetTP AS _WorkOrderDetails ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WorkAssignmentAddressTP AS _AddressDetails ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More