C_StRpRptdJournalEntry

DDL: C_STRPRPTDJOURNALENTRY SQL: CSRRPTDJRNLENTRY Type: view CONSUMPTION

Reported document for Statutory Reporting

C_StRpRptdJournalEntry is a Consumption CDS View that provides data about "Reported document for Statutory Reporting" in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 4 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpRepRun I_StRpRepRun left_outer

Parameters (2)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSRRPTDJRNLENTRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Reported document for Statutory Reporting view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpJournalEntryLog CompanyCode
KEY AccountingDocument I_StRpJournalEntryLog AccountingDocument
KEY FiscalYear I_StRpJournalEntryLog FiscalYear
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus 
@AbapCatalog.sqlViewName: 'CSRRPTDJRNLENTRY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Reported document for Statutory Reporting'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED

////////////////////////////////////////////////////////////////////

// This view is intended to derive all reported document for Statutory Reporting //

////////////////////////////////////////////////////////////////////


define view C_StRpRptdJournalEntry

  with parameters

    P_StatryRptgEntity  : srf_reporting_entity,
    P_StatryRptCategory : srf_rep_cat_id

  as select distinct from I_StRpJournalEntryLog

    left outer join       I_StRpRepRun on  I_StRpRepRun.StatryRptgEntity  = I_StRpJournalEntryLog.StatryRptgEntity
                                       and I_StRpRepRun.StatryRptCategory = I_StRpJournalEntryLog.StatryRptCategory
                                       and I_StRpRepRun.StatryRptRunID    = I_StRpJournalEntryLog.StatryRptRunID
{

  key I_StRpJournalEntryLog.CompanyCode,
  key I_StRpJournalEntryLog.AccountingDocument,
  key I_StRpJournalEntryLog.FiscalYear,
      I_StRpRepRun.StatryRptRunStatus


}
where
      I_StRpRepRun.StatryRptRunStatus         = 'SOK'
  and I_StRpJournalEntryLog.StatryRptCategory = $parameters.P_StatryRptCategory
  and I_StRpJournalEntryLog.StatryRptgEntity  = $parameters.P_StatryRptgEntity 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPJOURNALENTRYLOG",
"I_STRPREPRUN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More