I_ClfnCharcBasic

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_ClfnCharcBasic.
-- 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: INGCCHR20

CREATE VIEW I_ClfnCharcBasic AS
SELECT
  cast ( Characteristic.atinn as atinn_no_conv preserving type ) AS CharcInternalID,
  Characteristic.adzhl AS TimeIntervalNumber,
  Characteristic.atnam AS Characteristic,
  Characteristic.atidn AS CharcIdentificationCode,
  Characteristic.atmst AS CharcStatus,
  Characteristic.atfor AS CharcDataType,
  Characteristic.anzst AS CharcLength,
  Characteristic.anzdz AS CharcDecimals,
  Characteristic.atsch AS CharcTemplate,
  Characteristic.atkle AS ValueIsCaseSensitive,
  Characteristic.atkon AS CharcConversionRoutine,
  cast ( Characteristic.atkla as charcgroup preserving type ) AS CharcGroup,
  Characteristic.aterf AS EntryRequiredCode,
  case when Characteristic.atein = '*' then '*' when Characteristic.atein = '' then 'X' when not ( Characteristic.atein = '*' and Characteristic.atein = '' ) then '' end as MultipleValuesAllowedCode AS ateinthenendasMultipleValuesAllowedCode,
  Characteristic.unit AS CharcValueUnit,
  Characteristic.currency AS Currency,
  Characteristic.atdex AS CharcExponentFormat,
  Characteristic.atdim AS CharcExponentValue,
  Characteristic.atint AS ValueIntervalAllowedCode,
  Characteristic.atson AS AdditionalValueAllowedCode,
  Characteristic.atvor AS NegativeValueIsAllowed,
  Characteristic.datuv AS ValidityStartDate,
  Characteristic.datub AS ValidityEndDate,
  Characteristic.aennr AS ChangeNumber,
  Characteristic.lkenz AS IsDeleted,
  Characteristic.dokar AS DocumentInfoRecordDocType,
  Characteristic.doknr AS DocumentInfoRecordDocNumber,
  Characteristic.dokvr AS DocumentInfoRecordDocVersion,
  Characteristic.doktl AS DocumentInfoRecordDocPart,
  Characteristic.atauth AS CharcMaintAuthGrp,
  Characteristic.atinp AS CharcReadOnlyCode,
  Characteristic.atvie AS CharcHiddenCode,
  Characteristic.atgla AS CharcRestrictableCode,
  Characteristic.attab AS CharcReferenceTable,
  Characteristic.atfel AS CharcReferenceTableField,
  Characteristic.atprt AS CharcCheckTable,
  Characteristic.atprf AS CharcCheckFunctionModule,
  Characteristic.atfod AS CharcEntryNotFormatCtrldCode,
  Characteristic.atvsc AS CharcTemplateDisplayedCode,
  Characteristic.auswahlmge AS CharcSelectedSet,
  Characteristic.werks AS Plant,
  Characteristic.katalogart AS CharcCatalogType,
  Characteristic.aname AS CreatedByUser,
  Characteristic.adatu AS CreationDate,
  Characteristic.vname AS LastChangedByUser,
  Characteristic.vdatu AS LastChangeDate,
  Characteristic.lastchangeddatetime AS CharcLastChangedDateTime
FROM cabn AS Characteristic
;