P_RSHBscStaffReqSupply

DDL: P_RSHBSCSTAFFREQSUPPLY SQL: PRSHBSCSTFREQSUP Type: view CONSUMPTION
4 Fields 3 Data Sources

Staffing Request Supply Data from CPM

P_RSHBscStaffReqSupply is a Consumption CDS View that provides data about "Staffing Request Supply Data from CPM" in SAP S/4HANA. It reads from 3 data sources (P_RSHResourceAvailability, I_CalendarDate, P_RSHBscStaffReqSupplyCalc) and exposes 4 fields with key fields EmploymentInternalID, ResourceDemandUUID, CalendarDate.

Data Sources (3)

SourceAliasJoin Type
P_RSHResourceAvailability _EmpTime left_outer
I_CalendarDate Cal from
P_RSHBscStaffReqSupplyCalc Supply inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRSHBSCSTFREQSUP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Staffing Request Supply Data from CPM view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID P_RSHBscStaffReqSupplyCalc EmploymentInternalID WorkForce Assgmt ID
KEY ResourceDemandUUID P_RSHBscStaffReqSupplyCalc ResourceDemandUUID Demand Key
KEY CalendarDate I_CalendarDate CalendarDate Calendar Date
Difference4else0endasAssignedHours

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 P_RSHBscStaffReqSupply.
-- 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: PRSHBSCSTFREQSUP

CREATE VIEW P_RSHBscStaffReqSupply AS
SELECT
  Supply.EmploymentInternalID AS EmploymentInternalID,
  Supply.ResourceDemandUUID AS ResourceDemandUUID,
  Cal.CalendarDate AS CalendarDate,
  case when Supply.Availability > 0 then Division ( ( _EmpTime.Availability * Supply.EmployeeRequestDuration ) , Supply.Availability , 4 ) when Supply.Difference > 0 and ( Supply.Availability = 0 or Supply.Availability is null ) then Division ( Supply.EmployeeRequestDuration , Supply.Difference , 4 ) else 0 end as AssignedHours AS Difference4else0endasAssignedHours
FROM I_CalendarDate AS Cal
INNER JOIN P_RSHBscStaffReqSupplyCalc AS Supply ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RSHResourceAvailability AS _EmpTime ON /* join condition not captured in parsed metadata */
;

Learn More