P_KR_NONDCBLPREFIXASSETS00

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_NONDCBLPREFIXASSETS00.
-- 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: PKRNDPREAS00

CREATE VIEW P_KR_NONDCBLPREFIXASSETS00 AS
SELECT
  taxitem.CompanyCode AS CompanyCode,
  taxitem.AccountingDocument AS AccountingDocument,
  taxitem.FiscalYear AS FiscalYear,
  taxitem.TaxItem AS TaxItem,
  taxitem.TaxCalculationProcedure AS TaxCalculationProcedure,
  taxitem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  taxitem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  taxitem.CompanyCodeCurrency AS CompanyCodeCurrency,
  'SOK'as StatryRptRunStatus AS SOKasStatryRptRunStatus,
  RPTDtaxitem.KR_NoneDeductibleInputVATCat AS KR_NoneDeductibleInputVATCat,
  RPTDtaxitem.KR_NoneDeductibleInputVATSts AS KR_NoneDeductibleInputVATSts,
  taxitem.TaxCode AS TaxCode,
  taxitem.Supplier AS Supplier,
  taxitem.BusinessPlace AS BusinessPlace,
  '99991231' AS ReportingDate,
  taxitem._TaxCodeText AS _TaxCodeText,
  taxitem._JournalEntry AS _JournalEntry
INNER JOIN I_StRpTaxItem AS taxitem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_KR_NonDeductibleVATItem AS _NonDedVATItem ON CompanyCode = _NonDedVATItem.CompanyCode AND AccountingDocument = _NonDedVATItem.AccountingDocument AND FiscalYear = _NonDedVATItem.FiscalYear AND TaxItem = _NonDedVATItem.TaxItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN P_KR_STRPRPTDNDEDITEM AS _reporteditem ON CompanyCode = _reporteditem.CompanyCode AND AccountingDocument = _reporteditem.AccountingDocument AND FiscalYear = _reporteditem.FiscalYear AND TaxItem = _reporteditem.TaxItem  -- association [0..1]
LEFT OUTER JOIN P_KR_STRPRPTDDISTINNDEDOUTITEM AS _RptOutItem ON CompanyCode = _RptOutItem.KR_InputVATCompanyCode AND AccountingDocument = _RptOutItem.KR_InputVATAccountingDocument AND FiscalYear = _RptOutItem.KR_InputVATFiscalYear AND TaxItem = _RptOutItem.KR_InputVATItem  -- association [0..1]
LEFT OUTER JOIN I_KR_NoneDcblInputVATCatVH AS _category ON KR_NoneDeductibleInputVATCat = _category.KR_NoneDeductibleInputVATCat AND TaxItem = _NonDedVATItem.TaxItem  -- association [1..1]
;