I_KR_RPTDNONEDCBLVATITMDETAIL

CDS View
20 Fields 2 CDS Views

Non Deductible Input VAT Item

I_KR_RPTDNONEDCBLVATITMDETAIL is a CDS View in S/4HANA. Non Deductible Input VAT Item. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_KR_NoneDcblVATItemCube view from COMPOSITE KR Non Deductible VAT Item - Cube
P_KR_StRpGenTaxPyrVATNonDedItm view from COMPOSITE Non-deductible item for General Taxpayer VAT

Fields (20)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 4
KEY DeclarationPeriodNumber DeclarationPeriodNumber 3
KEY FiscalYear FiscalYear 4
KEY ReportingDate ReportingDate 3
KEY StatryRptCategory StatryRptCategory 3
KEY StatryRptgEntity StatryRptgEntity 3
KEY StatryRptRunID StatryRptRunID 3
KEY TaxItem TaxItem 4
CaseCreatedOn CaseCreatedOn 2
CaseLastChangedOn CaseLastChangedOn 2
ChangedByUserName ChangedByUserName 2
CreatedByUser CreatedByUser 2
Currency CompanyCodeCurrency,Currency 3
FinancialAccountType FinancialAccountType 3
IsCompleted IsCompleted 3
KR_NoneDeductibleInputVATCat KR_NoneDeductibleInputVATCat 3
KR_NoneDeductibleInputVATSts KR_NoneDeductibleInputVATSts 3
KR_TaxExemptRevenueInCCCrcy KR_TaxExemptRevenueInCCCrcy 3
TotalRevenueInCoCodeCrcy TotalRevenueInCoCodeCrcy 3

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.

-- Non Deductible Input VAT Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_KR_RPTDNONEDCBLVATITMDETAIL (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DECLARATIONPERIODNUMBER,
    FISCALYEAR,
    REPORTINGDATE,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXITEM,
    CASECREATEDON,
    CASELASTCHANGEDON,
    CHANGEDBYUSERNAME,
    CREATEDBYUSER,
    CURRENCY,
    FINANCIALACCOUNTTYPE,
    ISCOMPLETED,
    KR_NONEDEDUCTIBLEINPUTVATCAT,
    KR_NONEDEDUCTIBLEINPUTVATSTS,
    KR_TAXEXEMPTREVENUEINCCCRCY,
    TOTALREVENUEINCOCODECRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DECLARATIONPERIODNUMBER, FISCALYEAR, REPORTINGDATE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXITEM)
);

Learn More