C_RO_StRpDocumentJournalC

DDL: C_RO_STRPDOCUMENTJOURNALC Type: view_entity CONSUMPTION Package: GLO_FIN_IS_RO_DOCUMENTJOURNAL

Romania Document Journal - Cube

C_RO_StRpDocumentJournalC is a Consumption CDS View (Cube) that provides data about "Romania Document Journal - Cube" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 26 fields with key fields CompanyCode, AccountingDocument, FiscalYear, SourceLedger, Ledger. Part of development package GLO_FIN_IS_RO_DOCUMENTJOURNAL.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry JE from

Annotations (10)

NameValueLevelField
EndUserText.label Romania Document Journal - Cube view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.internalName #LOCAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY AccountingDocument I_JournalEntry AccountingDocument
KEY FiscalYear I_JournalEntry FiscalYear
KEY SourceLedger
KEY Ledger
KEY LedgerGLLineItem
KEY StatryRptCategory _ReportedItemsLog StatryRptCategory
KEY StatryRptgEntity _ReportedItemsLog StatryRptgEntity
KEY StatryRptRunID _ReportedItemsLog StatryRptRunID
AccountingDocumentType I_JournalEntry AccountingDocumentType
AccountingDocumentCategory I_JournalEntry AccountingDocumentCategory
FinancialAccountType
DebitCreditCode
PostingDate I_JournalEntry PostingDate
DocumentDate I_JournalEntry DocumentDate
DocumentReferenceID I_JournalEntry DocumentReferenceID
CompanyCodeCurrency
AmountInCompanyCodeCurrency
TransactionCurrency
AmountInTransactionCurrency
GLAccount
AlternativeGLAccount
AccountingDocumentHeaderText I_JournalEntry AccountingDocumentHeaderText
DocumentItemText
AccountingDocumentTypeName
BusinessArea 
@EndUserText.label: 'Romania Document Journal - Cube'
@VDM.viewType: #CONSUMPTION
@Analytics: { dataCategory: #CUBE }
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@Metadata.allowExtensions:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@Analytics.internalName:#LOCAL
define view entity C_RO_StRpDocumentJournalC as select from I_JournalEntry as JE
left outer to one join I_StRpJournalEntryLog   as _ReportedItemsLog           on  JE.CompanyCode         = _ReportedItemsLog.CompanyCode
                                                                              and JE.AccountingDocument  = _ReportedItemsLog.AccountingDocument
                                                                              and JE.FiscalYear          = _ReportedItemsLog.FiscalYear
{
key JE.CompanyCode,
key JE.AccountingDocument,
key JE.FiscalYear,
key JE._JournalEntryItem.SourceLedger,
key JE._JournalEntryItem.Ledger,
key JE._JournalEntryItem.LedgerGLLineItem,
key _ReportedItemsLog.StatryRptCategory,
key _ReportedItemsLog.StatryRptgEntity,
key _ReportedItemsLog.StatryRptRunID,
JE.AccountingDocumentType,
JE.AccountingDocumentCategory,
JE._JournalEntryItem.FinancialAccountType,
JE._JournalEntryItem.DebitCreditCode,
JE.PostingDate,
JE.DocumentDate,
JE.DocumentReferenceID,
JE._JournalEntryItem.CompanyCodeCurrency,
 @Aggregation.default: #SUM
 @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
JE._JournalEntryItem.AmountInCompanyCodeCurrency,
JE._JournalEntryItem.TransactionCurrency,
 @Aggregation.default: #SUM
 @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
JE._JournalEntryItem.AmountInTransactionCurrency,
JE._JournalEntryItem.GLAccount,
JE._JournalEntryItem.AlternativeGLAccount,
JE.AccountingDocumentHeaderText,
JE._JournalEntryItem.DocumentItemText,
JE._AccountingDocumentTypeText[1: Language = $session.system_language ].AccountingDocumentTypeName,
JE._JournalEntryItem.BusinessArea
}

Learn More