C_PE_StRpNotRptdJournalEntry

DDL: C_PE_STRPNOTRPTDJOURNALENTRY Type: view_entity CONSUMPTION Package: GLO_FIN_IS_PE

Not Reported Journal Entries for Statutory Reporting

C_PE_StRpNotRptdJournalEntry is a Consumption CDS View that provides data about "Not Reported Journal Entries for Statutory Reporting" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 23 fields with key fields CompanyCode, FiscalYear, AccountingDocument, BusinessTransactionType, FiscalYear. Part of development package GLO_FIN_IS_PE.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry JournalEntry from

Parameters (2)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Not Reported Journal Entries for Statutory Reporting view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
KEY AccountingDocument I_JournalEntry AccountingDocument
KEY BusinessTransactionType I_JournalEntry BusinessTransactionType
ReferenceDocumentType I_JournalEntry ReferenceDocumentType
IsReversal I_JournalEntry IsReversal
IsReversed I_JournalEntry IsReversed
PostingDate I_JournalEntry PostingDate
DocumentDate I_JournalEntry DocumentDate
AccountingDocumentType I_JournalEntry AccountingDocumentType
P_StatryRptgEntity
CompanyCode
KEY FiscalYear GLAccountLineItem FiscalYear
KEY AccountingDocument GLAccountLineItem AccountingDocument
KEY ReportingDate GLAccountLineItem PostingDate
KEY BusinessTransactionType GLAccountLineItem BusinessTransactionType
ReferenceDocumentType GLAccountLineItem ReferenceDocumentType
IsReversal GLAccountLineItem IsReversal
IsReversed GLAccountLineItem IsReversed
PostingDate GLAccountLineItem PostingDate
DocumentDate GLAccountLineItem DocumentDate
AccountingDocumentType GLAccountLineItem AccountingDocumentType
AccountingDocumentCategory GLAccountLineItem AccountingDocumentCategory 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #TRANSACTIONAL
}
@EndUserText.label: 'Not Reported Journal Entries for Statutory Reporting'
define view entity C_PE_StRpNotRptdJournalEntry
  with parameters
    P_StatryRptgEntity  : srf_reporting_entity,
    P_StatryRptCategory : srf_rep_cat_id
  as select from           I_JournalEntry                                                                    as JournalEntry

    left outer to one join P_PE_StRpRptdJournalEntry( P_StatryRptgEntity  :$parameters.P_StatryRptgEntity ,
                                                      P_StatryRptCategory :$parameters.P_StatryRptCategory ) as StRpRptdJournalEntry on  JournalEntry.CompanyCode        = StRpRptdJournalEntry.CompanyCode
                                                                                                                                     and JournalEntry.AccountingDocument = StRpRptdJournalEntry.AccountingDocument
                                                                                                                                     and JournalEntry.FiscalYear         = StRpRptdJournalEntry.FiscalYear
{
  key JournalEntry.CompanyCode,
  key JournalEntry.FiscalYear,
  key JournalEntry.AccountingDocument,
  key cast( case
              when JournalEntry.TaxReportingDate = '00000000' then JournalEntry.PostingDate
              else JournalEntry.TaxReportingDate
            end as glo_reporting_date preserving type ) as ReportingDate,
  key JournalEntry.BusinessTransactionType,
      JournalEntry.ReferenceDocumentType,
      JournalEntry.IsReversal,
      JournalEntry.IsReversed,
      JournalEntry.PostingDate,
      JournalEntry.DocumentDate,
      JournalEntry.AccountingDocumentType,
      JournalEntry.AccountingDocumentCategory
}
where
  StRpRptdJournalEntry.StatryRptRunStatus is null

union all

select distinct from     I_GLAccountLineItemRawData                                                        as GLAccountLineItem

  left outer to one join P_PE_StRpRptdJournalEntry( P_StatryRptgEntity  :$parameters.P_StatryRptgEntity ,
                                                    P_StatryRptCategory :$parameters.P_StatryRptCategory ) as StRpRptdJournalEntry on  GLAccountLineItem.CompanyCode        = StRpRptdJournalEntry.CompanyCode
                                                                                                                                   and GLAccountLineItem.AccountingDocument = StRpRptdJournalEntry.AccountingDocument
                                                                                                                                   and GLAccountLineItem.FiscalYear         = StRpRptdJournalEntry.FiscalYear
{
  key GLAccountLineItem.CompanyCode,
  key GLAccountLineItem.FiscalYear,
  key GLAccountLineItem.AccountingDocument,
  key GLAccountLineItem.PostingDate as ReportingDate,
  key GLAccountLineItem.BusinessTransactionType,
      GLAccountLineItem.ReferenceDocumentType,
      GLAccountLineItem.IsReversal,
      GLAccountLineItem.IsReversed,
      GLAccountLineItem.PostingDate,
      GLAccountLineItem.DocumentDate,
      GLAccountLineItem.AccountingDocumentType,
      GLAccountLineItem.AccountingDocumentCategory
}
where
      GLAccountLineItem.AccountingDocumentCategory = 'C' //Balance carryforward does not create entries in BKPF

  and StRpRptdJournalEntry.StatryRptRunStatus      is null

Learn More