P_QltyNotifPurgDocs1

DDL: P_QLTYNOTIFPURGDOCS1 SQL: PQLTNTFPURDOC Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
16 Fields 3 Data Sources 1 Associations

Supplier Eval by Quality Notification

P_QltyNotifPurgDocs1 is a Consumption CDS View that provides data about "Supplier Eval by Quality Notification" in SAP S/4HANA. It reads from 3 data sources (I_PurchaseOrder, I_PurchaseOrderItem, I_QltyNotificationCube) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder inner
I_PurchaseOrderItem PurchaseOrderItem from
I_QltyNotificationCube QltyNotification inner

Parameters (2)

NameTypeDefault
P_StartDate qdatumerst
P_EndDate qdatumerst

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingCategoryMatlGroup _PurchasingCategoryMatlGroup PurchaseOrderItem.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PQLTNTFPURDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Eval by Quality Notification view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_QltyNotificationCube PurchasingDocument Purchasing Document
KEY PurchaseOrderItem I_QltyNotificationCube PurchasingDocumentItem Purchasing Doc. Item
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode I_PurchaseOrder CompanyCode Receiver Company Code
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
PurchaseOrderDate I_PurchaseOrder PurchaseOrderDate PO Date
Supplier I_PurchaseOrder Supplier Supplier
DocumentCurrency I_PurchaseOrder DocumentCurrency Document Currency
Material I_PurchaseOrderItem Material Vehicle Model
Plant I_PurchaseOrderItem Plant Valuation Area
MaterialGroup I_PurchaseOrderItem MaterialGroup Product Group
NetAmount I_PurchaseOrderItem NetAmount Stated Amount
PurchasingDocumentCategory I_PurchaseOrderItem PurchaseOrderCategory Doc. Category
PurchasingCategory
PurgCatName
QualityNotificationCount I_QltyNotificationCube QualityNotificationCount

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 P_QltyNotifPurgDocs1.
-- 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: PQLTNTFPURDOC
-- Parameters: P_StartDate : qdatumerst, P_EndDate : qdatumerst

CREATE VIEW P_QltyNotifPurgDocs1 AS
SELECT
  QltyNotification.PurchasingDocument AS PurchaseOrder,
  QltyNotification.PurchasingDocumentItem AS PurchaseOrderItem,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.NetAmount AS NetAmount,
  PurchaseOrderItem.PurchaseOrderCategory AS PurchasingDocumentCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  QltyNotification.QualityNotificationCount AS QualityNotificationCount
FROM I_PurchaseOrderItem AS PurchaseOrderItem
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_QltyNotificationCube AS QltyNotification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON PurchaseOrderItem.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
;

Learn More