R_ProjDmndRsceAssgmtDistrTP

DDL: R_PROJDMNDRSCEASSGMTDISTRTP Type: view_entity TRANSACTIONAL
27 Fields 1 Data Sources 1 Associations

Resource Assignment Distribution - TP

R_ProjDmndRsceAssgmtDistrTP is a Transactional CDS View that provides data about "Resource Assignment Distribution - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjDmndRsceAssgmtDistr) and exposes 27 fields with key field ProjDmndRsceAssgmtDistrUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjDmndRsceAssgmtDistr R_ProjDmndRsceAssgmtDistr from

Associations (1)

CardinalityTargetAliasCondition
[1] I_ProjectDemandTP _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey ProjDmndRsceAssgmtDistrUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Resource Assignment Distribution - TP view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndRsceAssgmtDistrUUID ProjDmndRsceAssgmtDistrUUID Assgmt Distr. UUID
ProjDmndRsceAssgmtUUID ProjDmndRsceAssgmtUUID Resource Assgmt UUID
ProjectDemandUUID ProjectDemandUUID Entity GUID
ProjectUUID ProjectUUID Project UUID
ReferencedObjectUUID ReferencedObjectUUID Referenced Object
ProjDmndRsceAssgmtDistrYearVal ProjDmndRsceAssgmtDistrYearVal Year of Distribution
ProjDmndRsceAssgmtDistrPerdVal ProjDmndRsceAssgmtDistrPerdVal Distribution Period
ProjDmndRsceAssgmtDistrQty ProjDmndRsceAssgmtDistrQty Distributed Quantity
ProjDmndRsceAssgmtDistrQtyUnit ProjDmndRsceAssgmtDistrQtyUnit Quantity Unit
ProjDmndRsceDistrPerdAmt ProjDmndRsceDistrPerdAmt Plannend Cost
ProjDmndRsceDistrPerdAmtCur ProjDmndRsceDistrPerdAmtCur Currency
ProjDmndRsceDistrRevenueAmt ProjDmndRsceDistrRevenueAmt Planned Revenue
ProjDmndRsceDistrRevenueAmtCur ProjDmndRsceDistrRevenueAmtCur Currency
ProjDmndReferencedPlanDataUUID ProjDmndReferencedPlanDataUUID Referenced Object
ProjDmndRsceAssgmtDistrStrtDte ProjDmndRsceAssgmtDistrStrtDte Distr. Start Date
ProjDmndRsceAssgmtDistrEndDte ProjDmndRsceAssgmtDistrEndDte Distr. End Date
ProjDmndRsceDistrIsNotSupplied ProjDmndRsceDistrIsNotSupplied Assgmt Is Confirmed
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Assignment _Assignment
_Root _Root
_EnterpriseProject _EnterpriseProject
_ProjDmndRsceDistrQtyUnit _ProjDmndRsceDistrQtyUnit
_ProjDmndRsceDistrPerdAmtCur _ProjDmndRsceDistrPerdAmtCur
_ProjDmndRsceDistrRevnAmtCur _ProjDmndRsceDistrRevnAmtCur

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_ProjDmndRsceAssgmtDistrTP.
-- 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_ProjDmndRsceAssgmtDistrTP AS
SELECT
  ProjDmndRsceAssgmtDistrUUID,
  ProjDmndRsceAssgmtUUID,
  ProjectDemandUUID,
  ProjectUUID,
  ReferencedObjectUUID,
  ProjDmndRsceAssgmtDistrYearVal,
  ProjDmndRsceAssgmtDistrPerdVal,
  ProjDmndRsceAssgmtDistrQty,
  ProjDmndRsceAssgmtDistrQtyUnit,
  ProjDmndRsceDistrPerdAmt,
  ProjDmndRsceDistrPerdAmtCur,
  ProjDmndRsceDistrRevenueAmt,
  ProjDmndRsceDistrRevenueAmtCur,
  ProjDmndReferencedPlanDataUUID,
  ProjDmndRsceAssgmtDistrStrtDte,
  ProjDmndRsceAssgmtDistrEndDte,
  ProjDmndRsceDistrIsNotSupplied,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjDmndRsceAssgmtDistr
LEFT OUTER JOIN I_ProjectDemandTP AS _Root ON ProjectDemandUUID = _Root.ProjectDemandUUID  -- association [1]
;

Learn More