A_Defect

DDL: A_DEFECT SQL: ADEFECT Type: view CONSUMPTION

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)

SourceAliasJoin Type
I_Defect_TP I_Defect_TP from

Annotations (18)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/