I_CATaxReportingDocClearing

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_CATaxReportingDocClearing.
-- 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_CATaxReportingDocClearing AS
SELECT
  opbel AS CADocumentNumber,
  opupk AS CAGLItemNumber,
  gpart AS BusinessPartner,
  vinfo AS CATaxReportingDetailingAssgmt,
  tzahl AS CATaxReportingItemSequenceNmbr,
  applk AS CAApplicationArea,
  bukrs AS CompanyCode,
  bupla AS BusinessPlace,
  hkont AS GLAccount,
  cast(mwskz as fis_mwskz preserving type ) AS TaxCode,
  strkz AS CAOtherTaxCode,
  stprz AS CATaxRate,
  xrefs AS CADocumentHasRefToOtherTaxes,
  sbash AS CATaxBaseAmountInLocalCurrency,
  sbasw AS CATaxBaseAmount,
  sbeth AS CATaxAmountInLocalCurrency,
  sbetw AS CATaxAmountInTransCurrency,
  gebth AS CAAmountPerTaxCodeInCCCrcy,
  gebtw AS CAAmountPerTaxCodeInTransCrcy,
  augbo AS CAClearingAmtInDocOpenItemCrcy,
  augbh AS CAClearingAmountInLocalCrcy,
  augbw AS CAClearingAmountInTransCrcy,
  hwaer AS CompanyCodeCurrency,
  twaer AS TransactionCurrency,
  tbdat AS CAPostingDate,
  tldat AS DocumentDate,
  faedn AS CANetDueDate,
  vmdat AS CAPlannedTaxReportDate,
  sdata AS CATaxReportingAdditionalText,
  cast(xblnr as xblnr_kk preserving type ) AS CAReferenceDocument,
  ktosl AS CATransactionKeyAccountDetn,
  kschl AS CATaxItemCatForOtherTaxCodes,
  cast(txjcd as fis_txjcd preserving type ) AS TaxJurisdiction,
  txjco AS CAEnteredTaxJurisdictionCode,
  aubel AS CATriggeredDocument,
  xsatz AS CATaxRptgDocPostgTriggerCode,
  refnr AS CARelatedDocument,
  xstor AS CADocumentHasBeenReversed,
  augrd AS CAClearingReason,
  cast(cpudt as fis_cpdat preserving type) AS CreationDate,
  cast(cputm as ttet_dt_cr_time preserving type ) AS CreationTime,
  exbel_betrh AS CAOfficialDocAmountInCCCrcy,
  exbel_betrw AS CAOfficialDocAmountInTransCrcy,
  ori_opbel AS CATransferredDocument,
  ori_opupk AS CATransferredDocumentItem,
  tra_opbel AS CATransfPostgDocOfDeferredTax,
  tax_country AS TaxCountry,
  _DocHeader.TransactionCurrency AS DocumentOpenItemCurrency,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts
FROM dfkkrep07
LEFT OUTER JOIN I_CADocumentHeader AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CADocumentHeader AS _TriggeredDocHeader ON CATriggeredDocument = _TriggeredDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _RelatedDocHeader ON CARelatedDocument = _RelatedDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _TransferredDocHeader ON CATransferredDocument = _TransferredDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _TransfPostgDfrrdTaxDocHeader ON CATransfPostgDocOfDeferredTax = _TransfPostgDfrrdTaxDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccount ON ChartOfAccounts = _GLAccount.ChartOfAccounts AND GLAccount = _GLAccount.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentOpenItemCurrency ON DocumentOpenItemCurrency = _DocumentOpenItemCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
;