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.
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 |
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_MNGJRNLENTRPRKDDOCITEMAMOUNT",
"R_MNGJRNLENTRYENTRYVIEWAMOUNT",
"R_MNGJRNLENTRYLEDGERVIEWAMOUNT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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