C_ZA_StRpTaxItemLogQuery

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 C_ZA_StRpTaxItemLogQuery.
-- 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: CSRZATAXITEMLGQ

CREATE VIEW C_ZA_StRpTaxItemLogQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TransactionTypeDetermination,
  TaxItem,
  TaxItemGroupingVersion,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  VATRegistration,
  DocumentDate,
  PostingDate,
  ReportingDate,
  LinkUUID,
  TaxRate,
  NumberOfDocuments,
  TaxBox,
  TaxDeclnAmountType,
  DocumentReferenceID,
  cast(TaxBaseAmountInCoCodeCrcy as afledx15d2o21s) AS TaxBaseAmountInCoCodeCrcy,
  cast(TaxAmountInCoCodeCrcy as afledx13d2o17n) AS TaxAmountInCoCodeCrcy,
  cast(TaxBaseAmountInRptgCrcy as afledx15d2o21s) AS TaxBaseAmountInRptgCrcy,
  cast(TaxAmountInRptgCrcy as afledx13d2o17n) AS TaxAmountInRptgCrcy,
  cast(TaxBox01AmtInReportingCurrency as fiza_amt_stdrt_exc_cap_goods) AS TaxBox01AmtInReportingCurrency,
  cast(TaxBox02AmtInReportingCurrency as fiza_amt_stdrt_nly_cap_goods) AS TaxBox02AmtInReportingCurrency,
  cast(TaxBox03AmtInReportingCurrency as fiza_amt_zerort_exc_exp_goods) AS TaxBox03AmtInReportingCurrency,
  cast(TaxBox04AmtInReportingCurrency as fiza_amt_zerort_nly_exp_goods) AS TaxBox04AmtInReportingCurrency,
  cast(TaxBox05AmtInReportingCurrency as fiza_amt_exmpt_non_supp) AS TaxBox05AmtInReportingCurrency,
  cast(TaxBox06AmtInReportingCurrency as fiza_amt_acmdtn_exdn_28_days) AS TaxBox06AmtInReportingCurrency,
  cast(TaxBox07AmtInReportingCurrency as fiza_amt_acmdtn_ntexdn_28days) AS TaxBox07AmtInReportingCurrency,
  cast(TaxBox08AmtInReportingCurrency as fiza_amt_chnguse_exp_scndhndgd) AS TaxBox08AmtInReportingCurrency,
  cast(TaxBox09AmtInReportingCurrency as fiza_amt_oth_adjs_imp_ser) AS TaxBox09AmtInReportingCurrency,
  cast(TaxBox10AmtInReportingCurrency as fiza_amt_cap_sup_to_u_full) AS TaxBox10AmtInReportingCurrency,
  cast(TaxBox11AmtInReportingCurrency as fiza_amt_cap_sup_to_u_part) AS TaxBox11AmtInReportingCurrency,
  cast(TaxBox12AmtInReportingCurrency as fiza_amt_cap_gds_imp_by_u_full) AS TaxBox12AmtInReportingCurrency,
  cast(TaxBox13AmtInReportingCurrency as fiza_amt_cap_gds_imp_by_u_part) AS TaxBox13AmtInReportingCurrency,
  cast(TaxBox14AmtInReportingCurrency as fiza_amt_odrgdsser_to_u_full) AS TaxBox14AmtInReportingCurrency,
  cast(TaxBox15AmtInReportingCurrency as fiza_amt_odrgdsser_to_u_part) AS TaxBox15AmtInReportingCurrency,
  cast(TaxBox16AmtInReportingCurrency as fiza_amt_odrgds_imp_by_u_full) AS TaxBox16AmtInReportingCurrency,
  cast(TaxBox17AmtInReportingCurrency as fiza_amt_odrgds_imp_by_u_part) AS TaxBox17AmtInReportingCurrency,
  cast(TaxBox18AmtInReportingCurrency as fiza_amt_change_in_use) AS TaxBox18AmtInReportingCurrency,
  cast(TaxBox19AmtInReportingCurrency as fiza_amt_bad_debts) AS TaxBox19AmtInReportingCurrency,
  cast(TaxBox20AmtInReportingCurrency as fiza_amt_other_adjstmnts) AS TaxBox20AmtInReportingCurrency,
  CustomerSupplierVATRegn,
  FinancialAccountType,
  TaxType,
  CompanyCodeCurrency,
  ReportingCurrency,
  BusinessPartnerName,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  ReportingCountry,
  RecordType,
  Customer,
  Supplier
;