I_UA_VATReturnGroupCube

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_UA_VATReturnGroupCube.
-- 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: IUATAXRETURNBOXC
-- 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 I_UA_VATReturnGroupCube AS
SELECT
  I_UA_CalculateTaxReturnBoxCube.CompanyCode AS CompanyCode,
  I_UA_CalculateTaxReturnBoxCube.AccountingDocument AS AccountingDocument,
  cast (I_UA_CalculateTaxReturnBoxCube.FiscalYear as fis_gjahr_no_conv ) AS FiscalYear,
  I_UA_CalculateTaxReturnBoxCube.TaxItem AS TaxItem,
  I_UA_CalculateTaxReturnBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_UA_CalculateTaxReturnBoxCube.DebitCreditCode AS DebitCreditCode,
  I_UA_CalculateTaxReturnBoxCube.AccountingDocumentType AS AccountingDocumentType,
  cast( I_UA_CalculateTaxReturnBoxCube.SupplierAccountGroup as farp_supplier_account_group ) AS SupplierAccountGroup,
  I_UA_CalculateTaxReturnBoxCube.TaxBox AS TaxBox,
  I_UA_CalculateTaxReturnBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  I_UA_CalculateTaxReturnBoxCube.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  I_UA_CalculateTaxReturnBoxCube.TaxGroup AS TaxGroup,
  I_UA_CalculateTaxReturnBoxCube.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  cast( I_UA_CalculateTaxReturnBoxCube.TaxItemGrpgAcctgDocumentType as glo_tax_item_grpg_acc_doc_type ) AS TaxItemGrpgAcctgDocumentType,
  cast( I_UA_CalculateTaxReturnBoxCube.TaxItemGrpgSupplierAcctGroup as glo_tax_itm_grpg_suplr_acc_grp ) AS TaxItemGrpgSupplierAcctGroup,
  I_UA_CalculateTaxReturnBoxCube.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  I_UA_CalculateTaxReturnBoxCube.StatryRptgEntity AS StatryRptgEntity,
  I_UA_CalculateTaxReturnBoxCube.StatryRptCategory AS StatryRptCategory,
  I_UA_CalculateTaxReturnBoxCube.StatryRptRunID AS StatryRptRunID,
  cast( I_UA_CalculateTaxReturnBoxCube.Country as glo_country ) AS Country,
  I_UA_CalculateTaxReturnBoxCube.TaxCode AS TaxCode,
  I_UA_CalculateTaxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_UA_CalculateTaxReturnBoxCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_UA_CalculateTaxReturnBoxCube.TaxRateValidityEndDate AS TaxRateValidityEndDate,
  I_UA_CalculateTaxReturnBoxCube.StatryRptRun AS StatryRptRun,
  I_UA_CalculateTaxReturnBoxCube.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  I_UA_CalculateTaxReturnBoxCube.UA_AssetIsNotCurrent AS UA_AssetIsNotCurrent,
  I_UA_CalculateTaxReturnBoxCube.TaxItemGroupingAccountNumber AS TaxItemGroupingAccountNumber,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  I_UA_CalculateTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_UA_CalculateTaxReturnBoxCube.TaxRate AS TaxRate,
  I_UA_CalculateTaxReturnBoxCube.GLAccount AS GLAccount,
  I_UA_CalculateTaxReturnBoxCube.TaxItemGroup AS TaxItemGroup,
  I_UA_CalculateTaxReturnBoxCube.BusinessPlace AS BusinessPlace,
  I_UA_CalculateTaxReturnBoxCube.TaxJurisdiction AS TaxJurisdiction,
  I_UA_CalculateTaxReturnBoxCube.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_UA_CalculateTaxReturnBoxCube.ReferenceDocumentType AS ReferenceDocumentType,
  I_UA_CalculateTaxReturnBoxCube.ReverseDocument AS ReverseDocument,
  I_UA_CalculateTaxReturnBoxCube.ConditionRecord AS ConditionRecord,
  I_UA_CalculateTaxReturnBoxCube.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  I_UA_CalculateTaxReturnBoxCube.DocumentReferenceID AS DocumentReferenceID,
  I_UA_CalculateTaxReturnBoxCube.Ledger AS Ledger,
  I_UA_CalculateTaxReturnBoxCube.LedgerGroup AS LedgerGroup,
  I_UA_CalculateTaxReturnBoxCube.PostingDate AS PostingDate,
  I_UA_CalculateTaxReturnBoxCube.DocumentDate AS DocumentDate,
  I_UA_CalculateTaxReturnBoxCube.TaxReportingDate AS TaxReportingDate,
  I_UA_CalculateTaxReturnBoxCube.ReportingDate AS ReportingDate,
  I_UA_CalculateTaxReturnBoxCube.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  I_UA_CalculateTaxReturnBoxCube.FiscalPeriod AS FiscalPeriod,
  I_UA_CalculateTaxReturnBoxCube.OriginalFiscalPeriod AS OriginalFiscalPeriod,
  I_UA_CalculateTaxReturnBoxCube.IsReversal AS IsReversal,
  I_UA_CalculateTaxReturnBoxCube.IsReversed AS IsReversed,
  I_UA_CalculateTaxReturnBoxCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_UA_CalculateTaxReturnBoxCube.CompanyCodeCountry AS CompanyCodeCountry,
  cast(I_UA_CalculateTaxReturnBoxCube.ReportingCountry as glo_tax_cntry_or_cocd_cntry) AS ReportingCountry,
  I_UA_CalculateTaxReturnBoxCube.TaxReturnCountry AS TaxReturnCountry,
  I_UA_CalculateTaxReturnBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_UA_CalculateTaxReturnBoxCube.ReportingCurrency AS ReportingCurrency,
  I_UA_CalculateTaxReturnBoxCube.UA_XMLFileIsFound AS UA_XMLFileIsFound,
  I_UA_CalculateTaxReturnBoxCube.TaxType AS TaxType,
  I_UA_CalculateTaxReturnBoxCube.BPTaxNumber AS BPTaxNumber,
  I_UA_CalculateTaxReturnBoxCube.ReportingVATRegistration AS ReportingVATRegistration,
  I_UA_CalculateTaxReturnBoxCube.TaxNumber1 AS TaxNumber1,
  I_UA_CalculateTaxReturnBoxCube.ShippingPointCountry AS ShippingPointCountry,
  I_UA_CalculateTaxReturnBoxCube.TaxIsDeferredRelevant AS TaxIsDeferredRelevant,
  I_UA_CalculateTaxReturnBoxCube.TaxIsMossRelevant AS TaxIsMossRelevant,
  I_UA_CalculateTaxReturnBoxCube.BusinessPartner AS BusinessPartner,
  I_UA_CalculateTaxReturnBoxCube.CAReconciliationKey AS CAReconciliationKey,
  I_UA_CalculateTaxReturnBoxCube.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  I_UA_CalculateTaxReturnBoxCube.DcblVATIncrdCostInRptgCrcy AS DcblVATIncrdCostInRptgCrcy,
  I_UA_CalculateTaxReturnBoxCube.BusinessPartnerName AS BusinessPartnerName,
  I_UA_CalculateTaxReturnBoxCube.BusinessPartnerCountry AS BusinessPartnerCountry,
  I_UA_CalculateTaxReturnBoxCube.TaxTypeName AS TaxTypeName,
  I_UA_CalculateTaxReturnBoxCube.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_UA_CalculateTaxReturnBoxCube.SenderCompanyCode AS SenderCompanyCode,
  I_UA_CalculateTaxReturnBoxCube.SenderAccountingDocument AS SenderAccountingDocument,
  I_UA_CalculateTaxReturnBoxCube.SenderFiscalYear AS SenderFiscalYear,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxStructure AS TaxBoxStructure,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxStructureName AS TaxBoxStructureName,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxName AS TaxBoxName,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxCondition AS TaxBoxCondition,
  I_UA_CalculateTaxReturnBoxCube.TaxBoxAggregationOperation AS TaxBoxAggregationOperation,
  I_UA_CalculateTaxReturnBoxCube.TaxGroupOperation AS TaxGroupOperation,
  I_UA_CalculateTaxReturnBoxCube.ConditionType AS ConditionType,
  case AS IsVATRelevantendasIsVATRelevant,
  I_UA_CalculateTaxReturnBoxCube.IsNegativePosting AS IsNegativePosting,
  I_UA_CalculateTaxReturnBoxCube.TaxCountry AS TaxCountry,
  I_UA_CalculateTaxReturnBoxCube.TaxCntryOrCompanyCodeCntry AS TaxCntryOrCompanyCodeCntry,
  I_UA_CalculateTaxReturnBoxCube.UA_SupplierIndividualNumber AS UA_SupplierIndividualNumber,
  I_UA_CalculateTaxReturnBoxCube.UA_CustomerIndividualNumber AS UA_CustomerIndividualNumber,
  I_UA_CalculateTaxReturnBoxCube.LatestRegistrationDate AS LatestRegistrationDate,
  I_UA_CalculateTaxReturnBoxCube.UA_TaxLiabilityIsAdjdArtcl199 AS UA_TaxLiabilityIsAdjdArtcl199,
  I_UA_CalculateTaxReturnBoxCube.UA_TaxDocumentNumber AS UA_TaxDocumentNumber,
  I_UA_CalculateTaxReturnBoxCube.UA_TaxDocumentCategory AS UA_TaxDocumentCategory,
  I_UA_CalculateTaxReturnBoxCube.VATIncomingDocumentDate AS VATIncomingDocumentDate,
  I_UA_CalculateTaxReturnBoxCube.VATCorrectionDocumentDate AS VATCorrectionDocumentDate,
  I_UA_CalculateTaxReturnBoxCube.UA_BranchNumber AS UA_BranchNumber,
  I_UA_CalculateTaxReturnBoxCube.UA_CrrtnInvoiceBranchNumber AS UA_CrrtnInvoiceBranchNumber,
  I_UA_CalculateTaxReturnBoxCube.UA_TaxInvoiceForCorrection AS UA_TaxInvoiceForCorrection,
  I_UA_CalculateTaxReturnBoxCube._ReportingCurrency AS _ReportingCurrency,
  I_UA_CalculateTaxReturnBoxCube._CompanyCodeCountry AS _CompanyCodeCountry,
  I_UA_CalculateTaxReturnBoxCube._TaxTypeText AS _TaxTypeText,
  I_UA_CalculateTaxReturnBoxCube._TaxCodeText AS _TaxCodeText,
  I_UA_CalculateTaxReturnBoxCube._TaxDocumentCategoryText AS _TaxDocumentCategoryText
FROM I_UA_CalculateTaxReturnBoxCube
;