Which CDS Views use I_TAXITEM?

I_TAXITEM is used by 55 CDS view(s), including: C_CA_StRpGSTItemCube, C_IN_AcctgDocTaxItem, C_PE_StRpJournalEntryWithTax, FAC_DART_Z3_JOURNAL_ENTRY, FAC_DART_Z3_TAX_LINEITEM_BASE, I_IN_EDocGSTPurRegTaxItem, I_PL_SAFTGetDownPayAll, I_PL_SAFTGetDownPaymentHeader, I_PL_SAFTGetInvoiceHeader, I_SAFTAccountingTaxCheck.

I_TAXITEM

Q: How many fields does I_TAXITEM have?

I_TAXITEM has 79 fields. Key fields: AccountingDocument, CompanyCode, FiscalYear, TaxCode, TaxItem, TaxItemAcctgDocItemRef, TaxItemUUID, TransactionTypeDetermination.

CDS View

79 Fields 55 CDS Views

Tax Item

I_TAXITEM is a CDS View in S/4HANA. Tax Item. It contains 79 fields. 55 CDS views read from this table.

CDS Views using this table (55)

View	Type	Join	VDM	Description
C_CA_StRpGSTItemCube	view	left_outer	CONSUMPTION	Canada GST Tax Item Details
C_IN_AcctgDocTaxItem	view	from	CONSUMPTION	Accounting Document Tax Item details
C_PE_StRpJournalEntryWithTax	view	inner	CONSUMPTION	Peru journal entries with tax
FAC_DART_Z3_JOURNAL_ENTRY	view	left_outer		DART Z3 G/L Accounts-Line Items
FAC_DART_Z3_TAX_LINEITEM_BASE	view	from		Tax - Line Items Base View
I_IN_EDocGSTPurRegTaxItem	view_entity	inner	COMPOSITE	India GST Purchase Register Tax Item
I_PL_SAFTGetDownPayAll	view_entity	inner	COMPOSITE	SAFT PL FA DonwPaymentAll
I_PL_SAFTGetDownPaymentHeader	view_entity	inner	COMPOSITE	SAF T PL Down Payment Header
I_PL_SAFTGetInvoiceHeader	view_entity	inner	COMPOSITE	SAFT PL FA Invoice Header
I_SAFTAccountingTaxCheck	view	from	COMPOSITE	SAF-T Accounting Tax Check
P_AR_StRpTaxJournalEntryItem	view_entity	from	COMPOSITE
P_AR_StRpVatPrcptnTaxItem	view_entity	from	COMPOSITE
P_AR_TaxItem	view	from	CONSUMPTION
P_AUDIT_AT_BSET	view_entity	inner	COMPOSITE	Austrian Audit Journal Tax Data
P_BaseAmtForNegativeCharge	view	from	COMPOSITE
P_GB_AROpenItem	view_entity	inner	COMPOSITE	Great Britain AR Open items
P_HR_TaxItem	view_entity	from	COMPOSITE
P_HU_ReverseItem	view_entity	inner	CONSUMPTION
P_HU_STRPINVOICECOUNTRY	view	from	COMPOSITE
P_ID_StRpTaxItemBoxCube	view	inner	COMPOSITE
P_IN_RvsChrgAcctgDocTaxItem	view_entity	from	COMPOSITE
P_KR_EDCJrnlEntrTxItm	view_entity	from	COMPOSITE	KR Cons. Checks- Tax Items
P_KR_TaxInvoice06	view	from	CONSUMPTION
P_LU_SAFTDPZeroTaxLine	view	inner	COMPOSITE
P_LU_SAFTTaxItem	view	from	COMPOSITE
P_LU_SAFTZeroTaxLine	view	inner	COMPOSITE
P_ManageJournalEntryTaxItem	view_entity	from	COMPOSITE
P_NO_SAFTTaxAmountSum	view_entity	inner	COMPOSITE
P_NO_SAFTTaxAmountSum	view_entity	union	COMPOSITE
P_NO_SAFTTaxAmountSum	view_entity	from	COMPOSITE
P_NO_SAFTTaxSpGL	view	from	COMPOSITE
P_PE_PurDmstcSuplrTaxItem	view	inner	CONSUMPTION
P_PE_PurFrgnSuplrTaxItem	view_entity	from	CONSUMPTION
P_PE_SalesTaxItem	view	inner	CONSUMPTION
P_PL_SAFTGETACCOUNTINGINVCDATA	view_entity	inner	COMPOSITE
P_PL_SAFTGetSalesInvoiceData	view_entity	inner	COMPOSITE
P_RO_SAFTNTRPURINVWIAHEADER	view_entity	inner	CONSUMPTION
P_RO_SAFTNTRSLSINVWIAHEADER	view_entity	inner	CONSUMPTION
P_RO_SAFTNTRTAXINFO	view_entity	from	CONSUMPTION
P_RO_SAFTPurInvoiceItemTaxBase	view_entity	inner	CONSUMPTION	Sales Invoice Item Taxbase
P_RO_SAFTSlsInvoiceItemTaxBase	view_entity	inner	CONSUMPTION	Sales Invoice Item Taxbase
P_RU_CommissionTradeInvoice11	view_entity	inner	CONSUMPTION
P_SAFTTaxAmountSum	view	from	COMPOSITE
P_SK_CABsetTaxItem	view_entity	from	COMPOSITE
P_SlsPurListBPTaxItem20	view	from	CONSUMPTION	Sales Purchase List BP Tax Item (Helper)
P_StRpBPTaxItem2	view	from	COMPOSITE
P_StRpTaxItmWithEUTaxClass3	view	from	COMPOSITE
P_TH_TaxCodeRate2	view	from	COMPOSITE
P_TW_AcctgDocLeadingTaxCode	view_entity	inner	COMPOSITE
P_TW_LeadingTaxItem	view_entity	union_all	COMPOSITE
P_TW_TaxItemConsume	view	from	CONSUMPTION	Private Consumption View for TAX ITEM
P_TW_TaxItemLeadingTaxCode	view_entity	from	COMPOSITE
P_TxDocStRpActy1	view	inner	COMPOSITE
R_ES_EDCSalesInvoiceSIITaxItem	view_entity	inner	COMPOSITE	Spain SII Customer Inv TaxLines
R_ES_EDCSuplrInvcSIITaxLine	view_entity	inner	COMPOSITE	Spain Supplier Invoice Tax lines

