I_SecurityClassBasic

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_SecurityClassBasic.
-- 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_SecurityClassBasic AS
SELECT
  cast(ranl as ftr_gen_security_class preserving type) AS SecurityClass,
  cast(sanlf as ftr_gen_fin_instr_prod_categ preserving type) AS FinancialInstrProductCategory,
  SecurityClass.sstati AS SecurityClassStatus,
  cast(SecurityClass.xalkz as ftr_gen_security_class_name preserving type) AS SecurityClassName,
  cast(SecurityClass.xallb as ftr_gen_security_class_lname preserving type) AS SecurityClassDescription,
  SecurityClass.gsart AS FinancialInstrumentProductType,
  SecurityClass.srolext AS ScrtyClassGenClassification,
  cast(SecurityClass.repke as repke_new preserving type) AS Issuer,
  SecurityClass.rewhr AS IssueCurrency,
  cast(SecurityClass.bempreis as ftr_sc_bempreis) AS SecurityClassIssuePriceValue,
  SecurityClass.pemkurs AS IssueRateInPercent,
  SecurityClass.swerttyp AS SecurityClassTransferType,
  SecurityClass.snoti AS SecurityClassQuotation,
  cast( SecurityClass.unit_tick as ftr_sc_min_unit_num preserving type ) AS ScrtyClMinimalNumberOfUnits,
  SecurityClass.sboernot AS SecurityClassIsListed,
  SecurityClass.coicode AS ScrtyClCmplmntyIdnCode,
  SecurityClass.coiland AS ScrtyClCmplmntyIdnCtryReg,
  cast(SecurityClass.rerf as ftr_sc_rerf preserving type) AS SecurityClassCreatedByUser,
  cast(SecurityClass.derf as ftr_sc_derf preserving type) AS SecurityClassCreationDate,
  cast(SecurityClass.terf as ftr_sc_terf preserving type) AS SecurityClassCreationTime,
  cast(SecurityClass.reher as ftr_sc_reher preserving type) AS SecurityClassCreationSource,
  cast(SecurityClass.rbear as ftr_sc_rbear preserving type) AS SecurityClassLastChangedByUser,
  cast(SecurityClass.dbear as ftr_sc_dbear preserving type) AS SecurityClassLastChangedDate,
  cast(SecurityClass.tbear as ftr_sc_tbear preserving type) AS SecurityClassLastChangedTime,
  cast(SecurityClass.rbher as ftr_sc_rbher preserving type) AS SecurityClassLastChangedSource,
  SecurityClass.wpfan AS SecurityClassIsPledgeable
FROM vwpanla AS SecurityClass
;