R_ProjectClaimTP
Project Claim - TP
R_ProjectClaimTP is a Transactional CDS View that provides data about "Project Claim - TP" in SAP S/4HANA. It reads from 1 data source (I_ProjectClaim) and exposes 78 fields with key field ProjectClaim. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ProjectClaim | I_ProjectClaim | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ProjectClaimsCause | _ProjectClaimsCause | $projection.ProjectClaim = _ProjectClaimsCause.ProjectClaim |
| [0..1] | I_ClaimOpponentValueHelp | _ClaimOpponentValueHelp | $projection.ProjectClaimOpponent = _ClaimOpponentValueHelp.ClaimOpponent and _ClaimOpponentValueHelp.Language = $session.system_language |
| [0..1] | I_ClaimChanceValueHelp | _ClaimChanceValueHelp | $projection.ProjectClaimChance = _ClaimChanceValueHelp.ClaimChance and _ClaimChanceValueHelp.Language = $session.system_language |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Project Claim - TP | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view |
Fields (78)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectClaim | ProjectClaim | Notification | |
| ProjectClaimType | ProjectClaimType | Notifictn Type | ||
| ProjectClaimTypeText | ||||
| ProjectClaimShortText | ProjectClaimShortText | Description | ||
| ProjectClaimOpponent | ProjectClaimOpponent | Partner Type | ||
| ProjectClaimOpponentText | ||||
| Customer | Customer | Sold-to Party | ||
| CustomerName | _Customer | CustomerName | Name of Customer | |
| Supplier | Supplier | Supplier | ||
| SupplierName | _Supplier | SupplierName | Supplier Name | |
| ProjectClaimProcessingPhase | ProjectClaimProcessingPhase | Step | ||
| PrjClaimProcessingPhaseDesc | ||||
| WBSElementInternalID | WBSElementInternalID | WBS Internal ID | ||
| WBSElementExternalID | _WBSElementData | WBSElementExternalID | WBS Element External ID | |
| WBSDescriptionendasWBSDescription | ||||
| CompanyCode | _WBSElementData | CompanyCode | Receiver Company Code | |
| CompanyCodeName | ||||
| ProjectInternalID | _WBSElementData | ProjectInternalID | Project Def. | |
| ProjectExternalID | ||||
| 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 | Priority | ||
| ProjectClaimPriorityText | ||||
| ClaimPriorityType | ClaimPriorityType | PriorityType | ||
| ProjectClaimChance | ProjectClaimChance | Chance | ||
| ProjectClaimChanceText | ||||
| ProjectClaimCatalog | ProjectClaimCatalog | Catalog Type | ||
| ProjectClaimCodeGroup | ProjectClaimCodeGroup | Code Group | ||
| ProjectClaimCodeGroupText | ||||
| ProjectClaimCode | ProjectClaimCode | Coding | ||
| ProjectClaimCodeText | ||||
| ProjectClaimCauseCodeCatalog | _ProjectClaimsCause | ProjectClaimCauseCodeCatalog | ||
| ProjectClaimCauseCodeGroup | _ProjectClaimsCause | ProjectClaimCauseCodeGroup | ||
| ProjectClaimCauseCodeGroupText | ||||
| ProjectClaimCauseCode | _ProjectClaimsCause | ProjectClaimCauseCode | ||
| ProjectClaimCauseCodeText | ||||
| ProjectClaimCauseText | _ProjectClaimsCause | ProjectClaimCauseText | ||
| ProjectClaimExternalReference | ProjectClaimExternalReference | Reference No. | ||
| ProjectClaimCurrency | ProjectClaimCurrency | Transaction Currency | ||
| ProjectEstimatedCost | ProjectEstimatedCost | Estimated | ||
| ProjectClaimedCost | ProjectClaimedCost | Required | ||
| ProjectResultCost | ProjectResultCost | Accepted | ||
| ProjectClaimHasLongText | ProjectClaimHasLongText | Long text | ||
| ProjectClaimObject | ProjectClaimObject | Val. Obj. No. | ||
| ReferenceProjectClaim | ReferenceProjectClaim | Referen. Notif. | ||
| ReportedByUser | ReportedByUser | Reported By | ||
| ProjectClaimCreationDate | ProjectClaimCreationDate | Notif. Date | ||
| ProjectClaimCreationTime | ProjectClaimCreationTime | Notif. Time | ||
| 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 | Completion Date | ||
| ProjectClaimCompletionTime | ProjectClaimCompletionTime | Completion Time | ||
| _Customer | _Customer | |||
| _MaintNotificationCatalog | _MaintNotificationCatalog | |||
| _MaintNotificationCode | _MaintNotificationCode | |||
| _MaintNotificationCodeGroup | _MaintNotificationCodeGroup | |||
| _PMNotificationPhase | _PMNotificationPhase | |||
| _PMNotificationPriority | _PMNotificationPriority | |||
| _PMNotificationPriorityType | _PMNotificationPriorityType | |||
| _PMNotificationType | _PMNotificationType | |||
| _Supplier | _Supplier | |||
| _WBSElementData | _WBSElementData | |||
| _ProjectClaimsCause | _ProjectClaimsCause | |||
| _ClaimOpponentValueHelp | _ClaimOpponentValueHelp | |||
| _ClaimChanceValueHelp | _ClaimChanceValueHelp |
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 R_ProjectClaimTP.
-- 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 R_ProjectClaimTP AS
SELECT
ProjectClaim,
ProjectClaimType,
_PMNotificationType._Text[1: Language = $session.system_language].NotificationTypeName AS ProjectClaimTypeText,
ProjectClaimShortText,
ProjectClaimOpponent,
_ClaimOpponentValueHelp[1: Language = $session.system_language].ClaimOpponentText AS ProjectClaimOpponentText,
Customer,
_Customer.CustomerName AS CustomerName,
Supplier,
_Supplier.SupplierName AS SupplierName,
ProjectClaimProcessingPhase,
_PMNotificationPhase._Text[1: Language = $session.system_language].NotifProcessingPhaseDesc AS PrjClaimProcessingPhaseDesc,
WBSElementInternalID,
_WBSElementData.WBSElementExternalID AS WBSElementExternalID,
case when _WBSElementData._WBSElementShortText.LanguageBasedShortText is not initial then _WBSElementData._WBSElementShortText.LanguageBasedShortText else _WBSElementData.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
_WBSElementData.CompanyCode AS CompanyCode,
_WBSElementData._CompanyCode[1: Language = $session.system_language].CompanyCodeName AS CompanyCodeName,
_WBSElementData.ProjectInternalID AS ProjectInternalID,
_WBSElementData._Project.ProjectExternalID AS ProjectExternalID,
PurchaseOrderByCustomer,
PurchaseOrder,
PurchaseOrderItem,
SalesOrder,
SalesOrderItem,
DeliveryDocument,
DeliveryDocumentItem,
ProjectClaimPriority,
I_ProjectClaim._PMNotificationPriority._Text[1: Language = $session.system_language].MaintPriorityDesc AS ProjectClaimPriorityText,
ClaimPriorityType,
ProjectClaimChance,
_ClaimChanceValueHelp[1: Language = $session.system_language].ClaimChanceText AS ProjectClaimChanceText,
ProjectClaimCatalog,
ProjectClaimCodeGroup,
_MaintNotificationCodeGroup._Text[1: Language = $session.system_language].InspSpecAddlCodeGroupText AS ProjectClaimCodeGroupText,
ProjectClaimCode,
_MaintNotificationCode._Text[1: Language = $session.system_language].InspectionCodeText AS ProjectClaimCodeText,
_ProjectClaimsCause.ProjectClaimCauseCodeCatalog AS ProjectClaimCauseCodeCatalog,
_ProjectClaimsCause.ProjectClaimCauseCodeGroup AS ProjectClaimCauseCodeGroup,
_ProjectClaimsCause._NotifCauseCodeGroup._NotifCauseCodeGroupText[1: Language = $session.system_language].NotificationCauseCodeGroupText AS ProjectClaimCauseCodeGroupText,
_ProjectClaimsCause.ProjectClaimCauseCode AS ProjectClaimCauseCode,
_ProjectClaimsCause._NotifCauseCode._NotifCauseCodeText[1: Language = $session.system_language].NotificationCauseCodeText AS ProjectClaimCauseCodeText,
_ProjectClaimsCause.ProjectClaimCauseText AS 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 I_ProjectClaim
LEFT OUTER JOIN I_ProjectClaimsCause AS _ProjectClaimsCause ON ProjectClaim = _ProjectClaimsCause.ProjectClaim -- association [0..1]
LEFT OUTER JOIN I_ClaimOpponentValueHelp AS _ClaimOpponentValueHelp ON ProjectClaimOpponent = _ClaimOpponentValueHelp.ClaimOpponent AND _ClaimOpponentValueHelp.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_ClaimChanceValueHelp AS _ClaimChanceValueHelp ON ProjectClaimChance = _ClaimChanceValueHelp.ClaimChance AND _ClaimChanceValueHelp.Language = $session.system_language -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA