I_KR_NonDeductibleVATItem

DDL: I_KR_NONDEDUCTIBLEVATITEM SQL: IKRNDEDVATIT Type: view BASIC Package: GLO_FIN_NON_DEDUCTIBLE_VAT
10 Fields 1 Data Sources

Non Deductible Input VAT Item

I_KR_NonDeductibleVATItem is a Basic CDS View that provides data about "Non Deductible Input VAT Item" in SAP S/4HANA. It reads from 1 data source (idkr_ndedvatitm) and exposes 10 fields with key fields CompanyCode, FiscalYear, AccountingDocument, TaxItem. Part of development package GLO_FIN_NON_DEDUCTIBLE_VAT.

Data Sources (1)

SourceAliasJoin Type
idkr_ndedvatitm idkr_ndedvatitm from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IKRNDEDVATIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Non Deductible Input VAT Item view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode companycode Receiver Company Code
KEY FiscalYear fiscalyear G/L Fiscal Year
KEY AccountingDocument accountingdocument Journal Entry
KEY TaxItem documentitem Item
KR_NoneDeductibleInputVATCat nondeductiblecat Non-Deductible Cat.
KR_NoneDeductibleInputVATSts nondeductiblestatus Non-Deductible Sts
CreatedByUser createdby User Name
CaseCreatedOn createdon Time Stamp
ChangedByUserName changedby User Name
CaseLastChangedOn changedon Time Stamp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_KR_NonDeductibleVATItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IKRNDEDVATIT

CREATE VIEW I_KR_NonDeductibleVATItem AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  documentitem AS TaxItem,
  nondeductiblecat AS KR_NoneDeductibleInputVATCat,
  nondeductiblestatus AS KR_NoneDeductibleInputVATSts,
  createdby AS CreatedByUser,
  createdon AS CaseCreatedOn,
  changedby AS ChangedByUserName,
  changedon AS CaseLastChangedOn
FROM idkr_ndedvatitm
;

Learn More