C_SE_TaxReturnBoxQuery

DDL: C_SE_TAXRETURNBOXQUERY SQL: CSETAXRETURNBOXQ Type: view CONSUMPTION

Query Tax Items for Sweden

C_SE_TaxReturnBoxQuery is a Consumption CDS View that provides data about "Query Tax Items for Sweden" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxReturnBoxCube) and exposes 61 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination.

1 data source(s) 61 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube from

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSETAXRETURNBOXQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
EndUserText.label Query Tax Items for Sweden view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY TaxItem TaxItem
KEY TransactionTypeDetermination TransactionTypeDetermination
KEY DebitCreditCode DebitCreditCode
KEY AccountingDocumentType AccountingDocumentType
KEY SupplierAccountGroup SupplierAccountGroup
KEY TaxBox TaxBox
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY ValidFrom TaxBoxStrucValidityStartDate
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType
KEY TaxGroup TaxGroup
KEY TaxItemGrpgDebitCreditCode TaxItemGrpgDebitCreditCode
KEY TaxItemGrpgAcctgDocumentType TaxItemGrpgAcctgDocumentType
KEY TaxItemGrpgSupplierAcctGroup TaxItemGrpgSupplierAcctGroup
KEY TaxItemGrpgSpecialGLCode TaxItemGrpgSpecialGLCode
KEY StatryRptgEntity StatryRptgEntity
KEY StatryRptCategory StatryRptCategory
KEY StatryRptRunID StatryRptRunID
Country Country
TaxCode TaxCode
TaxItemGroupingVersion TaxItemGroupingVersion
TaxBoxStructureType TaxBoxStructureType
ValidTo TaxBoxStrucValidityEndDate
TaxCalculationProcedure TaxCalculationProcedure
TaxRate TaxRate
TaxRateValidityStartDate TaxRateValidityStartDate
GLAccount GLAccount
TaxItemGroup TaxItemGroup
ReferenceDocumentType ReferenceDocumentType
PostingDate PostingDate
DocumentDate DocumentDate
TaxReportingDate TaxReportingDate
ReportingDate ReportingDate
FiscalPeriod FiscalPeriod
CompanyCodeCountry CompanyCodeCountry
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry
CompanyCodeCurrency CompanyCodeCurrency
DocumentCurrency DocumentCurrency
ReportingCurrency ReportingCurrency
AmountInReportingCurrency AmountInReportingCurrency
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy
TaxAmountInRptgCrcy TaxAmountInRptgCrcy
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy
TaxAmount TaxAmount
TaxType TaxType
TargetTaxCode TargetTaxCode
CAReconciliationKey CAReconciliationKey
StatryRptRun StatryRptRun
TaxTypeName TaxTypeName
TaxIsNotDeductible TaxIsNotDeductible
TaxBoxStructure TaxBoxStructure
TaxBoxStructureName TaxBoxStructureName
TaxBoxName TaxBoxName
TaxBoxCondition TaxBoxCondition
_TaxTypeText _TaxTypeText 
@AbapCatalog.sqlViewName: 'CSETAXRETURNBOXQ'
@VDM.viewType: #CONSUMPTION
@Analytics.query:true
@EndUserText.label: 'Query Tax Items for Sweden'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

define view C_SE_TaxReturnBoxQuery 
     with parameters
    P_StatryRptgEntity      : srf_reporting_entity,
    P_StatryRptCategory     : srf_rep_cat_id,
    P_StatryRptRunID        : srf_report_run_id,
    P_ReportingCountry      : land1


as select from I_StRpTaxReturnBoxCube(
                                                                                  P_TaxIsDeferredRelevant: 'N',    
                                                                                  P_TaxIsMossRelevant   :  'N',     
                                                                                  P_StatryRptgEntity     : $parameters.P_StatryRptgEntity , 
                                                                                  P_StatryRptCategory    : $parameters.P_StatryRptCategory,
                                                                                  P_StatryRptRunID       : $parameters.P_StatryRptRunID,
                                                                                  P_ReportingCountry     : $parameters.P_ReportingCountry,
                                                                                  P_TaxBoxConfiguration  : '1'                                               
                                                                                  )
                                                               
 {
  
     @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key CompanyCode,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
  key AccountingDocument,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key FiscalYear,
  key TaxItem, 
  key TransactionTypeDetermination,  
  key DebitCreditCode,
  key AccountingDocumentType, 
  key SupplierAccountGroup,     
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TaxBox, 
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TaxDeclnAmountType,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
  key TaxBoxStrucValidityStartDate as ValidFrom,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key UnifiedTaxBoxStructureType,  
  key TaxGroup,    
  key TaxItemGrpgDebitCreditCode,
  key TaxItemGrpgAcctgDocumentType,
  key TaxItemGrpgSupplierAcctGroup,
  key TaxItemGrpgSpecialGLCode,    
  key StatryRptgEntity,
  key StatryRptCategory,
  key StatryRptRunID,
      
      Country, 
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      TaxCode,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      TaxItemGroupingVersion,
      TaxBoxStructureType, 
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      TaxBoxStrucValidityEndDate as ValidTo,  
      TaxCalculationProcedure,
      @AnalyticsDetails.query.hidden: true  
      TaxRate,     
      TaxRateValidityStartDate,      
      GLAccount,
      TaxItemGroup,
      ReferenceDocumentType,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      PostingDate,
      DocumentDate,
      TaxReportingDate,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      ReportingDate,
      FiscalPeriod,
      CompanyCodeCountry,
      @Consumption.filter : { selectionType: #RANGE, multipleSelections : true}
      ReportingCountry,
      TaxReturnCountry,
      CompanyCodeCurrency, 
      DocumentCurrency,
      ReportingCurrency,
      AmountInReportingCurrency,
      TaxBaseAmountInRptgCrcy,      
      TaxAmountInRptgCrcy,
      @AnalyticsDetails.query.hidden: true       
      NonDeductibleInputTaxAmount, 
      @AnalyticsDetails.query.hidden: true                  
      TaxBaseAmountInCoCodeCrcy,
      @AnalyticsDetails.query.hidden: true  
      TaxAmountInCoCodeCrcy,
      @AnalyticsDetails.query.hidden: true  
      TaxBaseAmountInTransCrcy,
      @AnalyticsDetails.query.hidden: true  
      TaxAmount,
      @ObjectModel.text.association: '_TaxTypeText'
      @AnalyticsDetails.query.display:#TEXT
      TaxType,
      TargetTaxCode,
      CAReconciliationKey,
      StatryRptRun,
      TaxTypeName,
      TaxIsNotDeductible,
      TaxBoxStructure,
      TaxBoxStructureName,
      TaxBoxName,
      TaxBoxCondition,
    
      _TaxTypeText  
      
}


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

Learn More