I_ClfnCharcForKeyDateTP

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_ClfnCharcForKeyDateTP.
-- 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: INGCCHR01TP
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_ClfnCharcForKeyDateTP AS
SELECT
  Characteristic.CharcInternalID AS CharcInternalID,
  Characteristic.Characteristic AS Characteristic,
  Characteristic.CharcStatus AS CharcStatus,
  _CharacteristicStatusText[1:Language=$session.system_language].CharcStatusName AS CharcStatusName,
  Characteristic.CharcDataType AS CharcDataType,
  Characteristic.CharcLength AS CharcLength,
  Characteristic.CharcDecimals AS CharcDecimals,
  Characteristic.CharcTemplate AS CharcTemplate,
  Characteristic.ValueIsCaseSensitive AS ValueIsCaseSensitive,
  Characteristic.CharcGroup AS CharcGroup,
  _CharacteristicGroupText[1:Language=$session.system_language].CharcGroupName AS CharcGroupName,
  EntryIsRequired,
  MultipleValuesAreAllowed,
  Characteristic.CharcValueUnit AS CharcValueUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  Characteristic.Currency AS Currency,
  _Currency.CurrencyISOCode AS CurrencyISOCode,
  Characteristic.CharcExponentValue AS CharcExponentValue,
  ValueIntervalIsAllowed,
  AdditionalValueIsAllowed,
  Characteristic.NegativeValueIsAllowed AS NegativeValueIsAllowed,
  Characteristic.ValidityStartDate AS ValidityStartDate,
  Characteristic.ValidityEndDate AS ValidityEndDate,
  Characteristic.ChangeNumber AS ChangeNumber,
  Characteristic.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  Characteristic.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  Characteristic.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  Characteristic.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  Characteristic.CharcMaintAuthGrp AS CharcMaintAuthGrp,
  CharcIsReadOnly,
  CharcIsHidden,
  Characteristic.CharcIsRestrictable AS CharcIsRestrictable,
  Characteristic.CharcExponentFormat AS CharcExponentFormat,
  CharcEntryIsNotFormatCtrld,
  CharcTemplateIsDisplayed,
  Characteristic.CreationDate AS CreationDate,
  Characteristic.LastChangeDate AS LastChangeDate,
  Characteristic.CharcLastChangedDateTime AS CharcLastChangedDateTime,
  $parameters.P_KeyDate AS KeyDate
FROM I_ClfnCharacteristicForKeyDate
LEFT OUTER JOIN I_ClfnCharcGroupText AS _CharacteristicGroupText ON CharcGroup = _CharacteristicGroupText.CharcGroup  -- association [0..*]
LEFT OUTER JOIN I_ClfnCharcStatusText AS _CharacteristicStatusText ON CharcStatus = _CharacteristicStatusText.CharcStatus  -- association [0..*]
LEFT OUTER JOIN I_ClfnCharcDescForKeyDateTP AS _CharacteristicDesc ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ClfnCharcRstrcnForKeyDateTP AS _CharacteristicRestriction ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ClfnCharcRefForKeyDateTP AS _CharacteristicReference ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ClfnCharcValForKeyDateTP AS _CharacteristicValue ON /* condition not available in parsed metadata */  -- association [0..*]
;