I_ProjectChangeDocuments

DDL: I_PROJECTCHANGEDOCUMENTS Type: view BASIC
29 Fields 3 Data Sources 3 Associations

Change document for Project data

I_ProjectChangeDocuments (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Project · R&D Engineering

I_ProjectChangeDocuments is a Basic CDS View (Fact) that provides data about "Change document for Project data" in SAP S/4HANA. It reads from 3 data sources (I_ChangeDocument, I_ChangeDocumentItem, I_ProjectData_2) and exposes 29 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPS-ST
CapabilitiesData Source in SQL Select, Data Source for Data Extraction, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (3)

SourceAliasJoin Type
I_ChangeDocument cdhdr inner
I_ChangeDocumentItem cdpos inner
I_ProjectData_2 proj from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProjectResponsiblePerson _ResponsiblePerson $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson
[0..1] I_ProjectApplicant _ProjectApplicant $projection.ApplicantCode = _ProjectApplicant.ApplicantCode
[0..*] I_WBSElementData_2 _WBSElement $projection.ProjectInternalID = _WBSElement.ProjectInternalID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPROJCHGDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change document for Project data view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name Project view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocument ChangeDocObject Object Value
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Change Number of Document
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Key of Modified Table Row
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField Field Name
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
KEY ProjectInternalID I_ProjectData_2 ProjectInternalID Project (internal)
ProjectExternalID I_ProjectData_2 ProjectExternalID Project Number (External) Edited
ChangeDocGlobalFieldName FieldmapProj GFNName DD: Field Name Original Spelling
ProjectDescription I_ProjectData_2 ProjectDescription Project Name
ControllingArea I_ProjectData_2 ControllingArea Controlling Area
ProfitCenter I_ProjectData_2 ProfitCenter Profit Center
ResponsiblePerson I_ProjectData_2 ResponsiblePerson Number of the Responsible Person (Project Manager)
ApplicantCode I_ProjectData_2 ApplicantCode Applicant number
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit Referenced Unit for Old Field Content
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit Referenced Unit for New Field Content
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency Referenced Currency for Old Field Content
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency Referenced Currency for New Field Content
ChangeDocumentOldFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Content of Changed Field
ChangeDocumentNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Content of Changed Field
LastChangedByUser I_ChangeDocument CreatedByUser User Name of Person Making Change in Change Document
LastChangeDate I_ChangeDocument CreationDate Creation Date of Change Document
LastChangeTime I_ChangeDocument CreationTime Time of Change
_ControllingArea I_ProjectData_2 _ControllingArea
_ProfitCenter I_ProjectData_2 _ProfitCenter
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant
_WBSElement _WBSElement

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_ProjectChangeDocuments.
-- 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_ProjectChangeDocuments 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,
  proj.ProjectInternalID AS ProjectInternalID,
  proj.ProjectExternalID AS ProjectExternalID,
  FieldmapProj.GFNName AS ChangeDocGlobalFieldName,
  proj.ProjectDescription AS ProjectDescription,
  proj.ControllingArea AS ControllingArea,
  proj.ProfitCenter AS ProfitCenter,
  proj.ResponsiblePerson AS ResponsiblePerson,
  proj.ApplicantCode AS ApplicantCode,
  cdpos.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  cdpos.ChangeDocNewUnit AS ChangeDocNewUnit,
  cdpos.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  cdpos.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  cdpos.ChangeDocPreviousFieldValue AS ChangeDocumentOldFieldValue,
  cdpos.ChangeDocNewFieldValue AS ChangeDocumentNewFieldValue,
  cdhdr.CreatedByUser AS LastChangedByUser,
  cdhdr.CreationDate AS LastChangeDate,
  cdhdr.CreationTime AS LastChangeTime,
  proj._ControllingArea AS _ControllingArea,
  proj._ProfitCenter AS _ProfitCenter
FROM I_ProjectData_2 AS proj
INNER JOIN I_ChangeDocument AS cdhdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS cdpos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectResponsiblePerson AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON ApplicantCode = _ProjectApplicant.ApplicantCode  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON ProjectInternalID = _WBSElement.ProjectInternalID  -- association [0..*]
;

Learn More