C_StRpNotRptdEUTaxClass

DDL: C_STRPNOTRPTDEUTAXCLASS SQL: CSRNTRPECSLITM Type: view CONSUMPTION

Non Reported document for ECSL

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

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
C_StRpRptdJournalEntry C_StRpRptdJournalEntry left_outer

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (10)

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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItmWithEUTaxClass CompanyCode
KEY AccountingDocument I_StRpTaxItmWithEUTaxClass AccountingDocument
KEY FiscalYear I_StRpTaxItmWithEUTaxClass FiscalYear
KEY TaxCode TaxCode
KEY TransactionTypeDetermination TransactionTypeDetermination
Creditor Creditor
Debtor Debtor
VATRegistration VATRegistration
TaxableEntity TaxableEntity
ReportingDate ReportingDate
PostingDate PostingDate
DocumentDate DocumentDate
TaxReportingDate TaxReportingDate
ReportingCountry ReportingCountry
IsEUTriangularDeal IsEUTriangularDeal
DelivOfGoodsDestCountry DelivOfGoodsDestCountry
DelivOfGoodsOriginCountry DelivOfGoodsOriginCountry
EUTaxClassification EUTaxClassification
TaxType TaxType
StatryRptgEntity
StatryRptCategory
StatryRptRunID 
@AbapCatalog.sqlViewName:'CSRNTRPECSLITM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Non Reported document for ECSL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED

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

// This view is intended to derive non-reported documents

// for Statutory Reporting //

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


define view C_StRpNotRptdEUTaxClass
  with parameters

    P_StatryRptgEntity  : srf_reporting_entity,
    P_StatryRptCategory : srf_rep_cat_id,
    P_StatryRptRunID    : srf_report_run_id

  as select distinct from I_StRpTaxItmWithEUTaxClass
      left outer join       C_StRpRptdJournalEntry  ( P_StatryRptgEntity  :$parameters.P_StatryRptgEntity ,
                                                      P_StatryRptCategory :$parameters.P_StatryRptCategory )

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

{

  key I_StRpTaxItmWithEUTaxClass.CompanyCode,
  key I_StRpTaxItmWithEUTaxClass.AccountingDocument,
  key I_StRpTaxItmWithEUTaxClass.FiscalYear,
  key TaxCode,
  key TransactionTypeDetermination,
      Creditor,
      Debtor,
      VATRegistration,
      TaxableEntity,
      ReportingDate,
      PostingDate,
      DocumentDate,
      TaxReportingDate,
      ReportingCountry,
      IsEUTriangularDeal,
      DelivOfGoodsDestCountry,
      DelivOfGoodsOriginCountry,
      EUTaxClassification,
      TaxType,
      $parameters.P_StatryRptgEntity     as StatryRptgEntity,
      $parameters.P_StatryRptCategory    as StatryRptCategory,
      $parameters.P_StatryRptRunID       as StatryRptRunID

} 
where
  C_StRpRptdJournalEntry.StatryRptRunStatus is null                         
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_STRPRPTDJOURNALENTRY",
"I_STRPTAXITMWITHEUTAXCLASS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More