A_Defect

DDL: A_DEFECT Type: view_entity CONSUMPTION Package: ODATA_QM_DEFECT_API
44 Fields 1 Data Sources

Defects

A_Defect is a Consumption CDS View that provides data about "Defects" in SAP S/4HANA. It reads from 1 data source (I_Defect_TP) and exposes 44 fields with key field DefectInternalID. Part of development package ODATA_QM_DEFECT_API.

Data Sources (1)

SourceAliasJoin Type
I_Defect_TP I_Defect_TP from

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Defects view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.entityChangeStateId ChangedDateTime view
Metadata.ignorePropagatedAnnotations true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID
Defect Defect
DefectCategory DefectCategory
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
DefectText DefectText
DefectCodeCatalog DefectCodeCatalog
DefectCodeGroup DefectCodeGroup Code Group
DefectCode DefectCode Damage Code
DefectCodeVersion DefectCodeVersion
DefectObjectCodeCatalog DefectObjectCodeCatalog
DefectObjectCodeGroup DefectObjectCodeGroup
DefectObjectCode DefectObjectCode
DefectiveQuantity DefectiveQuantity
DefectiveQuantityUnit DefectiveQuantityUnit
ManufacturingOrder ProductionOrder Order
OrderInternalID OrderInternalID Plan No.f.Oper.
ManufacturingOrderOperation Transaction
ManufacturingOrderSequence ProductionOrderSequence Visit Sequence
CreationTime CreationTime Time of Change
LastChangeTime LastChangeTime Time changed
DefectClass DefectClass Defect Class
NumberOfDefects NumberOfDefects
InspPlanOperationInternalID InspPlanOperationInternalID
InspectionCharacteristic InspectionCharacteristic
InspectionSubsetInternalID InspectionSubsetInternalID
MaterialSample MaterialSample
WorkCenterTypeCode WorkCenterTypeCode Object Type
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
MainWorkCenter MainWorkCenter Work Center
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
IsDeleted IsDeleted TRUE
DefectOrigin DefectOrigin
Material Material Vehicle Model
Plant Plant Valuation Area
InspectionLot InspectionLot Inspection Lot
CatalogProfile CatalogProfile Catalog Profile
ChangedDateTime ChangedDateTime Time Stamp
IsBusinessPurposeCompleted
_InspectionLot _InspectionLot

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_Defect.
-- 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_Defect AS
SELECT
  cast( I_Defect_TP.DefectInternalID as qmnum preserving type ) AS DefectInternalID,
  Defect,
  DefectCategory,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  DefectText,
  DefectCodeCatalog,
  DefectCodeGroup,
  DefectCode,
  DefectCodeVersion,
  DefectObjectCodeCatalog,
  DefectObjectCodeGroup,
  DefectObjectCode,
  DefectiveQuantity,
  DefectiveQuantityUnit,
  ProductionOrder AS ManufacturingOrder,
  OrderInternalID,
  cast( ProductionOrderOperation as vdm_vornr preserving type ) AS ManufacturingOrderOperation,
  ProductionOrderSequence AS ManufacturingOrderSequence,
  CreationTime,
  LastChangeTime,
  DefectClass,
  NumberOfDefects,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID,
  MaterialSample,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenterPlant,
  MainWorkCenter,
  Equipment,
  FunctionalLocation,
  IsDeleted,
  DefectOrigin,
  Material,
  Plant,
  InspectionLot,
  CatalogProfile,
  ChangedDateTime,
  I_Defect_TP._InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_Defect_TP
;

Learn More