I_KR_VATINVOICEITEMCUBE

CDS View
13 Fields 2 CDS Views

VAT Reporting Tax Items

I_KR_VATINVOICEITEMCUBE is a CDS View in S/4HANA. VAT Reporting Tax Items. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_KR_VATInvoiceItemQuery view from CONSUMPTION VAT Reporting Tax Items
I_KR_ZeroValueAddedTaxItemCube view from COMPOSITE VAT Reporting Zero Tax Rate Items

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
BusinessType BusinessType 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentDate DocumentDate 1
IndustryType IndustryType 1
PostingDate PostingDate 1
ReportingDate ReportingDate 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxInvoiceRepresentativeName TaxInvoiceRepresentativeName 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 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.

-- VAT Reporting Tax Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_KR_VATINVOICEITEMCUBE (
    COMPANYCODE,
    FISCALYEAR,
    BUSINESSTYPE,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    INDUSTRYTYPE,
    POSTINGDATE,
    REPORTINGDATE,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXINVOICEREPRESENTATIVENAME,
    TAXNUMBER1,
    TAXNUMBER2,
    PRIMARY KEY (COMPANYCODE, FISCALYEAR)
);

Learn More