VATRETURNMAINSECTION

VATRETURNMAINSECTION is an SAP database table in S/4HANA. It contains 41 fields.

Fields (41)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 9
AccountingDocumentType AccountingDocumentType 11
BusinessTransactionType BusinessTransactionType 11
CompanyCode CompanyCode 11
CompanyCodeCurrency CompanyCodeCurrency 11
DocumentDate DocumentDate 11
ExportInvcConfirmedFiscalYear ExportInvcConfirmedFiscalYear 2
ExternalInvoice ExternalInvoice 9
FirstName FirstName 1
FiscalPeriod FiscalPeriod 2
FiscalYear FiscalYear 11
IsReversal IsReversal 9
IsReversed IsReversed 9
JournalEntry JournalEntry 2
LastName LastName 1
MiddleName MiddleName 1
PostingDate PostingDate 11
RU_PartnerOrganizationINN RU_PartnerOrganizationINN 1
RU_PartnerOrganizationKPP RU_PartnerOrganizationKPP 1
RU_PartnerPersonINN RU_PartnerPersonINN 1
RU_TerritoryClassfctnOKTMO RU_TerritoryClassfctnOKTMO 1
RU_VATReturnSection RU_VATReturnSection 11
RU_VATReturnSectionType RU_VATReturnSectionType 11
RU_VATReturnVersion RU_VATReturnVersion 11
RU_VATScenario RU_VATScenario 11
RU_VATSubScenario RU_VATSubScenario 11
RU_VATSubScenarioVersion RU_VATSubScenarioVersion 11
SourceDocument SourceDocument 11
SourceDocumentFiscalYear SourceDocumentFiscalYear 11
StatryRptCategory StatryRptCategory 9
StatryRptgEntity StatryRptgEntity 9
StatryRptRunID StatryRptRunID 9
Supplier Supplier 2
SupplierName SupplierName 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 3
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 3
TaxBoxByTaxAuthority TaxBoxByTaxAuthority 11
TaxCode TaxCode 11
TaxReportingDate TaxReportingDate 11
VATReturnItemDescription VATReturnItemDescription 11
VATReturnOperation VATReturnOperation 7

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 VATRETURNMAINSECTION (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    EXPORTINVCCONFIRMEDFISCALYEAR,
    EXTERNALINVOICE,
    FIRSTNAME,
    FISCALPERIOD,
    FISCALYEAR,
    ISREVERSAL,
    ISREVERSED,
    JOURNALENTRY,
    LASTNAME,
    MIDDLENAME,
    POSTINGDATE,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_PARTNERPERSONINN,
    RU_TERRITORYCLASSFCTNOKTMO,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOVERSION,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    SUPPLIERNAME,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBOXBYTAXAUTHORITY,
    TAXCODE,
    TAXREPORTINGDATE,
    VATRETURNITEMDESCRIPTION,
    VATRETURNOPERATION
);