R_WorkAssignmentTP_3

DDL: R_WORKASSIGNMENTTP_3 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP_ODATA
15 Fields 1 Data Sources 5 Associations

Work Assignments

R_WorkAssignmentTP_3 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_ODATA.

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignment_1 Workassignment from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_WorkAssignmentDetailTP_3 _WorkAssignmentDetail
[0..*] R_WrkAssgmtPaymentTP_3 _WorkAssignmentPayment
[0..*] R_WrkAssgmtSrvcCostLvlTP_3 _WrkAssgmtSrvcCostLvl
[0..*] R_WrkAssgmtWrkOrdDetTP_3 _WrkAssgmtWrkOrdDet
[0..*] R_WorkAssignmentAddressTP_3 _WorkAssignmentAddress

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
_WorkAssignmentDetail _WorkAssignmentDetail
_WrkAssgmtSrvcCostLvl _WrkAssgmtSrvcCostLvl
_WrkAssgmtWrkOrdDet _WrkAssgmtWrkOrdDet
_WorkAssignmentPayment _WorkAssignmentPayment
_WorkAssignmentAddress _WorkAssignmentAddress

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_3.
-- 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_3 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_3 AS _WorkAssignmentDetail ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_WrkAssgmtPaymentTP_3 AS _WorkAssignmentPayment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WrkAssgmtSrvcCostLvlTP_3 AS _WrkAssgmtSrvcCostLvl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WrkAssgmtWrkOrdDetTP_3 AS _WrkAssgmtWrkOrdDet ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WorkAssignmentAddressTP_3 AS _WorkAssignmentAddress ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More