Which tables does C_DE_TaxReturnBoxQuery use?

C_DE_TaxReturnBoxQuery reads from 1 data source(s): I_StRpTaxReturnBoxCube.

How many fields does C_DE_TaxReturnBoxQuery have?

C_DE_TaxReturnBoxQuery has 62 fields. Key fields: CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

C_DE_TaxReturnBoxQuery

DDL: C_DE_TAXRETURNBOXQUERY SQL: CDETAXRETURNBOXQ Type: view CONSUMPTION

Query Tax Items for Germany

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

Data Sources (1)

Source	Alias	Join Type
I_StRpTaxReturnBoxCube	I_StRpTaxReturnBoxCube	from

Parameters (4)

Name	Type	Default
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id
P_ReportingCountry	land1

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CDETAXRETURNBOXQ	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
EndUserText.label	Query Tax Items for Germany	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 (62)

Key	Field	Source Field
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	ValidFrom	ValidFrom
KEY	UnifiedTaxBoxStructureType	UnifiedTaxBoxStructureType
KEY	StatryRptgEntity	StatryRptgEntity
KEY	StatryRptCategory	StatryRptCategory
KEY	StatryRptRunID	StatryRptRunID
KEY	AccountingDocumentType	AccountingDocumentType
KEY	DebitCreditCode	DebitCreditCode
KEY	SupplierAccountGroup	SupplierAccountGroup
KEY	TaxBoxStrucValidityStartDate	TaxBoxStrucValidityStartDate
KEY	TaxItemGrpgDebitCreditCode	TaxItemGrpgDebitCreditCode
KEY	TaxItemGrpgAcctgDocumentType	TaxItemGrpgAcctgDocumentType
KEY	TaxItemGrpgSupplierAcctGroup	TaxItemGrpgSupplierAcctGroup
KEY	TaxItemGrpgSpecialGLCode	TaxItemGrpgSpecialGLCode
	TaxItemGroupingVersion	TaxItemGroupingVersion
	TaxBoxStructureType	TaxBoxStructureType
	ValidTo	ValidTo
	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: 'CDETAXRETURNBOXQ'
@VDM.viewType: #CONSUMPTION
@Analytics.query:true
@EndUserText.label: 'Query Tax Items for Germany'
@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_DE_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,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key TaxCode,
  key TransactionTypeDetermination,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TaxBox,
  key TaxGroup,
  key Country,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS
  key TaxDeclnAmountType,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
  key ValidFrom,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
  key UnifiedTaxBoxStructureType,
  key StatryRptgEntity,
  key StatryRptCategory,
  key StatryRptRunID,
      @AnalyticsDetails.query.hidden: true
  key AccountingDocumentType,
      @AnalyticsDetails.query.hidden: true
  key DebitCreditCode,
      @AnalyticsDetails.query.hidden: true
  key SupplierAccountGroup,
      @AnalyticsDetails.query.hidden: true
  key TaxBoxStrucValidityStartDate,
      @AnalyticsDetails.query.hidden: true
  key TaxItemGrpgDebitCreditCode,
      @AnalyticsDetails.query.hidden: true
  key TaxItemGrpgAcctgDocumentType,
      @AnalyticsDetails.query.hidden: true
  key TaxItemGrpgSupplierAcctGroup,
      @AnalyticsDetails.query.hidden: true
  key TaxItemGrpgSpecialGLCode,

      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      TaxItemGroupingVersion,
      TaxBoxStructureType,
      @Consumption.filter : { selectionType : #RANGE, multipleSelections : true}
      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":""
}
}*/

Depth:

C_DE_TaxReturnBoxQuery view

I_StRpTaxReturnBoxCube view