What is I_EntProjStsAreaChgDocuments in SAP S/4HANA?

I_EntProjStsAreaChgDocuments is a composite CDS view in SAP S/4HANA. Chg Doc for Status Area of Ent Proj It contains 35 fields.

Which tables does I_EntProjStsAreaChgDocuments read from?

I_EntProjStsAreaChgDocuments reads data from: I_ChangeDocument, I_ChangeDocumentItem, I_EnterpriseProject, I_PPM_ProjectStatusAreaData.

What VDM layer is I_EntProjStsAreaChgDocuments?

I_EntProjStsAreaChgDocuments is classified as a Composite view that combines data from multiple basic views.

I_EntProjStsAreaChgDocuments

DDL: I_ENTPROJSTSAREACHGDOCUMENTS Type: view COMPOSITE

35 Fields 4 Data Sources 9 Associations

Chg Doc for Status Area of Ent Proj

I_EntProjStsAreaChgDocuments is a Composite CDS View that provides data about "Chg Doc for Status Area of Ent Proj" in SAP S/4HANA. It reads from 4 data sources (I_ChangeDocument, I_ChangeDocumentItem, I_EnterpriseProject, I_PPM_ProjectStatusAreaData) and exposes 35 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 9 associations to related views.

Data Sources (4)

Source	Alias	Join Type
I_ChangeDocument	cdhdr	from
I_ChangeDocumentItem	cdpos	inner
I_EnterpriseProject	EntProject	inner
I_PPM_ProjectStatusAreaData	status_data	inner

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_PPM_StatusAreaCode	_StatusArea	`$projection.StatusArea = _StatusArea.StatusArea`
[0..*]	I_PPM_StatusAreaCodeText	_StatusAreaText	`$projection.StatusArea = _StatusAreaText.StatusArea`
[0..*]	I_EntProjChangeIndicatorText	_ChangeTypeText	`$projection.ChangeDocItemChangeType = _ChangeTypeText.ChangeDocItemChangeType`
[0..*]	I_PPM_ContactData	_ChangedBy	`$projection.LastChangedByUser = _ChangedBy.UserID`
[0..*]	I_EntProjChgDocTableFieldText	_FieldText	`( _FieldText.ChangeDocDatabaseTableField = $projection.ChangeDocDatabaseTableField and _FieldText.DatabaseTable = cdpos.DatabaseTable )`
[0..*]	I_PPM_AuthznByUsrH	_AuthUser	`_AuthUser.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthUser.UserID = $session.user and ( _AuthUser.Activity = 'Admin' or _AuthUser.Activity = 'Write' or _AuthUser.Activity = 'Read' )`
[0..*]	I_PPM_AuthznBySubstitH	_AuthSubst	`_AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthSubst.UserID = $session.user and ( _AuthSubst.Activity = 'Admin' or _AuthSubst.Activity = 'Write' or _AuthSubst.Activity = 'Read' )`
[0..*]	I_PPM_AuthznByUserRoleH	_AuthRole	`_AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthRole.UserID = $session.user and ( _AuthRole.Activity = 'Admin' or _AuthRole.Activity = 'Write' or _AuthRole.Activity = 'Read' )`
[0..*]	I_PPM_AuthznByUsrGrpH	_AuthGroup	`_AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthGroup.UserID = $session.user and ( _AuthGroup.Activity = 'Admin' or _AuthGroup.Activity = 'Write' or _AuthGroup.Activity = 'Read' )`

Annotations (13)

Name	Value	Level
EndUserText.label	Chg Doc for Status Area of Ent Proj	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AbapCatalog.sqlViewName	IPROJSTSAREACD	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XL	view

Fields (35)

