C_GRC_SuplrCoCodeChangeLog

DDL: C_GRC_SUPLRCOCODECHANGELOG SQL: CGRCSUPMSTRCCCHG Type: view CONSUMPTION
39 Fields 2 Data Sources

Supplier company code change log

C_GRC_SuplrCoCodeChangeLog is a Consumption CDS View that provides data about "Supplier company code change log" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocumentItem, I_SupplierCompany) and exposes 39 fields with key fields Supplier, CompanyCode, ChangeDocument, ChangeDocDatabaseTableField, ChangeDocItemChangeType.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from
I_SupplierCompany I_SupplierCompany inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCSUPMSTRCCCHG view
EndUserText.label Supplier company code change log view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_SupplierCompany Supplier Supplier
KEY CompanyCode I_SupplierCompany CompanyCode Receiver Company Code
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Document Number
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
ChangeDocCreationDate
LastChangedByUser
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Field Value
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Field Value
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit New Unit
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit Old Unit
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency New Currency
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency Old Currency
SupplierName
SupplierAccountGroup
CreatedByUser
CreationDate
IsOneTimeAccount
SupplierIsBlockedForPosting I_SupplierCompany SupplierIsBlockedForPosting Co.code post.block
IsBusinessPurposeCompleted I_SupplierCompany IsBusinessPurposeCompleted Purpose Completed
PurchasingIsBlocked
CityName
Country
AuthorizationGroup I_SupplierCompany AuthorizationGroup AuthorizGroup
PaymentBlockingReason I_SupplierCompany PaymentBlockingReason Pmnt block
PaymentMethodsList I_SupplierCompany PaymentMethodsList Payment Methods
ClearCustomerSupplier I_SupplierCompany ClearCustomerSupplier Clrg with Cust.
IsDoubleInvoice I_SupplierCompany IsDoubleInvoice Chk Double Inv.
CustomerSupplierClearingIsUsed I_SupplierCompany CustomerSupplierClearingIsUsed Clrg with vend.
ReconciliationAccount I_SupplierCompany ReconciliationAccount Recon. account
AlternativePayee I_SupplierCompany AlternativePayee Alternat.payee
DeletionIndicator I_SupplierCompany DeletionIndicator Deletion Ind.
SupplierReleaseGroup I_SupplierCompany SupplierReleaseGroup Release Group
CreditMemoPaymentTerms I_SupplierCompany CreditMemoPaymentTerms Cr Memo Terms
PaymentClearingGroup I_SupplierCompany PaymentClearingGroup Payment Clrg Grp ID
_Supplier I_SupplierCompany _Supplier
_CompanyCode I_SupplierCompany _CompanyCode
ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass Change Doc. Object
DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name

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_SuplrCoCodeChangeLog.
-- 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: CGRCSUPMSTRCCCHG

CREATE VIEW C_GRC_SuplrCoCodeChangeLog AS
SELECT
  I_SupplierCompany.Supplier AS Supplier,
  I_SupplierCompany.CompanyCode AS CompanyCode,
  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_SupplierCompany._Supplier.SupplierName AS SupplierName,
  I_SupplierCompany._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  I_SupplierCompany._Supplier.CreatedByUser AS CreatedByUser,
  I_SupplierCompany._Supplier.CreationDate AS CreationDate,
  I_SupplierCompany._Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  I_SupplierCompany.SupplierIsBlockedForPosting AS SupplierIsBlockedForPosting,
  I_SupplierCompany.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_SupplierCompany._Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  I_SupplierCompany._Supplier.CityName AS CityName,
  I_SupplierCompany._Supplier.Country AS Country,
  I_SupplierCompany.AuthorizationGroup AS AuthorizationGroup,
  I_SupplierCompany.PaymentBlockingReason AS PaymentBlockingReason,
  I_SupplierCompany.PaymentMethodsList AS PaymentMethodsList,
  I_SupplierCompany.ClearCustomerSupplier AS ClearCustomerSupplier,
  I_SupplierCompany.IsDoubleInvoice AS IsDoubleInvoice,
  I_SupplierCompany.CustomerSupplierClearingIsUsed AS CustomerSupplierClearingIsUsed,
  I_SupplierCompany.ReconciliationAccount AS ReconciliationAccount,
  I_SupplierCompany.AlternativePayee AS AlternativePayee,
  I_SupplierCompany.DeletionIndicator AS DeletionIndicator,
  I_SupplierCompany.SupplierReleaseGroup AS SupplierReleaseGroup,
  I_SupplierCompany.CreditMemoPaymentTerms AS CreditMemoPaymentTerms,
  I_SupplierCompany.PaymentClearingGroup AS PaymentClearingGroup,
  I_SupplierCompany._Supplier AS _Supplier,
  I_SupplierCompany._CompanyCode AS _CompanyCode,
  I_ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  I_ChangeDocumentItem.DatabaseTable AS DatabaseTable
FROM I_ChangeDocumentItem
INNER JOIN I_SupplierCompany ON /* join condition not captured in parsed metadata */
;

Learn More