C_STRPRPTDJOURNALENTRY

CDS View

Reported document for Statutory Reporting

C_STRPRPTDJOURNALENTRY is a CDS View in S/4HANA. Reported document for Statutory Reporting. 17 CDS views read from this table.

Used by 17 CDS view(s)

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_CZ_StRpTaxItemReturn view left_outer CONSUMPTION EVAT Tax Line Item CZ
C_GB_StRpNotRptdParkedDocTxItm view left_outer CONSUMPTION Not reported parked documents
C_GB_StRpNotRptdTaxItem view left_outer CONSUMPTION GB: Non Reported document for Statutory Reporting
C_IE_StRpNotRptdTaxItem view left_outer CONSUMPTION IE: Non Reported document for SRF
C_JP_VATReturnDetailCube view left_outer CONSUMPTION Japan VAT Return Detail Cube
C_RO_StRpNotRptdDfrrdTaxItem view left_outer CONSUMPTION RO: Non Reported Deffered tax documents
C_RO_StRpNotRptdTaxItem view left_outer CONSUMPTION RO: Non Reported document for SRF
C_StRpNotRptdEUTaxClass view left_outer CONSUMPTION Non Reported document for ECSL
C_StRpNotRptdJournalEntry view left_outer CONSUMPTION Not Reported Journal Entries
C_StRpNotRptdTaxItem view left_outer CONSUMPTION Non Reported document for Statutory Reporting
P_GB_StRpNotRepTaxBoxItem view left_outer CONSUMPTION Not reported tax box items
P_JP_CentralBkPaytWithItems view left_outer CONSUMPTION View for Japan Central Bank Payment Detail Items
P_NL_STRPNOTRPTDTAXITEM view left_outer CONSUMPTION Non reported documents for NL VAT reporting
P_PH_StRpNotRptdTaxItem view left_outer CONSUMPTION
P_StRpAllTaxItem view left_outer CONSUMPTION Private view to select all the tax items
P_StRpNotRptdItem view left_outer CONSUMPTION
P_StRpNotRptdTaxItem view left_outer CONSUMPTION 
@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