P_SFINRecurringToJournalEntry

DDL: P_SFINRECURRINGTOJOURNALENTRY Type: view_entity BASIC Package: ODATA_GL_DSP_DOC_FLW

SFIN Recurring Journal Entry

P_SFINRecurringToJournalEntry is a Basic CDS View that provides data about "SFIN Recurring Journal Entry" in SAP S/4HANA. It reads from 2 data sources (P_SFINRecurringJournalEntry, I_JournalEntry) and exposes 6 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package ODATA_GL_DSP_DOC_FLW.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
P_SFINRecurringJournalEntry _RecurringJE inner
I_JournalEntry I_JournalEntry from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SFIN Recurring Journal Entry view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
KEY AccountingDocument I_JournalEntry AccountingDocument
RecurringAccountingDocument I_JournalEntry RecurringAccountingDocument
RecrrgJournalEntryCompanyCode I_JournalEntry RecrrgJournalEntryCompanyCode
RecrrgJournalEntryFiscalYear I_JournalEntry RecrrgJournalEntryFiscalYear 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SFIN Recurring Journal Entry'
@ObjectModel:{
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #M,
  usageType.dataClass: #TRANSACTIONAL,
  supportedCapabilities:[
    #CDS_MODELING_DATA_SOURCE,
    #VALUE_HELP_PROVIDER ]}
@VDM.private: true
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
define view entity P_SFINRecurringToJournalEntry
  as select from I_JournalEntry
    inner join   P_SFINRecurringJournalEntry as _RecurringJE on  I_JournalEntry.RecurringAccountingDocument = _RecurringJE.RecurringAccountingDocument
                                                             and I_JournalEntry.RecrrgJournalEntryCompanyCode = _RecurringJE.RecrrgAcctgDocCompanyCode
                                                             and I_JournalEntry.RecrrgJournalEntryFiscalYear = _RecurringJE.RecrrgJournalEntryFiscalYear
{
  key I_JournalEntry.CompanyCode,
  key I_JournalEntry.FiscalYear,
  key I_JournalEntry.AccountingDocument,
      I_JournalEntry.RecurringAccountingDocument,
      I_JournalEntry.RecrrgJournalEntryCompanyCode,
      I_JournalEntry.RecrrgJournalEntryFiscalYear
}
where
  I_JournalEntry.RecurringAccountingDocument is not initial

Learn More