C_ProjectClaimStatus

DDL: C_PROJECTCLAIMSTATUS Type: view_entity CONSUMPTION Package: ODATA_PS_CLAIM
15 Fields 1 Data Sources 1 OData Services

Consumption for Project Claim Status

C_ProjectClaimStatus is a Consumption CDS View that provides data about "Consumption for Project Claim Status" in SAP S/4HANA. It reads from 1 data source (I_ProjectClaim) and exposes 15 fields with key fields ProjectClaim, StatusCode. It is exposed through 1 OData service (UI_PROJECTCLAIM). Part of development package ODATA_PS_CLAIM.

Data Sources (1)

SourceAliasJoin Type
I_ProjectClaim _ProjectClaim inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption for Project Claim Status view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PROJECTCLAIM UI_PROJECTCLAIM V4 C1 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProjectClaim I_ProjectClaim ProjectClaim Notification
KEY StatusCode _StatusObject StatusCode Statuscode
StatusObject _StatusObject StatusObject Status Object
ProjectClaimType I_ProjectClaim ProjectClaimType Notifictn Type
StatusSequenceNumber
StatusProfile _StatusObject StatusProfile Status Profile
StatusProfileName
StatusIsActive _StatusObject StatusIsActive
IsUserStatus _StatusObject IsUserStatus User Status
StatusShortName
StatusName
Customer I_ProjectClaim Customer Sold-to Party
_Customer I_ProjectClaim _Customer
Supplier I_ProjectClaim Supplier Supplier
_Supplier I_ProjectClaim _Supplier

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_ProjectClaimStatus.
-- 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_ProjectClaimStatus AS
SELECT
  _ProjectClaim.ProjectClaim AS ProjectClaim,
  _StatusObject.StatusCode AS StatusCode,
  _StatusObject.StatusObject AS StatusObject,
  _ProjectClaim.ProjectClaimType AS ProjectClaimType,
  cast(_StatusObject._StatusCode.StatusSequenceNumber as ps_s4_stonr) AS StatusSequenceNumber,
  _StatusObject.StatusProfile AS StatusProfile,
  cast(_StatusObject._StatusProfile._StatusProfileText[1: Language = $session.system_language].StatusProfileName as ps_s4_stsma_desc) AS StatusProfileName,
  _StatusObject.StatusIsActive AS StatusIsActive,
  _StatusObject.IsUserStatus AS IsUserStatus,
  _StatusObject._StatusCode._StatusCodeText[1: Language = $session.system_language].StatusShortName AS StatusShortName,
  cast( _StatusObject._StatusCode._StatusCodeText[1: Language = $session.system_language].StatusName as text30 preserving type ) AS StatusName,
  _ProjectClaim.Customer AS Customer,
  _ProjectClaim._Customer AS _Customer,
  _ProjectClaim.Supplier AS Supplier,
  _ProjectClaim._Supplier AS _Supplier
INNER JOIN I_ProjectClaim AS _ProjectClaim ON /* join condition not captured in parsed metadata */
;

Learn More