P_TAXDECLAR_NOWCUBE

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_TAXDECLAR_NOWCUBE.
-- 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: PNOWDECLAR

CREATE VIEW P_TAXDECLAR_NOWCUBE AS
SELECT
  CompanyCode,
  FiscalYear,
  TaxCode,
  TransactionTypeDetermination,
  CompanyCodeCurrency,
  cast(bseg.AccountingDocument as fis_belnr) AS AccountingDocument,
  PostingFiscalPeriod,
  cast (bseg.TaxBaseAmountIsNetAmount as xmwsn) AS TaxBaseAmountIsNetAmount,
  cast (bseg.CashDiscountBaseAmtIsNetAmt as xskfn) AS CashDiscountBaseAmtIsNetAmt,
  cast (CashDiscount1Percent as dzbd1p_farp) AS CashDiscount1Percent,
  cast(_TaxBox_TaxAmt_TDT.tax_box as fot_tax_amount_taxbox) AS TaxAmountTaxBox,
  cast(_Taxbox_Base_TDT.tax_box as fot_tax_base_amount_taxbox) AS TaxBaseAmountTaxBox,
  TaxRateValidityStartDate,
  cast (TaxBaseAmountInCoCodeCrcy as dmbtr_shl) AS TaxBaseAmountInCoCodeCrcy,
  cast (TaxAmountInCoCodeCrcy as fis_mwsts) AS TaxAmountInCoCodeCrcy,
  cast (CalculatedTxAmtInCoCodeCrcy as fot_tax_recon_amt) AS CalculatedTxAmtInCoCodeCrcy,
  cast (SubTotalAmountInCoCodeCrcy as fot_tax_recon_subtotal_amt) AS SubTotalAmountInCoCodeCrcy,
  cast ( TaxRate as kbetr_tax) AS TaxRate,
  AccountingDocumentType AS DocumentType,
  DocumentDate,
  PostingDate,
  Country,
  cast (coalesce(t007z.verstax,'') as verstax ) AS TaxItemGroupingVersion,
  ConditionRateValue,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure
FROM I_TaxDeclaration AS bseg
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN P_TaxBox_TaxAmt_TDT AS _TaxBox_TaxAmt_TDT ON Country = _TaxBox_TaxAmt_TDT.land1 AND TransactionTypeDetermination = _TaxBox_TaxAmt_TDT.ktosl AND TaxCode = _TaxBox_TaxAmt_TDT.mwskz AND PostingDate >= _TaxBox_TaxAmt_TDT.valid_from AND PostingDate <= _TaxBox_TaxAmt_TDT.valid_to AND TaxRateValidityStartDate >= _TaxBox_TaxAmt_TDT.txdat_from AND TaxRateValidityStartDate <= _TaxBox_TaxAmt_TDT.txdat_to  -- association [0..*]
LEFT OUTER JOIN P_TaxBox_Base_TDT AS _Taxbox_Base_TDT ON Country = _Taxbox_Base_TDT.land1 AND TransactionTypeDetermination = _Taxbox_Base_TDT.ktosl AND TaxCode = _Taxbox_Base_TDT.mwskz AND PostingDate >= _Taxbox_Base_TDT.valid_from AND PostingDate <= _Taxbox_Base_TDT.valid_to AND TaxRateValidityStartDate >= _Taxbox_Base_TDT.txdat_from AND TaxRateValidityStartDate <= _Taxbox_Base_TDT.txdat_to  -- association [0..*]
;