R_DevProjRoleStfngDistrTP

DDL: R_DEVPROJROLESTFNGDISTRTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources

Dev Project Staffing Distribution - TP

R_DevProjRoleStfngDistrTP is a Transactional CDS View that provides data about "Dev Project Staffing Distribution - TP" in SAP S/4HANA. It reads from 1 data source (I_DevProjRoleStfngDistribution) and exposes 15 fields with key fields ProjectUUID, ProjectRoleUUID, DevProjRoleStfngShadowRoleUUID, DevProjRoleStfngDistrUUID, DevProjRoleStfngDistrEndDate.

Data Sources (1)

SourceAliasJoin Type
I_DevProjRoleStfngDistribution I_DevProjRoleStfngDistribution from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Dev Project Staffing Distribution - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_DevProjRoleStaffing_2 ProjectUUID Project UUID
KEY ProjectRoleUUID I_DevProjRoleStaffing_2 ProjectRoleUUID Role
KEY DevProjRoleStfngShadowRoleUUID I_DevProjRoleStaffing_2 DevProjRoleStfngShadowRoleUUID Appl. GUID
KEY DevProjRoleStfngDistrUUID I_DevProjRoleStfngDistribution DevProjRoleStfngDistrUUID
KEY DevProjRoleStfngDistrEndDate I_DevProjRoleStfngDistribution DevProjRoleStfngDistrEndDate Valid To
BusinessPartnerUUID I_DevProjRoleStaffing_2 BusinessPartnerUUID UUID
CreatedByUser I_DevProjRoleStfngDistribution CreatedByUser User Name
DevProjDistrCreatedOnDateTime I_DevProjRoleStfngDistribution DevProjDistrCreatedOnDateTime
LastChangedByUser I_DevProjRoleStfngDistribution LastChangedByUser User Name
LastChangeDateTime I_DevProjRoleStfngDistribution LastChangeDateTime Timestamp
DevProjRoleStfngDistrUnit I_DevProjRoleStfngDistribution DevProjRoleStfngDistrUnit Distr. Unit
DevProjRoleStfngDistrPerdType I_DevProjRoleStfngDistribution DevProjRoleStfngDistrPerdType PeriodIndicator
DevProjRoleStfngDistrStartDate I_DevProjRoleStfngDistribution DevProjRoleStfngDistrStartDate Valid From
DevProjRoleStfngDistrWrkQty I_DevProjRoleStfngDistribution DevProjRoleStfngDistrWrkQty Demand/Effort
_Staffing_2 _Staffing_2

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_DevProjRoleStfngDistrTP.
-- 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_DevProjRoleStfngDistrTP AS
SELECT
  I_DevProjRoleStaffing_2.ProjectUUID AS ProjectUUID,
  I_DevProjRoleStaffing_2.ProjectRoleUUID AS ProjectRoleUUID,
  I_DevProjRoleStaffing_2.DevProjRoleStfngShadowRoleUUID AS DevProjRoleStfngShadowRoleUUID,
  I_DevProjRoleStfngDistribution.DevProjRoleStfngDistrUUID AS DevProjRoleStfngDistrUUID,
  I_DevProjRoleStfngDistribution.DevProjRoleStfngDistrEndDate AS DevProjRoleStfngDistrEndDate,
  I_DevProjRoleStaffing_2.BusinessPartnerUUID AS BusinessPartnerUUID,
  I_DevProjRoleStfngDistribution.CreatedByUser AS CreatedByUser,
  I_DevProjRoleStfngDistribution.DevProjDistrCreatedOnDateTime AS DevProjDistrCreatedOnDateTime,
  I_DevProjRoleStfngDistribution.LastChangedByUser AS LastChangedByUser,
  I_DevProjRoleStfngDistribution.LastChangeDateTime AS LastChangeDateTime,
  I_DevProjRoleStfngDistribution.DevProjRoleStfngDistrUnit AS DevProjRoleStfngDistrUnit,
  I_DevProjRoleStfngDistribution.DevProjRoleStfngDistrPerdType AS DevProjRoleStfngDistrPerdType,
  I_DevProjRoleStfngDistribution.DevProjRoleStfngDistrStartDate AS DevProjRoleStfngDistrStartDate,
  I_DevProjRoleStfngDistribution.DevProjRoleStfngDistrWrkQty AS DevProjRoleStfngDistrWrkQty
FROM I_DevProjRoleStfngDistribution
;

Learn More