P_StRpNotRptdItem

DDL: P_STRPNOTRPTDITEM SQL: PSRNTRPTDTAXITM Type: view CONSUMPTION

P_StRpNotRptdItem is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (C_StRpRptdJournalEntry) and exposes 17 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
C_StRpRptdJournalEntry C_StRpRptdJournalEntry left_outer

Parameters (2)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PSRNTRPTDTAXITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
AbapCatalog.preserveKey true view
AccessControl.blocking #BLOCKED_DATA_INCLUDED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItem CompanyCode
KEY AccountingDocument I_StRpTaxItem AccountingDocument
KEY FiscalYear I_StRpTaxItem FiscalYear
ReportingDate ReportingDate
PostingDate PostingDate
DocumentDate DocumentDate
TaxReportingDate TaxReportingDate
TaxReportingDocumentDate TaxReportingDocumentDate
CompanyCodeCountry CompanyCodeCountry
AccountingDocumentType I_StRpTaxItem AccountingDocumentType
TransactionTypeDetermination TransactionTypeDetermination
GLAccount GLAccount
BusinessPlace BusinessPlace
TaxJurisdiction TaxJurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction
TaxDataSource TaxDataSource
ReportingCountry ReportingCountry 
@AbapCatalog.sqlViewName: 'PSRNTRPTDTAXITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
//@EndUserText.label: 'Non Reported document for Statutory Reporting'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private: true
@AbapCatalog.preserveKey:true 
@AccessControl.blocking:#BLOCKED_DATA_INCLUDED
////////////////////////////////////////////////////////////////////

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

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


define view P_StRpNotRptdItem

  with parameters
    
    P_StatryRptgEntity  : srf_reporting_entity,
    P_StatryRptCategory : srf_rep_cat_id

  as select distinct from I_StRpTaxItem

    left outer join       C_StRpRptdJournalEntry (
                                                    P_StatryRptgEntity  : $parameters.P_StatryRptgEntity,
                                                    P_StatryRptCategory : $parameters.P_StatryRptCategory
                                                  ) as C_StRpRptdJournalEntry

    on  I_StRpTaxItem.CompanyCode        = C_StRpRptdJournalEntry.CompanyCode
    and I_StRpTaxItem.AccountingDocument = C_StRpRptdJournalEntry.AccountingDocument
    and I_StRpTaxItem.FiscalYear         = C_StRpRptdJournalEntry.FiscalYear

{

  key I_StRpTaxItem.CompanyCode,
  key I_StRpTaxItem.AccountingDocument,
  key I_StRpTaxItem.FiscalYear,
      ReportingDate,
      PostingDate,
      DocumentDate,
      TaxReportingDate,
      TaxReportingDocumentDate,
      CompanyCodeCountry,
      I_StRpTaxItem.AccountingDocumentType,
      TransactionTypeDetermination,
      GLAccount,
      BusinessPlace,
      TaxJurisdiction,
      LowestLevelTaxJurisdiction,
      TaxDataSource,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      ReportingCountry

}

where
  C_StRpRptdJournalEntry.StatryRptRunStatus is null 

  
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_STRPRPTDJOURNALENTRY",
"I_STRPTAXITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More