R_MNGJRNLENTRYLEDGERVIEWAMOUNT

CDS View

Journal Entry

R_MNGJRNLENTRYLEDGERVIEWAMOUNT is a CDS View in S/4HANA. Journal Entry. It contains 8 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 8 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ManageJournalEntryAmount view_entity from COMPOSITE Journal Entry Amount

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
CompanyCodeCurrency CompanyCodeCurrency 1
FunctionalCurrency FunctionalCurrency 1
TransactionCurrency TransactionCurrency 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Journal Entry'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

define view entity R_MngJrnlEntryLedgerViewAmount
  as select from P_MngJrnlEntryLedgerViewAmount as _LineItem
{
  key _LineItem.CompanyCode,
  key _LineItem.FiscalYear,
  key _LineItem.AccountingDocument,
  
  _LineItem.CompanyCodeCurrency,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  max(_LineItem.AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency,
  
  _LineItem.TransactionCurrency,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  max(_LineItem.AmountInTransactionCurrency) as AmountInTransactionCurrency,
  
  _LineItem.FunctionalCurrency,
  @Semantics.amount.currencyCode: 'FunctionalCurrency'
  max(_LineItem.AmountInFunctionalCurrency) as AmountInFunctionalCurrency

}

group by
  _LineItem.CompanyCode, 
  _LineItem.FiscalYear, 
  _LineItem.AccountingDocument,
  
  _LineItem.CompanyCodeCurrency, 
  _LineItem.TransactionCurrency,
  _LineItem.FunctionalCurrency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MNGJRNLENTRYLEDGERVIEWAMOUNT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More