I_KR_VATInvoiceItemCube

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_VATInvoiceItemCube.
-- 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: IKRVATINVCITEMC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_StatryRptRunType : srf_report_run_type

CREATE VIEW I_KR_VATInvoiceItemCube AS
SELECT
  P_KR_VATInvoiceItem_v2.CompanyCode AS CompanyCode,
  P_KR_VATInvoiceItem_v2.FiscalYear AS FiscalYear,
  AccountingDocument,
  TaxItem AS AccountingDocumentItem,
  TaxItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  P_KR_VATInvoiceItem_v2.BusinessPartner AS BusinessPartner,
  cast( '' as opbel_kk ) AS CADocumentNumber,
  cast( '' as lfd_opupk_kk ) AS CAGLItemNumber,
  cast( '' as vinfo_kk ) AS CATaxReportingDetailingAssgmt,
  cast( '' as tzahl_kk) AS CATaxReportingItemSequenceNmbr,
  TaxRate,
  TaxRateValidityStartDate,
  P_KR_VATInvoiceItem_v2.CompanyCodeCurrency AS CompanyCodeCurrency,
  BusinessPlace,
  FinancialAccountType,
  CustSuppNumber AS CustomerSupplierAccount,
  AccountingDocumentType,
  DocumentReferenceID,
  P_KR_VATInvoiceItem_v2.TaxType AS TaxType,
  TaxInvoiceApprovalNmbr,
  TaxInvoiceApprovalNmbr AS TaxInvoiceNumber,
  InvoiceDate,
  IsReversal,
  IsReversed,
  ReversalReason,
  ExchangeRateDate,
  P_KR_VATInvoiceItem_v2.DocumentDate AS DocumentDate,
  P_KR_VATInvoiceItem_v2.PostingDate AS PostingDate,
  P_KR_VATInvoiceItem_v2.TaxNumber2 AS TaxNumber2,
  case when P_KR_VATInvoiceItem_v2.TaxNumber2 <> '' then '' else P_KR_VATInvoiceItem_v2.TaxNumber1 end as TaxNumber1 AS TaxNumber1endasTaxNumber1,
  BusinessPartnerName,
  ExporterUUID,
  LoadingDate,
  DocumentCurrency,
  TaxBaseAmountInTransCrcy,
  P_KR_VATInvoiceItem_v2.ExchangeRate AS ExchangeRate,
  TaxInvcNmbrValidityStartDate,
  cast (P_KR_VATInvoiceItem_v2.IndustryType as indtyp) AS IndustryType,
  cast (P_KR_VATInvoiceItem_v2.BusinessType as gestyp) AS BusinessType,
  P_KR_VATInvoiceItem_v2.TaxInvoiceRepresentativeName AS TaxInvoiceRepresentativeName,
  P_KR_VATInvoiceItem_v2.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_KR_VATInvoiceItem_v2.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _I_KR_VAT_REP_CONF.TaxInvoiceType AS TaxInvoiceType,
  _I_KR_VAT_REP_CONF.MultipleInvoiceType AS MultipleInvoiceType,
  _I_KR_VAT_REP_CONF.ExportType AS ExportType,
  TaxItemGroup,
  BusinessPartner1 AS ReferenceBusinessPartner,
  CAReconciliationKey,
  ReferenceDocumentType,
  cast(concat_with_space( concat_with_space( StatryRptgEntity,StatryRptCategory,1),StatryRptRunID,1 ) as srf_reportrun) AS StatryRptRun,
  cast( '' as sdata_kk ) as CATaxReportingAdditionalText AS P_StatryRptgEntity,
  P_StatryRptCategory :$parameters.P_StatryRptCategory AS P_StatryRptCategory,
  P_StatryRptRunID :$parameters.P_StatryRptRunID AS P_StatryRptRunID,
  FICA_ITEM.ReportingDate AS ReportingDate,
  FICA_ITEM.VATRegistration AS VATRegistration,
  cast( FICA_ITEM.TaxNumber1 as stcd1 ) AS TaxNumber1,
  '' AS Supplier,
  FICA_ITEM._I_KR_VAT_REP_CONF AS _I_KR_VAT_REP_CONF,
  FICA_ITEM._I_Customer AS _I_Customer,
  FICA_ITEM._I_Supplier AS _I_Supplier,
  rtrim(substring(FICA_ITEM.CATaxReportingAdditionalText,1,50),' ') AS CATaxReportingAdditionalText
FROM P_KR_VATInvoiceItem_v2
-- UNION with additional select branch(es): P_KR_CAVATInvoiceItem
;