I_WBSElementChangeDocuments

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_WBSElementChangeDocuments.
-- 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_WBSElementChangeDocuments 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,
  prps.WBSElementInternalID AS WBSElementInternalID,
  prps.WBSElementExternalID AS WBSElementExternalID,
  FieldmapProj.GFNName AS ChangeDocGlobalFieldName,
  prps.WBSDescription AS WBSDescription,
  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,
  prps.ControllingArea AS ControllingArea,
  prps.ProfitCenter AS ProfitCenter,
  prps.ResponsiblePerson AS ResponsiblePerson,
  prps.ApplicantCode AS ApplicantCode,
  prps.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  prps.ResponsibleCostCenter AS ResponsibleCostCenter,
  prps.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  prps.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  prps.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  prps.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  prps.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  prps.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  prps.ProjectType AS ProjectType,
  prps._ControllingArea AS _ControllingArea,
  prps._ProfitCenter AS _ProfitCenter,
  prps._ResponsibleCostCenter AS _ResponsibleCostCenter
FROM I_WBSElementData_2 AS prps
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_ProjectData_2 AS _Project ON ChangeDocObject = _Project.ProjectInternalID  -- association [1..1]
;