I_MasterProjectItemList

DDL: I_MASTERPROJECTITEMLIST SQL: IMPITEMLIST Type: view COMPOSITE
28 Fields 3 Data Sources 1 Associations

Master Project Item List

I_MasterProjectItemList is a Composite CDS View that provides data about "Master Project Item List" in SAP S/4HANA. It reads from 3 data sources (I_MasterProject, I_MstrProjUsrAuthList, I_MasterProjectItem) and exposes 28 fields. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_MasterProject MasterProject inner
I_MstrProjUsrAuthList MasterProjectAuth inner
I_MasterProjectItem MasterProjectItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MasterProjectCurrency _Currency $projection.MasterProjectUUID = _Currency.MasterProjectUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPITEMLIST view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Master Project Item List view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MstrProjUsrAuthList MasterProjectUUID NodeID
MasterProject I_MstrProjUsrAuthList MasterProject Project ID
MasterProjectName I_MasterProject MasterProjectName
MasterProjectStage I_MasterProject MasterProjectStage
StartDate I_MasterProject StartDate Valid From
EndDate I_MasterProject EndDate Term to
Customer I_MasterProject Customer Sold-to Party
MasterProjectOrganization I_MasterProject MasterProjectOrganization
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
Country I_MasterProject Country Venue: Ctry/Reg
Region I_MasterProject Region Venue Region
WorkType I_MasterProject WorkType SAF-T Work Type
Industry I_MasterProject Industry Industry Sector
ProjectRisk I_MasterProject ProjectRisk
FinancialRisk I_MasterProject FinancialRisk Financial Risk
TechnicalRisk I_MasterProject TechnicalRisk Technical Risk
OverallRisk I_MasterProject OverallRisk
MasterProjectItemUUID I_MasterProjectItem MasterProjectItemUUID UUID
MasterProjectItemObjectType I_MasterProjectItem MasterProjectItemObjectType Object Link
MasterProjectItem I_MasterProjectItem MasterProjectItem Item Key
CreatedByUser I_MasterProjectItem CreatedByUser User Name
CreationDateTime I_MasterProjectItem CreationDateTime Timestamp
LastChangedByUser I_MasterProjectItem LastChangedByUser User Name
LastChangeDateTime I_MasterProjectItem LastChangeDateTime Timestamp
UserIsInvolved I_MstrProjUsrAuthList UserIsInvolved
MasterProjectType I_MstrProjUsrAuthList MasterProjectType
CurrencyendasCurrency
MstrProjCutOffDate I_MasterProject MstrProjCutOffDate Cut-Off Date

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_MasterProjectItemList.
-- 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: IMPITEMLIST

CREATE VIEW I_MasterProjectItemList AS
SELECT
  MasterProjectAuth.MasterProjectUUID AS MasterProjectUUID,
  MasterProjectAuth.MasterProject AS MasterProject,
  MasterProject.MasterProjectName AS MasterProjectName,
  MasterProject.MasterProjectStage AS MasterProjectStage,
  MasterProject.StartDate AS StartDate,
  MasterProject.EndDate AS EndDate,
  MasterProject.Customer AS Customer,
  MasterProject.MasterProjectOrganization AS MasterProjectOrganization,
  MasterProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MasterProject.Country AS Country,
  MasterProject.Region AS Region,
  MasterProject.WorkType AS WorkType,
  MasterProject.Industry AS Industry,
  MasterProject.ProjectRisk AS ProjectRisk,
  MasterProject.FinancialRisk AS FinancialRisk,
  MasterProject.TechnicalRisk AS TechnicalRisk,
  MasterProject.OverallRisk AS OverallRisk,
  MasterProjectItem.MasterProjectItemUUID AS MasterProjectItemUUID,
  MasterProjectItem.MasterProjectItemObjectType AS MasterProjectItemObjectType,
  MasterProjectItem.MasterProjectItem AS MasterProjectItem,
  MasterProjectItem.CreatedByUser AS CreatedByUser,
  MasterProjectItem.CreationDateTime AS CreationDateTime,
  MasterProjectItem.LastChangedByUser AS LastChangedByUser,
  MasterProjectItem.LastChangeDateTime AS LastChangeDateTime,
  MasterProjectAuth.UserIsInvolved AS UserIsInvolved,
  MasterProjectAuth.MasterProjectType AS MasterProjectType,
  case when MasterProject.Currency = '' then _Currency.Currency else MasterProject.Currency end as Currency AS CurrencyendasCurrency,
  MasterProject.MstrProjCutOffDate AS MstrProjCutOffDate
FROM I_MasterProjectItem AS MasterProjectItem
INNER JOIN I_MstrProjUsrAuthList AS MasterProjectAuth ON /* join condition not captured in parsed metadata */
INNER JOIN I_MasterProject AS MasterProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterProjectCurrency AS _Currency ON MasterProjectUUID = _Currency.MasterProjectUUID  -- association [1..1]
;

Learn More