C_StRpNotRptdJournalEntry

DDL: C_STRPNOTRPTDJOURNALENTRY SQL: CNOTRPTDDOCS Type: view CONSUMPTION Package: GLO_FIN_IS_GEN

Not Reported Journal Entries

C_StRpNotRptdJournalEntry is a Consumption CDS View that provides data about "Not Reported Journal Entries" in SAP S/4HANA. It reads from 2 data sources (C_StRpRptdJournalEntry, I_JournalEntry) and exposes 44 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_GEN.

2 data source(s) 44 fields

Data Sources (2)

SourceAliasJoin Type
C_StRpRptdJournalEntry C_StRpRptdJournalEntry left_outer
I_JournalEntry I_JournalEntry from

Parameters (2)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CNOTRPTDDOCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Not Reported Journal Entries view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
KEY AccountingDocument I_JournalEntry AccountingDocument
AccountingDocumentType AccountingDocumentType
TaxReportingDate TaxReportingDate
DocumentDate DocumentDate
PostingDate PostingDate
FiscalPeriod FiscalPeriod
AccountingDocumentCreationDate AccountingDocumentCreationDate
TransactionCode TransactionCode
IntercompanyTransaction IntercompanyTransaction
TransactionCurrency TransactionCurrency
AccountingDocumentCategory AccountingDocumentCategory
BusinessTransactionType BusinessTransactionType
ReferenceDocumentType ReferenceDocumentType
OriginalReferenceDocument OriginalReferenceDocument
FinancialManagementArea FinancialManagementArea
CompanyCodeCurrency CompanyCodeCurrency
AdditionalCurrency1 AdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
ReversalIsPlanned ReversalIsPlanned
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount
SourceCompanyCode SourceCompanyCode
Branch Branch
IsDiscountDocument IsDiscountDocument
InvoiceReceiptDate InvoiceReceiptDate
AccountingDocumentClass AccountingDocumentClass
ExchangeRateType ExchangeRateType
SenderCompanyCode SenderCompanyCode
SenderAccountingDocument SenderAccountingDocument
SenderFiscalYear SenderFiscalYear
IsReversal IsReversal
IsReversed IsReversed
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccountingDocumentType _AccountingDocumentType
_FiscalPeriod _FiscalPeriod
_TransactionCurrency _TransactionCurrency
_AccountingDocumentCategory _AccountingDocumentCategory
_BusinessTransactionType _BusinessTransactionType
_ReferenceDocumentType _ReferenceDocumentType
_FinancialManagementArea _FinancialManagementArea
_CompanyCodeCurrency _CompanyCodeCurrency 
@AbapCatalog.sqlViewName: 'CNOTRPTDDOCS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Not Reported Journal Entries'

define view C_StRpNotRptdJournalEntry
  with parameters
    P_StatryRptgEntity:  srf_reporting_entity,
    P_StatryRptCategory: srf_rep_cat_id
  as select from    I_JournalEntry

    left outer join C_StRpRptdJournalEntry  ( P_StatryRptgEntity  :$parameters.P_StatryRptgEntity ,
                                              P_StatryRptCategory :$parameters.P_StatryRptCategory ) 
      on  I_JournalEntry.CompanyCode        = C_StRpRptdJournalEntry.CompanyCode
      and I_JournalEntry.AccountingDocument = C_StRpRptdJournalEntry.AccountingDocument
      and I_JournalEntry.FiscalYear         = C_StRpRptdJournalEntry.FiscalYear
{
    key I_JournalEntry.CompanyCode,
    key I_JournalEntry.FiscalYear,
    key I_JournalEntry.AccountingDocument,
    case
      when TaxReportingDate = '00000000' then PostingDate
      else TaxReportingDate
    end as ReportingDate,
    AccountingDocumentType,
    TaxReportingDate,
    DocumentDate,
    PostingDate,
    FiscalPeriod,
    AccountingDocumentCreationDate,
    TransactionCode,
    IntercompanyTransaction,
    TransactionCurrency,
    AccountingDocumentCategory,
    BusinessTransactionType,
    ReferenceDocumentType,
    OriginalReferenceDocument,
    FinancialManagementArea,
    CompanyCodeCurrency,
    AdditionalCurrency1,
    AdditionalCurrency2,
    ReversalIsPlanned,
    TaxIsCalculatedAutomatically,
    TaxBaseAmountIsNetAmount,
    SourceCompanyCode,
    Branch,
    IsDiscountDocument,
    InvoiceReceiptDate,
    AccountingDocumentClass,
    ExchangeRateType,
    SenderCompanyCode,
    SenderAccountingDocument,
    SenderFiscalYear,
    IsReversal,
    IsReversed,
    _CompanyCode,
    _FiscalYear,
    _AccountingDocumentType,
    _FiscalPeriod,
    _TransactionCurrency,
    _AccountingDocumentCategory,
    _BusinessTransactionType,
    _ReferenceDocumentType,
    _FinancialManagementArea,
    _CompanyCodeCurrency
}
where
  C_StRpRptdJournalEntry.StatryRptRunStatus is null

Learn More