TAXITEM

191 Fields

TAXITEM is an SAP database table in S/4HANA. It contains 191 fields.

Fields (191)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,TaxTransferDocument 27
KEY AccountingDocumentItem AccountingDocumentItem 4
KEY AccountingDocumentType AccountingDocumentType 8
KEY CAClearingDocumentNumber CAClearingDocumentNumber 1
KEY CADocumentNumber CADocumentNumber 1
KEY CAGLItemNumber CAGLItemNumber 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CARptgTaxItemOriginType CARptgTaxItemOriginType 1
KEY CASubItemNumber CASubItemNumber 1
KEY CompanyCode CompanyCode,CompanyCode2 39
KEY Country Country 6
KEY FiscalYear FiscalYear 27
KEY MX_DIOTOperationType MX_DIOTOperationType 8
KEY MX_SupplierType MX_SupplierType 8
KEY PaymentDocument PaymentDocument 4
KEY PostingDate PostingDate 20
KEY SenderFiscalYear SenderFiscalYear 6
KEY StatryRptCategory StatryRptCategory 16
KEY StatryRptgEntity StatryRptgEntity 16
KEY StatryRptRunID StatryRptRunID 16
KEY Supplier Supplier 9
KEY TaxBox TaxBox 12
KEY TaxBoxStructureType TaxBoxStructureType 7
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 4
KEY TaxCode T_TaxCode,TaxCode 36
KEY TaxDeclnAmountType TaxDeclnAmountType 7
KEY TaxGroup TaxGroup 12
KEY TaxItem AccountingDocumentItem,TaxItem 20
KEY TaxItemGroup T_TaxItemGroup,TaxItemGroup 6
KEY TaxItemGroupingVersion TaxItemGroupingVersion 8
KEY TaxItemUUID TaxItemUUID 1
KEY TaxRateValidityStartDate TaxRateValidityStartDate 9
KEY TaxTransferDocument TaxTransferDocument 4
KEY TaxTransferDocumentYear TaxTransferDocumentYear 4
KEY TransactionTypeDetermination TransactionTypeDetermination 21
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 1
KEY ValidFrom ValidFrom 6
_AccountingDocument _AccountingDocument 2
_CompanyCodeCountry _CompanyCodeCountry 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_Currency _Currency 1
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem 1
_GLAccount _GLAccount 1
_JournalEntry _JournalEntry 1
_OneTimeAccountBP _OneTimeAccountBP 2
_ReceivablesPayablesItem _ReceivablesPayablesItem 2
_ReportedItemsLog _ReportedItemsLog 1
_TaxJurisdiction _TaxJurisdiction 2
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem 1
AccountingDocumentClass AccountingDocumentClass 1
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency2 AdditionalCurrency2 3
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 2
AmountInTransactionCurrency AmountInTransactionCurrency 2
AR_Branch AR_Branch 2
AR_CAE AR_CAE 2
AR_CAEInvoiceDueDate AR_CAEInvoiceDueDate 2
AR_OfficialDocumentNumber AR_OfficialDocumentNumber 2
AR_PrintCharacter AR_PrintCharacter 2
AssetAdditionalDescription AssetAdditionalDescription 1
BillingDocument BillingDocument 1
BPCountry BPCountry 1
Branch Branch 1
BusinessPartner BusinessPartner 6
BusinessPartnerCountry BusinessPartnerCountry 3
BusinessPartnerName BusinessPartnerName 8
BusinessPlace BusinessPlace 12
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer 1
CAReconciliationKey CAReconciliationKey 1
CARptgSrceReference CARptgSrceReference 3
CARptgSrceRefType CARptgSrceRefType 3
CATransactionKeyAccountDetn CATransactionKeyAccountDetn,TransactionTypeDetermination 2
CompanyCodeCountry CompanyCodeCountry 4
CompanyCodeCurrency CompanyCodeCurrency 16
ConditionRecord ConditionRecord 1
ConditionType ConditionType 2
CountryCurrency CountryCurrency 3
CountryThreeLetterISOCode CountryThreeLetterISOCode 4
Customer Customer 2
CustomerCountry CustomerCountry 2
DebitCreditCode DebitCreditCode,T_DebitCreditCode 7
DestinationCountry DestinationCountry 1
DocumentCurrency DocumentCurrency 6
DocumentDate DocumentDate 17
DocumentReferenceID DocumentReferenceID 5
ExchangeRate ExchangeRate 2
ExchangeRateDate ExchangeRateDate 1
FiscalPeriod FiscalPeriod 15
FiscalPeriodEndDate FiscalPeriodEndDate 4
FixedAssetDescription FixedAssetDescription 1
FormatCode AccountingDocumentClass 1
GLAccount GLAccount 16
haveonlyonebset haveonlyonebset 1
IsDocumentFromSD IsDocumentFromSD 1
IsEuropeanUnionMember IsEuropeanUnionMember 1
IsNaturalPerson IsNaturalPerson 2
IsReversal IsReversal 3
IsReversed IsReversed 3
Isvstmst Isvstmst 1
LogicalSystem LogicalSystem 2
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 3
MX_BorderClassification MX_BorderClassification 5
MX_FiscalEffectManifest MX_FiscalEffectManifest 5
MX_FullAddressText MX_FullAddressText 3
NationalityName NationalityName 3
NmbrOfPages NmbrOfPages 1
OriginalReferenceDocument OriginalReferenceDocument 2
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
ReferenceDocumentType ReferenceDocumentType 5
ReportingCountry ReportingCountry 5
ReportingCurrency Currency,ReportingCurrency 13
ReportingDate ReportingDate 16
ReversalReferenceDocument ReversalReferenceDocument 2
ReverseDocument ReverseDocument 3
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
SalesDocument SalesDocument 1
SenderAccountingDocument SenderAccountingDocument 2
SenderCompanyCode SenderCompanyCode 2
SoldToParty SoldToParty 1
SupplierCountry SupplierCountry 2
SupplyingCountry SupplyingCountry 1
TaiwaneseCalendarYear TaiwaneseCalendarYear 1
TaxAmount TaxAmount 9
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 4
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 3
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy,TaxAmt 8
TaxAmountInCountryCrcy TaxAmountInCountryCrcy 2
TaxAmountInRptgCrcy TaxAmountInCoCodeCrcy,TaxAmountInRptgCrcy 7
TaxAmountInRptgCrcy_sum TaxAmountInRptgCrcy_sum 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy,TaxBaseAmt 11
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 7
TaxBaseAmountInRptgCrcy_sum TaxBaseAmountInRptgCrcy_sum 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy,TaxBaseAmtTcc 8
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 4
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 4
TaxBox08AmtInReportingCurrency TaxBox08AmtInReportingCurrency 2
TaxBox09AmtInReportingCurrency TaxBox09AmtInReportingCurrency 2
TaxBox10AmtInReportingCurrency TaxBox10AmtInReportingCurrency 2
TaxBox11AmtInReportingCurrency TaxBox11AmtInReportingCurrency 2
TaxBox12AmtInReportingCurrency TaxBox12AmtInReportingCurrency 2
TaxBox13AmtInReportingCurrency TaxBox13AmtInReportingCurrency 2
TaxBox14AmtInReportingCurrency TaxBox14AmtInReportingCurrency 2
TaxBox15AmtInReportingCurrency TaxBox15AmtInReportingCurrency 2
TaxBox16AmtInReportingCurrency TaxBox16AmtInReportingCurrency 2
TaxBox17AmtInReportingCurrency TaxBox17AmtInReportingCurrency 2
TaxBox18AmtInReportingCurrency TaxBox18AmtInReportingCurrency 2
TaxBox19AmtInReportingCurrency TaxBox19AmtInReportingCurrency 2
TaxBox20AmtInReportingCurrency TaxBox20AmtInReportingCurrency 2
TaxBox21AmtInReportingCurrency TaxBox21AmtInReportingCurrency 2
TaxBox22AmtInReportingCurrency TaxBox22AmtInReportingCurrency 2
TaxBox23AmtInReportingCurrency TaxBox23AmtInReportingCurrency 2
TaxBox24AmtInReportingCurrency TaxBox24AmtInReportingCurrency 2
TaxBox25AmtInReportingCurrency TaxBox25AmtInReportingCurrency 2
TaxBox26AmtInReportingCurrency TaxBox26AmtInReportingCurrency 2
TaxBox27AmtInReportingCurrency TaxBox27AmtInReportingCurrency 2
TaxBox29AmtInReportingCurrency TaxBox29AmtInReportingCurrency 2
TaxBox30AmtInReportingCurrency TaxBox30AmtInReportingCurrency 2
TaxBox31AmtInReportingCurrency TaxBox31AmtInReportingCurrency 2
TaxBox32AmtInReportingCurrency TaxBox32AmtInReportingCurrency 2
TaxBox33AmtInReportingCurrency TaxBox33AmtInReportingCurrency 2
TaxBoxConfiguration TaxBoxConfiguration 1
TaxBoxStructure TaxBoxStructure 1
TaxBoxStructureName TaxBoxStructureName 1
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 4
TaxCalculationProcedure TaxCalculationProcedure 5
TaxCountry TaxCountry 1
TaxDataSource TaxDataSource 1
TaxDeterminationDate TaxDeterminationDate 1
TaxGroupFreeClassification TaxGroupFreeClassification 1
TaxGroupOperation TaxGroupOperation 1
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef 1
TaxJurisdiction TaxJurisdiction 7
TaxJurisdictionLevel TaxJurisdictionLevel 1
TaxNumber1 TaxNumber1 6
TaxNumber2 TaxNumber2 2
TaxNumber3 TaxNumber3 1
TaxNumberResponsible TaxNumberResponsible 5
TaxRate TaxRate 12
TaxReportingDate TaxReportingDate 10
TaxReportingDocumentDate TaxReportingDocumentDate 3
TaxResultManualModification TaxResultManualModification 1
TaxReturnCountry TaxReturnCountry 2
TaxReturnDate TaxReturnDate 1
TaxReturnExecutionTime TaxReturnExecutionTime 1
TaxType TaxType 14
TransactionCurrency TransactionCurrency 2
ValidTo ValidTo 1
VATRegistration VATRegistration 3
WhldgTaxAmtInReportingCrcy WhldgTaxAmtInReportingCrcy 1
YearMonth YearMonth 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TAXITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    CACLEARINGDOCUMENTNUMBER,
    CADOCUMENTNUMBER,
    CAGLITEMNUMBER,
    CAREPETITIONITEMNUMBER,
    CARPTGTAXITEMORIGINTYPE,
    CASUBITEMNUMBER,
    COMPANYCODE,
    COUNTRY,
    FISCALYEAR,
    MX_DIOTOPERATIONTYPE,
    MX_SUPPLIERTYPE,
    PAYMENTDOCUMENT,
    POSTINGDATE,
    SENDERFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUP,
    TAXITEMGROUPINGVERSION,
    TAXITEMUUID,
    TAXRATEVALIDITYSTARTDATE,
    TAXTRANSFERDOCUMENT,
    TAXTRANSFERDOCUMENTYEAR,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    VALIDFROM,
    _ACCOUNTINGDOCUMENT,
    _COMPANYCODECOUNTRY,
    _COMPANYCODECURRENCY,
    _CURRENCY,
    _DEBTORCREDITORRBLSPYBLSITEM,
    _GLACCOUNT,
    _JOURNALENTRY,
    _ONETIMEACCOUNTBP,
    _RECEIVABLESPAYABLESITEM,
    _REPORTEDITEMSLOG,
    _TAXJURISDICTION,
    _TAXRECEIVABLESPAYABLESITEM,
    ACCOUNTINGDOCUMENTCLASS,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINTRANSACTIONCURRENCY,
    AR_BRANCH,
    AR_CAE,
    AR_CAEINVOICEDUEDATE,
    AR_OFFICIALDOCUMENTNUMBER,
    AR_PRINTCHARACTER,
    ASSETADDITIONALDESCRIPTION,
    BILLINGDOCUMENT,
    BPCOUNTRY,
    BRANCH,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    CADOCUMENTTYPEFORGLTRANSFER,
    CARECONCILIATIONKEY,
    CARPTGSRCEREFERENCE,
    CARPTGSRCEREFTYPE,
    CATRANSACTIONKEYACCOUNTDETN,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONRECORD,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    COUNTRYTHREELETTERISOCODE,
    CUSTOMER,
    CUSTOMERCOUNTRY,
    DEBITCREDITCODE,
    DESTINATIONCOUNTRY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    FISCALPERIOD,
    FISCALPERIODENDDATE,
    FIXEDASSETDESCRIPTION,
    FORMATCODE,
    GLACCOUNT,
    HAVEONLYONEBSET,
    ISDOCUMENTFROMSD,
    ISEUROPEANUNIONMEMBER,
    ISNATURALPERSON,
    ISREVERSAL,
    ISREVERSED,
    ISVSTMST,
    LOGICALSYSTEM,
    LOWESTLEVELTAXJURISDICTION,
    MX_BORDERCLASSIFICATION,
    MX_FISCALEFFECTMANIFEST,
    MX_FULLADDRESSTEXT,
    NATIONALITYNAME,
    NMBROFPAGES,
    ORIGINALREFERENCEDOCUMENT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSALREFERENCEDOCUMENT,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SALESDOCUMENT,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SOLDTOPARTY,
    SUPPLIERCOUNTRY,
    SUPPLYINGCOUNTRY,
    TAIWANESECALENDARYEAR,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXAMOUNTINRPTGCRCY_SUM,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINRPTGCRCY_SUM,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXBOX08AMTINREPORTINGCURRENCY,
    TAXBOX09AMTINREPORTINGCURRENCY,
    TAXBOX10AMTINREPORTINGCURRENCY,
    TAXBOX11AMTINREPORTINGCURRENCY,
    TAXBOX12AMTINREPORTINGCURRENCY,
    TAXBOX13AMTINREPORTINGCURRENCY,
    TAXBOX14AMTINREPORTINGCURRENCY,
    TAXBOX15AMTINREPORTINGCURRENCY,
    TAXBOX16AMTINREPORTINGCURRENCY,
    TAXBOX17AMTINREPORTINGCURRENCY,
    TAXBOX18AMTINREPORTINGCURRENCY,
    TAXBOX19AMTINREPORTINGCURRENCY,
    TAXBOX20AMTINREPORTINGCURRENCY,
    TAXBOX21AMTINREPORTINGCURRENCY,
    TAXBOX22AMTINREPORTINGCURRENCY,
    TAXBOX23AMTINREPORTINGCURRENCY,
    TAXBOX24AMTINREPORTINGCURRENCY,
    TAXBOX25AMTINREPORTINGCURRENCY,
    TAXBOX26AMTINREPORTINGCURRENCY,
    TAXBOX27AMTINREPORTINGCURRENCY,
    TAXBOX29AMTINREPORTINGCURRENCY,
    TAXBOX30AMTINREPORTINGCURRENCY,
    TAXBOX31AMTINREPORTINGCURRENCY,
    TAXBOX32AMTINREPORTINGCURRENCY,
    TAXBOX33AMTINREPORTINGCURRENCY,
    TAXBOXCONFIGURATION,
    TAXBOXSTRUCTURE,
    TAXBOXSTRUCTURENAME,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXCALCULATIONPROCEDURE,
    TAXCOUNTRY,
    TAXDATASOURCE,
    TAXDETERMINATIONDATE,
    TAXGROUPFREECLASSIFICATION,
    TAXGROUPOPERATION,
    TAXITEMACCTGDOCITEMREF,
    TAXJURISDICTION,
    TAXJURISDICTIONLEVEL,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBERRESPONSIBLE,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXRESULTMANUALMODIFICATION,
    TAXRETURNCOUNTRY,
    TAXRETURNDATE,
    TAXRETURNEXECUTIONTIME,
    TAXTYPE,
    TRANSACTIONCURRENCY,
    VALIDTO,
    VATREGISTRATION,
    WHLDGTAXAMTINREPORTINGCRCY,
    YEARMONTH,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCOUNTINGDOCUMENTTYPE, CACLEARINGDOCUMENTNUMBER, CADOCUMENTNUMBER, CAGLITEMNUMBER, CAREPETITIONITEMNUMBER, CARPTGTAXITEMORIGINTYPE, CASUBITEMNUMBER, COMPANYCODE, COUNTRY, FISCALYEAR, MX_DIOTOPERATIONTYPE, MX_SUPPLIERTYPE, PAYMENTDOCUMENT, POSTINGDATE, SENDERFISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIER, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUP, TAXITEMGROUPINGVERSION, TAXITEMUUID, TAXRATEVALIDITYSTARTDATE, TAXTRANSFERDOCUMENT, TAXTRANSFERDOCUMENTYEAR, TRANSACTIONTYPEDETERMINATION, UNIFIEDTAXBOXSTRUCTURETYPE, VALIDFROM)
);

Learn More