C_MPStatusItemDetails

DDL: C_MPSTATUSITEMDETAILS SQL: CMPSTATUSITEMDTL Type: view CONSUMPTION
26 Fields 4 Data Sources 1 Associations

Master Project Scope Area Details

C_MPStatusItemDetails is a Consumption CDS View that provides data about "Master Project Scope Area Details" in SAP S/4HANA. It reads from 4 data sources (I_BusinessUser, I_MPStatusItem, I_UserContactCard, I_StatusCpd) and exposes 26 fields with key fields EngagementProjectUUID, EngagementProjStatusAreaUUID. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_BusinessUser I_BusinessUser left_outer
I_MPStatusItem I_MPStatusItem from
I_UserContactCard I_UserContactCard left_outer
I_StatusCpd MPStatus left_outer

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkforcePerson _Employee $projection.BusinessPartner = _Employee.Person association[0..1] to I_WorkforcePersonImageURL as _WorkforcePersonImageURL on $projection.BusinessPartner = _WorkforcePersonImageURL.Person

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMPSTATUSITEMDTL view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
EndUserText.label Master Project Scope Area Details view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectUUID
KEY EngagementProjStatusAreaUUID
MasterProject I_MPStatusItem MasterProject Project ID
EngagementProjectStatusArea I_MPStatusItem EngagementProjectStatusArea
EngmtProjectStatusAreaName
EngagementProjectStatus I_MPStatusItem EngagementProjectStatus
EngagementProjectStatusName
EngmtProjectStatusComment I_MPStatusItem EngmtProjectStatusComment
HeaderUUID
MstrProjStatusColorCode I_StatusCpd MstrProjStatusColorCode Status Colour
MasterProjectUUID I_MPStatusItem MasterProjectUUID NodeID
LastChangedByUserName I_MPStatusItem LastChangedByUserName User Name
LastChangedDate
ProjectLastChangedDateTime I_MPStatusItem LastChangedDate Created On
MasterProjectOverallStatus
MasterProjectType I_MPStatusItem MasterProjectType
MasterProjectOrganization I_MPStatusItem MasterProjectOrganization
MasterProjectIsConfidential I_MPStatusItem MasterProjectIsConfidential
EmailAddress I_UserContactCard EmailAddress E-Mail Address
FullName I_UserContactCard FullName Name
PhoneNumber I_UserContactCard PhoneNumber Telephone no.
MobilePhoneNumber I_UserContactCard MobilePhoneNumber Telephone
EmployeeImageURL _WorkforcePersonImageURL WorkforcePersonImageURL
BusinessPartner I_BusinessUser BusinessPartner Issuing Authority
Employee
_Employee _Employee

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_MPStatusItemDetails.
-- 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: CMPSTATUSITEMDTL
-- Parameters: P_Language : sylangu

CREATE VIEW C_MPStatusItemDetails AS
SELECT
  bintohex(I_MPStatusItem.EngagementProjectUUID) AS EngagementProjectUUID,
  bintohex(I_MPStatusItem.EngagementProjStatusAreaUUID) AS EngagementProjStatusAreaUUID,
  I_MPStatusItem.MasterProject AS MasterProject,
  I_MPStatusItem.EngagementProjectStatusArea AS EngagementProjectStatusArea,
  I_EngagementProjectStatusArea._Text[1:Language = $parameters.P_Language].EngmtProjectStatusAreaName AS EngmtProjectStatusAreaName,
  I_MPStatusItem.EngagementProjectStatus AS EngagementProjectStatus,
  I_EngagementProjectStatusText[1:Language = $parameters.P_Language].EngagementProjectStatusName AS EngagementProjectStatusName,
  I_MPStatusItem.EngmtProjectStatusComment AS EngmtProjectStatusComment,
  bintohex(I_MPStatusItem.HeaderUUID) AS HeaderUUID,
  MPStatus.MstrProjStatusColorCode AS MstrProjStatusColorCode,
  I_MPStatusItem.MasterProjectUUID AS MasterProjectUUID,
  I_MPStatusItem.LastChangedByUserName AS LastChangedByUserName,
  cast( I_MPStatusItem.LastChangedDate as abap.dats ) AS LastChangedDate,
  I_MPStatusItem.LastChangedDate AS ProjectLastChangedDateTime,
  cast (I_MPStatusItem.MasterProjectOverallStatus as /cpd/cpm_isuser_satatus) AS MasterProjectOverallStatus,
  I_MPStatusItem.MasterProjectType AS MasterProjectType,
  I_MPStatusItem.MasterProjectOrganization AS MasterProjectOrganization,
  I_MPStatusItem.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  I_UserContactCard.EmailAddress AS EmailAddress,
  I_UserContactCard.FullName AS FullName,
  I_UserContactCard.PhoneNumber AS PhoneNumber,
  I_UserContactCard.MobilePhoneNumber AS MobilePhoneNumber,
  _WorkforcePersonImageURL.WorkforcePersonImageURL AS EmployeeImageURL,
  I_BusinessUser.BusinessPartner AS BusinessPartner,
  cast (_Employee.PersonExternalID as bu_id_number) AS Employee
FROM I_MPStatusItem
LEFT OUTER JOIN I_StatusCpd AS MPStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON BusinessPartner = _Employee.Person association[0..1] to I_WorkforcePersonImageURL as _WorkforcePersonImageURL on BusinessPartner = _WorkforcePersonImageURL.Person  -- association [0..1]
;

Learn More