_TAXITEM

74 Fields

_TAXITEM is an SAP database table in S/4HANA. It contains 74 fields.

Fields (74)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY BillingDocumentItem BillingDocumentItem 1
KEY BusinessPlace BusinessPlace 4
KEY CompanyCode CompanyCode 7
KEY FiscalYear FiscalYear 5
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY TaxBox TaxBox 2
KEY TaxBoxStructureType TaxBoxStructureType 4
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 8
KEY TaxCode TaxCode 6
KEY TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef 1
KEY TaxType TaxType 3
KEY TransactionTypeDetermination TransactionTypeDetermination 2
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 6
AccountingDocumentType AccountingDocumentType 1
ActiveCountry ActiveCountry 1
AddressLine1 AddressLine1 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
BillingDocumentType BillingDocumentType 1
BillingQuantity BillingQuantity 1
BillingQuantityUnit BillingQuantityUnit 1
BOMHasHeaderInfoRecord BOMHasHeaderInfoRecord 1
BusinessPartner BusinessPartner 2
BusinessPartnerName BusinessPartnerName 1
CAReconciliationKey CAReconciliationKey 1
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 2
CompanyCodeParameterValue CompanyCodeParameterValue 1
ContractOptionsBuyerSellerName ContractOptionsBuyerSellerName 1
CostPricePerUnit CostPricePerUnit 1
Country Country 2
CountryThreeLetterISOCode CountryThreeLetterISOCode 1
Customer Customer 1
DebitCreditCode DebitCreditCode 2
DocumentCurrency DocumentCurrency 2
DocumentDate DocumentDate 2
EligibleAmountForCashDiscount EligibleAmountForCashDiscount 1
EmailAddress EmailAddress 1
GLAccount GLAccount 2
GLAccountName GLAccountName 1
IN_GSTDocumentType IN_GSTDocumentType 1
IN_GSTPlaceOfSupply IN_GSTPlaceOfSupply 1
IN_GSTSection IN_GSTSection 1
ItemGroup ItemGroup 1
LuxuryTaxRate LuxuryTaxRate 1
Material Material 1
MaterialType MaterialType 1
OriginalTaxBaseAmount OriginalTaxBaseAmount 1
OriglTaxBaseAmountInCoCodeCrcy OriglTaxBaseAmountInCoCodeCrcy 1
PerInvoicePrcUnitAmount PerInvoicePrcUnitAmount 1
PostingDate PostingDate 4
ReferenceDocumentType ReferenceDocumentType 1
ReportingCurrency ReportingCurrency 1
SalesOrganization SalesOrganization 1
SoldToPartyTaxNumber SoldToPartyTaxNumber 1
Supplier Supplier 1
TaxAmount TaxAmount 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 3
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 2
TaxBoxCondition TaxBoxCondition 1
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 5
TaxIsNotDeductible TaxIsNotDeductible 1
TaxItem TaxItem 1
TaxItemGroup TaxItemGroup 1
TaxNumber1 TaxNumber1 1
TaxNumber3 TaxNumber3 1
TaxNumber5 TaxNumber5 1
TaxRate TaxRate 3
TaxRateValidityStartDate TaxRateValidityStartDate 5
TaxReportingDate TaxReportingDate 3
UnitedStatesTaxCategoryName UnitedStatesTaxCategoryName 1

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,
    BILLINGDOCUMENTITEM,
    BUSINESSPLACE,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCODE,
    TAXITEMACCTGDOCITEMREF,
    TAXTYPE,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ACTIVECOUNTRY,
    ADDRESSLINE1,
    AMOUNTINCOMPANYCODECURRENCY,
    BILLINGDOCUMENTTYPE,
    BILLINGQUANTITY,
    BILLINGQUANTITYUNIT,
    BOMHASHEADERINFORECORD,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME,
    CARECONCILIATIONKEY,
    CASHDISCOUNTAMTINCOCODECRCY,
    COMPANYCODECURRENCY,
    COMPANYCODEPARAMETERVALUE,
    CONTRACTOPTIONSBUYERSELLERNAME,
    COSTPRICEPERUNIT,
    COUNTRY,
    COUNTRYTHREELETTERISOCODE,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    ELIGIBLEAMOUNTFORCASHDISCOUNT,
    EMAILADDRESS,
    GLACCOUNT,
    GLACCOUNTNAME,
    IN_GSTDOCUMENTTYPE,
    IN_GSTPLACEOFSUPPLY,
    IN_GSTSECTION,
    ITEMGROUP,
    LUXURYTAXRATE,
    MATERIAL,
    MATERIALTYPE,
    ORIGINALTAXBASEAMOUNT,
    ORIGLTAXBASEAMOUNTINCOCODECRCY,
    PERINVOICEPRCUNITAMOUNT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCURRENCY,
    SALESORGANIZATION,
    SOLDTOPARTYTAXNUMBER,
    SUPPLIER,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBOXCONDITION,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXISNOTDEDUCTIBLE,
    TAXITEM,
    TAXITEMGROUP,
    TAXNUMBER1,
    TAXNUMBER3,
    TAXNUMBER5,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    UNITEDSTATESTAXCATEGORYNAME,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BILLINGDOCUMENTITEM, BUSINESSPLACE, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXCODE, TAXITEMACCTGDOCITEMREF, TAXTYPE, TRANSACTIONTYPEDETERMINATION, UNIFIEDTAXBOXSTRUCTURETYPE)
);

Learn More