Key	Field	Source Table	Source Field	Description
KEY	ChangeDocObject	I_ChangeDocument	ChangeDocObject	Object Value
KEY	ChangeDocObjectClass	I_ChangeDocument	ChangeDocObjectClass	Change Doc. Object
KEY	ChangeDocument	I_ChangeDocumentItem	ChangeDocument	Document Number
KEY	DatabaseTable	I_ChangeDocumentItem	DatabaseTable	Table Name
KEY	ChangeDocTableKey	I_ChangeDocumentItem	ChangeDocTableKey	Table Keys
KEY	ChangeDocDatabaseTableField	I_ChangeDocumentItem	ChangeDocDatabaseTableField	User
KEY	ChangeDocItemChangeType	I_ChangeDocumentItem	ChangeDocItemChangeType	Change Indicator
KEY	ProjectUUID	I_EnterpriseProject	ProjectUUID	Project UUID
	ProjectSummaryTaskUUID	I_EnterpriseProject	ProjectSummaryTaskUUID	Entity GUID
	Project	I_EnterpriseProject	Project	WBS Element
	ProjectName	I_EnterpriseProject	ProjectDescription	Project Name
	_StatusArea		_StatusArea
	_StatusAreaText		_StatusAreaText
	_ChangedBy		_ChangedBy
	_ChangeTypeText		_ChangeTypeText
	_FieldText		_FieldText
	ControllingArea	I_EnterpriseProject	ControllingArea	Controlling Area
	ProfitCenter	I_EnterpriseProject	ProfitCenter	Profit Center
	CompanyCode	I_EnterpriseProject	CompanyCode	Receiver Company Code
	ProjectProfileCode	I_EnterpriseProject	ProjectProfileCode	Project Profile
	ResponsibleCostCenter	I_EnterpriseProject	ResponsibleCostCenter	Responsible Cost Center
	Plant	I_EnterpriseProject	Plant	Valuation Area
	EnterpriseProjectType	I_EnterpriseProject	EnterpriseProjectType	Proj.type
	FunctionalArea	I_EnterpriseProject	FunctionalArea	Sendr Fctl Area
	_AuthUser		_AuthUser
	_AuthSubst		_AuthSubst
	_AuthRole		_AuthRole
	_AuthGroup		_AuthGroup
	StatusArea	I_PPM_ProjectStatusAreaData	StatusArea	Status Area
	ChangeDocumentOldFieldValue		ChangeDocPreviousFieldValue	Old Value
	ChangeDocumentNewFieldValue		ChangeDocNewFieldValue	New Value
	LastChangedByUser	I_ChangeDocument	CreatedByUser	User Name
	LastChangedDate	I_ChangeDocument	CreationDate	Time Stamp
	LastChangeDate	I_ChangeDocument	CreationDate	Time Stamp
	LastChangeTime	I_ChangeDocument	CreationTime	Time of Change

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_EntProjStsAreaChgDocuments.
-- 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 I_EntProjStsAreaChgDocuments AS
SELECT
  cdhdr.ChangeDocObject AS ChangeDocObject,
  cdhdr.ChangeDocObjectClass AS ChangeDocObjectClass,
  cdpos.ChangeDocument AS ChangeDocument,
  cdpos.DatabaseTable AS DatabaseTable,
  cdpos.ChangeDocTableKey AS ChangeDocTableKey,
  cdpos.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  cdpos.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  EntProject.ProjectUUID AS ProjectUUID,
  EntProject.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  EntProject.Project AS Project,
  EntProject.ProjectDescription AS ProjectName,
  EntProject.ControllingArea AS ControllingArea,
  EntProject.ProfitCenter AS ProfitCenter,
  EntProject.CompanyCode AS CompanyCode,
  EntProject.ProjectProfileCode AS ProjectProfileCode,
  EntProject.ResponsibleCostCenter AS ResponsibleCostCenter,
  EntProject.Plant AS Plant,
  EntProject.EnterpriseProjectType AS EnterpriseProjectType,
  EntProject.FunctionalArea AS FunctionalArea,
  status_data.StatusArea AS StatusArea,
  ChangeDocPreviousFieldValue AS ChangeDocumentOldFieldValue,
  ChangeDocNewFieldValue AS ChangeDocumentNewFieldValue,
  cdhdr.CreatedByUser AS LastChangedByUser,
  cdhdr.CreationDate AS LastChangedDate,
  cdhdr.CreationDate AS LastChangeDate,
  cdhdr.CreationTime AS LastChangeTime
FROM I_ChangeDocument AS cdhdr
INNER JOIN I_EnterpriseProject AS EntProject ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS cdpos ON /* join condition not captured in parsed metadata */
INNER JOIN I_PPM_ProjectStatusAreaData AS status_data ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_StatusAreaCode AS _StatusArea ON StatusArea = _StatusArea.StatusArea  -- association [0..1]
LEFT OUTER JOIN I_PPM_StatusAreaCodeText AS _StatusAreaText ON StatusArea = _StatusAreaText.StatusArea  -- association [0..*]
LEFT OUTER JOIN I_EntProjChangeIndicatorText AS _ChangeTypeText ON ChangeDocItemChangeType = _ChangeTypeText.ChangeDocItemChangeType  -- association [0..*]
LEFT OUTER JOIN I_PPM_ContactData AS _ChangedBy ON LastChangedByUser = _ChangedBy.UserID  -- association [0..*]
LEFT OUTER JOIN I_EntProjChgDocTableFieldText AS _FieldText ON ( _FieldText.ChangeDocDatabaseTableField = ChangeDocDatabaseTableField AND _FieldText.DatabaseTable = cdpos.DatabaseTable )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
;

Depth:

I_EntProjStsAreaChgDocuments view

C_EntProjStsAreaChgDocuments view