C_QltyNotificationItemFDP

DDL: C_QLTYNOTIFICATIONITEMFDP SQL: CQLTYNTFITMFDP Type: view CONSUMPTION
57 Fields 1 Data Sources 2 Associations

Item Data of Quality Notification

C_QltyNotificationItemFDP is a Consumption CDS View that provides data about "Item Data of Quality Notification" in SAP S/4HANA. It reads from 1 data source (I_QualityNotificationItem) and exposes 57 fields with key fields QualityNotification, NotificationItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_QualityNotificationItem I_QualityNotificationItem from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_QltyNotificationTaskFDP _QltyNotificationTaskFDP $projection.QualityNotification = _QltyNotificationTaskFDP.QualityNotification and $projection.NotificationItem = _QltyNotificationTaskFDP.NotificationItem
[1..1] E_NotificationItem _Extension $projection.QualityNotification = _Extension.Notification and $projection.NotificationItem = _Extension.NotificationItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYNTFITMFDP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Item Data of Quality Notification view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey NotificationItem view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification QualityNotification Notification
KEY NotificationItem NotificationItem
NotifProcessingPhase NotifProcessingPhase Notif. Phase
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
NotificationItemText NotificationItemText
DefectCodeCatalog DefectCodeCatalog
DefectCodeGroup DefectCodeGroup Code Group
DefectCode DefectCode Damage Code
NotifItmObjectPartCodeCtlg NotifItmObjectPartCodeCtlg
NotifItmObjectPartCodeGroup NotifItmObjectPartCodeGroup
NotifItmObjectPartCode NotifItmObjectPartCode
Assembly Assembly Pegged Reqmt
MasterLanguage MasterLanguage Primary lang.
CreationTime CreationTime Time of Change
LastChangeTime LastChangeTime Time changed
DefectClass DefectClass Defect Class
NumberOfDefects NumberOfDefects
InspPlanOperationInternalID InspPlanOperationInternalID
InspectionCharacteristic InspectionCharacteristic
InspectionSubsetInternalID InspectionSubsetInternalID
MaterialSample MaterialSample
DefectiveSingleUnit DefectiveSingleUnit
WorkCenterTypeCode WorkCenterTypeCode Object Type
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
IsDeleted IsDeleted TRUE
NotificationItemExternalID NotificationItemExternalID
DefectOrigin DefectOrigin
DefectiveQuantity DefectiveQuantity
DefectiveQuantityUnit DefectiveQuantityUnit
ReferencedDefect ReferencedDefect
ChangedDateTime ChangedDateTime Time Stamp
_Assembly _Assembly
_CreatedByUserContactCard _CreatedByUserContactCard
_DefectClass _DefectClass
_DefectCode _DefectCode
_DefectCodeCatalog _DefectCodeCatalog
_DefectCodeGroup _DefectCodeGroup
_DefectiveQtyUnitOfMeasure _DefectiveQtyUnitOfMeasure
_DefectiveQuantityUnit _DefectiveQuantityUnit
_DefectLocationCatalog _DefectLocationCatalog
_DefectLocationCode _DefectLocationCode
_DefectLocationCodeGroup _DefectLocationCodeGroup
_LastChangedByUserContactCard _LastChangedByUserContactCard
_Notification _Notification
_NotifItmObjectPartCode _NotifItmObjectPartCode
_NotifItmObjectPartCodeCtlg _NotifItmObjectPartCodeCtlg
_NotifItmObjectPartCodeGroup _NotifItmObjectPartCodeGroup
_QltyNotificationActivity _QltyNotificationActivity
_QltyNotificationCause _QltyNotificationCause
_QltyNotificationTaskFDP _QltyNotificationTaskFDP
_QltyNotifItemLongText _QltyNotifItemLongText
_ReferencedDefect _ReferencedDefect

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_QltyNotificationItemFDP.
-- 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: CQLTYNTFITMFDP

CREATE VIEW C_QltyNotificationItemFDP AS
SELECT
  QualityNotification,
  NotificationItem,
  NotifProcessingPhase,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  NotificationItemText,
  DefectCodeCatalog,
  DefectCodeGroup,
  DefectCode,
  NotifItmObjectPartCodeCtlg,
  NotifItmObjectPartCodeGroup,
  NotifItmObjectPartCode,
  Assembly,
  MasterLanguage,
  CreationTime,
  LastChangeTime,
  DefectClass,
  NumberOfDefects,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID,
  MaterialSample,
  DefectiveSingleUnit,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterPlant,
  IsDeleted,
  NotificationItemExternalID,
  DefectOrigin,
  DefectiveQuantity,
  DefectiveQuantityUnit,
  ReferencedDefect,
  ChangedDateTime
FROM I_QualityNotificationItem
LEFT OUTER JOIN C_QltyNotificationTaskFDP AS _QltyNotificationTaskFDP ON QualityNotification = _QltyNotificationTaskFDP.QualityNotification AND NotificationItem = _QltyNotificationTaskFDP.NotificationItem  -- association [0..*]
LEFT OUTER JOIN E_NotificationItem AS _Extension ON QualityNotification = _Extension.Notification AND NotificationItem = _Extension.NotificationItem  -- association [1..1]
;

Learn More