NONDEDVATITEM

22 Fields

NONDEDVATITEM is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY DeclarationPeriodNumber DeclarationPeriodNumber 1
KEY FiscalYear FiscalYear 1
KEY ReportingDate ReportingDate 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY TaxItem TaxItem 1
_taxitem _taxitem 1
CaseCreatedOn CaseCreatedOn 1
CaseLastChangedOn CaseLastChangedOn 2
ChangedByUserName ChangedByUserName 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreatedByUser CreatedByUser 1
FinancialAccountType FinancialAccountType 1
IsCompleted IsCompleted 1
KR_NoneDeductibleInputVATCat KR_NoneDeductibleInputVATCat 2
KR_NoneDeductibleInputVATSts KR_NoneDeductibleInputVATSts 1
KR_TaxExemptRevenueInCCCrcy KR_TaxExemptRevenueInCCCrcy 1
TaxReportingDate TaxReportingDate 1
TotalRevenueInCoCodeCrcy TotalRevenueInCoCodeCrcy 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 NONDEDVATITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DECLARATIONPERIODNUMBER,
    FISCALYEAR,
    REPORTINGDATE,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXITEM,
    _TAXITEM,
    CASECREATEDON,
    CASELASTCHANGEDON,
    CHANGEDBYUSERNAME,
    COMPANYCODECURRENCY,
    CREATEDBYUSER,
    FINANCIALACCOUNTTYPE,
    ISCOMPLETED,
    KR_NONEDEDUCTIBLEINPUTVATCAT,
    KR_NONEDEDUCTIBLEINPUTVATSTS,
    KR_TAXEXEMPTREVENUEINCCCRCY,
    TAXREPORTINGDATE,
    TOTALREVENUEINCOCODECRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DECLARATIONPERIODNUMBER, FISCALYEAR, REPORTINGDATE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXITEM)
);

Learn More