R_ManageJournalEntryAmount

DDL: R_MANAGEJOURNALENTRYAMOUNT Type: view_entity COMPOSITE Package: ODATA_MANAGE_JOURNAL_ENTRY_V2

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 2 Fiori applications: Manage Journal Entries - New Version, Display Journal Entries. Part of development package ODATA_MANAGE_JOURNAL_ENTRY_V2.

Data Sources (3)

SourceAliasJoin Type
R_MngJrnlEntryEntryViewAmount _AcctgDocItem union
R_MngJrnlEntryLedgerViewAmount _JournalEntryItemAggr from
R_MngJrnlEntrPrkdDocItemAmount _ParkedAmount union

Annotations (14)

NameValueLevelField
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)

ServiceBindingVersionContractRelease
UI_JOURNALENTRY_MANAGE UI_JOURNALENTRY_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
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 (25)

KeyFieldSource TableSource FieldDescription
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 CompanyCodeCurrency
AmountInCompanyCodeCurrency R_MngJrnlEntrPrkdDocItemAmount AmountInCompanyCodeCurrency
TransactionCurrency R_MngJrnlEntrPrkdDocItemAmount TransactionCurrency
AmountInTransactionCurrency R_MngJrnlEntrPrkdDocItemAmount AmountInTransactionCurrency
FunctionalCurrency
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.CompanyCodeCurrency,
  _ParkedAmount.AmountInCompanyCodeCurrency,
  _ParkedAmount.TransactionCurrency,
  _ParkedAmount.AmountInTransactionCurrency,
  cast( '' as fins_currfc) as FunctionalCurrency,
  abap.curr'0.00' as AmountInFunctionalCurrency
  
  }