C_ManageJournalEntryHistory
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. It is exposed through 1 OData service (UI_JOURNALENTRY_MANAGE). It is used in 2 Fiori applications: Manage Journal Entries - New Version, Display Journal Entries. Part of development package ODATA_MANAGE_JOURNAL_ENTRY_V2.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_ManageJournalEntryHistory | _History | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.auditFilter | #ENABLED | 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 | |
| UI.headerInfo.typeNamePlural | Change Documents | view | |
| UI.headerInfo.typeName | Change Document | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_JOURNALENTRY_MANAGE | UI_JOURNALENTRY_MANAGE | V2 | C1 | NOT_RELEASED |
Fiori Apps (2)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F0717A | Manage Journal Entries - New Version | Transactional | With this app you can analyze journal entries, create reversals or make adjustments. |
| F7697 | Display Journal Entries | Transactional | With this app you can display and analyze journal entries. |
Manage Journal Entries - New Version
Business Role: General Ledger Accountant
With this app, you can manage and analyze journal entries. You can find, filter, sort, and group journal entries according to the requirements of your business. The app is your entry point for many important journal entry management functions, allowing you to create, copy, verify, edit, and reverse entries. Additionally, you can initiate correspondence, analyze change and reversal logs, and display entries in t-account views or document flows. You navigate to the details of individual journal entries to display more information, such as transaction data, line items, associated journal entries, and other related documents.
Display Journal Entries
Business Role: General Ledger Accountant
With this app, you can view and analyze journal entries. You can find, filter, sort, and group journal entries according to the requirements of your business. Additionally, you can analyze change logs and display entries in t-account views or document flows. You navigate to the details of individual journal entries to display more information, such as transaction data, line items, associated journal entries, and other related documents.
Key Features: Display journal entries and their line items Access a detail screen for each journal entry Display parked documents View change logs See related documents, such as purchase orders or incoming invoices Display amounts in different ledgers and currencies Display intercompany journal entries See an overview of the customer and supplier accounting document data View notes and attachments added to journal entries Display predictive journal entries if you use predictive accounting
Fields (32)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | ||||
| LedgerName | R_ManageJournalEntryHistory | LedgerName | ||
| AccountingDocumentCategory | R_ManageJournalEntryHistory | AccountingDocumentCategory | ||
| AccountingDocumentCategoryName | ||||
| AccountingDocumentType | R_ManageJournalEntryHistory | AccountingDocumentType | ||
| AccountingDocumentTypeName | ||||
| UICT_AuditMask | ||||
| _ChangedByContactCard | _ChangedByContactCard |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.auditFilter: #ENABLED
@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
}]
}]
@UI.headerInfo: {
typeNamePlural: 'Change Documents',
typeName: 'Change Document'
}
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
cast(_History.CompanyCodeName as fis_butxt preserving type) as CompanyCodeName,
@Semantics.text: 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
cast(_History._AccountingDocumentCategoryT.AccountingDocumentCategoryName as fis_bstat_name preserving type ) as AccountingDocumentCategoryName,
@Consumption.valueHelpDefinition: [{ entity:{ name: 'I_AccountingDocumentTypeStdVH', element: 'AccountingDocumentType' } }]
@ObjectModel.text.element: [ 'AccountingDocumentTypeName' ]
@UI.textArrangement: #TEXT_LAST
_History.AccountingDocumentType,
@Semantics.text: 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA