P_KR_NONDCBLINPUTVATITEM02

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_NONDCBLINPUTVATITEM02.
-- 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: PKRNINVATITM02
-- Parameters: P_FromReportingDate : idkr_rptdat_from, P_ToReportingDate : idkr_rptdat_to

CREATE VIEW P_KR_NONDCBLINPUTVATITEM02 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCalculationProcedure,
  min(TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  min(TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  TaxCode,
  Supplier,
  BusinessPlace,
  min(TaxReportingDate) AS TaxReportingDate,
  min(ReportingDate) AS ReportingDate,
  KR_NoneDeductibleInputVATCat,
  KR_NoneDeductibleInputVATSts,
  CaseLastChangedOn
FROM P_KR_NONDCBLINPUTVATITEM01
LEFT OUTER JOIN I_KR_NoneDeductibleVATCmnt AS _Comments ON CompanyCode = _Comments.CompanyCode AND AccountingDocument = _Comments.AccountingDocument AND FiscalYear = _Comments.FiscalYear AND TaxItem = _Comments.TaxItem  -- association [0..*]
;