I_BE_CADocumentTaxReporting

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_BE_CADocumentTaxReporting.
-- 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.

CREATE VIEW I_BE_CADocumentTaxReporting AS
SELECT
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  stceg AS VATRegistration,
  gpart AS BusinessPartner,
  bukrs AS CompanyCode,
  mwskz AS TaxCode,
  opbel AS CADocumentNumber,
  budat AS CAPostingDate,
  land1 AS Country,
  betrh AS CAAmountInLocalCurrency,
  sbeth AS CATaxAmountInLocalCurrency,
  hwaer AS CompanyCodeCurrency,
  blart AS CADocumentType,
  bldat AS DocumentDate,
  xblnr AS CAReferenceDocument
FROM dfkkrep01
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CADocument AS _CADocument ON CADocumentNumber = _CADocument.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [1..1]
;