I_ProdExQltyInfoRecdInProcmt

DDL: I_PRODEXQLTYINFORECDINPROCMT SQL: IPREXQINFRECPROC Type: view COMPOSITE
9 Fields 5 Data Sources

Products without Q-Info records

I_ProdExQltyInfoRecdInProcmt is a Composite CDS View that provides data about "Products without Q-Info records" in SAP S/4HANA. It reads from 5 data sources (I_Product, I_Productplantqtmanagement, I_QualityInProcurement, P_QltyInProcmtPlntIdxTblFunc, tq08) and exposes 9 fields with key fields Product, Plant.

Data Sources (5)

SourceAliasJoin Type
I_Product _Prod inner
I_Productplantqtmanagement _Productplantqtmanagement from
I_QualityInProcurement _QualityInProcurement left_outer
P_QltyInProcmtPlntIdxTblFunc P_QltyInProcmtPlntIdxTblFunc inner
tq08 tq08 left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPREXQINFRECPROC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Products without Q-Info records view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product I_Productplantqtmanagement Product Product Sold
KEY Plant I_Productplantqtmanagement Plant Valuation Area
QltyInProcmtIntID _PlantCount werksIndx
QualityMgmtCtrlKey QualityMgmtCtrlKey QM Control Key
SupplierReleaseIsRequired tq08 lieffrei Suppl. Release
QltyMgmtInProcmtIsActive I_Product QltyMgmtInProcmtIsActive QM procurement
BaseUnit I_Product BaseUnit Unit of Measure
AuthorizationGroup I_Product AuthorizationGroup AuthorizGroup
MatlQualityAuthorizationGroup I_Productplantqtmanagement MatlQualityAuthorizationGroup QM Matl Auth.

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_ProdExQltyInfoRecdInProcmt.
-- 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: IPREXQINFRECPROC

CREATE VIEW I_ProdExQltyInfoRecdInProcmt AS
SELECT
  _Productplantqtmanagement.Product AS Product,
  _Productplantqtmanagement.Plant AS Plant,
  _PlantCount.werksIndx AS QltyInProcmtIntID,
  QualityMgmtCtrlKey,
  tq08.lieffrei AS SupplierReleaseIsRequired,
  _Prod.QltyMgmtInProcmtIsActive AS QltyMgmtInProcmtIsActive,
  _Prod.BaseUnit AS BaseUnit,
  _Prod.AuthorizationGroup AS AuthorizationGroup,
  _Productplantqtmanagement.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_Productplantqtmanagement AS _Productplantqtmanagement
INNER JOIN I_Product AS _Prod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tq08 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_QualityInProcurement AS _QualityInProcurement ON /* join condition not captured in parsed metadata */
INNER JOIN P_QltyInProcmtPlntIdxTblFunc ON /* join condition not captured in parsed metadata */
;

Learn More