What is I_StRpTaxItemBoxCube in SAP S/4HANA?

I_StRpTaxItemBoxCube is a composite CDS view in SAP S/4HANA. VAT Tax Item box level reporting It contains 102 fields.

Which tables does I_StRpTaxItemBoxCube read from?

I_StRpTaxItemBoxCube reads data from: I_StRpTaxItem, I_StRpTaxItemGrpg.

What VDM layer is I_StRpTaxItemBoxCube?

I_StRpTaxItemBoxCube is classified as a Composite view that combines data from multiple basic views.

I_StRpTaxItemBoxCube

DDL: I_STRPTAXITEMBOXCUBE SQL: ISRTAXITEMBOX Type: view COMPOSITE Package: GLO_FIN_IS_VAT_GEN

102 Fields 2 Data Sources

VAT Tax Item box level reporting

I_StRpTaxItemBoxCube is a Composite CDS View (Cube) that provides data about "VAT Tax Item box level reporting" in SAP S/4HANA. It reads from 2 data sources (I_StRpTaxItem, I_StRpTaxItemGrpg) and exposes 102 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination. Part of development package GLO_FIN_IS_VAT_GEN.

Data Sources (2)

Source	Alias	Join Type
I_StRpTaxItem	I_StRpTaxItem	from
I_StRpTaxItemGrpg	I_StRpTaxItemGrpg	left_outer

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	ISRTAXITEMBOX	view
EndUserText.label	VAT Tax Item box level reporting	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
AccessControl.authorizationCheck	#CHECK	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
Metadata.allowExtensions	true	view
AbapCatalog.preserveKey	true	view

Fields (102)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_StRpTaxItem	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_StRpTaxItem	AccountingDocument	Journal Entry
KEY	FiscalYear	I_StRpTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem		TaxItem	Tax Item
KEY	TransactionTypeDetermination	I_StRpTaxItem	TransactionTypeDetermination	Transaction Key
KEY	DebitCreditCode	I_StRpTaxItem	DebitCreditCode	Single-Character Flag
KEY	AccountingDocumentType	I_StRpTaxItem	AccountingDocumentType	Journal Entry Type
KEY	SupplierAccountGroup	I_StRpTaxItem	SupplierAccountGroup	Account group
KEY	TaxBox	I_StRpTaxItemGrpg	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	I_StRpTaxItemGrpg	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	I_StRpTaxItemGrpg	TaxItemGroupingVersion	Tax Grping Ver.
KEY	ValidFrom	I_StRpTaxItemGrpg	ValidFrom	Vers.Valid From
KEY	TaxBoxStructureType	I_StRpTaxItemGrpg	TaxBoxStructureType
KEY	TaxGroup	I_StRpTaxItemGrpg	TaxGroup	Tax Group
KEY	TaxItemGrpgDebitCreditCode	I_StRpTaxItemGrpg	DebitCreditCode	Single-Character Flag
KEY	TaxItemGrpgAcctgDocumentType	I_StRpTaxItemGrpg	AccountingDocumentType	Journal Entry Type
KEY	TaxItemGrpgSupplierAcctGroup	I_StRpTaxItemGrpg	SupplierAccountGroup	Account group
KEY	TaxItemGrpgSpecialGLCode	I_StRpTaxItemGrpg	SpecialGLCode	Special G/L Ind
	TaxCode	I_StRpTaxItem	TaxCode	Tax Code
	TaxRate	I_StRpTaxItem	TaxRate	Tax Rate
	TaxCodeRatePointer	I_StRpTaxItemGrpg	TaxRate	Tax Rate
	GLAccount		GLAccount	General Ledger
	TaxItemGroup	I_StRpTaxItem	TaxItemGroup	Tax doc. item number
	BusinessPlace		BusinessPlace	Business place
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdict. Code
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	DocumentReferenceID		DocumentReferenceID	Reference
	Ledger		Ledger	Ledger
	LedgerGroup		LedgerGroup	Ledger Group
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	TaxReportingDocumentDate		TaxReportingDocumentDate
	FiscalPeriod		FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry	I_StRpTaxItem	TaxReturnCountry	Reporting C/R
	TaxCountry	I_StRpTaxItem	TaxCountry	Tax Ctry/Reg.
	ReportingDate	I_StRpTaxItem	ReportingDate
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	CountryCurrency		CountryCurrency	Currency
	DocumentCurrency		DocumentCurrency	Document Currency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxType	I_StRpTaxItem	TaxType	Tax Type
	TaxCalculationProcedure	I_StRpTaxItem	TaxCalculationProcedure	Tax Procedure
	TargetTaxCode	I_StRpTaxItem	TargetTaxCode
	ConditionType	I_StRpTaxItem	ConditionType	Condition type
	EUTaxClassification	I_StRpTaxItem	EUTaxClassification
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	TaxNumber3		TaxNumber3
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerCountry		BusinessPartnerCountry	BP Ctry/Reg.
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress		CustomerSupplierAddress
	TaxIsNotDeductible		TaxIsNotDeductible	Non-Deductible
	MiniOneStopShopTxRptgCntry		MiniOneStopShopTxRptgCntry
	Supplier		Supplier	Supplier
	Customer		Customer	Sold-to Party
	TaxBoxStructure		TaxBoxStructure
	TaxBoxStructureName		TaxBoxStructureName
	TaxBoxName		TaxBoxName
	TaxBoxCondition		TaxBoxCondition
	TaxBoxAggregationOperation	I_StRpTaxItemGrpg	TaxBoxAggregationOperation
	TaxGroupOperation	I_StRpTaxItemGrpg	TaxGroupOperation
	CAReconciliationKey		CAReconciliationKey	Reconcil. Key
	SenderCompanyCode		SenderCompanyCode	Sender Company Code
	SenderAccountingDocument		SenderAccountingDocument	Sender Journal Entry
	SenderFiscalYear		SenderFiscalYear	Sender FiscalYr
	TaxBoxConfiguration		TaxBoxConfiguration
	_ReportingCurrency		_ReportingCurrency
	_AccountingDocument	I_StRpTaxItem	_AccountingDocument
	_GLAccount	I_StRpTaxItem	_GLAccount
	_TaxJurisdiction	I_StRpTaxItem	_TaxJurisdiction
	_DebtorCreditorRblsPyblsItem	I_StRpTaxItem	_DebtorCreditorRblsPyblsItem
	_ReceivablesPayablesItem	I_StRpTaxItem	_ReceivablesPayablesItem
	_TaxReceivablesPayablesItem	I_StRpTaxItem	_TaxReceivablesPayablesItem
	_TaxTypeText	I_StRpTaxItem	_TaxTypeText
	_TaxCodeText	I_StRpTaxItem	_TaxCodeText
	_ReportedItemsLog	I_StRpTaxItem	_ReportedItemsLog
	_JournalEntry	I_StRpTaxItem	_JournalEntry

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_StRpTaxItemBoxCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISRTAXITEMBOX

