I_PT_SAFTSettlementTax

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_PT_SAFTSettlementTax.
-- 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_PT_SAFTSettlementTax AS
SELECT
  Doc.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  Doc.SettlmtMgmtDocItem AS SettlmtMgmtDocItem,
  Doc.SuplrSettlmtCompanyCode AS SuplrSettlmtCompanyCode,
  Doc._SettlmtMgmtDoc.PostingDate AS InvoiceDate,
  Doc._SettlmtMgmtDoc.SuplrSettlmtCompanyCode AS CompanyCode,
  coalesce(Tax.TaxCode, '') AS TaxCode,
  Doc._SuplrSettlmtCompanyCode.Currency AS CompanyCodeCurrency,
  SAFTTax.PT_SAFTTaxType AS PT_SAFTTaxType,
  SAFTTax.CountryRegion AS CountryRegion,
  SAFTTax.PT_SAFTTaxCode AS PT_SAFTTaxCode,
  SAFTTax.TaxCodeDescription AS TaxCodeDescription,
  SAFTTax.EndDate AS EndDate,
  SAFTTax.ExemptionReason AS ExemptionReason,
  SAFTTax.ExemptionReasonText AS ExemptionReasonText,
  case when SAFTTax.PT_SAFTTaxType = 'IVA' and Tax.ConditionRateValue is not initial then cast(Tax.ConditionRateValue as abap.dec(5,2)) else 0 end as TaxRate AS dec52else0endasTaxRate
FROM I_SetlMgmtDocItmCustPrcgElmnt AS Tax
INNER JOIN I_SAFTSettlementManagementItem AS Doc ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SettlmtDocsDgtlSgntr AS SettlmtDigitalSignature ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTBillgMasterDataTax AS SAFTTax ON /* join condition not captured in parsed metadata */
;