I_QltyCertPrflMaterialTP

DDL: I_QLTYCERTPRFLMATERIALTP Type: view_entity TRANSACTIONAL
10 Fields 1 Data Sources

Trans. Process. for Cert. Prfl Material

I_QltyCertPrflMaterialTP is a Transactional CDS View that provides data about "Trans. Process. for Cert. Prfl Material" in SAP S/4HANA. It reads from 1 data source (I_QltyCertPrflMaterial) and exposes 10 fields with key fields QualityCertificateType, QltyCertificateProfile, QltyCertProfileVersion, QltyCertPrflCharcValueOrigin, Material.

Data Sources (1)

SourceAliasJoin Type
I_QltyCertPrflMaterial I_QltyCertPrflMaterial from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Trans. Process. for Cert. Prfl Material view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY QualityCertificateType QualityCertificateType Currency Type
KEY QltyCertificateProfile QltyCertificateProfile Cert. Profile
KEY QltyCertProfileVersion QltyCertProfileVersion XML Vers.
KEY QltyCertPrflCharcValueOrigin QltyCertPrflCharcValueOrigin Data origin cat
KEY Material Material Vehicle Model
QltyCertPrflGroup QltyCertPrflGroup Char.block no.
QltyCertPrflMaterialSortNumber QltyCertPrflMaterialSortNumber Sort no. mat.
InspectionLotOrigin InspectionLotOrigin Insp. Lot Orig.
InspectionLotType InspectionLotType Inspection Type
_QltyCertificateProfile _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_QltyCertPrflMaterialTP.
-- 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.

CREATE VIEW I_QltyCertPrflMaterialTP AS
SELECT
  QualityCertificateType,
  QltyCertificateProfile,
  QltyCertProfileVersion,
  QltyCertPrflCharcValueOrigin,
  Material,
  QltyCertPrflGroup,
  QltyCertPrflMaterialSortNumber,
  InspectionLotOrigin,
  InspectionLotType
FROM I_QltyCertPrflMaterial
;

Learn More