I_QltyCertificateProfile

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_QltyCertificateProfile.
-- 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: IQLTYCERTPF

CREATE VIEW I_QltyCertificateProfile AS
SELECT
  ctyp AS QualityCertificateType,
  vorlnr AS QltyCertificateProfile,
  version AS QltyCertProfileVersion,
  kurztext AS QltyCertProfileText,
  tdform AS QltyCertificateForm,
  kzgutlose AS QltyCertHasOnlyAcceptedInspLot,
  minqkz AS QltyCertMinInspLotQltyScore,
  kzlastlot AS QltyCertHasLastInspLot,
  kzliefsch AS QltyCertInspLotHasDelivery,
  herkunft AS InspectionLotOrigin,
  art AS InspectionLotType,
  withtransf AS QltyCertBatchWhereUsdListCtrl,
  alstf AS QltyCertBatchExpansionLevel,
  adbform AS QltyCertificateAdobeForm,
  cast( qkz_useadb as vdm_qc_qkz_useadb preserving type ) AS QltyCertProfileHasAdobeForm,
  char_field_conf AS QltyCertPrflCharcConfign,
  ChangedDateTime
FROM qcvk
LEFT OUTER JOIN I_QltyCertPrflCharacteristic AS _QltyCertPrflCharacteristic ON QltyCertificateProfile = _QltyCertPrflCharacteristic.QltyCertificateProfile AND QltyCertProfileVersion = _QltyCertPrflCharacteristic.QltyCertProfileVersion AND QualityCertificateType = _QltyCertPrflCharacteristic.QualityCertificateType  -- association [0..*]
LEFT OUTER JOIN I_QltyCertPrflMaterialAssgmt AS _QltyCertPrflMaterialAssgmt ON QltyCertificateProfile = _QltyCertPrflMaterialAssgmt.QltyCertificateProfile AND QltyCertProfileVersion = _QltyCertPrflMaterialAssgmt.QltyCertProfileVersion AND QualityCertificateType = _QltyCertPrflMaterialAssgmt.QualityCertificateType  -- association [0..*]
;