I_ProjectDemandServiceSupplyTP

DDL: I_PROJECTDEMANDSERVICESUPPLYTP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources 1 Associations

Supply Data of Service Demand - TP

I_ProjectDemandServiceSupplyTP is a Transactional CDS View that provides data about "Supply Data of Service Demand - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandServiceSupply) and exposes 11 fields with key field ProjectDemandServiceSupplyUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandServiceSupply R_ProjectDemandServiceSupply from

Associations (1)

CardinalityTargetAliasCondition
[1..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 ProjectDemandServiceSupplyUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Supply Data of Service Demand - TP view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandServiceSupplyUUID ProjectDemandServiceSupplyUUID Srvc Sply UUID
ProjectDemandServiceUUID ProjectDemandServiceUUID Service Dmnd UUID
ProjectDemandUUID ProjectDemandUUID Entity GUID
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Service _Service
_Root _Root

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_ProjectDemandServiceSupplyTP.
-- 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_ProjectDemandServiceSupplyTP AS
SELECT
  ProjectDemandServiceSupplyUUID,
  ProjectDemandServiceUUID,
  ProjectDemandUUID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjectDemandServiceSupply
LEFT OUTER JOIN I_ProjectDemandTP AS _Root ON ProjectDemandUUID = _Root.ProjectDemandUUID  -- association [1..1]
;

Learn More