C_ManageJournalEntryHistory

DDL: C_MANAGEJOURNALENTRYHISTORY Type: view_entity CONSUMPTION

Journal Entry History

C_ManageJournalEntryHistory is a Consumption CDS View that provides data about "Journal Entry History" in SAP S/4HANA. It reads from 1 data source (R_ManageJournalEntryHistory) and exposes 32 fields with key fields CompanyCode, Ledger, AccountingDocument, ChangeDocument, DatabaseTable.

Data Sources (1)

SourceAliasJoin Type
R_ManageJournalEntryHistory _History from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Entry History view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode R_ManageJournalEntryHistory CompanyCode
KEY Ledger R_ManageJournalEntryHistory Ledger
KEY AccountingDocument R_ManageJournalEntryHistory AccountingDocument
KEY ChangeDocument R_ManageJournalEntryHistory ChangeDocument
KEY DatabaseTable R_ManageJournalEntryHistory DatabaseTable
KEY ChangeDocTableKey R_ManageJournalEntryHistory ChangeDocTableKey
KEY ChangeDocDatabaseTableField R_ManageJournalEntryHistory ChangeDocDatabaseTableField
KEY JournalEntryItem R_ManageJournalEntryHistory JournalEntryItem
KEY FiscalYear R_ManageJournalEntryHistory FiscalYear
DocumentDate R_ManageJournalEntryHistory DocumentDate
PostingDate R_ManageJournalEntryHistory PostingDate
ChangedBy R_ManageJournalEntryHistory ChangedBy Changed By
ChangedByUserName
LastChangedDate R_ManageJournalEntryHistory LastChangedDate
ChangedFieldOldValue R_ManageJournalEntryHistory ChangedFieldOldValue
ChangedFieldOldValueForFilter ChangedFieldOldValue
ChangedFieldNewValue R_ManageJournalEntryHistory ChangedFieldNewValue
ChangedFieldNewValueForFilter ChangedFieldNewValue
LastChangeTime R_ManageJournalEntryHistory LastChangeTime
LastChangeDateTime R_ManageJournalEntryHistory LastChangeDateTime Changed On
CreationDateTime R_ManageJournalEntryHistory CreationDateTime
CreationDate R_ManageJournalEntryHistory CreationDate
CreationTime R_ManageJournalEntryHistory CreationTime
DatabaseTableFieldName R_ManageJournalEntryHistory DatabaseTableFieldName
CompanyCodeName R_ManageJournalEntryHistory CompanyCodeName
LedgerName R_ManageJournalEntryHistory LedgerName
AccountingDocumentCategory R_ManageJournalEntryHistory AccountingDocumentCategory
AccountingDocumentCategoryName
AccountingDocumentType R_ManageJournalEntryHistory AccountingDocumentType
AccountingDocumentTypeName
UICT_AuditMask
_ChangedByContactCard _ChangedByContactCard
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Journal Entry History'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #CONSUMPTION
}
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}

@AccessControl.privilegedAssociations: ['_ChangedByContactCard']

@UI.presentationVariant: [{
    sortOrder: [{
      by: 'LastChangeDateTime',
      direction: #DESC
    }]
}]