Fields (79)

Key	Field	CDS Fields	Used in Views
KEY	AccountingDocument	AccountingDocument,belnr	21
KEY	CompanyCode	bukrs,CompanyCode	20
KEY	FiscalYear	FiscalYear,gjahr	19
KEY	TaxCode	mwskz,TaxCode	20
KEY	TaxItem	buzei,TaxItem	17
KEY	TaxItemAcctgDocItemRef	TaxItemAcctgDocItemRef,taxps	4
KEY	TaxItemUUID	TaxItemUUID	1
KEY	TransactionTypeDetermination	ktosl,TransactionTypeDetermination	13
	_CompanyCodeCountry	_CompanyCodeCountry	1
	_CompanyCodeCurrency	_CompanyCodeCurrency	1
	_GLAccount	_GLAccount	1
	_JournalEntry	_JournalEntry	1
	_ReceivablesPayablesItem	_ReceivablesPayablesItem	1
	_TaxJurisdiction	_TaxJurisdiction	1
	AccountingDocumentCategory	AccountingDocumentCategory	1
	AccountingDocumentHeaderText	AccountingDocumentHeaderText	1
	AccountingDocumentType	AccountingDocumentType	1
	AdditionalCurrency1	AdditionalCurrency1	3
	AdditionalCurrency2	AdditionalCurrency2	3
	BusinessPlace	BusinessPlace	3
	CompanyCodeCountry	CompanyCodeCountry,Country	5
	CompanyCodeCurrency	CompanyCodeCurrency	7
	ConditionRecord	ConditionRecord	1
	ConditionType	ConditionType	4
	CountryCurrency	CountryCurrency	5
	DebitCreditCode	DebitCreditCode,DebitCreditCodeCalc,shkzg,TaxDebitCreditCode	8
	DestinationCountry	DestinationCountry,egbld	2
	DocumentCurrency	DocumentCurrency	4
	DocumentDate	DocumentDate	1
	DocumentReferenceID	DocumentReferenceID	1
	ExchangeRate	ExchangeRate	1
	FiscalPeriod	FiscalPeriod	1
	GLAccount	ActiveGLAccount,GLAccount,hkont	6
	IsReversal	IsReversal	1
	IsReversed	IsReversed	1
	Ledger	Ledger	1
	LedgerGroup	LedgerGroup	1
	LowestLevelTaxJurisdiction	LowestLevelTaxJurisdiction	2
	OriginalReferenceDocument	OriginalReferenceDocument	1
	PostingDate	PostingDate	1
	ReferenceDocumentType	ReferenceDocumentType	1
	ReportingCountry	ReportingCountry	1
	ReportingCurrency	ReportingCurrency	1
	ReportingDate	ReportingDate	1
	ReverseDocument	ReverseDocument	1
	ReverseDocumentFiscalYear	ReverseDocumentFiscalYear	1
	SenderAccountingDocument	SenderAccountingDocument	1
	SenderCompanyCode	SenderCompanyCode	1
	SenderFiscalYear	SenderFiscalYear	1
	SenderLogicalSystem	SenderLogicalSystem	1
	SupplyingCountry	eglld,SupplyingCountry	2
	TaxAmount	TaxAmount	4
	TaxAmountInAdditionalCurrency1	TaxAmountInAdditionalCurrency1	2
	TaxAmountInAdditionalCurrency2	TaxAmountInAdditionalCurrency2	2
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	7
	TaxAmountInCountryCrcy	TaxAmountInCountryCrcy	2
	TaxBaseAmountInCoCodeCrcy	TaxableAmount,TaxBaseAmountInCoCodeCrcy	8
	TaxBaseAmountInCountryCrcy	TaxBaseAmountInCountryCrcy	3
	TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy	4
	TaxBaseAmtInAdditionalCrcy1	TaxBaseAmtInAdditionalCrcy1	1
	TaxBaseAmtInAdditionalCrcy2	TaxBaseAmtInAdditionalCrcy2	1
	TaxCalculationProcedure	TaxCalculationProcedure	1
	TaxCodeIsLeading	TaxCodeIsLeading	1
	TaxCountry	TaxCountry	4
	TaxDataSource	TaxDataSource	2
	TaxDeterminationDate	TaxDeterminationDate	1
	TaxFulfillmentDate	TaxFulfillmentDate	1
	TaxItemGroup	TaxItemGroup	4
	TaxItemIsExternal	TaxItemIsExternal	1
	TaxJurisdiction	TaxJurisdiction	4
	TaxJurisdictionLevel	TaxJurisdictionLevel	1
	TaxRate	kbetr,TaxRate	7
	TaxRateValidityStartDate	TaxRateValidityStartDate	1
	TaxReportingDate	mlddt,TaxReportingDate	3
	TaxReportingDocumentDate	TaxReportingDocumentDate	1
	TaxResultManualModification	TaxResultManualModification	1
	TaxReturnCountry	TaxReturnCountry	5
	TaxReturnDate	TaxReturnDate	1
	VATRegistration	stceg,VATRegistration	2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Tax Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TAXITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXCODE,
    TAXITEM,
    TAXITEMACCTGDOCITEMREF,
    TAXITEMUUID,
    TRANSACTIONTYPEDETERMINATION,
    _COMPANYCODECOUNTRY,
    _COMPANYCODECURRENCY,
    _GLACCOUNT,
    _JOURNALENTRY,
    _RECEIVABLESPAYABLESITEM,
    _TAXJURISDICTION,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSPLACE,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONRECORD,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    DEBITCREDITCODE,
    DESTINATIONCOUNTRY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LEDGER,
    LEDGERGROUP,
    LOWESTLEVELTAXJURISDICTION,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    SUPPLYINGCOUNTRY,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXCALCULATIONPROCEDURE,
    TAXCODEISLEADING,
    TAXCOUNTRY,
    TAXDATASOURCE,
    TAXDETERMINATIONDATE,
    TAXFULFILLMENTDATE,
    TAXITEMGROUP,
    TAXITEMISEXTERNAL,
    TAXJURISDICTION,
    TAXJURISDICTIONLEVEL,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXRESULTMANUALMODIFICATION,
    TAXRETURNCOUNTRY,
    TAXRETURNDATE,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXCODE, TAXITEM, TAXITEMACCTGDOCITEMREF, TAXITEMUUID, TRANSACTIONTYPEDETERMINATION)
);

Depth:

I_TAXITEM

CDS Views using this table (55)

Fields (79)

Learn More