I_QltyCertPrflMaterialAssgmt

DDL: I_QLTYCERTPRFLMATERIALASSGMT SQL: IQLTYCERTPFMATAS Type: view BASIC
7 Fields 2 Data Sources

Certificate Profile Material Assignment

I_QltyCertPrflMaterialAssgmt is a Basic CDS View that provides data about "Certificate Profile Material Assignment" in SAP S/4HANA. It reads from 2 data sources (kondi, koti001) and exposes 7 fields with key field ConditionRecord.

Data Sources (2)

SourceAliasJoin Type
kondi kondi from
koti001 koti001 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IQLTYCERTPFMATAS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Certificate Profile Material Assignment view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord kondi knumh NoCondRec.Batch
QltyCertificateProfile kondi vorlnr Cert. Profile
QltyCertProfileVersion kondi version XML Vers.
QualityCertificateType kondi ctyp Currency Type
Material koti001 matnr Vehicle Model
ConditionValidityEndDate koti001 datbi Validity period
ConditionValidityStartDate koti001 datab Validity period

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_QltyCertPrflMaterialAssgmt.
-- 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: IQLTYCERTPFMATAS

CREATE VIEW I_QltyCertPrflMaterialAssgmt AS
SELECT
  kondi.knumh AS ConditionRecord,
  kondi.vorlnr AS QltyCertificateProfile,
  kondi.version AS QltyCertProfileVersion,
  kondi.ctyp AS QualityCertificateType,
  koti001.matnr AS Material,
  koti001.datbi AS ConditionValidityEndDate,
  koti001.datab AS ConditionValidityStartDate
FROM kondi
INNER JOIN koti001 ON /* join condition not captured in parsed metadata */
;

Learn More