A_Defect
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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Defect_TP | I_Defect_TP | from |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ADEFECT | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DefectInternalID | |||
| Defect | Defect | |||
| DefectCategory | DefectCategory | |||
| CreatedByUser | CreatedByUser | |||
| CreationDate | CreationDate | |||
| LastChangedByUser | LastChangedByUser | |||
| LastChangeDate | LastChangeDate | |||
| DefectText | DefectText | |||
| DefectCodeCatalog | DefectCodeCatalog | |||
| DefectCodeGroup | DefectCodeGroup | |||
| DefectCode | DefectCode | |||
| DefectCodeVersion | DefectCodeVersion | |||
| DefectObjectCodeCatalog | DefectObjectCodeCatalog | |||
| DefectObjectCodeGroup | DefectObjectCodeGroup | |||
| DefectObjectCode | DefectObjectCode | |||
| DefectiveQuantity | DefectiveQuantity | |||
| DefectiveQuantityUnit | DefectiveQuantityUnit | |||
| ManufacturingOrder | ProductionOrder | |||
| OrderInternalID | OrderInternalID | |||
| ManufacturingOrderOperation | ||||
| ManufacturingOrderSequence | ProductionOrderSequence | |||
| CreationTime | CreationTime | |||
| LastChangeTime | LastChangeTime | |||
| DefectClass | DefectClass | |||
| NumberOfDefects | NumberOfDefects | |||
| InspPlanOperationInternalID | InspPlanOperationInternalID | |||
| InspectionCharacteristic | InspectionCharacteristic | |||
| InspectionSubsetInternalID | InspectionSubsetInternalID | |||
| MaterialSample | MaterialSample | |||
| WorkCenterTypeCode | WorkCenterTypeCode | |||
| MainWorkCenterInternalID | MainWorkCenterInternalID | |||
| MainWorkCenterPlant | MainWorkCenterPlant | |||
| MainWorkCenter | MainWorkCenter | |||
| Equipment | Equipment | |||
| FunctionalLocation | FunctionalLocation | |||
| IsDeleted | IsDeleted | |||
| DefectOrigin | DefectOrigin | |||
| Material | Material | |||
| Plant | Plant | |||
| InspectionLot | InspectionLot | |||
| CatalogProfile | CatalogProfile | |||
| ChangedDateTime | ChangedDateTime | |||
| IsBusinessPurposeCompleted | _InspectionLot | IsBusinessPurposeCompleted | ||
| _InspectionLot | _InspectionLot |
@AbapCatalog.sqlViewName: 'ADEFECT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@EndUserText.label: 'Defects'
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #XL,
serviceQuality: #C
},
compositionRoot: true,
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
entityChangeStateId: 'ChangedDateTime'
}
@Metadata.ignorePropagatedAnnotations: true
define view A_Defect as select from I_Defect_TP
{
@ObjectModel.readOnly: true
key cast( I_Defect_TP.DefectInternalID as qmnum preserving type ) as DefectInternalID,
@ObjectModel.readOnly: true
Defect,
@ObjectModel.readOnly: true
DefectCategory,
@ObjectModel.readOnly: true
CreatedByUser,
@ObjectModel.readOnly: true
CreationDate,
@ObjectModel.readOnly: true
LastChangedByUser,
@ObjectModel.readOnly: true
LastChangeDate,
DefectText,
DefectCodeCatalog,
DefectCodeGroup,
DefectCode,
DefectCodeVersion,
DefectObjectCodeCatalog,
DefectObjectCodeGroup,
DefectObjectCode,
@Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
DefectiveQuantity,
DefectiveQuantityUnit,
ProductionOrder as ManufacturingOrder,
@ObjectModel.readOnly: true
OrderInternalID,
cast( ProductionOrderOperation as vdm_vornr preserving type ) as ManufacturingOrderOperation,
ProductionOrderSequence as ManufacturingOrderSequence,
@ObjectModel.readOnly: true
CreationTime,
@ObjectModel.readOnly: true
LastChangeTime,
DefectClass,
NumberOfDefects,
InspPlanOperationInternalID,
InspectionCharacteristic,
InspectionSubsetInternalID,
MaterialSample,
WorkCenterTypeCode,
MainWorkCenterInternalID,
MainWorkCenterPlant,
MainWorkCenter,
Equipment,
FunctionalLocation,
@ObjectModel.readOnly: true
IsDeleted,
DefectOrigin,
Material,
Plant,
InspectionLot,
CatalogProfile,
@ObjectModel.readOnly: true
ChangedDateTime,
@Consumption.hidden: true
_InspectionLot.IsBusinessPurposeCompleted,
@Consumption.hidden: true
_InspectionLot
} where DefectCategory <> '08'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECT_TP",
"I_INSPECTIONLOT"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT"
],
"BASE":
[
"I_DEFECT_TP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA