R_MNGJRNLENTRYENTRYVIEWAMOUNT

CDS View

Journal Entry

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

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ManageJournalEntryAmount view_entity union COMPOSITE Journal Entry Amount

Fields (7)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 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_MngJrnlEntryEntryViewAmount
  as select from R_ManageJournalEntryItem
  
{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  
  AccountingDocumentCategory,
  AccountingDocumentType,
  
  CompanyCodeCurrency,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sum(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency,
  
  TransactionCurrency,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  sum(AmountInTransactionCurrency) as AmountInTransactionCurrency,
  
  FunctionalCurrency,
  @Semantics.amount.currencyCode: 'FunctionalCurrency'
  sum(AmountInFunctionalCurrency) as AmountInFunctionalCurrency

}
where
// _JournalEntry._Ledger.IsLeadingLedger = 'X'

// and 

 DebitCreditCode = 'S' // shkzg

// and

// AccountingDocumentCategory <> 'L'

group by
  CompanyCode, 
  FiscalYear, 
  AccountingDocument,
  
  AccountingDocumentCategory,
  AccountingDocumentType,
  
  CompanyCodeCurrency, 
  TransactionCurrency,
  FunctionalCurrency

Learn More