US_TxPartTxJurisdictionLevel

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 US_TxPartTxJurisdictionLevel.
-- 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 US_TxPartTxJurisdictionLevel AS
SELECT
  etxdcj.docnr AS US_TaxPartnerTaxDocument,
  etxdcj.itemnr AS US_TaxPartnerTaxDocumentItem,
  cast(etxdcj.txjlv as txjcd_level preserving type) AS TaxJurisdictionLevel,
  cast(etxdcj.gl_shkzg as fis_shkzg preserving type) AS DebitCreditCode,
  cast(etxdcj.taxamt as wmwst_shl preserving type) AS TaxAmountInTransCrcy,
  cast(etxdcj.taxbas as fwbas_shl preserving type) AS TaxBaseAmountInTransCrcy,
  cast(etxdcj.taxpct as fis_externaltaxtaxrate ) AS TaxRate,
  cast(etxdcj.txjcd as fis_txjcd preserving type) AS TaxJurisdiction,
  cast(etxdcj.hkont as fis_racct preserving type) AS GLAccount,
  cast(etxdcj.examt as idpt_a03amount preserving type) AS TaxExemptionAmount,
  cast(etxdcj.excode as exdetcode preserving type) AS US_JxTxExtExmpRsnCode,
  _TaxDoc.TransactionCurrency AS TransactionCurrency,
  _TaxDoc.CompanyCode AS CompanyCode
FROM etxdcj
LEFT OUTER JOIN US_TaxPartnerTaxDocument AS _TaxDoc ON etxdcj.docnr = _TaxDoc.US_TaxPartnerTaxDocument  -- association [1..1]
LEFT OUTER JOIN US_TaxPartnerTaxDocumentItem AS _TaxDocItem ON etxdcj.docnr = _TaxDocItem.US_TaxPartnerTaxDocument AND etxdcj.itemnr = _TaxDocItem.US_TaxPartnerTaxDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
;