C_GRC_SuplrCoCodeChangeLog

DDL: C_GRC_SUPLRCOCODECHANGELOG SQL: CGRCSUPMSTRCCCHG Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS

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. Part of development package FINS_FIS_GRC_APPS.

2 data source(s) 39 fields

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
KEY CompanyCode I_SupplierCompany CompanyCode
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType
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
IsBusinessPurposeCompleted I_SupplierCompany IsBusinessPurposeCompleted
PurchasingIsBlocked
CityName
Country
AuthorizationGroup I_SupplierCompany AuthorizationGroup
PaymentBlockingReason I_SupplierCompany PaymentBlockingReason
PaymentMethodsList I_SupplierCompany PaymentMethodsList
ClearCustomerSupplier I_SupplierCompany ClearCustomerSupplier
IsDoubleInvoice I_SupplierCompany IsDoubleInvoice
CustomerSupplierClearingIsUsed I_SupplierCompany CustomerSupplierClearingIsUsed
ReconciliationAccount I_SupplierCompany ReconciliationAccount
AlternativePayee I_SupplierCompany AlternativePayee
DeletionIndicator I_SupplierCompany DeletionIndicator
SupplierReleaseGroup I_SupplierCompany SupplierReleaseGroup
CreditMemoPaymentTerms I_SupplierCompany CreditMemoPaymentTerms
PaymentClearingGroup I_SupplierCompany PaymentClearingGroup
_Supplier I_SupplierCompany _Supplier
_CompanyCode I_SupplierCompany _CompanyCode
ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass
DatabaseTable I_ChangeDocumentItem DatabaseTable 
@AbapCatalog.sqlViewName: 'CGRCSUPMSTRCCCHG'
@EndUserText.label: 'Supplier company code change log'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@OData.publish: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view C_GRC_SuplrCoCodeChangeLog
  as select from I_ChangeDocumentItem
    inner join   I_SupplierCompany on  I_ChangeDocumentItem.ChangeDocObject = I_SupplierCompany.Supplier
                                   and I_SupplierCompany.CompanyCode        = right(
      I_ChangeDocumentItem.ChangeDocTableKey, 4
    )
{
  key I_SupplierCompany.Supplier,
  key I_SupplierCompany.CompanyCode,
  key I_ChangeDocumentItem.ChangeDocument,
  key I_ChangeDocumentItem.ChangeDocDatabaseTableField,
  key I_ChangeDocumentItem.ChangeDocItemChangeType,

      cast (I_ChangeDocumentItem._ChangeDocument.CreationDate as fis_udate)      as ChangeDocCreationDate,
      cast(I_ChangeDocumentItem._ChangeDocument.CreatedByUser as lcm_changed_by) as LastChangedByUser,
      @EndUserText.label: 'New Field Value'
      I_ChangeDocumentItem.ChangeDocNewFieldValue,
      @EndUserText.label: 'Old Field Value'
      I_ChangeDocumentItem.ChangeDocPreviousFieldValue,
      @EndUserText.label: 'New Unit'
      I_ChangeDocumentItem.ChangeDocNewUnit,
      @EndUserText.label: 'Old Unit'
      I_ChangeDocumentItem.ChangeDocPreviousUnit,
      @EndUserText.label: 'New Currency'
      I_ChangeDocumentItem.ChangeDocNewCurrency,
      @EndUserText.label: 'Old Currency'
      I_ChangeDocumentItem.ChangeDocPreviousCurrency,
      
      I_SupplierCompany._Supplier.SupplierName,
      I_SupplierCompany._Supplier.SupplierAccountGroup,
      I_SupplierCompany._Supplier.CreatedByUser,
      I_SupplierCompany._Supplier.CreationDate,
      I_SupplierCompany._Supplier.IsOneTimeAccount,
      I_SupplierCompany.SupplierIsBlockedForPosting,
      I_SupplierCompany.IsBusinessPurposeCompleted,
      I_SupplierCompany._Supplier.PurchasingIsBlocked,      
      I_SupplierCompany._Supplier.CityName,
      I_SupplierCompany._Supplier.Country,
      I_SupplierCompany.AuthorizationGroup,
      I_SupplierCompany.PaymentBlockingReason,
      I_SupplierCompany.PaymentMethodsList,      
      I_SupplierCompany.ClearCustomerSupplier,
      I_SupplierCompany.IsDoubleInvoice,
      I_SupplierCompany.CustomerSupplierClearingIsUsed,
      I_SupplierCompany.ReconciliationAccount,
      I_SupplierCompany.AlternativePayee,
      I_SupplierCompany.DeletionIndicator,
      I_SupplierCompany.SupplierReleaseGroup,
      I_SupplierCompany.CreditMemoPaymentTerms,
      I_SupplierCompany.PaymentClearingGroup,      

      I_SupplierCompany._Supplier,
      I_SupplierCompany._CompanyCode,

      I_ChangeDocumentItem.ChangeDocObjectClass,
      I_ChangeDocumentItem.DatabaseTable

}
where
      I_ChangeDocumentItem.ChangeDocObjectClass = 'KRED'
  and I_ChangeDocumentItem.DatabaseTable        = 'LFB1'

Learn More