P_PE_JournalEntryFSStructure

DDL: P_PE_JOURNALENTRYFSSTRUCTURE SQL: PPEJRNLEFSS Type: view CONSUMPTION Package: GLO_FIN_IS_PE

Peru Journal Entry with Financial Statement Structure

P_PE_JournalEntryFSStructure is a Consumption CDS View that provides data about "Peru Journal Entry with Financial Statement Structure" in SAP S/4HANA. It reads from 2 data sources (I_FinancialStatementStructure, P_PE_JournalEntryFSStructure2) and exposes 6 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger, FinancialStatementHierarchy. Part of development package GLO_FIN_IS_PE.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_FinancialStatementStructure FinancialStatement inner
P_PE_JournalEntryFSStructure2 P_PE_JournalEntryFSStructure2 from

Parameters (4)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FiscalYear fis_gjahr_no_conv
P_Ledger rldnr
P_FinancialStatementHierarchy hryid

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPEJRNLEFSS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntry CompanyCode
KEY FiscalYear JournalEntry FiscalYear
KEY AccountingDocument JournalEntry AccountingDocument
KEY Ledger JournalEntry Ledger
KEY FinancialStatementHierarchy I_FinancialStatementStructure FinancialStatementHierarchy
HierarchyParentNodeVal 
@AbapCatalog.sqlViewName: 'PPEJRNLEFSS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED

define view P_PE_JournalEntryFSStructure
  with parameters
    P_CompanyCode                 : fis_bukrs,
    P_FiscalYear                  : fis_gjahr_no_conv,
    P_Ledger                      : rldnr,
    P_FinancialStatementHierarchy : hryid

  as select from P_PE_JournalEntryFSStructure2( P_CompanyCode: $parameters.P_CompanyCode,
                                                P_FiscalYear: $parameters.P_FiscalYear,
                                                P_Ledger: $parameters.P_Ledger,
                                                P_FinancialStatementHierarchy: $parameters.P_FinancialStatementHierarchy ) as JournalEntry

    inner join   I_FinancialStatementStructure                                                                             as FinancialStatement on  FinancialStatement.HierarchyNodeVal            = JournalEntry.GLAccount
                                                                                                                                                 and FinancialStatement.FinancialStatementHierarchy = JournalEntry.FinancialStatementHierarchy
{
  key JournalEntry.CompanyCode,
  key JournalEntry.FiscalYear,
  key JournalEntry.AccountingDocument,
  key JournalEntry.Ledger,
  key FinancialStatement.FinancialStatementHierarchy,

      min( FinancialStatement.HierarchyParentNodeVal ) as HierarchyParentNodeVal

}
where
      FinancialStatement.FinancialStatementNodeType = 'G'
  and JournalEntry.CompanyCode                      = $parameters.P_CompanyCode
  and JournalEntry.FiscalYear                       = $parameters.P_FiscalYear
  and JournalEntry.Ledger                           = $parameters.P_Ledger

group by
  JournalEntry.CompanyCode,
  JournalEntry.FiscalYear,
  JournalEntry.AccountingDocument,
  JournalEntry.Ledger,
  FinancialStatement.FinancialStatementHierarchy

Learn More