A_QualityNotificationItem

DDL: A_QUALITYNOTIFICATIONITEM Type: view_entity CONSUMPTION
36 Fields 1 Data Sources

Quality Notification Item

A_QualityNotificationItem is a Consumption CDS View that provides data about "Quality Notification Item" in SAP S/4HANA. It reads from 1 data source (R_QualityNotificationItemTP) and exposes 36 fields with key fields QualityNotification, NotificationItem.

Data Sources (1)

SourceAliasJoin Type
R_QualityNotificationItemTP R_QualityNotificationItemTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Quality Notification Item view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey NotificationItem view
OData.entitySet.name QualityNotificationItem view
OData.entityType.name QualityNotificationItem_Type view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification _QualityNotificationItem QualityNotification
KEY NotificationItem _QualityNotificationItem NotificationItem
NotificationItemExternalID _QualityNotificationItem NotificationItemExternalID
NotificationItemText _QualityNotificationItem NotificationItemText
MasterLanguage _QualityNotificationItem MasterLanguage Primary lang.
Assembly _QualityNotificationItem Assembly Pegged Reqmt
DefectClass _QualityNotificationItem DefectClass Defect Class
NumberOfDefects _QualityNotificationItem NumberOfDefects
InspPlanOperationInternalID _QualityNotificationItem InspPlanOperationInternalID
InspectionCharacteristic _QualityNotificationItem InspectionCharacteristic
InspectionSubsetInternalID _QualityNotificationItem InspectionSubsetInternalID
MaterialSample _QualityNotificationItem MaterialSample
DefectiveSingleUnit _QualityNotificationItem DefectiveSingleUnit
WorkCenterTypeCode _QualityNotificationItem WorkCenterTypeCode Object Type
MainWorkCenterInternalID _QualityNotificationItem MainWorkCenterInternalID Work Center
MainWorkCenter _QualityNotificationItem MainWorkCenter Work Center
MainWorkCenterPlant _QualityNotificationItem MainWorkCenterPlant Plnt WorkCenter
DefectOrigin _QualityNotificationItem DefectOrigin
ReferencedDefect _QualityNotificationItem ReferencedDefect
IsDeleted _QualityNotificationItem IsDeleted TRUE
DefectCodeCatalog _QualityNotificationItem DefectCodeCatalog
DefectCodeGroup _QualityNotificationItem DefectCodeGroup Code Group
DefectCode _QualityNotificationItem DefectCode Damage Code
NotifItmObjectPartCodeCtlg _QualityNotificationItem NotifItmObjectPartCodeCtlg
NotifItmObjectPartCodeGroup _QualityNotificationItem NotifItmObjectPartCodeGroup
NotifItmObjectPartCode _QualityNotificationItem NotifItmObjectPartCode
ExternalDefectiveQuantity _QualityNotificationItem ExternalDefectiveQuantity
InternalDefectiveQuantity _QualityNotificationItem InternalDefectiveQuantity
DefectiveQuantityUnit _QualityNotificationItem DefectiveQuantityUnit
CreatedByUser _QualityNotificationItem CreatedByUser User Name
CreationDate _QualityNotificationItem CreationDate Time Stamp
CreationTime _QualityNotificationItem CreationTime Time of Change
LastChangedByUser _QualityNotificationItem LastChangedByUser User Name
LastChangeDate _QualityNotificationItem LastChangeDate Time Stamp
LastChangeTime _QualityNotificationItem LastChangeTime Time changed
_Notification _QualityNotificationItem _Notification

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 A_QualityNotificationItem.
-- 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 A_QualityNotificationItem AS
SELECT
  _QualityNotificationItem.QualityNotification AS QualityNotification,
  _QualityNotificationItem.NotificationItem AS NotificationItem,
  _QualityNotificationItem.NotificationItemExternalID AS NotificationItemExternalID,
  _QualityNotificationItem.NotificationItemText AS NotificationItemText,
  _QualityNotificationItem.MasterLanguage AS MasterLanguage,
  _QualityNotificationItem.Assembly AS Assembly,
  _QualityNotificationItem.DefectClass AS DefectClass,
  _QualityNotificationItem.NumberOfDefects AS NumberOfDefects,
  _QualityNotificationItem.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _QualityNotificationItem.InspectionCharacteristic AS InspectionCharacteristic,
  _QualityNotificationItem.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _QualityNotificationItem.MaterialSample AS MaterialSample,
  _QualityNotificationItem.DefectiveSingleUnit AS DefectiveSingleUnit,
  _QualityNotificationItem.WorkCenterTypeCode AS WorkCenterTypeCode,
  _QualityNotificationItem.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _QualityNotificationItem.MainWorkCenter AS MainWorkCenter,
  _QualityNotificationItem.MainWorkCenterPlant AS MainWorkCenterPlant,
  _QualityNotificationItem.DefectOrigin AS DefectOrigin,
  _QualityNotificationItem.ReferencedDefect AS ReferencedDefect,
  _QualityNotificationItem.IsDeleted AS IsDeleted,
  _QualityNotificationItem.DefectCodeCatalog AS DefectCodeCatalog,
  _QualityNotificationItem.DefectCodeGroup AS DefectCodeGroup,
  _QualityNotificationItem.DefectCode AS DefectCode,
  _QualityNotificationItem.NotifItmObjectPartCodeCtlg AS NotifItmObjectPartCodeCtlg,
  _QualityNotificationItem.NotifItmObjectPartCodeGroup AS NotifItmObjectPartCodeGroup,
  _QualityNotificationItem.NotifItmObjectPartCode AS NotifItmObjectPartCode,
  _QualityNotificationItem.ExternalDefectiveQuantity AS ExternalDefectiveQuantity,
  _QualityNotificationItem.InternalDefectiveQuantity AS InternalDefectiveQuantity,
  _QualityNotificationItem.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  _QualityNotificationItem.CreatedByUser AS CreatedByUser,
  _QualityNotificationItem.CreationDate AS CreationDate,
  _QualityNotificationItem.CreationTime AS CreationTime,
  _QualityNotificationItem.LastChangedByUser AS LastChangedByUser,
  _QualityNotificationItem.LastChangeDate AS LastChangeDate,
  _QualityNotificationItem.LastChangeTime AS LastChangeTime,
  _QualityNotificationItem._Notification AS _Notification
FROM R_QualityNotificationItemTP
;

Learn More