P_RU_BSET

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 P_RU_BSET.
-- 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: PRUBSET

CREATE VIEW P_RU_BSET AS
SELECT
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  buzei AS AccountingDocumentItem,
  cast(buzei as taxitem preserving type) AS TaxItem,
  mwskz AS TaxCode,
  hkont AS GLAccount,
  txgrp AS TaxItemGroup2,
  kbetr AS TaxRate,
  ktosl AS TransactionTypeDetermination,
  shkzg AS DebitCreditCode,
  txjcd AS TaxJurisdiction,
  tax_country AS TaxCountry,
  hwste AS TaxAmountInCoCodeCrcy,
  hwbas AS TaxBaseAmountInCoCodeCrcy,
  fwste AS TaxAmount,
  fwbas AS TaxBaseAmountInTransCrcy
FROM bset
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _AcctgDocTaxItemNegPost ON _AcctgDocTaxItemNegPost.CompanyCode = CompanyCode AND _AcctgDocTaxItemNegPost.FiscalYear = FiscalYear AND _AcctgDocTaxItemNegPost.AccountingDocument = AccountingDocument AND _AcctgDocTaxItemNegPost.TaxItemGroup = TaxItemGroup2 AND _AcctgDocTaxItemNegPost.TaxCode = TaxCode AND _AcctgDocTaxItemNegPost.TaxCountry = TaxCountry AND _AcctgDocTaxItemNegPost.TaxJurisdiction = TaxJurisdiction AND _AcctgDocTaxItemNegPost.TransactionTypeDetermination = TransactionTypeDetermination AND _AcctgDocTaxItemNegPost.AccountingDocumentItemType = 'T' AND _AcctgDocTaxItemNegPost.IsNegativePosting = 'X'  -- association [0..1]
;