I_ProjDmndRsceAssgmtDistrTP

DDL: I_PROJDMNDRSCEASSGMTDISTRTP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources

Resource Assignment Distribution - TP

I_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_ProjDmndRsceAssgmtDistrTP) and exposes 26 fields with key field ProjDmndRsceAssgmtDistrUUID.

Data Sources (1)

SourceAliasJoin Type
R_ProjDmndRsceAssgmtDistrTP R_ProjDmndRsceAssgmtDistrTP projection

Annotations (11)

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

Fields (26)

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
_RootredirectedtoI_ProjectDemandTP_2
_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 I_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 I_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_ProjDmndRsceAssgmtDistrTP
;

Learn More