TAXDATA

TAXDATA is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 7
KEY AccountingDocumentType AccountingDocumentType 2
KEY CompanyCode CompanyCode 7
KEY FiscalYear FiscalYear 7
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY TaxBox TaxBox 1
KEY TaxCode TaxCode 1
KEY TaxDeclnAmountType TaxDeclnAmountType 1
KEY TaxItemGroupingVersion TaxItemGroupingVersion 1
KEY TransactionTypeDetermination TransactionTypeDetermination 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BusinessPlace BusinessPlace 1
DocumentDate DocumentDate 1
FiscalPeriod FiscalPeriod 1
GLAccount GLAccount 1
PostingDate PostingDate 1
TaxJurisdiction TaxJurisdiction 1
TaxReportingDate TaxReportingDate 1
TaxType TaxType 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 TAXDATA (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXBOX,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPLACE,
    DOCUMENTDATE,
    FISCALPERIOD,
    GLACCOUNT,
    POSTINGDATE,
    TAXJURISDICTION,
    TAXREPORTINGDATE,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXBOX, TAXCODE, TAXDECLNAMOUNTTYPE, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION)
);