P_QltyNotifPurgDocsScr1

DDL: P_QLTYNOTIFPURGDOCSSCR1 SQL: PQLYNTFPURSCR Type: view CONSUMPTION
49 Fields 6 Data Sources 1 Associations

Supplier Eval by Quality Notification

P_QltyNotifPurgDocsScr1 is a Consumption CDS View that provides data about "Supplier Eval by Quality Notification" in SAP S/4HANA. It reads from 6 data sources and exposes 49 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem, PurchaseOrderItem. It has 1 association to related views.

Data Sources (6)

SourceAliasJoin Type
I_QltyNotificationCube QltyNotification inner
I_QltyNotificationCube QltyNotification inner
I_QltyNotificationCube QltyNotification inner
I_PurgDocScheduleLineEnhanced ScheduleLineEnhanced from
I_PurgDocScheduleLineEnhanced ScheduleLineEnhanced union_all
I_PurgDocScheduleLineEnhanced ScheduleLineEnhanced union_all

Parameters (2)

NameTypeDefault
P_StartDate qdatumerst
P_EndDate qdatumerst

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PQLYNTFPURSCR 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 (49)

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

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_QltyNotifPurgDocsScr1.
-- 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: PQLYNTFPURSCR
-- Parameters: P_StartDate : qdatumerst, P_EndDate : qdatumerst

CREATE VIEW P_QltyNotifPurgDocsScr1 AS
SELECT
  QltyNotification.PurchasingDocument AS PurchaseOrder,
  QltyNotification.PurchasingDocumentItem AS PurchaseOrderItem,
  ScheduleLineEnhanced.PurchasingGroup AS PurchasingGroup,
  ScheduleLineEnhanced.CompanyCode AS CompanyCode,
  ScheduleLineEnhanced.PurchasingOrganization AS PurchasingOrganization,
  ScheduleLineEnhanced.PurchaseOrderDate AS PurchaseOrderDate,
  ScheduleLineEnhanced.Supplier AS Supplier,
  ScheduleLineEnhanced.Material AS Material,
  ScheduleLineEnhanced.Plant AS Plant,
  ScheduleLineEnhanced.MaterialGroup AS MaterialGroup,
  ScheduleLineEnhanced.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  ScheduleLineEnhanced.NetAmount AS NetAmount,
  ScheduleLineEnhanced.DocumentCurrency AS DocumentCurrency,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  QltyNotification.QualityNotificationCount AS QualityNotificationCount,
  cast ( '1' as mmpur_ana_de_se_doc_config ) as SuplrEvalRelevantDocCategory AS PurchasingDocumentasPurchaseOrder,
  cast ( '3' as mmpur_ana_de_se_doc_config ) AS SuplrEvalRelevantDocCategory
FROM I_PurgDocScheduleLineEnhanced AS ScheduleLineEnhanced
INNER JOIN I_QltyNotificationCube AS QltyNotification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON ScheduleLineEnhanced.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
-- UNION ALL with additional select branch(es): I_PurgDocScheduleLineEnhanced
;

Learn More