P_EngmntProjChangeDocument

DDL: P_ENGMNTPROJCHANGEDOCUMENT SQL: PENGPROJCHGDOC Type: view COMPOSITE
19 Fields 2 Data Sources

Engagement Project Change Document

P_EngmntProjChangeDocument is a Composite CDS View that provides data about "Engagement Project Change Document" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 19 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument ChangeDocumentHdr inner
I_ChangeDocumentItem ChangeDocumentItem from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PENGPROJCHGDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Engagement Project Change Document view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject Object Value
KEY ChangeDocObjectClass I_ChangeDocumentItem 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
ChangeDocItemChangeTypeText ChangeType Text User Group
DatabaseTableText TableText Text User Group
ChangeTransactionCode I_ChangeDocument ChangeTransactionCode Change Tcode
CreatedByUser I_ChangeDocument CreatedByUser User Name
UserName UserDetails UserDescription Full Name
CreationDate I_ChangeDocument CreationDate Time Stamp
CreationTime I_ChangeDocument CreationTime Time of Change
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Value
ChangeDocNewStrFieldValue ChangeDocumentString ChangeDocStringNew
ChangeDocPreviousStrFieldValue ChangeDocumentString ChangeDocStringOld
ChangeDocLongTableKey LongTableKey ChangeDocLongTableKey

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 P_EngmntProjChangeDocument.
-- 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: PENGPROJCHGDOC

CREATE VIEW P_EngmntProjChangeDocument AS
SELECT
  ChangeDocumentItem.ChangeDocObject AS ChangeDocObject,
  ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  ChangeDocumentItem.ChangeDocument AS ChangeDocument,
  ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  ChangeDocumentItem.ChangeDocTableKey AS ChangeDocTableKey,
  ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  ChangeDocumentItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  ChangeType.Text AS ChangeDocItemChangeTypeText,
  TableText.Text AS DatabaseTableText,
  ChangeDocumentHdr.ChangeTransactionCode AS ChangeTransactionCode,
  ChangeDocumentHdr.CreatedByUser AS CreatedByUser,
  UserDetails.UserDescription AS UserName,
  ChangeDocumentHdr.CreationDate AS CreationDate,
  ChangeDocumentHdr.CreationTime AS CreationTime,
  ChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  ChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  ChangeDocumentString.ChangeDocStringNew AS ChangeDocNewStrFieldValue,
  ChangeDocumentString.ChangeDocStringOld AS ChangeDocPreviousStrFieldValue,
  LongTableKey.ChangeDocLongTableKey AS ChangeDocLongTableKey
FROM I_ChangeDocumentItem AS ChangeDocumentItem
INNER JOIN I_ChangeDocument AS ChangeDocumentHdr ON /* join condition not captured in parsed metadata */
;

Learn More