C_ProjectCostReportContactCard

DDL: C_PROJECTCOSTREPORTCONTACTCARD SQL: CPCRCONTCARD Type: view CONSUMPTION
5 Fields 1 Associations 1 OData Services 1 Fiori Apps

Contact Card for Project Cost Line Items

C_ProjectCostReportContactCard is a Consumption CDS View that provides data about "Contact Card for Project Cost Line Items" in SAP S/4HANA. It has 1 association to related views. It is exposed through 1 OData service (UI_PROJECTCOSTLINEITEM). It is used in 1 Fiori application: Project Cost Line Items.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard User.UserID = _UserContactCard.ContactCardID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPCRCONTCARD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey UserID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Contact Card for Project Cost Line Items view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PROJECTCOSTLINEITEM UI_PROJECTCOSTLINEITEM V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6992 Project Cost Line Items Analytical Fiori Application for displaying project cost (Actual/Plan) in Project System

Project Cost Line Items

Business Role: Project Financial Controller

The Fiori app Project Cost Line Items is enhanced to enable the analysis of planned and actual cost details of service order items and service contract items assigned to projects. You can use the new filters Service Order, Service Order Item, Service Contract, and Service Contract Item to restrict the display of service order items and service contract items.

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UserID UserID User ID
FullName _UserContactCard FullName Name
EmailAddress _UserContactCard EmailAddress Email
PhoneNumber _UserContactCard PhoneNumber Phone Number
_UserContactCard _UserContactCard

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_ProjectCostReportContactCard.
-- 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.
-- SQL view name: CPCRCONTCARD

CREATE VIEW C_ProjectCostReportContactCard AS
SELECT
  UserID,
  _UserContactCard.FullName AS FullName,
  _UserContactCard.EmailAddress AS EmailAddress,
  _UserContactCard.PhoneNumber AS PhoneNumber
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON User.UserID = _UserContactCard.ContactCardID  -- association [1..1]
;

Learn More