C_NO_TaxReturnBoxCube

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_NO_TaxReturnBoxCube.
-- 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: CNOTAXRETURNBOXC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_KeyDate : vdm_v_key_date

CREATE VIEW C_NO_TaxReturnBoxCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  I_StRpTaxReturnBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  DebitCreditCode,
  AccountingDocumentType,
  SupplierAccountGroup,
  TaxBox,
  TaxDeclnAmountType,
  TaxBoxStrucValidityStartDate,
  UnifiedTaxBoxStructureType,
  TaxGroup,
  TaxItemGrpgDebitCreditCode,
  TaxItemGrpgAcctgDocumentType,
  TaxItemGrpgSupplierAcctGroup,
  TaxItemGrpgSpecialGLCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  I_StRpTaxReturnBoxCube.TaxCode AS TaxCode,
  I_StRpTaxReturnBoxCube.Country AS Country,
  TaxBoxStrucValidityEndDate,
  TaxBoxName,
  I_StRpTaxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxBoxStructureType,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxCondition,
  TaxCountry,
  I_StRpTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxRate,
  cast(right(cast( I_StRpTaxReturnBoxCube.TaxRate as char20 ), 10 ) as figen_taxrateinpercentastext ) AS TaxRateInPercentAsText,
  TaxRateValidityStartDate,
  GLAccount,
  TaxItemGroup,
  ReferenceDocumentType,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  TaxType,
  FiscalPeriod,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  TaxTypeName,
  CompanyCodeCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AmountInReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  NonDeductibleInputTaxAmount,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TargetTaxCode,
  CAReconciliationKey,
  TaxIsNotDeductible,
  TransactionType.stgrp AS TransactionTaxType,
  VAT_Adj_Reason.NO_VATAdjustmentReason AS NO_VATAdjustmentReason
FROM I_StRpTaxReturnBoxCube
;