C_UA_VATReturnGroupQuery

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_UA_VATReturnGroupQuery.
-- 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: CUATAXRETURNBOXQ
-- Parameters: P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_UA_VATReturnSubmissionDate : fiua_vatret_sub_date, P_TaxBoxConfiguration : figen_tdt_taxbox_config

CREATE VIEW C_UA_VATReturnGroupQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxGroup,
  Country,
  TaxDeclnAmountType,
  TaxBoxStrucValidityStartDate,
  UnifiedTaxBoxStructureType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  StatryRptRun,
  TaxBoxStructureType,
  TaxItemGroupingVersion,
  TaxBoxStrucValidityEndDate,
  DebitCreditCode,
  TaxCalculationProcedure,
  UA_AssetIsNotCurrent,
  TaxRate,
  Customer,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  FiscalPeriod,
  OriginalFiscalPeriod,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxCountry,
  CompanyCodeCurrency,
  ReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  HasNegativeSign,
  UA_XMLFileIsFound,
  TaxType,
  BusinessPartner,
  BusinessPartnerName,
  BusinessPartnerCountry,
  TaxIsNotDeductible,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  TaxCntryOrCompanyCodeCntry,
  UA_SupplierIndividualNumber,
  UA_CustomerIndividualNumber,
  UA_TaxDocumentNumber,
  UA_DocumentIsRegistered,
  UA_TaxDocumentCategory,
  LatestRegistrationDate,
  VATIncomingDocumentDate,
  VATCorrectionDocumentDate,
  UA_BranchNumber,
  UA_CrrtnInvoiceBranchNumber,
  UA_TaxInvoiceForCorrection,
  UA_TaxLiabilityIsAdjdArtcl199
FROM I_UA_VATReturnGroupCube
;