C_DefectFDP

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_DefectFDP.
-- 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: CDEFECTFDP

CREATE VIEW C_DefectFDP AS
SELECT
  _Defect.Defect AS Defect,
  _Defect.DefectInternalID AS DefectInternalID,
  _Defect.DefectCategory AS DefectCategory,
  _Defect.CreatedByUser AS CreatedByUser,
  _Defect.CreationDate AS CreationDate,
  _Defect.LastChangedByUser AS LastChangedByUser,
  _Defect.LastChangeDate AS LastChangeDate,
  _Defect.DefectText AS DefectText,
  _Defect.DefectCodeCatalog AS DefectCodeCatalog,
  _Defect.DefectCodeGroup AS DefectCodeGroup,
  _Defect.DefectCode AS DefectCode,
  _Defect.DefectCodeVersion AS DefectCodeVersion,
  _Defect.DefectObjectCodeCatalog AS DefectObjectCodeCatalog,
  _Defect.DefectObjectCodeGroup AS DefectObjectCodeGroup,
  _Defect.DefectObjectCode AS DefectObjectCode,
  _Defect.DefectObjectCodeVersion AS DefectObjectCodeVersion,
  _Defect.DefectCauseCodeCatalog AS DefectCauseCodeCatalog,
  _Defect.DefectCauseCodeGroup AS DefectCauseCodeGroup,
  _Defect.DefectCauseCode AS DefectCauseCode,
  _Defect.DefectCauseCodeVersion AS DefectCauseCodeVersion,
  _Defect.DefectiveQuantity AS DefectiveQuantity,
  _Defect.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  _Defect.DefectIsCreatedAutomatically AS DefectIsCreatedAutomatically,
  _Defect.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  _Defect.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  _Defect.Batch AS Batch,
  _Defect.DefectiveSingleUnit AS DefectiveSingleUnit,
  _Defect.ProductionOrder AS ProductionOrder,
  _Defect.OrderInternalID AS OrderInternalID,
  _Defect.CreationTime AS CreationTime,
  _Defect.LastChangeTime AS LastChangeTime,
  _Defect.DefectClass AS DefectClass,
  _Defect.NumberOfDefects AS NumberOfDefects,
  _Defect.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _Defect.InspectionCharacteristic AS InspectionCharacteristic,
  _Defect.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _Defect.MaterialSample AS MaterialSample,
  _Defect.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Defect.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _Defect.MainWorkCenterPlant AS MainWorkCenterPlant,
  _Defect.MainWorkCenter AS MainWorkCenter,
  _Defect.Equipment AS Equipment,
  _Defect.FunctionalLocation AS FunctionalLocation,
  _Defect.IsDeleted AS IsDeleted,
  _Defect.DefectOrigin AS DefectOrigin,
  _Defect.Material AS Material,
  _Defect.Plant AS Plant,
  _Defect.InspectionLot AS InspectionLot,
  _Defect.CatalogProfile AS CatalogProfile,
  _Defect.ChangedDateTime AS ChangedDateTime,
  _Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  _Defect.ProblemAnalysisStatus AS ProblemAnalysisStatus,
  _Defect.QualityIssueReference AS QualityIssueReference,
  _Defect.MasterLanguage AS MasterLanguage,
  _Defect.DefectUUID AS DefectUUID,
  _Defect.StorageLocation AS StorageLocation,
  _Defect.SourceStorageBin AS SourceStorageBin,
  _Defect.StorageType AS StorageType,
  _Defect.ProductionSupplyArea AS ProductionSupplyArea,
  _Defect.Warehouse AS Warehouse,
  cast( '00' as numc2 preserving type ) AS BRFFunction
FROM I_Defect_TP AS _Defect
LEFT OUTER JOIN C_DefectTaskFDP AS _DefectTask ON DefectInternalID = _DefectTask.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN C_DefectAffectedObjectFDP AS _DefectAffectedObject ON DefectInternalID = _DefectAffectedObject.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN E_NotificationItem AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000'  -- association [1..1]
;