C_DefectFDP

@AbapCatalog.sqlViewName: 'CDEFECTFDP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck: #MANDATORY,
    personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'FDP view for QM Defect'
@VDM: {
    viewType: #CONSUMPTION,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #OUTPUT_FORM_DATA_PROVIDER ]
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #XL,
        serviceQuality: #C },
    representativeKey: 'Defect',
    semanticKey:  [ 'Defect' ]
}
@AccessControl.privilegedAssociations:  [ '_CreatedByUserContactCard', '_LastChangedByUserContactCard' ]
@Metadata.allowExtensions: true
@Consumption.semanticObject: 'Defect'
@ClientHandling.algorithm: #SESSION_VARIABLE

 /*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view C_DefectFDP as select from  I_Defect_TP as _Defect

    association [0..*] to C_DefectTaskFDP    as _DefectTask       on $projection.DefectInternalID = _DefectTask.DefectInternalID
    association [0..*] to C_DefectAffectedObjectFDP as _DefectAffectedObject   on $projection.DefectInternalID = _DefectAffectedObject.DefectInternalID

    //Extension

    association [1..1] to E_NotificationItem        as _Extension              on  $projection.DefectInternalID = _Extension.Notification and
                                                                                   _Extension.NotificationItem = '0000'
  {
    //I_Defect

    //key cast (substring(DefectInternalID,2,11) as qdefectid preserving type ) as Defect,

    key _Defect.Defect,
    _Defect.DefectInternalID,
    _Defect.DefectCategory,
    _Defect.CreatedByUser,
    _Defect.CreationDate,
    _Defect.LastChangedByUser,
    _Defect.LastChangeDate,
    _Defect.DefectText,
    _Defect.DefectCodeCatalog,
    _Defect.DefectCodeGroup,
    _Defect.DefectCode,
    _Defect.DefectCodeVersion,
    _Defect.DefectObjectCodeCatalog,
    _Defect.DefectObjectCodeGroup,
    _Defect.DefectObjectCode,
    _Defect.DefectObjectCodeVersion,
    _Defect.DefectCauseCodeCatalog,
    _Defect.DefectCauseCodeGroup,
    _Defect.DefectCauseCode,
    _Defect.DefectCauseCodeVersion,
    _Defect.DefectiveQuantity,
    _Defect.DefectiveQuantityUnit,
    @Semantics.booleanIndicator: true
    _Defect.DefectIsCreatedAutomatically,
    _Defect.ProductionOrderOperationActy,
    _Defect.ProductionOrderOpActyVers,
    _Defect.Batch,
    _Defect.DefectiveSingleUnit,
    _Defect.ProductionOrder,
    _Defect.OrderInternalID,
    _Defect.CreationTime,
    _Defect.LastChangeTime,
    _Defect.DefectClass,
    _Defect.NumberOfDefects,
    _Defect.InspPlanOperationInternalID,
    _Defect.InspectionCharacteristic,
    _Defect.InspectionSubsetInternalID,
    _Defect.MaterialSample,
    _Defect.WorkCenterTypeCode,
    _Defect.MainWorkCenterInternalID,
    _Defect.MainWorkCenterPlant,
    _Defect.MainWorkCenter,
    _Defect.Equipment,
    _Defect.FunctionalLocation,
    _Defect.IsDeleted,
    _Defect.DefectOrigin,
    _Defect.Material,
    _Defect.Plant,
    _Defect.InspectionLot,
    _Defect.CatalogProfile,
    _Defect.ChangedDateTime,
    _Defect.DefectLifecycleStatus,
    _Defect.ProblemAnalysisStatus,
    _Defect.QualityIssueReference,
    _Defect.MasterLanguage,
    _Defect.DefectUUID,
    _Defect.StorageLocation,
    _Defect.SourceStorageBin,
    _Defect.StorageType,
    _Defect.ProductionSupplyArea,
    _Defect.Warehouse,
    //needed for Print Optioning in BRF+

    cast( '00' as numc2 preserving type ) as BRFFunction,

    /* Associations */
     _CreatedByUserContactCard,
    _InspectionLot,
    _LastChangedByUserContactCard,
    _Product,
    _DefectAffectedObject, // List of affected Materials

    _DefectTask            // List of associated tasks

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECT_TP"
],
"ASSOCIATED":
[
"C_DEFECTAFFECTEDOBJECTFDP",
"C_DEFECTTASKFDP",
"E_NOTIFICATIONITEM",
"I_INSPECTIONLOT",
"I_PRODUCT",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_DEFECT_TP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/