VATREPORTING

VATREPORTING is an SAP database table in S/4HANA. It contains 42 fields.

Fields (42)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 9
AccountingDocumentType AccountingDocumentType 3
BusinessTransactionType BusinessTransactionType 1
CompanyCode CompanyCode 9
CompanyCodeCurrency CompanyCodeCurrency 2
Currency Currency 1
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 1
FiscalYear FiscalYear 9
IsCorrectionInvoice IsCorrectionInvoice 1
IsReversal IsReversal 7
IsReversed IsReversed 7
OriginalDocument OriginalDocument,SourceDocument 5
OriginalDocumentIsReversal OriginalDocumentIsReversal 2
OriginalDocumentIsReversed OriginalDocumentIsReversed 2
OriginalDocumentYear OriginalDocumentYear 4
PostingDate PostingDate 5
ReverseDocument ReverseDocument 4
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 4
ReverseDocumentTaxRepDate ReverseDocumentTaxRepDate 2
RevisionNumber RevisionNumber 1
RU_TaxAmountCalcType RU_TaxAmountCalcType 1
RU_TaxBaseAmountCalcType RU_TaxBaseAmountCalcType 1
RU_VATReturnLine RU_VATReturnLine 1
RU_VATReturnSection RU_VATReturnSection 1
RU_VATReturnSectionType RU_VATReturnSectionType 8
RU_VATReturnVersion RU_VATReturnVersion 8
RU_VATScenario RU_VATScenario 7
RU_VATSubScenario RU_VATSubScenario 7
RU_VATSubScenarioItem RU_VATSubScenarioItem,TaxItem 4
RU_VATSubScenarioVersion RU_VATSubScenarioVersion 4
Sign Sign 1
SourceDocument SourceDocument 2
SourceDocumentFiscalYear SourceDocumentFiscalYear 2
StatryRptCategory StatryRptCategory 2
StatryRptgEntity StatryRptgEntity 2
StatryRptRunID StatryRptRunID 2
TaxCode TaxCode 7
TaxItem TaxItem 5
TaxItemClassification TaxItemClassification 2
TaxReportingDate TaxReportingDate 6
TransactionTypeDetermination TransactionTypeDetermination 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 VATREPORTING (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FISCALYEAR,
    ISCORRECTIONINVOICE,
    ISREVERSAL,
    ISREVERSED,
    ORIGINALDOCUMENT,
    ORIGINALDOCUMENTISREVERSAL,
    ORIGINALDOCUMENTISREVERSED,
    ORIGINALDOCUMENTYEAR,
    POSTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    REVERSEDOCUMENTTAXREPDATE,
    REVISIONNUMBER,
    RU_TAXAMOUNTCALCTYPE,
    RU_TAXBASEAMOUNTCALCTYPE,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOITEM,
    RU_VATSUBSCENARIOVERSION,
    SIGN,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXCODE,
    TAXITEM,
    TAXITEMCLASSIFICATION,
    TAXREPORTINGDATE,
    TRANSACTIONTYPEDETERMINATION
);