What is I_US_TaxPartnerTaxDocItemCube in SAP S/4HANA?

I_US_TaxPartnerTaxDocItemCube is a composite CDS view in SAP S/4HANA. US Tax Partner Tax Document Item - Cube It contains 97 fields.

Which tables does I_US_TaxPartnerTaxDocItemCube read from?

I_US_TaxPartnerTaxDocItemCube reads data from: I_US_TxPartTxJurisdictionLevel.

What VDM layer is I_US_TaxPartnerTaxDocItemCube?

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

I_US_TaxPartnerTaxDocItemCube

DDL: I_US_TAXPARTNERTAXDOCITEMCUBE SQL: IUSTXPTDITEMCUBE Type: view COMPOSITE

97 Fields 1 Data Sources 17 Associations

US Tax Partner Tax Document Item - Cube

I_US_TaxPartnerTaxDocItemCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_US_TaxPartnerTaxDocItemCube is a Composite CDS View (Cube) that provides data about "US Tax Partner Tax Document Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_US_TxPartTxJurisdictionLevel) and exposes 97 fields with key fields US_TaxPartnerTaxDocument, US_TaxPartnerTaxDocumentItem, TaxJurisdictionLevel. It has 17 associations to related views.

SAP Help Documentation

Category	Accounting and Financial Close
Data Category	Cube
Status	Released
Corresponding DataSource	IUSTXPTDITEMCUBE

Purpose
This CDS view provides a single-source view for all external tax documents. This view shows the components of these tax documents, such as the original documents, line items, and the tax amounts at various jurisdiction levels, such as state, county, and city. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Any user who wants to use this CDS view needs to have the same minimum authorizations as the SAP_BR_GL_ACCOUNTANT_US business role template. Users must be assigned the SAP_FIN_BC_GL_TX_DCL_US_PC business catalog, which is predelivered with this role template. This business catalog contains the predeivered restrictions and permissions needed to use this CDS view. Your Administrator can see more information about this busness role template, this business catalog, and these restrictions in the Maintain Business Roles app.

Structure
Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment COMPANYCODE Company code Attribute COMPANYCODECURRENCY Company code currency Attribute US_TAXFREEDEFINEDVALUE1 ~ US_TAXFREEDEFINEDVALUE50 Extension fields Attribute FISCALYEAR Fiscal year Attribute GLACCOUNT G/L account Attribute ACCOUNTINGDOCUMENT Journal Entry Attribute DOCUMENTDATE Journal entry date Attribute MATERIALGROUP Material group Attribute POSTINGDATE Posting date Attribute PRODUCT Product number Attribute PURCHASINGDOCUMENT Purchasing document number Attribute SDDOCUMENT Sales order document number Attribute SERVICESRENDEREDDATE Service rendered date Attribute TAXAMOUNTINCOCODECRCY Tax amount in company code currency Measure Default calculation formula: SUM TAXAMOUNTINTRANSCRCY Tax amount in transaction currency Measure Default calculation formula: SUM TAXBASEAMOUNTINCOCODECRCY Tax base amount in company code currency Measure Default calculation formula: MAX TAXBASEAMOUNTINTRANSCRCY Tax base amount in transaction currency Measure Default calculation formula: MAX TAXCALCULATIONDATE Tax calculation date Attribute TAXCALCULATIONPROCEDURE Tax calculation procedure Attribute TAXCODE Tax code Attribute US_TAXPARTNERRECEIVEDTAXDATE Tax date as sent to tax partner Attribute TAXEXEMPTIONAMOUNT Tax exemption amount Measure Default calculation formula: MAX TAXJURISDICTION Tax jurisdiction code Attribute TAXJURISDICTIONTEXT Tax jurisdiction code description Attribute TAXJURISDICTIONLEVEL Tax jurisdiction level number Attribute TRANSACTIONCURRENCY Transaction currency Attribute UNITEDSTATESTAXCATEGORY US tax category Attribute US_TAXPARTNERTAXDOCUMENT US tax document number Attribute US_TAXPARTNERTAXDOCUMENTITEM US tax document item number Attribute UNITEDSTATESTAXSOURCING US tax sourcing Attribute US_TAXSTATE US tax state Attribute

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Corresponding DataSource (Extractor) IUSTXPTDITEMCUBE Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-FIO-GL
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_US_TxPartTxJurisdictionLevel	_JurisdictionLevel	from

Associations (17)