CREATE VIEW I_StRpTaxItemBoxCube AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.FiscalYear AS FiscalYear,
  TaxItem,
  I_StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItem.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItem.SupplierAccountGroup AS SupplierAccountGroup,
  I_StRpTaxItemGrpg.TaxBox AS TaxBox,
  I_StRpTaxItemGrpg.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxItemGrpg.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemGrpg.ValidFrom AS ValidFrom,
  I_StRpTaxItemGrpg.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpTaxItemGrpg.TaxGroup AS TaxGroup,
  I_StRpTaxItemGrpg.DebitCreditCode AS TaxItemGrpgDebitCreditCode,
  I_StRpTaxItemGrpg.AccountingDocumentType AS TaxItemGrpgAcctgDocumentType,
  I_StRpTaxItemGrpg.SupplierAccountGroup AS TaxItemGrpgSupplierAcctGroup,
  I_StRpTaxItemGrpg.SpecialGLCode AS TaxItemGrpgSpecialGLCode,
  I_StRpTaxItem.TaxCode AS TaxCode,
  I_StRpTaxItem.TaxRate AS TaxRate,
  I_StRpTaxItemGrpg.TaxRate AS TaxCodeRatePointer,
  GLAccount,
  I_StRpTaxItem.TaxItemGroup AS TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxReportingDocumentDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  I_StRpTaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxItem.TaxCountry AS TaxCountry,
  I_StRpTaxItem.ReportingDate AS ReportingDate,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  I_StRpTaxItem.TaxType AS TaxType,
  I_StRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxItem.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxItem.ConditionType AS ConditionType,
  I_StRpTaxItem.EUTaxClassification AS EUTaxClassification,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerCountry,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxIsNotDeductible,
  MiniOneStopShopTxRptgCntry,
  Supplier,
  Customer,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  I_StRpTaxItemGrpg.TaxBoxAggregationOperation AS TaxBoxAggregationOperation,
  I_StRpTaxItemGrpg.TaxGroupOperation AS TaxGroupOperation,
  CAReconciliationKey,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  TaxBoxConfiguration,
  I_StRpTaxItem._AccountingDocument AS _AccountingDocument,
  I_StRpTaxItem._GLAccount AS _GLAccount,
  I_StRpTaxItem._TaxJurisdiction AS _TaxJurisdiction,
  I_StRpTaxItem._DebtorCreditorRblsPyblsItem AS _DebtorCreditorRblsPyblsItem,
  I_StRpTaxItem._ReceivablesPayablesItem AS _ReceivablesPayablesItem,
  I_StRpTaxItem._TaxReceivablesPayablesItem AS _TaxReceivablesPayablesItem,
  I_StRpTaxItem._TaxTypeText AS _TaxTypeText,
  I_StRpTaxItem._TaxCodeText AS _TaxCodeText,
  I_StRpTaxItem._ReportedItemsLog AS _ReportedItemsLog,
  I_StRpTaxItem._JournalEntry AS _JournalEntry
FROM I_StRpTaxItem
LEFT OUTER JOIN I_StRpTaxItemGrpg ON /* join condition not captured in parsed metadata */
;

Depth:

I_StRpTaxItemBoxCube view

I_StRpTaxItem view
I_StRpTaxItemGrpg view