C_GLDisplayItemChangeLog

DDL: C_GLDISPLAYITEMCHANGELOG SQL: CGLITEMCHGLOG Type: view CONSUMPTION

Display G/L Item ChangeLog Ovw

C_GLDisplayItemChangeLog is a Consumption CDS View that provides data about "Display G/L Item ChangeLog Ovw" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryHistory) and exposes 20 fields with key fields Ledger, AccountingDocument, FreeDefinedAttribute01Label, JournalEntryItemText, UserName.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryHistory I_JournalEntryHistory from

Parameters (1)

NameTypeDefault
P_FiscalYear gjahr

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CGLITEMCHGLOG view
EndUserText.label Display G/L Item ChangeLog Ovw view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropogatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
lookupEntityP_GLFiscalYearByKeyDate
resultElementFiscalYear
KEY Ledger Ledger
KEY AccountingDocument AccountingDocument
KEY FreeDefinedAttribute01Label
KEY JournalEntryItemText
KEY UserName UserName
KEY FreeDefinedAttribute02Label
KEY LastChangeDateYearMonthName
KEY DatabaseTableFieldText
KEY FiscalYear FiscalYear
KEY DatabaseTable DatabaseTable
KEY DatabaseTableField DatabaseTableField
KEY ChangeDocument ChangeDocument
KEY ChangeDocTableKey ChangeDocTableKey
KEY AccountingDocumentItem AccountingDocumentItem
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
NewFieldContent NewFieldContent
OldFieldContent OldFieldContent 
@AbapCatalog.sqlViewName: 'CGLITEMCHGLOG'
@EndUserText.label: 'Display G/L Item ChangeLog Ovw'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropogatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

@Consumption.dbHints: ['NO_SUBPLAN_SHARING','USE_OLAP_PLAN','NO_JOIN_THRU_JOIN','NO_CYCLIC_JOIN','NO_JOIN_THRU_AGGR']

@VDM.viewType: #CONSUMPTION

@UI.presentationVariant: [{
    qualifier: 'presentVar',
  sortOrder: [
    { by: 'LastChangeDate', direction: #DESC },
    { by: 'LastChangeTime', direction: #DESC }

    ]
    }]

define view C_GLDisplayItemChangeLog
  with parameters
//    @Consumption.hidden: true

//    @Environment.systemField: #SYSTEM_DATE

//    P_KeyDate    : vdm_v_key_date,

    @Consumption.hidden: true
    @Consumption.derivation: {
      lookupEntity : 'P_GLFiscalYearByKeyDate',
      resultElement : 'FiscalYear',
      binding : [
      {
        targetParameter : 'P_KeyDate',
        type :  #SYSTEM_FIELD,
        value : '#SYSTEM_DATE'
      }]
    }
    P_FiscalYear : gjahr
  as select from I_JournalEntryHistory
{
      @Consumption.semanticObject: 'AccountingJournalList'
      @UI.identification: {
        importance: #HIGH,
        type: #FOR_INTENT_BASED_NAVIGATION,
        semanticObjectAction: 'displayAuditJournal'
      }
  key CompanyCode,
  key Ledger,
      //      GLAccount,

  key AccountingDocument,
      @UI.lineItem:[{position: 40}]
  key cast ('' as abap.char(50)) as FreeDefinedAttribute01Label,
      @UI.lineItem:[{position: 10}]
      //      cast ('' as abap.char(31))       as GLAccountInfo,

  key cast ('' as abap.char(25)) as JournalEntryItemText,
      @UI.lineItem:[{position: 20}]
  key UserName,
      @UI.lineItem:[{position: 30}]
  key cast ('' as abap.char(30)) as FreeDefinedAttribute02Label,
      @UI.lineItem:[{position: 60}]
  key cast ('' as abap.char(20)) as LastChangeDateYearMonthName,
      @UI.lineItem:[{position: 50}]
  key cast ('' as abap.char(60)) as DatabaseTableFieldText,

  key FiscalYear,
  key DatabaseTable,
  key DatabaseTableField,
  key ChangeDocument,
  key ChangeDocTableKey,
  key AccountingDocumentItem,
      LastChangeDate,
      LastChangeTime,
      NewFieldContent,
      OldFieldContent
}
where
      CompanyCode        <> ''
  and AccountingDocument <> ''
  and Ledger             <> ''
  and FiscalYear         =  :P_FiscalYear
group by
  CompanyCode,
  Ledger,
  AccountingDocument,
  LastChangeDate,
  LastChangeTime,
  NewFieldContent,
  OldFieldContent,
  UserName,
  DatabaseTableField,
  DatabaseTable,
  FiscalYear,
  ChangeDocument,
  ChangeDocTableKey,
  AccountingDocumentItem

Learn More