R_ManageJournalEntryAmount

DDL: R_MANAGEJOURNALENTRYAMOUNT Type: view_entity COMPOSITE

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)

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

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 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":""
}
}*/