C_StRpTaxReturnBoxQuery

DDL: C_STRPTAXRETURNBOXQUERY SQL: CSRTAXRETURNBOXQ Type: view CONSUMPTION

Analytical Query Tax Return info with TaxBox configuration

C_StRpTaxReturnBoxQuery is a Consumption CDS View that provides data about "Analytical Query Tax Return info with TaxBox configuration" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxReturnBoxCube) and exposes 113 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

1 data source(s) 113 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube from

Parameters (7)

NameTypeDefault
P_TaxIsDeferredRelevant figen_deferred_check
P_TaxIsMossRelevant figen_moss_check
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_TaxBoxConfiguration figen_tdt_taxbox_config

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSRTAXRETURNBOXQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Analytical Query Tax Return info with TaxBox configuration view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.query true view
AccessControl.blocking #BLOCKED_DATA_INCLUDED view

Fields (113)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY TaxItem TaxItem
KEY TaxCode TaxCode
KEY TransactionTypeDetermination TransactionTypeDetermination
KEY TaxBox TaxBox
KEY TaxGroup TaxGroup
KEY Country Country
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType
KEY StatryRptgEntity StatryRptgEntity
KEY StatryRptCategory StatryRptCategory
KEY StatryRptRunID StatryRptRunID
StatryRptRun StatryRptRun
ValidFrom ValidFrom
TaxBoxStructureType TaxBoxStructureType
TaxItemGroupingVersion TaxItemGroupingVersion
ValidTo ValidTo
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate
DebitCreditCode DebitCreditCode
TaxCalculationProcedure TaxCalculationProcedure
TaxRate TaxRate
IPITaxRate IPITaxRate
TaxCodeRatePointer TaxCodeRatePointer
TaxRateValidityStartDate TaxRateValidityStartDate
Customer Customer
GLAccount GLAccount
TaxItemGroup TaxItemGroup
BusinessPlace BusinessPlace
TaxJurisdiction TaxJurisdiction
LowestLevelTaxJurisdiction
AccountingDocumentType AccountingDocumentType
ReferenceDocumentType ReferenceDocumentType
AlternativeReferenceDocument AlternativeReferenceDocument
ReverseDocument ReverseDocument
ReverseDocumentFiscalYear ReverseDocumentFiscalYear
ConditionRecord ConditionRecord
RoundingDecimalPlaces
DocumentReferenceID DocumentReferenceID
Ledger Ledger
LedgerGroup LedgerGroup
PostingDate PostingDate
DocumentDate DocumentDate
TaxReportingDate TaxReportingDate
ReportingDate ReportingDate
TaxReportingDocumentDate TaxReportingDocumentDate
FiscalPeriod FiscalPeriod
ExchangeRate ExchangeRate
IsReversal IsReversal
IsReversed IsReversed
AccountingDocumentHeaderText AccountingDocumentHeaderText
CompanyCodeCountry CompanyCodeCountry
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry
TaxCountry TaxCountry
CompanyCodeCurrency CompanyCodeCurrency
CountryCurrency CountryCurrency
DocumentCurrency DocumentCurrency
ReportingCurrency ReportingCurrency
AdditionalCurrency1 AdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy
AmountInReportingCurrency AmountInReportingCurrency
TaxAmountInRptgCrcy TaxAmountInRptgCrcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy
TaxAmount TaxAmount
TotalGrossAmountInCoCodeCrcy TotalGrossAmountInCoCodeCrcy
TotalGrossAmountInTransCrcy TotalGrossAmountInTransCrcy
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy
TaxAmountInCountryCrcy TaxAmountInCountryCrcy
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount
TaxType TaxType
TargetTaxCode TargetTaxCode
BPTaxNumber BPTaxNumber
ReportingVATRegistration ReportingVATRegistration
TaxNumber1 TaxNumber1
TaxNumber2 TaxNumber2
TaxNumber3 TaxNumber3
ActiveTaxType ActiveTaxType
ShippingPointCountry ShippingPointCountry
CalculatedTxAmtInCoCodeCrcy CalculatedTxAmtInCoCodeCrcy
CalculatedTaxAmountInTransCrcy CalculatedTaxAmountInTransCrcy
CalculatedTxBaseAmtInTransCrcy CalculatedTxBaseAmtInTransCrcy
AmountInTransactionCurrency AmountInTransactionCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
CalcdTxBaseAmtInCoCodeCrcy CalcdTxBaseAmtInCoCodeCrcy
TaxTypeName TaxTypeName
DcblVATIncrdCostInRptgCrcy DcblVATIncrdCostInRptgCrcy
BalanceAmountInTransacCurrency BalanceAmountInTransacCurrency
CAReconciliationKey CAReconciliationKey
BusinessPartner BusinessPartner
BusinessPartnerName BusinessPartnerName
BusinessPartnerCountry BusinessPartnerCountry
CustomerSupplierAddress CustomerSupplierAddress
TaxIsNotDeductible TaxIsNotDeductible
ConditionType ConditionType
TaxBoxStructure TaxBoxStructure
TaxBoxStructureName TaxBoxStructureName
TaxBoxName TaxBoxName
TaxBoxCondition TaxBoxCondition
SupplierAccountGroup SupplierAccountGroup
TaxBoxAggregationOperation TaxBoxAggregationOperation
TaxGroupOperation TaxGroupOperation
TaxCntryOrCompanyCodeCntry TaxCntryOrCompanyCodeCntry
_TaxTypeText _TaxTypeText 
@AbapCatalog.sqlViewName: 'CSRTAXRETURNBOXQ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Analytical Query Tax Return info with TaxBox configuration'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.query: true
@AccessControl.blocking:#BLOCKED_DATA_INCLUDED

