I_ContractAccountTaxExemption

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_ContractAccountTaxExemption.
-- 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_ContractAccountTaxExemption AS
SELECT
  vkont AS ContractAccount,
  mwskz AS TaxCode,
  kschl AS CAConditionType,
  exdfr AS CustTaxGroupExemptionStartDate,
  exdto AS CustTaxGroupExemptionEndDate,
  exnum AS CATaxExemptionLicense,
  exrat AS CATaxExemptionRate,
  laufd AS CAMassRunDate,
  laufi AS CAMassRunID,
  exempt_lic AS CATaxExemptionLicenseExtended,
  exempt_amt AS CATaxExemptionLicenseAmount,
  exempt_amt_curr AS CATaxExemptionLicenseCurrency,
  exempt_issdat AS CATaxExemptionLicenseIssueDate
FROM dfkktaxex
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CATaxExemptionLicenseCurrency ON CATaxExemptionLicenseCurrency = _CATaxExemptionLicenseCurrency.Currency  -- association [0..1]
;