C_QltyProcmtCertInspLot

DDL: C_QLTYPROCMTCERTINSPLOT SQL: CQLTYPRCEIL Type: view CONSUMPTION Package: ODATA_QM_CERTIFICATE
14 Fields 2 Data Sources 2 OData Services 1 Fiori Apps

Certificate Receipt

C_QltyProcmtCertInspLot is a Consumption CDS View that provides data about "Certificate Receipt" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, I_QltyProcmtCertTP) and exposes 14 fields with key field QualityProcurementCertificate. It is exposed through 2 OData services (ASQL_F3233, UI_CERTIFICATERECEIPTS). It is used in 1 Fiori application: Manage Certificate Receipts. Part of development package ODATA_QM_CERTIFICATE.

Data Sources (2)

SourceAliasJoin Type
I_InspectionLot _InspectionLot from
I_QltyProcmtCertTP I_QltyProcmtCertTP inner

Annotations (8)

NameValueLevelField
EndUserText.label Certificate Receipt view
AbapCatalog.sqlViewName CQLTYPRCEIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3233 ASQL_F3233 C2 NOT_RELEASED
UI_CERTIFICATERECEIPTS UI_CERTIFICATERECEIPTS V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F3233 Manage Certificate Receipts Transactional With this app you can manage the receipts you receive from suppliers for purchase orders or goods receipt

Manage Certificate Receipts

Business Role: Quality Technician

Manage Quality Certificate Receipts With this app, you can manage and monitor the receipt of quality certificates from suppliers, ensuring that each required certificate is received for the respective materials. You can define the necessity of these certificates in the material master and track their receipt independently of the goods receipt through various methods, including manual recording and automatic system updates.

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY QualityProcurementCertificate I_QltyProcmtCertTP QualityProcurementCertificate
InspectionLot I_InspectionLot InspectionLot Inspection Lot
InspectionLotTypeText
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
InspectionLotQuantity I_InspectionLot InspectionLotQuantity
InspectionLotQuantityUnit I_InspectionLot InspectionLotQuantityUnit Sample UOM
_InspectionLotType _InspectionLotType
InspectionLotUsageDecisionCode _InspLotUsageDecision InspectionLotUsageDecisionCode
InspLotUsageDecisionCodeGroup _InspLotUsageDecision InspLotUsageDecisionCodeGroup
UsageDecisionCodeText
_UsageDecisionCode _InspLotUsageDecision _UsageDecisionCode
QualityCertificateType I_QltyProcmtCertTP QualityCertificateType
Plant I_QltyProcmtCertTP Plant Valuation Area
IsBusinessPurposeCompleted I_QltyProcmtCertTP IsBusinessPurposeCompleted Purpose Completed

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 C_QltyProcmtCertInspLot.
-- 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: CQLTYPRCEIL

CREATE VIEW C_QltyProcmtCertInspLot AS
SELECT
  I_QltyProcmtCertTP.QualityProcurementCertificate AS QualityProcurementCertificate,
  _InspectionLot.InspectionLot AS InspectionLot,
  _InspectionLot._InspectionLotType._Text[ 1: Language = $session.system_language ].InspectionLotTypeText AS InspectionLotTypeText,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspLotUsageDecision.InspLotUsageDecisionCodeGroup AS InspLotUsageDecisionCodeGroup,
  _InspLotUsageDecision._UsageDecisionCode._Text[ 1: Language = $session.system_language ].UsageDecisionCodeText AS UsageDecisionCodeText,
  _InspLotUsageDecision._UsageDecisionCode AS _UsageDecisionCode,
  I_QltyProcmtCertTP.QualityCertificateType AS QualityCertificateType,
  I_QltyProcmtCertTP.Plant AS Plant,
  I_QltyProcmtCertTP.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_InspectionLot AS _InspectionLot
INNER JOIN I_QltyProcmtCertTP ON /* join condition not captured in parsed metadata */
;

Learn More