I_UA_CalculateTaxReturnBoxCube

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_CalculateTaxReturnBoxCube.
-- 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: IUACALTAXRETBOXC
-- 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_CalculateTaxReturnBoxCube AS
SELECT
  I_UA_AdditionalTxReturnBoxCube.CompanyCode AS CompanyCode,
  I_UA_AdditionalTxReturnBoxCube.AccountingDocument AS AccountingDocument,
  cast (I_UA_AdditionalTxReturnBoxCube.FiscalYear as fis_gjahr_no_conv ) AS FiscalYear,
  I_UA_AdditionalTxReturnBoxCube.TaxItem AS TaxItem,
  I_UA_AdditionalTxReturnBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_UA_AdditionalTxReturnBoxCube.DebitCreditCode AS DebitCreditCode,
  I_UA_AdditionalTxReturnBoxCube.AccountingDocumentType AS AccountingDocumentType,
  I_UA_AdditionalTxReturnBoxCube.SupplierAccountGroup AS SupplierAccountGroup,
  I_UA_AdditionalTxReturnBoxCube.TaxBox AS TaxBox,
  I_UA_AdditionalTxReturnBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  I_UA_AdditionalTxReturnBoxCube.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  I_UA_AdditionalTxReturnBoxCube.TaxGroup AS TaxGroup,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGrpgAcctgDocumentType AS TaxItemGrpgAcctgDocumentType,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGrpgSupplierAcctGroup AS TaxItemGrpgSupplierAcctGroup,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  I_UA_AdditionalTxReturnBoxCube.StatryRptgEntity AS StatryRptgEntity,
  I_UA_AdditionalTxReturnBoxCube.StatryRptCategory AS StatryRptCategory,
  I_UA_AdditionalTxReturnBoxCube.StatryRptRunID AS StatryRptRunID,
  I_UA_AdditionalTxReturnBoxCube.Country AS Country,
  I_UA_AdditionalTxReturnBoxCube.TaxCode AS TaxCode,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_UA_AdditionalTxReturnBoxCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_UA_AdditionalTxReturnBoxCube.TaxRateValidityEndDate AS TaxRateValidityEndDate,
  I_UA_AdditionalTxReturnBoxCube.StatryRptRun AS StatryRptRun,
  I_UA_AdditionalTxReturnBoxCube.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  _ReferenceDocRegRecord.HasNegativeSign AS HasNegativeSign,
  I_UA_AdditionalTxReturnBoxCube.HasNegativeSign AS NegativeAmountIsAllowed,
  I_UA_AdditionalTxReturnBoxCube.VATIncomingDocumentDate AS VATIncomingDocumentDate,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGroupingAccountNumber AS TaxItemGroupingAccountNumber,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  I_UA_AdditionalTxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_UA_AdditionalTxReturnBoxCube.TaxRate AS TaxRate,
  I_UA_AdditionalTxReturnBoxCube.Customer AS Customer,
  I_UA_AdditionalTxReturnBoxCube.GLAccount AS GLAccount,
  I_UA_AdditionalTxReturnBoxCube.TaxItemGroup AS TaxItemGroup,
  I_UA_AdditionalTxReturnBoxCube.BusinessPlace AS BusinessPlace,
  I_UA_AdditionalTxReturnBoxCube.TaxJurisdiction AS TaxJurisdiction,
  I_UA_AdditionalTxReturnBoxCube.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_UA_AdditionalTxReturnBoxCube.ReferenceDocumentType AS ReferenceDocumentType,
  I_UA_AdditionalTxReturnBoxCube.ReverseDocument AS ReverseDocument,
  I_UA_AdditionalTxReturnBoxCube.ConditionRecord AS ConditionRecord,
  I_UA_AdditionalTxReturnBoxCube.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  I_UA_AdditionalTxReturnBoxCube.DocumentReferenceID AS DocumentReferenceID,
  I_UA_AdditionalTxReturnBoxCube.Ledger AS Ledger,
  I_UA_AdditionalTxReturnBoxCube.LedgerGroup AS LedgerGroup,
  I_UA_AdditionalTxReturnBoxCube.PostingDate AS PostingDate,
  I_UA_AdditionalTxReturnBoxCube.DocumentDate AS DocumentDate,
  I_UA_AdditionalTxReturnBoxCube.TaxReportingDate AS TaxReportingDate,
  I_UA_AdditionalTxReturnBoxCube.ReportingDate AS ReportingDate,
  I_UA_AdditionalTxReturnBoxCube.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  I_UA_AdditionalTxReturnBoxCube.FiscalPeriod AS FiscalPeriod,
  I_UA_AdditionalTxReturnBoxCube.OriginalFiscalPeriod AS OriginalFiscalPeriod,
  I_UA_AdditionalTxReturnBoxCube.IsReversal AS IsReversal,
  I_UA_AdditionalTxReturnBoxCube.IsReversed AS IsReversed,
  I_UA_AdditionalTxReturnBoxCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_UA_AdditionalTxReturnBoxCube.CompanyCodeCountry AS CompanyCodeCountry,
  cast( I_UA_AdditionalTxReturnBoxCube.ReportingCountry as glo_tax_cntry_or_cocd_cntry ) AS ReportingCountry,
  I_UA_AdditionalTxReturnBoxCube.TaxReturnCountry AS TaxReturnCountry,
  I_UA_AdditionalTxReturnBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_UA_AdditionalTxReturnBoxCube.ReportingCurrency AS ReportingCurrency,
  I_UA_AdditionalTxReturnBoxCube.TaxType AS TaxType,
  I_UA_AdditionalTxReturnBoxCube.BPTaxNumber AS BPTaxNumber,
  I_UA_AdditionalTxReturnBoxCube.ReportingVATRegistration AS ReportingVATRegistration,
  I_UA_AdditionalTxReturnBoxCube.TaxNumber1 AS TaxNumber1,
  I_UA_AdditionalTxReturnBoxCube.Country AS ShippingPointCountry,
  I_UA_AdditionalTxReturnBoxCube.TaxIsDeferredRelevant AS TaxIsDeferredRelevant,
  I_UA_AdditionalTxReturnBoxCube.TaxIsMossRelevant AS TaxIsMossRelevant,
  I_UA_AdditionalTxReturnBoxCube.BusinessPartner AS BusinessPartner,
  I_UA_AdditionalTxReturnBoxCube.CAReconciliationKey AS CAReconciliationKey,
  I_UA_AdditionalTxReturnBoxCube.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  I_UA_AdditionalTxReturnBoxCube.DcblVATIncrdCostInRptgCrcy AS DcblVATIncrdCostInRptgCrcy,
  I_UA_AdditionalTxReturnBoxCube.BusinessPartnerName AS BusinessPartnerName,
  I_UA_AdditionalTxReturnBoxCube.BusinessPartnerCountry AS BusinessPartnerCountry,
  I_UA_AdditionalTxReturnBoxCube.TaxTypeName AS TaxTypeName,
  I_UA_AdditionalTxReturnBoxCube.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_UA_AdditionalTxReturnBoxCube.SenderCompanyCode AS SenderCompanyCode,
  I_UA_AdditionalTxReturnBoxCube.SenderAccountingDocument AS SenderAccountingDocument,
  I_UA_AdditionalTxReturnBoxCube.SenderFiscalYear AS SenderFiscalYear,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxStructure AS TaxBoxStructure,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxStructureName AS TaxBoxStructureName,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxName AS TaxBoxName,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxCondition AS TaxBoxCondition,
  I_UA_AdditionalTxReturnBoxCube.TaxBoxAggregationOperation AS TaxBoxAggregationOperation,
  I_UA_AdditionalTxReturnBoxCube.TaxGroupOperation AS TaxGroupOperation,
  I_UA_AdditionalTxReturnBoxCube.ConditionType AS ConditionType,
  I_UA_AdditionalTxReturnBoxCube.IsVATRelevant AS IsVATRelevant,
  I_UA_AdditionalTxReturnBoxCube.UA_XMLFileIsFound AS UA_XMLFileIsFound,
  I_UA_AdditionalTxReturnBoxCube.UA_TaxLiabilityIsAdjdArtcl199 AS UA_TaxLiabilityIsAdjdArtcl199,
  I_UA_AdditionalTxReturnBoxCube.IsNegativePosting AS IsNegativePosting,
  I_UA_AdditionalTxReturnBoxCube.TaxCountry AS TaxCountry,
  I_UA_AdditionalTxReturnBoxCube.TaxCntryOrCompanyCodeCntry AS TaxCntryOrCompanyCodeCntry,
  I_UA_AdditionalTxReturnBoxCube.ActiveCustomer AS ActiveCustomer,
  I_UA_AdditionalTxReturnBoxCube.UA_BranchNumber AS UA_BranchNumber,
  I_UA_AdditionalTxReturnBoxCube.UA_CrrtnInvoiceBranchNumber AS UA_CrrtnInvoiceBranchNumber,
  I_UA_AdditionalTxReturnBoxCube.UA_TaxInvoiceForCorrection AS UA_TaxInvoiceForCorrection,
  I_UA_AdditionalTxReturnBoxCube.LatestRegistrationDate AS LatestRegistrationDate,
  I_UA_AdditionalTxReturnBoxCube.VATCorrectionDocumentDate AS VATCorrectionDocumentDate,
  I_UA_AdditionalTxReturnBoxCube.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  I_UA_AdditionalTxReturnBoxCube.ExternalContractNumber AS ExternalContractNumber,
  I_UA_AdditionalTxReturnBoxCube.UA_InvoiceDocumentDirection AS UA_InvoiceDocumentDirection,
  I_UA_AdditionalTxReturnBoxCube.UA_ArticleOfTaxLaw AS UA_ArticleOfTaxLaw,
  I_UA_AdditionalTxReturnBoxCube.UA_VATOperationDescription AS UA_VATOperationDescription,
  I_UA_AdditionalTxReturnBoxCube.UA_VATExemptionCode AS UA_VATExemptionCode,
  I_UA_AdditionalTxReturnBoxCube.UA_VATExemptionCodeText AS UA_VATExemptionCodeText,
  I_UA_AdditionalTxReturnBoxCube._ReportingCurrency AS _ReportingCurrency,
  I_UA_AdditionalTxReturnBoxCube._GLAccount AS _GLAccount,
  I_UA_AdditionalTxReturnBoxCube._TaxJurisdiction AS _TaxJurisdiction,
  I_UA_AdditionalTxReturnBoxCube._CompanyCodeCountry AS _CompanyCodeCountry,
  I_UA_AdditionalTxReturnBoxCube._TaxTypeText AS _TaxTypeText,
  I_UA_AdditionalTxReturnBoxCube._TaxCodeText AS _TaxCodeText,
  I_UA_AdditionalTxReturnBoxCube.UA_TaxDocumentCategory AS UA_TaxDocumentCategory,
  I_UA_AdditionalTxReturnBoxCube._TaxDocumentCategoryText AS _TaxDocumentCategoryText
FROM I_UA_AdditionalTxReturnBoxCube
;