Cardinality	Target	Alias	Condition
[0..1]	I_US_TaxPartnerTaxDocument	_Document	`$projection.US_TaxPartnerTaxDocument = _Document.US_TaxPartnerTaxDocument`
[0..1]	I_US_TaxPartnerTaxDocumentItem	_Item	`$projection.US_TaxPartnerTaxDocument = _Item.US_TaxPartnerTaxDocument and $projection.US_TaxPartnerTaxDocumentItem = _Item.US_TaxPartnerTaxDocumentItem`
[0..1]	I_US_TaxState	_US_TaxState	`$projection.US_TaxState = _US_TaxState.US_TaxState`
[0..1]	I_UnitedStatesTaxSourcing	_TaxSourcing	`$projection.UnitedStatesTaxSourcing = _TaxSourcing.UnitedStatesTaxSourcing`
[0..1]	I_Product	_Product	`$projection.Product = _Product.Product`
[0..1]	I_ProductGroup_2	_MaterialGroup	`$projection.materialgroup = _MaterialGroup.ProductGroup`
[0..1]	I_TaxCalculationProcedure	_TaxCalculationProcedure	`$projection.taxcalculationprocedure = _TaxCalculationProcedure.TaxCalculationProcedure`
[0..1]	I_TaxCode	_TaxCode	`$projection.taxcalculationprocedure = _TaxCode.TaxCalculationProcedure and $projection.taxcode = _TaxCode.TaxCode`
[0..1]	I_PurchaseOrderAPI01	_PurchasingDocument	`$projection.purchasingdocument = _PurchasingDocument.PurchaseOrder`
[0..1]	I_BillingDocument	_BillingDocument	`$projection.sddocument = _BillingDocument.BillingDocument`
[0..1]	I_UnitedStatesTaxCategory	_UnitedStatesTaxCategory	`$projection.unitedstatestaxcategory = _UnitedStatesTaxCategory.UnitedStatesTaxCategory`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.companycode = _CompanyCode.CompanyCode`
[0..1]	I_FiscalYearForCompanyCode	_FiscalYear	`$projection.fiscalyear = _FiscalYear.FiscalYear and $projection.companycode = _FiscalYear.CompanyCode`
[0..1]	I_JournalEntry	_JournalEntry	`$projection.companycode = _JournalEntry.CompanyCode and $projection.fiscalyear = _JournalEntry.FiscalYear and $projection.accountingdocument = _JournalEntry.AccountingDocument`
[0..1]	I_GLAccount	_GLAccount	`$projection.GLAccount = _GLAccount.GLAccount and $projection.companycode = _GLAccount.CompanyCode`
[0..1]	I_Currency	_TransactionCurrency	`$projection.transactioncurrency = _TransactionCurrency.Currency`
[0..1]	I_Currency	_CompanyCodeCurrency	`$projection.companycodecurrency = _CompanyCodeCurrency.Currency`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IUSTXPTDITEMCUBE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	US Tax Partner Tax Document Item - Cube	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (97)

Key	Field	Source Table	Source Field	Description
KEY	US_TaxPartnerTaxDocument	I_US_TxPartTxJurisdictionLevel	US_TaxPartnerTaxDocument	External-tax document number
KEY	US_TaxPartnerTaxDocumentItem	I_US_TxPartTxJurisdictionLevel	US_TaxPartnerTaxDocumentItem	External-tax document item number
KEY	TaxJurisdictionLevel	I_US_TxPartTxJurisdictionLevel	TaxJurisdictionLevel	Tax jurisdiction code level
	US_TaxState	I_US_TxPartTxJurisdictionLevel	US_TaxState	External Tax State
	UnitedStatesTaxSourcing	I_US_TxPartTxJurisdictionLevel	UnitedStatesTaxSourcing	Tax Sourcing
	TaxJurisdiction	I_US_TxPartTxJurisdictionLevel	TaxJurisdiction	Tax Jurisdiction
	TaxJurisdictionText	I_US_TxPartTxJurisdictionLevel	TaxJurisdictionText	Tax Jurisdiction Code Description
	Product			Product Number
	MaterialGroup	_Item	MaterialGroup	Material Group
	TaxCalculationProcedure	_Document	TaxCalculationProcedure	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
	TaxCode	_Item	TaxCode	Tax on Sales/Purchases Code
	PurchasingDocument	_Item	PurchasingDocument	Purchasing Document Number
	SDDocument	_Item	SDDocument	Sales and Distribution Document Number
	UnitedStatesTaxCategory	_Item	UnitedStatesTaxCategory	Tax Category for US Taxes
	CompanyCode	_Document	CompanyCode	Receiver Company Code
	AccountingDocument	_Document	AccountingDocument	Journal Entry
	FiscalYear	_Document	FiscalYear	G/L Fiscal Year
	GLAccount	I_US_TxPartTxJurisdictionLevel	GLAccount	General Ledger
	TaxBaseAmountInTransCrcy	I_US_TxPartTxJurisdictionLevel	TaxBaseAmountInTransCrcy	Tax Base Amount in Transaction Currency
	TaxAmountInTransCrcy	I_US_TxPartTxJurisdictionLevel	TaxAmountInTransCrcy	Tax Amount in Transaction Currency
	TaxExemptionAmount	I_US_TxPartTxJurisdictionLevel	TaxExemptionAmount	Tax-Exempt Revaluation Amount
	TransactionCurrency	_Document	TransactionCurrency	Transaction Currency
	TaxBaseAmountInCoCodeCrcy	I_US_TxPartTxJurisdictionLevel	TaxBaseAmountInCoCodeCrcy	Tax Base Amount in Company Code Currency
	TaxAmountInCoCodeCrcy	I_US_TxPartTxJurisdictionLevel	TaxAmountInCoCodeCrcy	Signed Tax Amount in Company Code Currency
	CompanyCodeCurrency	_Document	CompanyCodeCurrency	Company Code Currency
	PostingDate	_Item	PostingDate	Posting Date for GR
	DocumentDate	_Item	DocumentDate	Journal Entry Date
	ServicesRenderedDate	_Item	ServicesRenderedDate	Date on which services are rendered
	US_TaxPartnerReceivedTaxDate	_Item	US_TaxPartnerReceivedTaxDate	Tax Date as Sent to Partner
	TaxCalculationDate	_Item	TaxCalculationDate	The date used for external tax calculation
	US_TaxFreeDefinedValue1	_Item	US_TaxFreeDefinedValue1	Extension Field 001
	US_TaxFreeDefinedValue2	_Item	US_TaxFreeDefinedValue2	Extension Field 002
	US_TaxFreeDefinedValue3	_Item	US_TaxFreeDefinedValue3	Extension Field 003
	US_TaxFreeDefinedValue4	_Item	US_TaxFreeDefinedValue4	Extension Field 004
	US_TaxFreeDefinedValue5	_Item	US_TaxFreeDefinedValue5	Extension Field 005
	US_TaxFreeDefinedValue6	_Item	US_TaxFreeDefinedValue6	Extension Field 006
	US_TaxFreeDefinedValue7	_Item	US_TaxFreeDefinedValue7	Extension Field 007
	US_TaxFreeDefinedValue8	_Item	US_TaxFreeDefinedValue8	Extension Field 008
	US_TaxFreeDefinedValue9	_Item	US_TaxFreeDefinedValue9	Extension Field 009
	US_TaxFreeDefinedValue10	_Item	US_TaxFreeDefinedValue10	Extension Field 010
	US_TaxFreeDefinedValue11	_Item	US_TaxFreeDefinedValue11	Extension Field 011
	US_TaxFreeDefinedValue12	_Item	US_TaxFreeDefinedValue12	Extension Field 012
	US_TaxFreeDefinedValue13	_Item	US_TaxFreeDefinedValue13	Extension Field 013
	US_TaxFreeDefinedValue14	_Item	US_TaxFreeDefinedValue14	Extension Field 014
	US_TaxFreeDefinedValue15	_Item	US_TaxFreeDefinedValue15	Extension Field 015
	US_TaxFreeDefinedValue16	_Item	US_TaxFreeDefinedValue16	Extension Field 016
	US_TaxFreeDefinedValue17	_Item	US_TaxFreeDefinedValue17	Extension Field 017
	US_TaxFreeDefinedValue18	_Item	US_TaxFreeDefinedValue18	Extension Field 018
	US_TaxFreeDefinedValue19	_Item	US_TaxFreeDefinedValue19	Extension Field 019
	US_TaxFreeDefinedValue20	_Item	US_TaxFreeDefinedValue20	Extension Field 020
	US_TaxFreeDefinedValue21	_Item	US_TaxFreeDefinedValue21	Extension Field 021
	US_TaxFreeDefinedValue22	_Item	US_TaxFreeDefinedValue22	Extension Field 022
	US_TaxFreeDefinedValue23	_Item	US_TaxFreeDefinedValue23	Extension Field 023
	US_TaxFreeDefinedValue24	_Item	US_TaxFreeDefinedValue24	Extension Field 024
	US_TaxFreeDefinedValue25	_Item	US_TaxFreeDefinedValue25	Extension Field 025
	US_TaxFreeDefinedValue26	_Item	US_TaxFreeDefinedValue26	Extension Field 026
	US_TaxFreeDefinedValue27	_Item	US_TaxFreeDefinedValue27	Extension Field 027
	US_TaxFreeDefinedValue28	_Item	US_TaxFreeDefinedValue28	Extension Field 028
	US_TaxFreeDefinedValue29	_Item	US_TaxFreeDefinedValue29	Extension Field 029
	US_TaxFreeDefinedValue30	_Item	US_TaxFreeDefinedValue30	Extension Field 030
	US_TaxFreeDefinedValue31	_Item	US_TaxFreeDefinedValue31	Extension Field 031
	US_TaxFreeDefinedValue32	_Item	US_TaxFreeDefinedValue32	Extension Field 032
	US_TaxFreeDefinedValue33	_Item	US_TaxFreeDefinedValue33	Extension Field 033
	US_TaxFreeDefinedValue34	_Item	US_TaxFreeDefinedValue34	Extension Field 034
	US_TaxFreeDefinedValue35	_Item	US_TaxFreeDefinedValue35	Extension Field 035
	US_TaxFreeDefinedValue36	_Item	US_TaxFreeDefinedValue36	Extension Field 036
	US_TaxFreeDefinedValue37	_Item	US_TaxFreeDefinedValue37	Extension Field 037
	US_TaxFreeDefinedValue38	_Item	US_TaxFreeDefinedValue38	Extension Field 038
	US_TaxFreeDefinedValue39	_Item	US_TaxFreeDefinedValue39	Extension Field 039
	US_TaxFreeDefinedValue40	_Item	US_TaxFreeDefinedValue40	Extension Field 040
	US_TaxFreeDefinedValue41	_Item	US_TaxFreeDefinedValue41	Extension Field 041
	US_TaxFreeDefinedValue42	_Item	US_TaxFreeDefinedValue42	Extension Field 042
	US_TaxFreeDefinedValue43	_Item	US_TaxFreeDefinedValue43	Extension Field 043
	US_TaxFreeDefinedValue44	_Item	US_TaxFreeDefinedValue44	Extension Field 044
	US_TaxFreeDefinedValue45	_Item	US_TaxFreeDefinedValue45	Extension Field 045
	US_TaxFreeDefinedValue46	_Item	US_TaxFreeDefinedValue46	Extension Field 046
	US_TaxFreeDefinedValue47	_Item	US_TaxFreeDefinedValue47	Extension Field 047
	US_TaxFreeDefinedValue48	_Item	US_TaxFreeDefinedValue48	Extension Field 048
	US_TaxFreeDefinedValue49	_Item	US_TaxFreeDefinedValue49	Extension Field 049
	US_TaxFreeDefinedValue50	_Item	US_TaxFreeDefinedValue50	Extension Field 050
	_Document		_Document
	_Item		_Item
	_US_TaxState		_US_TaxState
	_TaxSourcing		_TaxSourcing
	_Product		_Product
	_MaterialGroup		_MaterialGroup
	_TaxCalculationProcedure		_TaxCalculationProcedure
	_TaxCode		_TaxCode
	_PurchasingDocument		_PurchasingDocument
	_BillingDocument		_BillingDocument
	_UnitedStatesTaxCategory		_UnitedStatesTaxCategory
	_CompanyCode		_CompanyCode
	_FiscalYear		_FiscalYear
	_JournalEntry		_JournalEntry
	_GLAccount		_GLAccount
	_TransactionCurrency		_TransactionCurrency
	_CompanyCodeCurrency		_CompanyCodeCurrency

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_US_TaxPartnerTaxDocItemCube.
-- 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: IUSTXPTDITEMCUBE

CREATE VIEW I_US_TaxPartnerTaxDocItemCube AS
SELECT
  _JurisdictionLevel.US_TaxPartnerTaxDocument AS US_TaxPartnerTaxDocument,
  _JurisdictionLevel.US_TaxPartnerTaxDocumentItem AS US_TaxPartnerTaxDocumentItem,
  _JurisdictionLevel.TaxJurisdictionLevel AS TaxJurisdictionLevel,
  _JurisdictionLevel.US_TaxState AS US_TaxState,
  _JurisdictionLevel.UnitedStatesTaxSourcing AS UnitedStatesTaxSourcing,
  _JurisdictionLevel.TaxJurisdiction AS TaxJurisdiction,
  _JurisdictionLevel.TaxJurisdictionText AS TaxJurisdictionText,
  cast( _Item.US_TaxProduct as productnumber ) AS Product,
  _Item.MaterialGroup AS MaterialGroup,
  _Document.TaxCalculationProcedure AS TaxCalculationProcedure,
  _Item.TaxCode AS TaxCode,
  _Item.PurchasingDocument AS PurchasingDocument,
  _Item.SDDocument AS SDDocument,
  _Item.UnitedStatesTaxCategory AS UnitedStatesTaxCategory,
  _Document.CompanyCode AS CompanyCode,
  _Document.AccountingDocument AS AccountingDocument,
  _Document.FiscalYear AS FiscalYear,
  _JurisdictionLevel.GLAccount AS GLAccount,
  _JurisdictionLevel.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  _JurisdictionLevel.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  _JurisdictionLevel.TaxExemptionAmount AS TaxExemptionAmount,
  _Document.TransactionCurrency AS TransactionCurrency,
  _JurisdictionLevel.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  _JurisdictionLevel.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _Document.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.PostingDate AS PostingDate,
  _Item.DocumentDate AS DocumentDate,
  _Item.ServicesRenderedDate AS ServicesRenderedDate,
  _Item.US_TaxPartnerReceivedTaxDate AS US_TaxPartnerReceivedTaxDate,
  _Item.TaxCalculationDate AS TaxCalculationDate,
  _Item.US_TaxFreeDefinedValue1 AS US_TaxFreeDefinedValue1,
  _Item.US_TaxFreeDefinedValue2 AS US_TaxFreeDefinedValue2,
  _Item.US_TaxFreeDefinedValue3 AS US_TaxFreeDefinedValue3,
  _Item.US_TaxFreeDefinedValue4 AS US_TaxFreeDefinedValue4,
  _Item.US_TaxFreeDefinedValue5 AS US_TaxFreeDefinedValue5,
  _Item.US_TaxFreeDefinedValue6 AS US_TaxFreeDefinedValue6,
  _Item.US_TaxFreeDefinedValue7 AS US_TaxFreeDefinedValue7,
  _Item.US_TaxFreeDefinedValue8 AS US_TaxFreeDefinedValue8,
  _Item.US_TaxFreeDefinedValue9 AS US_TaxFreeDefinedValue9,
  _Item.US_TaxFreeDefinedValue10 AS US_TaxFreeDefinedValue10,
  _Item.US_TaxFreeDefinedValue11 AS US_TaxFreeDefinedValue11,
  _Item.US_TaxFreeDefinedValue12 AS US_TaxFreeDefinedValue12,
  _Item.US_TaxFreeDefinedValue13 AS US_TaxFreeDefinedValue13,
  _Item.US_TaxFreeDefinedValue14 AS US_TaxFreeDefinedValue14,
  _Item.US_TaxFreeDefinedValue15 AS US_TaxFreeDefinedValue15,
  _Item.US_TaxFreeDefinedValue16 AS US_TaxFreeDefinedValue16,
  _Item.US_TaxFreeDefinedValue17 AS US_TaxFreeDefinedValue17,
  _Item.US_TaxFreeDefinedValue18 AS US_TaxFreeDefinedValue18,
  _Item.US_TaxFreeDefinedValue19 AS US_TaxFreeDefinedValue19,
  _Item.US_TaxFreeDefinedValue20 AS US_TaxFreeDefinedValue20,
  _Item.US_TaxFreeDefinedValue21 AS US_TaxFreeDefinedValue21,
  _Item.US_TaxFreeDefinedValue22 AS US_TaxFreeDefinedValue22,
  _Item.US_TaxFreeDefinedValue23 AS US_TaxFreeDefinedValue23,
  _Item.US_TaxFreeDefinedValue24 AS US_TaxFreeDefinedValue24,
  _Item.US_TaxFreeDefinedValue25 AS US_TaxFreeDefinedValue25,
  _Item.US_TaxFreeDefinedValue26 AS US_TaxFreeDefinedValue26,
  _Item.US_TaxFreeDefinedValue27 AS US_TaxFreeDefinedValue27,
  _Item.US_TaxFreeDefinedValue28 AS US_TaxFreeDefinedValue28,
  _Item.US_TaxFreeDefinedValue29 AS US_TaxFreeDefinedValue29,
  _Item.US_TaxFreeDefinedValue30 AS US_TaxFreeDefinedValue30,
  _Item.US_TaxFreeDefinedValue31 AS US_TaxFreeDefinedValue31,
  _Item.US_TaxFreeDefinedValue32 AS US_TaxFreeDefinedValue32,
  _Item.US_TaxFreeDefinedValue33 AS US_TaxFreeDefinedValue33,
  _Item.US_TaxFreeDefinedValue34 AS US_TaxFreeDefinedValue34,
  _Item.US_TaxFreeDefinedValue35 AS US_TaxFreeDefinedValue35,
  _Item.US_TaxFreeDefinedValue36 AS US_TaxFreeDefinedValue36,
  _Item.US_TaxFreeDefinedValue37 AS US_TaxFreeDefinedValue37,
  _Item.US_TaxFreeDefinedValue38 AS US_TaxFreeDefinedValue38,
  _Item.US_TaxFreeDefinedValue39 AS US_TaxFreeDefinedValue39,
  _Item.US_TaxFreeDefinedValue40 AS US_TaxFreeDefinedValue40,
  _Item.US_TaxFreeDefinedValue41 AS US_TaxFreeDefinedValue41,
  _Item.US_TaxFreeDefinedValue42 AS US_TaxFreeDefinedValue42,
  _Item.US_TaxFreeDefinedValue43 AS US_TaxFreeDefinedValue43,
  _Item.US_TaxFreeDefinedValue44 AS US_TaxFreeDefinedValue44,
  _Item.US_TaxFreeDefinedValue45 AS US_TaxFreeDefinedValue45,
  _Item.US_TaxFreeDefinedValue46 AS US_TaxFreeDefinedValue46,
  _Item.US_TaxFreeDefinedValue47 AS US_TaxFreeDefinedValue47,
  _Item.US_TaxFreeDefinedValue48 AS US_TaxFreeDefinedValue48,
  _Item.US_TaxFreeDefinedValue49 AS US_TaxFreeDefinedValue49,
  _Item.US_TaxFreeDefinedValue50 AS US_TaxFreeDefinedValue50
FROM I_US_TxPartTxJurisdictionLevel AS _JurisdictionLevel
LEFT OUTER JOIN I_US_TaxPartnerTaxDocument AS _Document ON US_TaxPartnerTaxDocument = _Document.US_TaxPartnerTaxDocument  -- association [0..1]
LEFT OUTER JOIN I_US_TaxPartnerTaxDocumentItem AS _Item ON US_TaxPartnerTaxDocument = _Item.US_TaxPartnerTaxDocument AND US_TaxPartnerTaxDocumentItem = _Item.US_TaxPartnerTaxDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_US_TaxState AS _US_TaxState ON US_TaxState = _US_TaxState.US_TaxState  -- association [0..1]
LEFT OUTER JOIN I_UnitedStatesTaxSourcing AS _TaxSourcing ON UnitedStatesTaxSourcing = _TaxSourcing.UnitedStatesTaxSourcing  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _MaterialGroup ON materialgroup = _MaterialGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON taxcalculationprocedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON taxcalculationprocedure = _TaxCode.TaxCalculationProcedure AND taxcode = _TaxCode.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchasingDocument ON purchasingdocument = _PurchasingDocument.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON sddocument = _BillingDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_UnitedStatesTaxCategory AS _UnitedStatesTaxCategory ON unitedstatestaxcategory = _UnitedStatesTaxCategory.UnitedStatesTaxCategory  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON fiscalyear = _FiscalYear.FiscalYear AND companycode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON companycode = _JournalEntry.CompanyCode AND fiscalyear = _JournalEntry.FiscalYear AND accountingdocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND companycode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON transactioncurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON companycodecurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
;

Depth:

I_US_TaxPartnerTaxDocItemCube view

I_US_TxPartTxJurisdictionLevel view

C_US_TaxPartnerTaxDocItemQuery view