Fields (42)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA