C_RSHStaffingRequestForRes

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 C_RSHStaffingRequestForRes.
-- 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: CRSHREQFORRES

CREATE VIEW C_RSHStaffingRequestForRes AS
SELECT
  Assignment.ProjAssignmentUUID AS ProjAssignmentUUID,
  Resource.AuthorizationGroup AS AuthorizationGroup,
  Resource.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  Resource.CompanyCode AS CompanyCode,
  Resource.CostCenter AS CostCenter,
  Request.ResourceDemandUUID AS ResourceDemandUUID,
  Request.WorkItem AS WorkItem,
  Request.ServiceOrganization AS ServiceOrganization,
  Request.EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  Request.EngagementProjectResource AS EngagementProjectResource,
  Request.EngagementProject AS EngagementProject,
  Request.Role AS Role,
  Request.EngagementProjectCategory AS EngagementProjectCategory,
  Request.EmployeeRequestDelivOrg AS EmployeeRequestDelivOrg,
  Request.Currency AS Currency,
  Request.PlannedRevenueInPlnCrcy AS PlannedRevenueInPlnCrcy,
  cast( '' as billgctrlcat) AS BillingControlCategory,
  Request.EngagementProjectName AS EngagementProjectName,
  Request.WorkPackage AS WorkPackage,
  Request.WorkPackageName AS WorkPackageName,
  Request.WorkItemName AS WorkItemName,
  Request.ProjectManager AS ProjectManager,
  Request.ProjectManagerExternalID AS ProjectManagerExternalID,
  Request.EmployeeRequestProjMgrFullName AS EmployeeRequestProjMgrFullName,
  Request.EmploymentInternalID AS EmploymentInternalID,
  Request.Customer AS Customer,
  Request.CustomerFullName AS CustomerFullName,
  Request.CityName AS CityName,
  Request.IsBusPrpsCmpltdCustomer AS IsBusPrpsCmpltdCustomer,
  Request.CustomerAuthznGrp AS CustomerAuthznGrp,
  Request.IsBusPrpsCmpltdProjectManager AS IsBusPrpsCmpltdProjectManager,
  Request.ProjectManagerAuthznGrp AS ProjectManagerAuthznGrp,
  Request.StartDate AS StartDate,
  Request.EndDate AS EndDate,
  Request.EmployeeRequestDuration AS EmployeeRequestDuration,
  Request.PlanSkillTagDescription AS PlanSkillTagDescription,
  Request.ProjectVisibility AS ProjectVisibility,
  Request.EngagementProjectStage AS EngagementProjectStage,
  Request.UnitOfMeasure AS UnitOfMeasure,
  Request._CategoryText AS _CategoryText
FROM P_RSHAssignment AS Assignment
LEFT OUTER JOIN P_RSHResourceTimeSlice AS Resource ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_RSHStaffingRequestData AS Request ON /* join condition not captured in parsed metadata */
;