P_KR_NONDCBLOUTPUTVATITEM00

DDL: P_KR_NONDCBLOUTPUTVATITEM00 SQL: PKRNOUTVATITM00 Type: view COMPOSITE Package: GLO_FIN_NON_DEDUCTIBLE_VAT
29 Fields 1 Data Sources 5 Associations

Non Deductible Input VAT Item

P_KR_NONDCBLOUTPUTVATITEM00 is a Composite CDS View that provides data about "Non Deductible Input VAT Item" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxItem) and exposes 29 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. It has 5 associations to related views. Part of development package GLO_FIN_NON_DEDUCTIBLE_VAT.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxItem taxitem from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..*] P_KR_STRPRPTDNDEDOUTITEM _KR_STRPRPTDNDEDOUTITEM $projection.CompanyCode = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATCompanyCode and $projection.AccountingDocument = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATAccountingDocument and $projection.FiscalYear = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATFiscalYear and $projection.TaxItem = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATItem
[0..1] I_KR_VATReportingConfiguration _KR_VATReportingConfiguration taxitem.TaxCode = _KR_VATReportingConfiguration.TaxCode

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKRNOUTVATITM00 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItem FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Tax Item
TaxCode TaxCode Tax Code
TaxCodeName
Language
TaxType I_StRpTaxItem TaxType Tax Type
TaxRate I_StRpTaxItem TaxRate Tax Rate
CompanyCodeCurrency I_StRpTaxItem CompanyCodeCurrency Local Currency
TaxBaseAmountInCoCodeCrcy I_StRpTaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_StRpTaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxRateValidityStartDate I_StRpTaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
KR_InputVATFiscalYear NonDedVATmapping KR_InputVATFiscalYear
KR_InputVATCompanyCode NonDedVATmapping KR_InputVATCompanyCode
KR_InputVATAccountingDocument NonDedVATmapping KR_InputVATAccountingDocument
KR_InputVATItem NonDedVATmapping KR_InputVATItem
TaxInvoiceType _KR_VATReportingConfiguration TaxInvoiceType
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPlace BusinessPlace Business place
TaxReportingDate TaxReportingDate Tax Reporting Date
TaxCalculationProcedure I_StRpTaxItem TaxCalculationProcedure Tax Procedure
_KR_VATReportingConfiguration _KR_VATReportingConfiguration
_KR_STRPRPTDNDEDOUTITEM _KR_STRPRPTDNDEDOUTITEM
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_Customer _Customer
_Supplier _Supplier

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 P_KR_NONDCBLOUTPUTVATITEM00.
-- 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: PKRNOUTVATITM00

CREATE VIEW P_KR_NONDCBLOUTPUTVATITEM00 AS
SELECT
  taxitem.CompanyCode AS CompanyCode,
  taxitem.AccountingDocument AS AccountingDocument,
  taxitem.FiscalYear AS FiscalYear,
  TaxItem,
  TaxCode,
  taxitem._TaxCodeText.TaxCodeName AS TaxCodeName,
  taxitem._TaxCodeText.Language AS Language,
  taxitem.TaxType AS TaxType,
  taxitem.TaxRate AS TaxRate,
  taxitem.CompanyCodeCurrency AS CompanyCodeCurrency,
  taxitem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  taxitem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  taxitem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  NonDedVATmapping.KR_InputVATFiscalYear AS KR_InputVATFiscalYear,
  NonDedVATmapping.KR_InputVATCompanyCode AS KR_InputVATCompanyCode,
  NonDedVATmapping.KR_InputVATAccountingDocument AS KR_InputVATAccountingDocument,
  NonDedVATmapping.KR_InputVATItem AS KR_InputVATItem,
  _KR_VATReportingConfiguration.TaxInvoiceType AS TaxInvoiceType,
  Customer,
  Supplier,
  BusinessPlace,
  TaxReportingDate,
  taxitem.TaxCalculationProcedure AS TaxCalculationProcedure
FROM I_StRpTaxItem AS taxitem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN P_KR_STRPRPTDNDEDOUTITEM AS _KR_STRPRPTDNDEDOUTITEM ON CompanyCode = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATCompanyCode AND AccountingDocument = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATAccountingDocument AND FiscalYear = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATFiscalYear AND TaxItem = _KR_STRPRPTDNDEDOUTITEM.KR_OutputVATItem  -- association [0..*]
LEFT OUTER JOIN I_KR_VATReportingConfiguration AS _KR_VATReportingConfiguration ON taxitem.TaxCode = _KR_VATReportingConfiguration.TaxCode  -- association [0..1]
;

Learn More