Which tables does I_StRpTaxReturnBoxCube use?

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

I_StRpTaxReturnBoxCube

Q: How many fields does I_StRpTaxReturnBoxCube have?

I_StRpTaxReturnBoxCube has 137 fields. Key fields: CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination.

DDL: I_STRPTAXRETURNBOXCUBE SQL: ISRTAXRETURNBOXC Type: view COMPOSITE

Cube View to Return Tax Details with TaxBox configuration

I_StRpTaxReturnBoxCube is a Composite CDS View (Cube) that provides data about "Cube View to Return Tax Details with TaxBox configuration" in SAP S/4HANA. It reads from 1 data source (P_StRpCalTaxReturnBox) and exposes 137 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination.

Data Sources (1)

Source	Alias	Join Type
P_StRpCalTaxReturnBox	P_StRpCalTaxReturnBox	from

Parameters (7)

Name	Type	Default
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 (13)

Name	Value	Level
AbapCatalog.sqlViewName	ISRTAXRETURNBOXC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Cube View to Return Tax Details with TaxBox configuration	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.allowExtensions	true	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view

Fields (137)

Key	Field	Source Table	Source Field
KEY	CompanyCode	P_StRpCalTaxReturnBox	CompanyCode
KEY	AccountingDocument	P_StRpCalTaxReturnBox	AccountingDocument
KEY	FiscalYear	P_StRpCalTaxReturnBox	FiscalYear
KEY	TaxItem	P_StRpCalTaxReturnBox	TaxItem
KEY	TransactionTypeDetermination	P_StRpCalTaxReturnBox	TransactionTypeDetermination
KEY	DebitCreditCode	P_StRpCalTaxReturnBox	DebitCreditCode
KEY	AccountingDocumentType	P_StRpCalTaxReturnBox	AccountingDocumentType
KEY	SupplierAccountGroup
KEY	TaxBox	P_StRpCalTaxReturnBox	TaxBox
KEY	TaxDeclnAmountType	P_StRpCalTaxReturnBox	TaxDeclnAmountType
KEY	TaxBoxStrucValidityStartDate	P_StRpCalTaxReturnBox	TaxBoxStrucValidityStartDate
KEY	UnifiedTaxBoxStructureType	P_StRpCalTaxReturnBox	UnifiedTaxBoxStructureType
KEY	TaxGroup	P_StRpCalTaxReturnBox	TaxGroup
KEY	TaxItemGrpgDebitCreditCode	P_StRpCalTaxReturnBox	TaxItemGrpgDebitCreditCode
KEY	TaxItemGrpgAcctgDocumentType
KEY	TaxItemGrpgSupplierAcctGroup
KEY	TaxItemGrpgSpecialGLCode	P_StRpCalTaxReturnBox	TaxItemGrpgSpecialGLCode
KEY	StatryRptgEntity	P_StRpCalTaxReturnBox	StatryRptgEntity
KEY	StatryRptCategory	P_StRpCalTaxReturnBox	StatryRptCategory
KEY	StatryRptRunID	P_StRpCalTaxReturnBox	StatryRptRunID
	StatryRptRun
	ValidFrom	P_StRpCalTaxReturnBox	ValidFrom
	Country
	TaxCode	P_StRpCalTaxReturnBox	TaxCode
	TaxItemGroupingVersion	P_StRpCalTaxReturnBox	TaxItemGroupingVersion
	TaxItemGroupingAccountNumber	P_StRpCalTaxReturnBox	TaxItemGroupingAccountNumber
	TaxBoxStructureType	P_StRpCalTaxReturnBox	TaxBoxStructureType
	ValidTo		ValidTo
	TaxBoxStrucValidityEndDate		TaxBoxStrucValidityEndDate
	TaxCalculationProcedure		TaxCalculationProcedure
	TaxRate		TaxRate
	IPITaxRate		IPITaxRate
	TaxCodeRatePointer		TaxCodeRatePointer
	TaxRateValidityStartDate		TaxRateValidityStartDate
	Customer		Customer
	GLAccount		GLAccount
	TaxItemGroup		TaxItemGroup
	BusinessPlace		BusinessPlace
	TaxJurisdiction		TaxJurisdiction
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction
	ReferenceDocumentType		ReferenceDocumentType
	AlternativeReferenceDocument		AlternativeReferenceDocument
	ReverseDocument		ReverseDocument
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear
	ConditionRecord		ConditionRecord
	RoundingDecimalPlaces		RoundingDecimalPlaces
	DocumentReferenceID		DocumentReferenceID
	Ledger		Ledger
	LedgerGroup		LedgerGroup
	PostingDate		PostingDate
	DocumentDate		DocumentDate
	TaxReportingDate		TaxReportingDate
	ReportingDate		ReportingDate
	TaxReportingDocumentDate		TaxReportingDocumentDate
	FiscalPeriod		FiscalPeriod
	OriginalFiscalPeriod		OriginalFiscalPeriod
	ExchangeRate		ExchangeRate
	IsReversal		IsReversal
	IsReversed		IsReversed
	AccountingDocumentHeaderText		AccountingDocumentHeaderText
	CompanyCodeCountry		CompanyCodeCountry
	ReportingCountry
	TaxReturnCountry		TaxReturnCountry
	CompanyCodeCurrency		CompanyCodeCurrency
	CountryCurrency		CountryCurrency
	DocumentCurrency		DocumentCurrency
	ReportingCurrency		ReportingCurrency
	AdditionalCurrency1		AdditionalCurrency1
	AdditionalCurrency2		AdditionalCurrency2
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy
	TaxAmount		TaxAmount
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2
	DifferenceTaxAmtInCoCodeCrcy		DifferenceTaxAmtInCoCodeCrcy
	DiffTaxBaseAmountInCoCodeCrcy		DiffTaxBaseAmountInCoCodeCrcy
	TotalGrossAmountInCoCodeCrcy		TotalGrossAmountInCoCodeCrcy
	TotalGrossAmount		TotalGrossAmount
	TotalGrossAmountInTransCrcy		TotalGrossAmountInTransCrcy
	TaxType		TaxType
	BPTaxNumber		BPTaxNumber
	ReportingVATRegistration		ReportingVATRegistration
	TaxNumber1		TaxNumber1
	ShippingPointCountry		Country
	TargetTaxCode		TargetTaxCode
	TaxNumber2		TaxNumber2
	ActiveTaxType		ActiveTaxType
	TaxNumber3		TaxNumber3
	TaxIsDeferredRelevant		TaxIsDeferredRelevant
	TaxIsMossRelevant		TaxIsMossRelevant
	BusinessPartner		BusinessPartner
	CAReconciliationKey		CAReconciliationKey
	NonDeductibleInputTaxAmount		NonDeductibleInputTaxAmount
	DcblVATIncrdCostInRptgCrcy		DcblVATIncrdCostInRptgCrcy
	BusinessPartnerName		BusinessPartnerName
	BusinessPartnerCountry		BusinessPartnerCountry
	TaxTypeName		TaxTypeName
	CustomerSupplierAddress		CustomerSupplierAddress
	TaxIsNotDeductible		TaxIsNotDeductible
	SenderCompanyCode		SenderCompanyCode
	SenderAccountingDocument		SenderAccountingDocument
	SenderFiscalYear		SenderFiscalYear
	BalanceAmountInTransacCurrency		BalanceAmountInTransacCurrency
	TaxBoxStructure		TaxBoxStructure
	TaxBoxStructureName
	TaxBoxName		TaxBoxName
	TaxBoxCondition		TaxBoxCondition
	TaxBoxAggregationOperation		TaxBoxAggregationOperation
	TaxGroupOperation		TaxGroupOperation
	ConditionType		ConditionType
	IsNegativePosting		IsNegativePosting
	TaxCountry		TaxCountry
	TaxCntryOrCompanyCodeCntry		TaxCntryOrCompanyCodeCntry
	TaxGroupFreeClassification		TaxGroupFreeClassification
	TaxFulfillmentDate	_JournalEntry	TaxFulfillmentDate
	JrnlEntryCntrySpecificRef4	_JournalEntry	JrnlEntryCntrySpecificRef4
	JrnlEntryCntrySpecificRef5	_JournalEntry	JrnlEntryCntrySpecificRef5
	_ReportedItemsLog		_ReportedItemsLog
	_ReportingCurrency		_ReportingCurrency
	_OneTimeAccountBP		_OneTimeAccountBP
	_JournalEntry		_JournalEntry
	_AccountingDocument		_AccountingDocument
	_GLAccount		_GLAccount
	_TaxJurisdiction		_TaxJurisdiction
	_DebtorCreditorRblsPyblsItem		_DebtorCreditorRblsPyblsItem
	_ReceivablesPayablesItem		_ReceivablesPayablesItem
	_TaxReceivablesPayablesItem		_TaxReceivablesPayablesItem
	_CompanyCodeCountry		_CompanyCodeCountry
	_TaxTypeText		_TaxTypeText
	_TaxCodeText		_TaxCodeText

