I_FinInstrActivityCategory

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_FinInstrActivityCategory.
-- 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: IFININSTRACTCAT

CREATE VIEW I_FinInstrActivityCategory AS
SELECT
  sanlfor AS FinancialInstrProductCategory,
  sfgtyp AS FinInstrTransactionCategory,
  sfgzustt AS FinancialInstrActivityCategory,
  cast(svgtyp as ftr_gen_activity_category) AS FinTransGenActivityCategory
FROM at02
LEFT OUTER JOIN I_FinancialInstrProdCat AS _ProductCategory ON FinancialInstrProductCategory = _ProductCategory.FinancialInstrProductCategory  -- association [0..1]
LEFT OUTER JOIN I_FinInstrTransCat AS _TransactionCategory ON FinancialInstrProductCategory = _TransactionCategory.FinancialInstrProductCategory AND FinInstrTransactionCategory = _TransactionCategory.FinInstrTransactionCategory  -- association [0..1]
LEFT OUTER JOIN I_FinInstrActivityCategoryText AS _ActivityCategoryText ON FinancialInstrProductCategory = _ActivityCategoryText.FinancialInstrProductCategory AND FinInstrTransactionCategory = _ActivityCategoryText.FinInstrTransactionCategory AND FinancialInstrActivityCategory = _ActivityCategoryText.FinancialInstrActivityCategory  -- association [0..*]
;