define view C_StRpTaxReturnBoxQuery

  with parameters
  
    P_TaxIsDeferredRelevant : figen_deferred_check,
    P_TaxIsMossRelevant     : figen_moss_check,
    P_StatryRptgEntity      : srf_reporting_entity,
    P_StatryRptCategory     : srf_rep_cat_id,
    P_StatryRptRunID        : srf_report_run_id,
    P_ReportingCountry      : land1,
    P_TaxBoxConfiguration   : figen_tdt_taxbox_config
    
  as select from I_StRpTaxReturnBoxCube ( 
                                          P_TaxIsDeferredRelevant : $parameters.P_TaxIsDeferredRelevant, 
                                          P_TaxIsMossRelevant     : $parameters.P_TaxIsMossRelevant,
                                          P_StatryRptgEntity      : $parameters.P_StatryRptgEntity, 
                                          P_StatryRptCategory     : $parameters.P_StatryRptCategory,
                                          P_StatryRptRunID        : $parameters.P_StatryRptRunID,
                                          P_ReportingCountry      : $parameters.P_ReportingCountry,
                                          P_TaxBoxConfiguration   : $parameters.P_TaxBoxConfiguration
                                        )

{
      @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,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TaxCode,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TransactionTypeDetermination,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TaxBox,
  key TaxGroup,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key Country,  
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key TaxDeclnAmountType,
      
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
  key TaxBoxStrucValidityStartDate,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key UnifiedTaxBoxStructureType,
  
  key StatryRptgEntity,
  key StatryRptCategory,
  key StatryRptRunID,
      StatryRptRun,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'TaxBoxStrucValidityStartDate'
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      ValidFrom,
  
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      TaxBoxStructureType,
      
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      TaxItemGroupingVersion,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'TaxBoxStrucValidityEndDate'
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      ValidTo,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      TaxBoxStrucValidityEndDate,  
      DebitCreditCode,

      TaxCalculationProcedure,
      
      @DefaultAggregation:#MIN
      TaxRate,

      IPITaxRate,
      
      @DefaultAggregation:#MIN
      TaxCodeRatePointer,

      /*@DefaultAggregation:#MIN
      @Analytics.hidden: true
      AdditionalTax1Rate,*/
      
      TaxRateValidityStartDate,
      
      /*@DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      ConditionAmount,*/

      Customer,

      GLAccount,
      TaxItemGroup,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      BusinessPlace,
      TaxJurisdiction,
      --LowestLevelTaxJurisdiction,
      AccountingDocumentType,
      ReferenceDocumentType,
      AlternativeReferenceDocument,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      ConditionRecord,
      --RoundingDecimalPlaces,

      DocumentReferenceID,
      Ledger,
      LedgerGroup,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      PostingDate,
      DocumentDate,
      TaxReportingDate,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      ReportingDate,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      TaxReportingDocumentDate,
      FiscalPeriod,
      @DefaultAggregation:#MIN
      ExchangeRate,
      IsReversal,
      IsReversed,
      AccountingDocumentHeaderText,
      CompanyCodeCountry,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      ReportingCountry,
      TaxReturnCountry,
      TaxCountry,
      @Semantics.currencyCode:true
      CompanyCodeCurrency,
      @Semantics.currencyCode:true
      CountryCurrency,
      @Semantics.currencyCode:true
      DocumentCurrency,
      @Semantics.currencyCode:true
      ReportingCurrency,
      @Semantics.currencyCode: true
      AdditionalCurrency1,
      @Semantics.currencyCode: true
      AdditionalCurrency2,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      TaxBaseAmountInRptgCrcy,
      
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      AmountInReportingCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      TaxAmountInRptgCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TaxBaseAmountInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TaxAmountInCoCodeCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TaxBaseAmountInTransCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TaxAmount,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TotalGrossAmountInCoCodeCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TotalGrossAmountInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CountryCurrency'
      TaxBaseAmountInCountryCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CountryCurrency'
      TaxAmountInCountryCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      TaxBaseAmtInAdditionalCrcy1,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      TaxBaseAmtInAdditionalCrcy2,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      TaxAmountInAdditionalCurrency1,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      TaxAmountInAdditionalCurrency2,


      /*@DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      DifferenceTaxAmtInCoCodeCrcy,


      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      DiffTaxBaseAmountInCoCodeCrcy,*/

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      NonDeductibleInputTaxAmount,

      @ObjectModel.text.association: '_TaxTypeText'
      @AnalyticsDetails.query.display:#TEXT
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      TaxType,
      TargetTaxCode,

      //TaxNumber1,

      BPTaxNumber,
      ReportingVATRegistration,
      TaxNumber1, //Stock Transfer Scenario

      TaxNumber2,
      TaxNumber3,
      
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      ActiveTaxType,

      ShippingPointCountry,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CalculatedTxAmtInCoCodeCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      CalculatedTaxAmountInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      CalculatedTxBaseAmtInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      AmountInTransactionCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      AmountInCompanyCodeCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CalcdTxBaseAmtInCoCodeCrcy,

      TaxTypeName,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      @AnalyticsDetails.query.totals: #SHOW
      DcblVATIncrdCostInRptgCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      BalanceAmountInTransacCurrency,
      CAReconciliationKey,
      BusinessPartner,

      BusinessPartnerName,
      BusinessPartnerCountry,
      CustomerSupplierAddress,

      TaxIsNotDeductible,

      ConditionType,
      
      //New Fields

      TaxBoxStructure,
      TaxBoxStructureName,
      TaxBoxName,
      TaxBoxCondition,
      SupplierAccountGroup,
      TaxBoxAggregationOperation,
      TaxGroupOperation,
      TaxCntryOrCompanyCodeCntry,
      //End of New Fields

      
//      TaxFulfillmentDate,

//      JrnlEntryCntrySpecificRef4,

//      JrnlEntryCntrySpecificRef5,

      
      _TaxTypeText
}
where
      TaxIsDeferredRelevant    = 'X'
  and TaxIsMossRelevant        = 'X'
  and IsVATRelevant = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPTAXRETURNBOXCUBE"
],
"ASSOCIATED":
[
"I_TAXTYPETEXT"
],
"BASE":
[
"I_STRPTAXRETURNBOXCUBE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More