P_MngJrnlEntryEntryViewAmount

DDL: P_MNGJRNLENTRYENTRYVIEWAMOUNT Type: view_entity COMPOSITE Package: ODATA_MANAGE_JOURNAL_ENTRY_V2

Journal Entry Entry View Amount

P_MngJrnlEntryEntryViewAmount is a Composite CDS View that provides data about "Journal Entry Entry View Amount" in SAP S/4HANA. It reads from 1 data source (R_ManageJournalEntryItem) and exposes 14 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package ODATA_MANAGE_JOURNAL_ENTRY_V2.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
R_ManageJournalEntryItem R_ManageJournalEntryItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
AccountingDocumentCategory AccountingDocumentCategory
AccountingDocumentType AccountingDocumentType
CompanyCodeCurrency CompanyCodeCurrency
CreditAmountInCoCodeCrcy
DebitAmountInCoCodeCrcy
TransactionCurrency TransactionCurrency
CreditAmountInTransCrcy
DebitAmountInTransCrcy
FunctionalCurrency FunctionalCurrency
CreditAmountInFunctionalCrcy
DebitAmountInFunctionalCrcy 
@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,
  private: true
}

define view entity P_MngJrnlEntryEntryViewAmount
  as select from R_ManageJournalEntryItem
  
{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  
  AccountingDocumentCategory,
  AccountingDocumentType,
  
  CompanyCodeCurrency,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sum(CreditAmountInCoCodeCrcy) as CreditAmountInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sum(DebitAmountInCoCodeCrcy) as DebitAmountInCoCodeCrcy,
    
  TransactionCurrency,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  sum(CreditAmountInTransCrcy) as CreditAmountInTransCrcy,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  sum(DebitAmountInTransCrcy) as DebitAmountInTransCrcy,
    
  FunctionalCurrency,
  @Semantics.amount.currencyCode: 'FunctionalCurrency'
  sum(CreditAmountInFunctionalCrcy) as CreditAmountInFunctionalCrcy,
  @Semantics.amount.currencyCode: 'FunctionalCurrency'
  sum(DebitAmountInFunctionalCrcy) as DebitAmountInFunctionalCrcy  
  
}
group by
  CompanyCode, 
  FiscalYear, 
  AccountingDocument,
  
  AccountingDocumentCategory,
  AccountingDocumentType,
  
  CompanyCodeCurrency, 
  TransactionCurrency,
  FunctionalCurrency

Learn More