C_ProjectDemandWorkTP

DDL: C_PROJECTDEMANDWORKTP Type: view_entity CONSUMPTION Package: ODATA_PS_DMND_MAINTAIN
11 Fields 1 Data Sources 1 OData Services

Project Demand Work Consumption TP view

C_ProjectDemandWorkTP is a Consumption CDS View that provides data about "Project Demand Work Consumption TP view" in SAP S/4HANA. It reads from 1 data source (I_ProjectDemandWorkTP) and exposes 11 fields with key field ProjectDemandWorkUUID. It is exposed through 1 OData service (ASQL_F4562). Part of development package ODATA_PS_DMND_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_ProjectDemandWorkTP I_ProjectDemandWorkTP projection

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Project Demand Work Consumption TP view view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4562 ASQL_F4562 C2 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandWorkUUID ProjectDemandWorkUUID Resource Dmnd UUID
ProjectDemandUUID ProjectDemandUUID Entity GUID
CostCenter CostCenter Cost Center
CostCenterName
ActivityType ActivityType Activity Type
CostCtrActivityTypeName
ReferencedObjectUUID _Root ReferencedObjectUUID Referenced Object
_CostCenter _CostCenter
_CostCenterText _CostCenterText
_CostCenterActType _CostCenterActType
_ActivityTypeText _ActivityTypeText

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 C_ProjectDemandWorkTP.
-- 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 C_ProjectDemandWorkTP AS
SELECT
  ProjectDemandWorkUUID,
  ProjectDemandUUID,
  CostCenter,
  _CostCenterText[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  ActivityType,
  _ActivityTypeText[1:Language = $session.system_language].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _Root.ReferencedObjectUUID AS ReferencedObjectUUID
FROM I_ProjectDemandWorkTP
;

Learn More