C_FI_TaxReturnBoxQuery

DDL: C_FI_TAXRETURNBOXQUERY SQL: CFITAXRETURNBOXQ Type: view CONSUMPTION

Tax Items for Finnland

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

1 data source(s) 60 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 CFITAXRETURNBOXQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
EndUserText.label Tax Items for Finnland 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 (60)

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 TaxBoxStrucValidityStartDate 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
TaxCode TaxCode
Country Country
TaxItemGroupingVersion TaxItemGroupingVersion
TaxBoxStructureType TaxBoxStructureType
TaxBoxStrucValidityEndDate 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
TaxTypeName TaxTypeName
TaxIsNotDeductible TaxIsNotDeductible
TaxBoxStructure TaxBoxStructure
TaxBoxStructureName TaxBoxStructureName
TaxBoxName TaxBoxName
TaxBoxCondition TaxBoxCondition
_TaxTypeText _TaxTypeText 
@AbapCatalog.sqlViewName: 'CFITAXRETURNBOXQ'
@VDM.viewType: #CONSUMPTION
@Analytics.query:true
@EndUserText.label: 'Tax Items for Finnland'
@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_FI_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,  
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key UnifiedTaxBoxStructureType,
  key TaxGroup,
  key TaxItemGrpgDebitCreditCode,
  key TaxItemGrpgAcctgDocumentType,
  key TaxItemGrpgSupplierAcctGroup,
  key TaxItemGrpgSpecialGLCode,      
  key StatryRptgEntity,
  key StatryRptCategory,
  key StatryRptRunID,
  
      TaxCode,
      Country,
      TaxItemGroupingVersion,
      TaxBoxStructureType, 
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      TaxBoxStrucValidityEndDate, 
      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,
      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