I_RSHProjectAssignmentDaily

DDL: I_RSHPROJECTASSIGNMENTDAILY SQL: IRSHPROJASGDAILY Type: view BASIC
6 Fields 2 Data Sources

Assignment details at a daily level

I_RSHProjectAssignmentDaily is a Basic CDS View that provides data about "Assignment details at a daily level" in SAP S/4HANA. It reads from 2 data sources (rsh_d_projasg, I_RSHProjectAssignmentPerDay) and exposes 6 fields with key field ProjAssignmentPerDayUUID.

Data Sources (2)

SourceAliasJoin Type
rsh_d_projasg AssignmentHeader from
I_RSHProjectAssignmentPerDay AssignmentPerDay inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IRSHPROJASGDAILY view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Assignment details at a daily level view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProjAssignmentPerDayUUID I_RSHProjectAssignmentPerDay ProjAssignmentPerDayUUID UUID
ProjAssignmentUUID I_RSHProjectAssignmentPerDay ProjAssignmentUUID UUID
EmploymentInternalID rsh_d_projasg employmentinternalid WorkForce Assgmt ID
ResourceDemandUUID rsh_d_projasg resourcedemanduuid Demand Key
ProjAssignmentDate I_RSHProjectAssignmentPerDay ProjAssignmentDate Date
ProjAssignmentDurationInHours I_RSHProjectAssignmentPerDay ProjAssignmentDurationInHours Duration in Hrs

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 I_RSHProjectAssignmentDaily.
-- 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: IRSHPROJASGDAILY

CREATE VIEW I_RSHProjectAssignmentDaily AS
SELECT
  AssignmentPerDay.ProjAssignmentPerDayUUID AS ProjAssignmentPerDayUUID,
  AssignmentPerDay.ProjAssignmentUUID AS ProjAssignmentUUID,
  AssignmentHeader.employmentinternalid AS EmploymentInternalID,
  AssignmentHeader.resourcedemanduuid AS ResourceDemandUUID,
  AssignmentPerDay.ProjAssignmentDate AS ProjAssignmentDate,
  AssignmentPerDay.ProjAssignmentDurationInHours AS ProjAssignmentDurationInHours
FROM rsh_d_projasg AS AssignmentHeader
INNER JOIN I_RSHProjectAssignmentPerDay AS AssignmentPerDay ON /* join condition not captured in parsed metadata */
;

Learn More