R_ManageJournalEntryAmount
Journal Entry Amount
R_ManageJournalEntryAmount is a Composite CDS View that provides data about "Journal Entry Amount" in SAP S/4HANA. It reads from 3 data sources (R_MngJrnlEntryEntryViewAmount, R_MngJrnlEntryLedgerViewAmount, R_MngJrnlEntrPrkdDocItemAmount) and exposes 25 fields with key fields CompanyCode, FiscalYear, AccountingDocument, FiscalYear, AccountingDocument. It is exposed through 1 OData service (UI_JOURNALENTRY_MANAGE). It is used in 1 Fiori application: Manage Journal Entries - New Version.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| R_MngJrnlEntryEntryViewAmount | _AcctgDocItem | union |
| R_MngJrnlEntryLedgerViewAmount | _JournalEntryItemAggr | from |
| R_MngJrnlEntrPrkdDocItemAmount | _ParkedAmount | union |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Journal Entry Amount | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| UI.headerInfo.typeName | Document | view | |
| UI.headerInfo.typeNamePlural | Documents | view | |
| UI.headerInfo.title.value | AccountingDocument | view | |
| UI.headerInfo.title.label | Document | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.description.value | AccountingDocument | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_JOURNALENTRY_MANAGE | UI_JOURNALENTRY_MANAGE | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| 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. |
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.
Fields (25)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | R_MngJrnlEntryLedgerViewAmount | CompanyCode | |
| KEY | FiscalYear | R_MngJrnlEntryLedgerViewAmount | FiscalYear | |
| KEY | AccountingDocument | R_MngJrnlEntryLedgerViewAmount | AccountingDocument | |
| CompanyCodeCurrency | R_MngJrnlEntryLedgerViewAmount | CompanyCodeCurrency | ||
| AmountInCompanyCodeCurrency | R_MngJrnlEntryLedgerViewAmount | AmountInCompanyCodeCurrency | ||
| TransactionCurrency | R_MngJrnlEntryLedgerViewAmount | TransactionCurrency | ||
| AmountInTransactionCurrency | R_MngJrnlEntryLedgerViewAmount | AmountInTransactionCurrency | ||
| FunctionalCurrency | R_MngJrnlEntryLedgerViewAmount | FunctionalCurrency | ||
| CompanyCode | ||||
| KEY | FiscalYear | R_MngJrnlEntryEntryViewAmount | FiscalYear | |
| KEY | AccountingDocument | R_MngJrnlEntryEntryViewAmount | AccountingDocument | |
| CompanyCodeCurrency | R_MngJrnlEntryEntryViewAmount | CompanyCodeCurrency | ||
| AmountInCompanyCodeCurrency | R_MngJrnlEntryEntryViewAmount | AmountInCompanyCodeCurrency | ||
| TransactionCurrency | R_MngJrnlEntryEntryViewAmount | TransactionCurrency | ||
| AmountInTransactionCurrency | R_MngJrnlEntryEntryViewAmount | AmountInTransactionCurrency | ||
| FunctionalCurrency | R_MngJrnlEntryEntryViewAmount | FunctionalCurrency | ||
| SourceCompanyCodeasCompanyCode | ||||
| KEY | FiscalYear | R_MngJrnlEntrPrkdDocItemAmount | SourceFiscalYear | |
| KEY | AccountingDocument | R_MngJrnlEntrPrkdDocItemAmount | SourceAccountingDocument | |
| CompanyCodeCurrency | R_MngJrnlEntrPrkdDocItemAmount | TransactionCurrency | ||
| AmountInCompanyCodeCurrency | R_MngJrnlEntrPrkdDocItemAmount | AmountInCompanyCodeCurrency | ||
| TransactionCurrency | R_MngJrnlEntrPrkdDocItemAmount | TransactionCurrency | ||
| AmountInTransactionCurrency | R_MngJrnlEntrPrkdDocItemAmount | AmountInTransactionCurrency | ||
| FunctionalCurrency | R_MngJrnlEntrPrkdDocItemAmount | TransactionCurrency | ||
| AmountInFunctionalCurrency |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Journal Entry Amount'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #XXL,
dataClass: #MIXED
}
@UI.headerInfo: {
typeName: 'Document',
typeNamePlural: 'Documents',
title: {
value: 'AccountingDocument',
label: 'Document'
},
description: { type: #STANDARD, value: 'AccountingDocument' }
}
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type:#SAP_INTERNAL_API
}
//docln
//buzei - link
//bstat - U only ACDOCA
//L - bseg_add
//rest - bseg & ACDOCA joachim becker
define view entity R_ManageJournalEntryAmount
as select
from R_MngJrnlEntryLedgerViewAmount as _JournalEntryItemAggr
{
key _JournalEntryItemAggr.CompanyCode, // BUKRS
key _JournalEntryItemAggr.FiscalYear, // GJAHR
key _JournalEntryItemAggr.AccountingDocument, // BELNR
_JournalEntryItemAggr.CompanyCodeCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
_JournalEntryItemAggr.AmountInCompanyCodeCurrency,
_JournalEntryItemAggr.TransactionCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
_JournalEntryItemAggr.AmountInTransactionCurrency,
_JournalEntryItemAggr.FunctionalCurrency,
@Semantics.amount.currencyCode: 'FunctionalCurrency'
_JournalEntryItemAggr.AmountInFunctionalCurrency
}
// where condition in view from which we select data
union
select
from R_MngJrnlEntryEntryViewAmount as _AcctgDocItem
{
key _AcctgDocItem.CompanyCode, // BUKRS
key _AcctgDocItem.FiscalYear, // GJAHR
key _AcctgDocItem.AccountingDocument, // BELNR
_AcctgDocItem.CompanyCodeCurrency,
_AcctgDocItem.AmountInCompanyCodeCurrency,
_AcctgDocItem.TransactionCurrency,
_AcctgDocItem.AmountInTransactionCurrency,
_AcctgDocItem.FunctionalCurrency,
_AcctgDocItem.AmountInFunctionalCurrency
}
where _AcctgDocItem.AccountingDocumentType <> 'AA'
union
select
from R_MngJrnlEntrPrkdDocItemAmount as _ParkedAmount
{
key _ParkedAmount.SourceCompanyCode as CompanyCode,
key _ParkedAmount.SourceFiscalYear as FiscalYear,
key _ParkedAmount.SourceAccountingDocument as AccountingDocument,
_ParkedAmount.TransactionCurrency as CompanyCodeCurrency,
_ParkedAmount.AmountInCompanyCodeCurrency,
_ParkedAmount.TransactionCurrency,
_ParkedAmount.AmountInTransactionCurrency,
_ParkedAmount.TransactionCurrency as FunctionalCurrency,
abap.curr'0.00' as AmountInFunctionalCurrency
}
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