A_ProjectClaim

DDL: A_PROJECTCLAIM Type: view_entity COMPOSITE
57 Fields 1 Data Sources 2 Associations

Project Claim

A_ProjectClaim is a Composite CDS View that provides data about "Project Claim" in SAP S/4HANA. It reads from 1 data source (R_ProjectClaimTP) and exposes 57 fields with key field ProjectClaim. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectClaimTP R_ProjectClaimTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_ProjectClaimStatus _ProjectClaimStatus _ProjectClaimStatus.ProjectClaim = _ProjectClaim.ProjectClaim
[0..*] A_ProjectClaimPartner _ProjectClaimPartner _ProjectClaimPartner.ProjectClaim = _ProjectClaim.ProjectClaim

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Project Claim view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
OData.entitySet.name ProjectClaim view
OData.entityType.name ProjectClaim_Type view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY ProjectClaim ProjectClaim
ProjectClaimType ProjectClaimType
ProjectClaimShortText ProjectClaimShortText
ProjectClaimOpponent ProjectClaimOpponent
Customer Customer Sold-to Party
Supplier Supplier Supplier
ProjectClaimProcessingPhase ProjectClaimProcessingPhase
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSDescription WBSDescription WBS Element Name
CompanyCode CompanyCode Receiver Company Code
ProjectInternalID ProjectInternalID Project Def.
ProjectExternalID ProjectExternalID Project def.
ProjectDescription ProjectDescription Project Name
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
ProjectClaimPriority ProjectClaimPriority
ProjectClaimChance ProjectClaimChance
ProjectClaimCatalog ProjectClaimCatalog
ProjectClaimCodeGroup ProjectClaimCodeGroup
ProjectClaimCode ProjectClaimCode
ProjectClaimCauseCodeCatalog ProjectClaimCauseCodeCatalog
ProjectClaimCauseCodeGroup ProjectClaimCauseCodeGroup
ProjectClaimCauseCode ProjectClaimCauseCode
ProjectClaimCauseText ProjectClaimCauseText
ProjectClaimExternalReference ProjectClaimExternalReference
ProjectClaimCurrency ProjectClaimCurrency
ProjectEstimatedCost ProjectEstimatedCost
ProjectClaimedCost ProjectClaimedCost
ProjectResultCost ProjectResultCost
ProjectClaimHasLongText ProjectClaimHasLongText
ProjectClaimObject ProjectClaimObject
ReferenceProjectClaim ReferenceProjectClaim
ReportedByUser ReportedByUser Reported By
ProjectClaimCreationDate ProjectClaimCreationDate
ProjectClaimCreationTime ProjectClaimCreationTime
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RequiredStartDate RequiredStartDate Req. Start Date
RequiredStartTime RequiredStartTime Req. start time
RequiredEndDate RequiredEndDate Req. End Date
RequiredEndTime RequiredEndTime Req. end time
ProjectClaimCompletionDate ProjectClaimCompletionDate
ProjectClaimCompletionTime ProjectClaimCompletionTime
_ProjectClaimStatus _ProjectClaimStatus
_ProjectClaimPartner _ProjectClaimPartner
_Supplier _Supplier
_Customer _Customer

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 A_ProjectClaim.
-- 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 A_ProjectClaim AS
SELECT
  ProjectClaim,
  ProjectClaimType,
  ProjectClaimShortText,
  ProjectClaimOpponent,
  Customer,
  Supplier,
  ProjectClaimProcessingPhase,
  WBSElementInternalID,
  WBSElementExternalID,
  WBSDescription,
  CompanyCode,
  ProjectInternalID,
  ProjectExternalID,
  ProjectDescription,
  PurchaseOrderByCustomer,
  PurchaseOrder,
  PurchaseOrderItem,
  SalesOrder,
  SalesOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  ProjectClaimPriority,
  ProjectClaimChance,
  ProjectClaimCatalog,
  ProjectClaimCodeGroup,
  ProjectClaimCode,
  ProjectClaimCauseCodeCatalog,
  ProjectClaimCauseCodeGroup,
  ProjectClaimCauseCode,
  ProjectClaimCauseText,
  ProjectClaimExternalReference,
  ProjectClaimCurrency,
  ProjectEstimatedCost,
  ProjectClaimedCost,
  ProjectResultCost,
  ProjectClaimHasLongText,
  ProjectClaimObject,
  ReferenceProjectClaim,
  ReportedByUser,
  ProjectClaimCreationDate,
  ProjectClaimCreationTime,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RequiredStartDate,
  RequiredStartTime,
  RequiredEndDate,
  RequiredEndTime,
  ProjectClaimCompletionDate,
  ProjectClaimCompletionTime
FROM R_ProjectClaimTP
LEFT OUTER JOIN A_ProjectClaimStatus AS _ProjectClaimStatus ON _ProjectClaimStatus.ProjectClaim = _ProjectClaim.ProjectClaim  -- association [1..*]
LEFT OUTER JOIN A_ProjectClaimPartner AS _ProjectClaimPartner ON _ProjectClaimPartner.ProjectClaim = _ProjectClaim.ProjectClaim  -- association [0..*]
;

Learn More