@AbapCatalog.sqlViewName: 'ISRTAXRETURNBOXC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cube View to Return Tax Details with TaxBox configuration'
@VDM.viewType: #COMPOSITE
@Analytics: { dataCategory: #CUBE }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking:#BLOCKED_DATA_INCLUDED

define view I_StRpTaxReturnBoxCube

  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 P_StRpCalTaxReturnBox (
                                                 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
                                                 
                                                )
{

      //P_StRpCalTaxReturnBox

  key P_StRpCalTaxReturnBox.CompanyCode,
  key P_StRpCalTaxReturnBox.AccountingDocument,
  key P_StRpCalTaxReturnBox.FiscalYear,
  key P_StRpCalTaxReturnBox.TaxItem,
  key P_StRpCalTaxReturnBox.TransactionTypeDetermination,
  key P_StRpCalTaxReturnBox.DebitCreditCode,
  key P_StRpCalTaxReturnBox.AccountingDocumentType,
  key cast( P_StRpCalTaxReturnBox.SupplierAccountGroup as farp_supplier_account_group ) as SupplierAccountGroup,  
  key P_StRpCalTaxReturnBox.TaxBox,
  key P_StRpCalTaxReturnBox.TaxDeclnAmountType,
  key P_StRpCalTaxReturnBox.TaxBoxStrucValidityStartDate,
  key P_StRpCalTaxReturnBox.UnifiedTaxBoxStructureType,  
  key P_StRpCalTaxReturnBox.TaxGroup,
  key P_StRpCalTaxReturnBox.TaxItemGrpgDebitCreditCode,
  key cast( P_StRpCalTaxReturnBox.TaxItemGrpgAcctgDocumentType as glo_tax_item_grpg_acc_doc_type ) as TaxItemGrpgAcctgDocumentType,
  key cast( P_StRpCalTaxReturnBox.TaxItemGrpgSupplierAcctGroup as glo_tax_itm_grpg_suplr_acc_grp ) as TaxItemGrpgSupplierAcctGroup,
  key P_StRpCalTaxReturnBox.TaxItemGrpgSpecialGLCode,
  key P_StRpCalTaxReturnBox.StatryRptgEntity,
  key P_StRpCalTaxReturnBox.StatryRptCategory,
  key P_StRpCalTaxReturnBox.StatryRptRunID,
  cast(concat_with_space( concat_with_space( StatryRptgEntity,StatryRptCategory,1),StatryRptRunID,1 ) as srf_reportrun) as StatryRptRun,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'TaxBoxStrucValidityStartDate'
      P_StRpCalTaxReturnBox.ValidFrom, 
      
      cast( P_StRpCalTaxReturnBox.Country as glo_country ) as Country,
      P_StRpCalTaxReturnBox.TaxCode,
      P_StRpCalTaxReturnBox.TaxItemGroupingVersion,
      P_StRpCalTaxReturnBox.TaxItemGroupingAccountNumber,
      P_StRpCalTaxReturnBox.TaxBoxStructureType,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'TaxBoxStrucValidityEndDate'
      ValidTo,
      TaxBoxStrucValidityEndDate,
      TaxCalculationProcedure,
      @DefaultAggregation:#MIN
      TaxRate,
      
      IPITaxRate,
      
      @DefaultAggregation:#MIN
      TaxCodeRatePointer,
     
      /*@DefaultAggregation:#MIN
      AdditionalTax1Rate,*/
      
      TaxRateValidityStartDate,
      
      /*@DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      ConditionAmount,*/
      Customer,
      GLAccount,
      TaxItemGroup,
      BusinessPlace,
      TaxJurisdiction,
      LowestLevelTaxJurisdiction,
      ReferenceDocumentType,
      AlternativeReferenceDocument,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      ConditionRecord,
      RoundingDecimalPlaces,
      DocumentReferenceID,
      Ledger,
      LedgerGroup,
      PostingDate,
      DocumentDate,
      TaxReportingDate,      
      ReportingDate,
      TaxReportingDocumentDate,
      FiscalPeriod,
      OriginalFiscalPeriod,
      @DefaultAggregation:#MIN
      ExchangeRate,
      IsReversal,
      IsReversed,
      AccountingDocumentHeaderText,
      CompanyCodeCountry,
      cast( ReportingCountry as glo_tax_cntry_or_cocd_cntry ) as ReportingCountry,
      TaxReturnCountry,
      @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'
      TaxAmountInRptgCrcy,

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

      cast(case TaxDeclnAmountType
          when 'B'
          then
           TaxBaseAmountInRptgCrcy
          when 'T'
          then
          case TaxIsNotDeductible
          when 'X'
          then
          NonDeductibleInputTaxAmount
          else
          TaxAmountInRptgCrcy
          end 
          else 
          0
          end  as glo_amount_rptg_crcy )  as AmountInReportingCurrency,
      

      @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: '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: 'CompanyCodeCurrency'
      TotalGrossAmountInCoCodeCrcy,
      
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      TotalGrossAmount,
                        
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TotalGrossAmountInTransCrcy,

      TaxType,
      BPTaxNumber,
      ReportingVATRegistration,
      TaxNumber1, //Stock Transfer Scenario is handled


      Country                                                                              as ShippingPointCountry,
      
      TargetTaxCode,
      TaxNumber2,
      ActiveTaxType,
      TaxNumber3,
      TaxIsDeferredRelevant,
      TaxIsMossRelevant,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast(case
      when TaxDeclnAmountType = 'T'
      then
      CalculatedTxAmtInCoCodeCrcy
      else 0
      end as glo_taxamount_calc_intrancrcy )                                               as
                                                                                              CalculatedTxAmtInCoCodeCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast(case
      when TaxDeclnAmountType = 'T'
      then
      CalculatedTaxAmountInTransCrcy
      else 0
      end as glo_taxamount_calc_intranscrcy )                                              as CalculatedTaxAmountInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast(case
      when TaxDeclnAmountType = 'B'
      then
      CalculatedTxBaseAmtInTransCrcy
      else 0
      end as glo_baseamount_calc_intrancrcy )                                              as CalculatedTxBaseAmtInTransCrcy,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast(case
      when TaxDeclnAmountType = 'B'
      then CalculatedTxBaseAmtInTransCrcy
      when TaxDeclnAmountType = 'T'
      then
      CalculatedTaxAmountInTransCrcy
      else 0
      end as glo_amount_trans_crcy )                                                       as AmountInTransactionCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast(case
      when TaxDeclnAmountType = 'B'
      then CalcdTxBaseAmtInCoCodeCrcy
      when TaxDeclnAmountType = 'T'
      then
      CalculatedTxAmtInCoCodeCrcy
      else 0
      end as glo_amount_compcode_crcy )                                                                as AmountInCompanyCodeCurrency,

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

      case
      when TaxDeclnAmountType = 'B'
      then
      CalcdTxBaseAmtInCoCodeCrcy
      else 0
      end                                                                                  as CalcdTxBaseAmtInCoCodeCrcy,
      
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      cast(case
           when TaxDeclnAmountType = 'B'
            then TaxBaseAmtInAdditionalCrcy1

            when TaxDeclnAmountType = 'T'
            then TaxAmountInAdditionalCurrency1
         end as glo_amount_add_crcy1 )                          as AmountInAdditionalCurrency1,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      cast(case
           when TaxDeclnAmountType = 'B'
            then TaxBaseAmtInAdditionalCrcy2

            when TaxDeclnAmountType = 'T'
            then TaxAmountInAdditionalCurrency2
         end as glo_amount_add_crcy2 )                          as AmountInAdditionalCurrency2,
      


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

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'ReportingCurrency'
      DcblVATIncrdCostInRptgCrcy,
      BusinessPartnerName,
      BusinessPartnerCountry,
      TaxTypeName,
      CustomerSupplierAddress,
      TaxIsNotDeductible,
      SenderCompanyCode,
      SenderAccountingDocument,
      SenderFiscalYear,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      BalanceAmountInTransacCurrency,
      TaxBoxStructure,
      cast( TaxBoxStructureName as taxboxsname ) as TaxBoxStructureName,
      TaxBoxName,
      TaxBoxCondition,
      TaxBoxAggregationOperation,
      TaxGroupOperation,
      ConditionType,

      case
      when ItelRelforReporting1 = 'X' and ItelRelforReporting2 = 'X' and ItelRelforReporting3 = 'X'
      then 'X'
      else ''
      end                                                                                  as IsVATRelevant,
      
      IsNegativePosting,
      TaxCountry,
      TaxCntryOrCompanyCodeCntry,
      TaxGroupFreeClassification,
      
      _JournalEntry.TaxFulfillmentDate as TaxFulfillmentDate,
      _JournalEntry.JrnlEntryCntrySpecificRef4 as JrnlEntryCntrySpecificRef4,
      _JournalEntry.JrnlEntryCntrySpecificRef5 as JrnlEntryCntrySpecificRef5,  
      
      _ReportedItemsLog,
      _ReportingCurrency,
      _OneTimeAccountBP,
      _JournalEntry,
      _AccountingDocument,
      _GLAccount,
      _TaxJurisdiction,
      _DebtorCreditorRblsPyblsItem,
      _ReceivablesPayablesItem,
      _TaxReceivablesPayablesItem,
      _CompanyCodeCountry,
      _TaxTypeText,
      _TaxCodeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"P_STRPCALTAXRETURNBOX"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_COUNTRY",
"I_CURRENCY",
"I_GLACCOUNT",
"I_JOURNALENTRY",
"I_ONETIMEACCOUNTBP",
"I_OPERATIONALACCTGDOCITEM",
"I_STRPJOURNALENTRYLOG",
"I_TAXCODETEXT",
"I_TAXJURISDICTION",
"I_TAXTYPETEXT"
],
"BASE":
[
"P_STRPCALTAXRETURNBOX"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_StRpTaxReturnBoxCube view

P_StRpCalTaxReturnBox view