I_ManageTaxItemCube

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_ManageTaxItemCube.
-- 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.
-- Parameters: P_TaxReportingFromDate : vatdate, P_TaxReportingToDate : vatdate

CREATE VIEW I_ManageTaxItemCube AS
SELECT
  MngTaxSTRpTaxItem.CompanyCode AS CompanyCode,
  MngTaxSTRpTaxItem.AccountingDocument AS AccountingDocument,
  cast( MngTaxSTRpTaxItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  cast( TaxRptgdate.ChangedOnDateTime as srf_changed_on preserving type ) AS ChangedOnDateTime,
  MngTaxSTRpTaxItem.TaxItem AS TaxItem,
  I_StRpTaxItemGrpg.TaxBox AS TaxBox,
  TaxRptgdate.LastChangedByUser AS LastChangedByUser,
  MngTaxSTRpTaxItem.ReportingDate AS ReportingDate,
  MngTaxSTRpTaxItem.PostingDate AS PostingDate,
  MngTaxSTRpTaxItem.DocumentDate AS DocumentDate,
  MngTaxSTRpTaxItem.TaxReportingDate AS TaxReportingDate,
  MngTaxSTRpTaxItem.TaxFulfillmentDate AS TaxFulfillmentDate,
  TaxRptgdate.OldTaxReportingDate AS OldTaxReportingDate,
  cast ( case when ( TaxRptgdate.OriginalTaxReportingDate is null ) then '00000000' else TaxRptgdate.OriginalTaxReportingDate end as figen_orig_tax_rptg_dt preserving type ) AS OriginalTaxReportingDate,
  MngTaxSTRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  MngTaxSTRpTaxItem.TaxCode AS TaxCode,
  MngTaxSTRpTaxItem.TaxCodeName AS TaxCodeName,
  MngTaxSTRpTaxItem.OneStopShopScheme AS OneStopShopScheme,
  MngTaxSTRpTaxItem.OneStopShopTaxReportingCountry AS OneStopShopTaxReportingCountry,
  MngTaxSTRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  MngTaxSTRpTaxItem.GLAccount AS GLAccount,
  MngTaxSTRpTaxItem.TaxJurisdiction AS TaxJurisdiction,
  MngTaxSTRpTaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  MngTaxSTRpTaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  cast((MngTaxSTRpTaxItem.TaxBaseAmountInRptgCrcy + MngTaxSTRpTaxItem.TaxAmountInRptgCrcy) as figen_total_amt_rptg_crcy ) AS TotalGrossAmountInRptgCrcy,
  MngTaxSTRpTaxItem.ReportingCurrency AS ReportingCurrency,
  MngTaxSTRpTaxItem.BusinessPartner AS BusinessPartner,
  MngTaxSTRpTaxItem.BusinessPartnerName AS BusinessPartnerName,
  cast( MngTaxSTRpTaxItem.ReportingCountry as glo_country preserving type ) AS ReportingCountry,
  MngTaxSTRpTaxItem.BusinessPlace AS BusinessPlace,
  MngTaxSTRpTaxItem.ReverseDocument AS ReverseDocument,
  MngTaxSTRpTaxItem.IsReversal AS IsReversal,
  MngTaxSTRpTaxItem.IsReversed AS IsReversed,
  MngTaxSTRpTaxItem.DocumentReferenceID AS DocumentReferenceID,
  MngTaxSTRpTaxItem.AccountingReferenceKey AS AccountingReferenceKey,
  MngTaxSTRpTaxItem.TaxNumber1 AS TaxNumber1,
  MngTaxSTRpTaxItem.TaxNumber2 AS TaxNumber2,
  MngTaxSTRpTaxItem.TaxNumber3 AS TaxNumber3,
  MngTaxSTRpTaxItem.TaxNumber4 AS TaxNumber4,
  MngTaxSTRpTaxItem.VATRegistration AS VATRegistration,
  MngTaxSTRpTaxItem.AddressID AS AddressID,
  _Address.HouseNumber AS HouseNumber,
  _Address.StreetName AS StreetName,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  _Address.PostalCode AS PostalCode,
  _Address.OrganizationName1 AS OrganizationName1,
  _Address.OrganizationName2 AS OrganizationName2,
  _Address.OrganizationName3 AS OrganizationName3,
  _Address.OrganizationName4 AS OrganizationName4,
  MngTaxSTRpTaxItem.SenderCompanyCode AS SenderCompanyCode,
  MngTaxSTRpTaxItem.SenderAccountingDocument AS SenderAccountingDocument,
  MngTaxSTRpTaxItem.SenderFiscalYear AS SenderFiscalYear,
  MngTaxSTRpTaxItem.SenderLogicalSystem AS SenderLogicalSystem,
  _Taxdeclarationinfo( P_SAPClient:$session.client ).DeclarationInformationText AS DeclarationInformationText,
  MngTaxSTRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  MngTaxSTRpTaxItem._TaxCode.TaxType AS TaxType,
  MngTaxSTRpTaxItem._TaxCode._TaxType AS _TaxType
;