I_QltyCertPrflCharacteristic

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_QltyCertPrflCharacteristic.
-- 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: IQLTYCERTPFC

CREATE VIEW I_QltyCertPrflCharacteristic AS
SELECT
  ctyp AS QualityCertificateType,
  vorlnr AS QltyCertificateProfile,
  version AS QltyCertProfileVersion,
  blocknr AS QltyCertPrflGroup,
  merkmalnr AS QltyCertPrflCharacteristic,
  sortnr AS QltyCertPrflCharcSortNumber,
  text_elem AS QltyCertPrflTextElement,
  kategorie AS QltyCertPrflCharcType,
  zaehler AS InspectionSpecificationPlant,
  mkmnr AS InspectionSpecification,
  versionmk AS InspectionSpecificationVersion,
  cmerkmalid AS CharacteristicInternalID,
  cast( cmerkmalid as atinn_no_conv preserving type ) AS CharcInternalID,
  kzherkwert AS QltyCertPrflCharcValueOrigin,
  kzherktext AS QltyCertPrflCharcTextOrigin,
  kzausgfmt AS QltyCertPrflCharcFormat,
  kzmethode AS QltyCertPrflCharcMethodOutput,
  kzesel AS QltyCertPrflCharcLevel,
  kzherkvg AS QltyCertPrflCharcSpecOrigin,
  kzstrskip AS QltyCertPrflCharcSkipOutput,
  masseinhsw AS InspectionSpecificationUnit,
  ausglen AS QltyCertPrflCharcOutputLength,
  stellen AS QltyCertPrflCharcDecimals,
  kzexpds AS QltyCertPrflCharcIsExponential,
  kzoffsptx AS QltyCertPrflCharcOutOfSpecOutp,
  kzobl AS QltyCertPrflCharcIsRequired,
  vmsortnr AS QltyCertPrflMaterialSortNumber,
  columnsort AS QltyCertPrflCharcHasColumn,
  columns AS QltyCertPrflCharcColumns,
  charact_id1 AS InspSpecGlobalName
FROM qcvm
LEFT OUTER JOIN I_QltyCertificateProfile AS _QltyCertificateProfile ON QualityCertificateType = _QltyCertificateProfile.QualityCertificateType AND QltyCertificateProfile = _QltyCertificateProfile.QltyCertificateProfile AND QltyCertProfileVersion = _QltyCertificateProfile.QltyCertProfileVersion  -- association [0..1]
LEFT OUTER JOIN I_QltyCertPrflCharcText AS _Text ON QualityCertificateType = _Text.QualityCertificateType AND QltyCertificateProfile = _Text.QltyCertificateProfile AND QltyCertProfileVersion = _Text.QltyCertProfileVersion AND QltyCertPrflGroup = _Text.QltyCertPrflGroup AND QltyCertPrflCharacteristic = _Text.QltyCertPrflCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_ClfnCharacteristicForKeyDate AS _ClfnCharacteristicForKeyDate ON CharcInternalID = _ClfnCharacteristicForKeyDate.CharcInternalID  -- association [0..1]
LEFT OUTER JOIN I_ClfnCharcDescForKeyDate AS _ClfnCharcDescForKeyDate ON CharcInternalID = _ClfnCharcDescForKeyDate.CharcInternalID  -- association [0..*]
;