I_CATaxReportingDocPosting

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_CATaxReportingDocPosting.
-- 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_CATaxReportingDocPosting 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,
  sbash AS CATaxBaseAmountInLocalCurrency,
  sbasw AS CATaxBaseAmount,
  sbeth AS CATaxAmountInLocalCurrency,
  sbetw AS CATaxAmountInTransCurrency,
  hwaer AS CompanyCodeCurrency,
  twaer AS TransactionCurrency,
  ubdat AS CASourceDocumentPostingDate,
  uldat AS CASourceDocumentDate,
  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,
  xnabe AS CATaxReportingItemCategory,
  nurel AS CATaxReportListItem,
  refnr AS CARelatedDocument,
  xstor AS CADocumentHasBeenReversed,
  cast(cpudt as fis_cpdat preserving type) AS CreationDate,
  cast(cputm as ttet_dt_cr_time preserving type ) AS CreationTime,
  xteil AS CADocumentDataIsOutdated,
  gebth AS CAAmountPerTaxCodeInCCCrcy,
  gebtw AS CAAmountPerTaxCodeInTransCrcy,
  exbel_betrh AS CAOfficialDocAmountInCCCrcy,
  exbel_betrw AS CAOfficialDocAmountInTransCrcy,
  ori_opbel AS CATransferredDocument,
  ori_opupk AS CATransferredDocumentItem,
  dp_opupk AS CADownPaymentDocumentItem,
  tax_country AS TaxCountry,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts
FROM dfkkrep06
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_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_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
;