I_MPManager

DDL: I_MPMANAGER SQL: IPROJMANAGER Type: view COMPOSITE
13 Fields 1 Data Sources 1 Associations

Master Project Manager

I_MPManager is a Composite CDS View that provides data about "Master Project Manager" in SAP S/4HANA. It reads from 1 data source (I_MasterProject) and exposes 13 fields with key field MasterProject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MasterProject Project from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner Project.ProjectManager = _BusinessPartner.BusinessPartner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPROJMANAGER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Project Manager view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MasterProject MasterProject Project ID
MasterProjectUUID I_MasterProject MasterProjectUUID NodeID
ProjectUUID I_MasterProject ProjectUUID Project UUID
ProjectManagerName _BusinessPartner BusinessPartnerFullName Broker Name
EmailAddress
InternationalMobilePhoneNumber
InternationalPhoneNumber
StartDate I_MasterProject StartDate Valid From
EndDate I_MasterProject EndDate Term to
Employee
BusinessPartner _BusinessPartner BusinessPartner Issuing Authority
ProjectManager I_MasterProject ProjectManager Busn. Partner
_BusinessPartner _BusinessPartner

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 I_MPManager.
-- 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: IPROJMANAGER

CREATE VIEW I_MPManager AS
SELECT
  Project.MasterProject AS MasterProject,
  Project.MasterProjectUUID AS MasterProjectUUID,
  Project.ProjectUUID AS ProjectUUID,
  _BusinessPartner.BusinessPartnerFullName AS ProjectManagerName,
  _BusinessPartner._CurrentDefaultAddress._Address._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _BusinessPartner._CurrentDefaultAddress._Address._DefaultMobilePhoneNumber.InternationalPhoneNumber AS InternationalMobilePhoneNumber,
  _BusinessPartner._CurrentDefaultAddress._Address._DefaultPhoneNumber.InternationalPhoneNumber AS InternationalPhoneNumber,
  Project.StartDate AS StartDate,
  Project.EndDate AS EndDate,
  Project._Employee.PersonExternalID AS Employee,
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  Project.ProjectManager AS ProjectManager
FROM I_MasterProject AS Project
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON Project.ProjectManager = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More