C_GRC_SupplierChangeLog

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 C_GRC_SupplierChangeLog.
-- 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: CGRCSUPLRMSTRCHG

CREATE VIEW C_GRC_SupplierChangeLog AS
SELECT
  I_Supplier.Supplier AS Supplier,
  I_ChangeDocumentItem.ChangeDocument AS ChangeDocument,
  I_ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  I_ChangeDocumentItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  cast (I_ChangeDocumentItem._ChangeDocument.CreationDate as fis_udate) AS ChangeDocCreationDate,
  cast(I_ChangeDocumentItem._ChangeDocument.CreatedByUser as lcm_changed_by) AS LastChangedByUser,
  I_ChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  I_ChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  I_ChangeDocumentItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  I_ChangeDocumentItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  I_ChangeDocumentItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  I_ChangeDocumentItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  I_Supplier.SupplierName AS SupplierName,
  I_Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  I_Supplier.CreatedByUser AS CreatedByUser,
  I_Supplier.CreationDate AS CreationDate,
  I_Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  I_Supplier.PostingIsBlocked AS PostingIsBlocked,
  I_Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  I_Supplier.CityName AS CityName,
  I_Supplier.Country AS Country,
  I_Supplier.AuthorizationGroup AS AuthorizationGroup,
  I_ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  I_ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  I_Supplier.DataControllerSet AS DataControllerSet,
  I_Supplier.DataController1 AS DataController1,
  I_Supplier.DataController2 AS DataController2,
  I_Supplier.DataController3 AS DataController3,
  I_Supplier.DataController4 AS DataController4,
  I_Supplier.DataController5 AS DataController5,
  I_Supplier.DataController6 AS DataController6,
  I_Supplier.DataController7 AS DataController7,
  I_Supplier.DataController8 AS DataController8,
  I_Supplier.DataController9 AS DataController9,
  I_Supplier.DataController10 AS DataController10
FROM I_ChangeDocumentItem
INNER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
;