TAXBOX_ITEM

52 Fields

TAXBOX_ITEM is an SAP database table in S/4HANA. It contains 52 fields.

Fields (52)

KeyField CDS FieldsUsed in Views
KEY Accountingdocument Accountingdocument 2
KEY Companycode Companycode 2
KEY Fiscalyear Fiscalyear 2
KEY Statryrptcategory Statryrptcategory 2
KEY Statryrptgentity Statryrptgentity 2
KEY Statryrptrunid Statryrptrunid 2
KEY TaxBox TaxBox 2
KEY TaxBoxStructureType TaxBoxStructureType 2
KEY TaxCode TaxCode 2
AccountingDocumentType AccountingDocumentType 2
BusinessPlace BusinessPlace 2
CAReconciliationKey CAReconciliationKey 2
CompanyCodeCurrency CompanyCodeCurrency 2
Country Country 2
Customer Customer 1
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 2
Financialaccounttype Financialaccounttype 1
GLAccount GLAccount 2
Ledger Ledger 2
PostingDate PostingDate 2
ReferenceDocumentType ReferenceDocumentType 2
ReportingDate ReportingDate 2
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBoxCondition TaxBoxCondition 2
TaxBoxName TaxBoxName 2
TaxBoxStructure TaxBoxStructure 2
TaxBoxStructureName TaxBoxStructureName 2
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 2
TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 2
TaxCountry TaxCountry 2
TaxDeclnAmountType TaxDeclnAmountType 2
TaxGroup TaxGroup 2
TaxGroupFreeClassification TaxGroupFreeClassification 2
TaxGroupOperation TaxGroupOperation 2
TaxItem TaxItem 2
TaxItemGroup TaxItemGroup 2
TaxItemGroupingAccountNumber TaxItemGroupingAccountNumber 2
TaxItemGroupingVersion TaxItemGroupingVersion 2
TaxItemGrpgSpecialGLCode SpecialGLCode 1
TaxRate TaxRate 2
TaxRateValidityStartDate TaxRateValidityStartDate 2
TaxReportingDate TaxReportingDate 2
TaxReportingDocumentDate TaxReportingDocumentDate 2
TaxType TaxType 2
TransactionTypeDetermination TransactionTypeDetermination 2
UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 2
ValidFrom ValidFrom 2
ValidTo ValidTo 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 TAXBOX_ITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXCODE,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    COMPANYCODECURRENCY,
    COUNTRY,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    LEDGER,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGDATE,
    SPECIALGLCODE,
    SUPPLIER,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBOXCONDITION,
    TAXBOXNAME,
    TAXBOXSTRUCTURE,
    TAXBOXSTRUCTURENAME,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCOUNTRY,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXGROUPFREECLASSIFICATION,
    TAXGROUPOPERATION,
    TAXITEM,
    TAXITEMGROUP,
    TAXITEMGROUPINGACCOUNTNUMBER,
    TAXITEMGROUPINGVERSION,
    TAXITEMGRPGSPECIALGLCODE,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXTYPE,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    VALIDFROM,
    VALIDTO,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXBOX, TAXBOXSTRUCTURETYPE, TAXCODE)
);

Learn More