I_CN_GoldenTaxPersonalSetting

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_CN_GoldenTaxPersonalSetting.
-- 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_CN_GoldenTaxPersonalSetting AS
SELECT
  uname AS UserID,
  inv_key AS CN_GoldenTaxInvoiceKey,
  cast( verif as eiv_reviewer ) AS CN_GoldenTaxReviewer,
  colle AS CN_GoldenTaxReceiver,
  cast( issuer as eiv_issuer ) AS CN_GoldenTaxIssuer,
  notty AS CN_GoldenTaxNoteType,
  cast( ct_vat as eiv_conditiontype1) AS CN_GoldenTaxConditionType,
  entity_id AS CN_TaxEntityID,
  cast( term_id as eiv_dflt_term_id ) AS CN_GoldenTaxTerminal
FROM idgt_ob_ctrl
LEFT OUTER JOIN I_CN_GoldenTaxInvoiceKey AS _GTInvcKey ON CN_GoldenTaxInvoiceKey = _GTInvcKey.CN_GoldenTaxInvoiceKey  -- association [0..1]
;