define view entity C_ManageJournalEntryHistory
  as select from R_ManageJournalEntryHistory as _History
{
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_CompanyCodeVH', element: 'CompanyCode' } }]
      @ObjectModel.text.element: ['CompanyCodeName']
      @UI.textArrangement: #TEXT_LAST
      @UI: {
        selectionField: [{ position: 30 }]
      }
      @Consumption.filter.mandatory: true
  key _History.CompanyCode,
      @ObjectModel.text.element:  [ 'LedgerName' ]
      @UI.textArrangement: #TEXT_LAST
  key _History.Ledger,
      @Consumption.semanticObject: 'AccountingDocument'
      @UI: {
        lineItem: [{ position: 10 }],
        selectionField: [{ position: 40 }]
      }
  key _History.AccountingDocument,
  key _History.ChangeDocument,
  key _History.DatabaseTable,
  key _History.ChangeDocTableKey,
      @ObjectModel.text.element:  [ 'DatabaseTableFieldName' ]
      @UI.textArrangement: #TEXT_LAST
      @UI: {
        lineItem: [{ position: 40 }]
      }
  key _History.ChangeDocDatabaseTableField,
  key _History.JournalEntryItem,
  key _History.FiscalYear,
      _History.DocumentDate,
      _History.PostingDate,
      @EndUserText.label: 'Changed By'
      @ObjectModel.text.element:  [ 'ChangedByUserName' ]
      @UI.textArrangement: #TEXT_LAST
      @UI: {
        selectionField: [{ position: 20 }],
        lineItem: [{ position: 30 }]
      }
      @Consumption.valueHelpDefinition: [  { entity:  { name: 'C_MngJrnlEntryHistoryUserVH', element: 'UserID' } }]
      _History.ChangedBy,
      @Semantics.text: true
      @UI.hidden: true
      _History._ChangedByContactCard.FullName as ChangedByUserName,
      @UI.hidden: true
      _History.LastChangedDate,
      @UI: {
        lineItem: [{ position: 50 }]
      }
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      @ObjectModel.filter.transformedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      @ObjectModel.sort.transformedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      _History.ChangedFieldOldValue,
      @Consumption.hidden: true
      ChangedFieldOldValue as ChangedFieldOldValueForFilter,

      @UI: {
        lineItem: [{ position: 60 }]
      }
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      @ObjectModel.filter.transformedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      @ObjectModel.sort.transformedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      _History.ChangedFieldNewValue,
      @Consumption.hidden: true
      ChangedFieldNewValue as ChangedFieldNewValueForFilter,

      @UI.hidden: true
      _History.LastChangeTime,
      @EndUserText.label: 'Changed On'
      @UI: {
        selectionField: [{ position: 10 }],
        lineItem: [{ position: 20 }]
      }
      @Consumption.filter.selectionType: #INTERVAL
      @Consumption.filter.mandatory: true
      @ObjectModel.filter.transformedBy: 'ABAP:CL_MJE_DATETIME_FLTR_TRANSFORM'
      @ObjectModel.sort.transformedBy: 'ABAP:CL_MJE_DATETIME_FLTR_TRANSFORM'
      _History.LastChangeDateTime,
      @ObjectModel.filter.transformedBy: 'ABAP:CL_MJE_DATETIME_FLTR_TRANSFORM'
      @ObjectModel.sort.transformedBy: 'ABAP:CL_MJE_DATETIME_FLTR_TRANSFORM'
      _History.CreationDateTime,
      @UI.hidden: true
      _History.CreationDate,
      @UI.hidden: true
      _History.CreationTime,
      @UI.hidden: true
      _History.DatabaseTableFieldName,
      @Semantics.text: true
      @UI.hidden: true
      _History.CompanyCodeName,
      @Semantics.text: true
      @UI.hidden: true
      _History.LedgerName,

      @Consumption.valueHelpDefinition: [  { entity:  { name: 'I_AccountingDocumentCategory', element: 'AccountingDocumentCategory' } }]
      @UI: {
        selectionField: [{ position: 50 }]
      }
      @ObjectModel.text.element:  [ 'AccountingDocumentCategoryName' ]
      @UI.textArrangement: #TEXT_LAST
      _History.AccountingDocumentCategory,
      @Semantics.text: true
      @UI.hidden: true
      _History._AccountingDocumentCategoryT.AccountingDocumentCategoryName,

      @Consumption.valueHelpDefinition: [{ entity:{ name: 'I_AccountingDocumentTypeStdVH', element: 'AccountingDocumentType' } }]
      @ObjectModel.text.element:  [ 'AccountingDocumentTypeName' ]
      @UI.textArrangement: #TEXT_LAST
      _History.AccountingDocumentType,
      @Semantics.text: true
      @UI.hidden: true
      _History._AccountingDocumentTypeText.AccountingDocumentTypeName,

      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MJE_AUDIT_MASK'
      @UI.hidden: true
      @Semantics.booleanIndicator
      cast ('' as abap.char(1)) as UICT_AuditMask,

      @Consumption.filter.hidden: true
      _ChangedByContactCard
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENTCATEGORYT",
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_USERCONTACTCARD",
"R_MANAGEJOURNALENTRYHISTORY"
],
"ASSOCIATED":
[
"I_USERCONTACTCARD"
],
"BASE":
[
"R_MANAGEJOURNALENTRYHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/