NONDED_ITEM

NONDED_ITEM is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY Accountingdocument Accountingdocument 1
KEY Companycode Companycode 1
KEY DeclarationPeriodNumber Declarationperiodno 1
KEY Fiscalyear Fiscalyear 1
KEY ReportingDate Reporteddate 1
KEY Statryrptcategory Statryrptcategory 1
KEY Statryrptgentity Statryrptgentity 1
KEY TaxItem Documentitem 1
Currency Currency 1
Financialaccounttype Financialaccounttype 1
IsCompleted Isfinished 1
KR_NoneDeductibleInputVATCat Nondeductiblecat 1
KR_NoneDeductibleInputVATSts Nondeductiblestatus 1
KR_TaxExemptRevenueInCCCrcy Taxexemptrevenue 1
TotalRevenueInCoCodeCrcy Totalrevenue 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 NONDED_ITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DECLARATIONPERIODNUMBER,
    FISCALYEAR,
    REPORTINGDATE,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    TAXITEM,
    CURRENCY,
    FINANCIALACCOUNTTYPE,
    ISCOMPLETED,
    KR_NONEDEDUCTIBLEINPUTVATCAT,
    KR_NONEDEDUCTIBLEINPUTVATSTS,
    KR_TAXEXEMPTREVENUEINCCCRCY,
    TOTALREVENUEINCOCODECRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DECLARATIONPERIODNUMBER, FISCALYEAR, REPORTINGDATE, STATRYRPTCATEGORY, STATRYRPTGENTITY, TAXITEM)
);