P_TaxCode

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_TaxCode.
-- 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: PFITAXCODE

CREATE VIEW P_TaxCode AS
SELECT
  kalsm AS TaxCalculationProcedure,
  cast(mwskz as fis_mwskz) AS TaxCode,
  mwart AS TaxType,
  cast (zmwsk as farp_dzmwsk) AS TargetTaxCode,
  egrkz AS EUTaxClassification,
  xslta AS IsSalesTaxes,
  cast ( txind as smwsk ) AS TaxCategory,
  lstml AS TaxReturnCountry,
  cast( tolerance as fot_tax_tolerance ) AS TaxTolerancePercent,
  zmwsk_esa AS EUAcqnInputTaxCode,
  zmwsk_ese AS EUAcqnOutputTaxCode,
  mossc AS MossTaxCode
FROM t007a
LEFT OUTER JOIN I_TaxCodeText AS _Text ON TaxCalculationProcedure = _Text.TaxCalculationProcedure AND TaxCode = _Text.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
;