R_WorkAssignmentTP

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.
-- 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 AS
SELECT
  _WorkAssignmentBP.BusinessPartnerUUID AS WorkAssignmentUUID,
  _BPUsrRole.BPUsrRoleValidFromDate AS StartDate,
  _BPUsrRole.BPUsrRoleValidToDate AS EndDate,
  _AssignmentKeyMap.WorkforceAssignment AS WorkAssignment,
  _AssignmentKeyMap.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  _AssignmentKeyMap.WorkforcePersonID AS WorkforcePersonID,
  _AssignmentKeyMap.WorkforcePersonUserID AS WorkforcePersonUserID,
  _AssignmentKeyMap.WorkAssignmentDataSource AS WorkAssignmentDataSource,
  _BuPaIdentification.WorkAssignmentBusinessPartner AS WorkAssignmentBusinessPartner,
  _AssignmentKeyMap.BusinessPartner AS Person,
  _WorkforcePersonBP.BusinessPartnerUUID AS PersonUUID,
  _AssignmentDetailsForKeyDate.CompanyCode AS CompanyCode,
  _AssignmentDetailsForKeyDate.Country2DigitISOCode AS WorkAssignmentCountryISOCode,
  _BPUsrRole.RoleCategory AS RoleCategory,
  case _BPUsrRole.BasicRoleCategory when '' then _BPUsrRole.RoleCategory else _BPUsrRole.BasicRoleCategory end as BasicRoleCategory AS BasicRoleCategoryendasBasicRoleCategory,
  _BPUsrRole.BusinessPartnerRole AS BusinessPartnerRole,
  cast( '' as bum_wf_employment_situation preserving type ) AS EmploymentSituation,
  cast( ' ' as boolean preserving type ) AS BusPartRelshpSupplierIsVisible,
  cast ( '' as abap.char(10)) AS BusinessPartnerRelshpSupplier,
  cast ( '' as abap.char(100)) AS BusinessPartnerName,
  _AssignmentKeyMap.IsBlocked AS IsBlocked,
  _WorkAssignmentBP.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
INNER JOIN R_WorkAssignmentBP AS _BuPaIdentification ON /* join condition not captured in parsed metadata */
INNER JOIN R_BPUsrRole AS _BPUsrRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_BPUsrRoleText AS _BPUsrRoleText ON _BPUsrRoleText.Role = BasicRoleCategory AND _BPUsrRoleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _WorkforcePersonBP ON _WorkforcePersonBP.BusinessPartner = _AssignmentKeyMap.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _WorkAssignmentBP ON _WorkAssignmentBP.BusinessPartner = _BuPaIdentification.WorkAssignmentBusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_WorkAssignmentDetail_1 AS _AssignmentDetailsForKeyDate ON _AssignmentDetailsForKeyDate.WorkforceAssignment = _AssignmentKeyMap.WorkforceAssignment AND _AssignmentDetailsForKeyDate.WorkforceAssgmtStartDate = _BPUsrRole.BPUsrRoleValidFromDate  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON _CompanyCodeText.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN R_WorkAssignmentDetailsTP AS _WorkAssignmentDetails ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_WorkAssgmtSrvcCostLvlTP AS _WorkAssgmtSrvcCostLvl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BPRltnShipSupplierTP AS _BPRltnShipSupplier ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WorkAssgmtAltCostAssgmtTP AS _WorkAssgmtAltCostAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
;