C_DefectAffectedObjectFDP

DDL: C_DEFECTAFFECTEDOBJECTFDP SQL: CDEFECTAOFDP Type: view CONSUMPTION

FDP view for QM Defect Affected Object

C_DefectAffectedObjectFDP is a Consumption CDS View that provides data about "FDP view for QM Defect Affected Object" in SAP S/4HANA. It reads from 1 data source (I_DefectAffectedObjectTP) and exposes 13 fields with key fields DefectInternalID, DefectAffectedObject. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectAffectedObjectTP _DefectAffectedObjectTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_DefectFDP _Defect $projection.DefectInternalID = _Defect.DefectInternalID
[1..1] E_DefectAffectedObject _Extension $projection.DefectInternalID = _Extension.Notification and _Extension.NotificationItem = '0000' and $projection.DefectAffectedObject = _Extension.DefectAffectedObject

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTAOFDP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label FDP view for QM Defect Affected Object view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey DefectInternalID view
Metadata.allowExtensions true view
Consumption.semanticObject Defect view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID I_DefectAffectedObjectTP DefectInternalID
KEY DefectAffectedObject I_DefectAffectedObjectTP DefectAffectedObject
Defect I_DefectAffectedObjectTP Defect
DefectAffectedObjectType I_DefectAffectedObjectTP DefectAffectedObjectType
Material I_DefectAffectedObjectTP Material
DefectAffectedObjectQuantity I_DefectAffectedObjectTP DefectAffectedObjectQuantity
DefectAffcdObjQuantityUnit I_DefectAffectedObjectTP DefectAffcdObjQuantityUnit
Batch I_DefectAffectedObjectTP Batch
QltyTaskFollowUpAction I_DefectAffectedObjectTP QltyTaskFollowUpAction
QltyTaskFllwUpActionSts I_DefectAffectedObjectTP QltyTaskFllwUpActionSts
QualityTask I_DefectAffectedObjectTP QualityTask
DefectAffcdObjIsDefective I_DefectAffectedObjectTP DefectAffcdObjIsDefective
_Defect _Defect 
@AbapCatalog.sqlViewName: 'CDEFECTAOFDP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck: #MANDATORY,
    personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'FDP view for QM Defect Affected Object'
@VDM: {
    viewType: #CONSUMPTION,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #OUTPUT_FORM_DATA_PROVIDER ]
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #XL,
        serviceQuality: #C },
    representativeKey: 'DefectInternalID',
    semanticKey:  [ 'Defect' ]
}
@Metadata.allowExtensions: true
@Consumption.semanticObject: 'Defect'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_DefectAffectedObjectFDP as select from I_DefectAffectedObjectTP as _DefectAffectedObjectTP

  association [1..1] to C_DefectFDP        as _Defect                  on $projection.DefectInternalID = _Defect.DefectInternalID

  // Extension

  association [1..1] to E_DefectAffectedObject as _Extension           on $projection.DefectInternalID = _Extension.Notification
                                                                      and _Extension.NotificationItem = '0000'
                                                                      and $projection.DefectAffectedObject = _Extension.DefectAffectedObject

{
    @ObjectModel.readOnly: true
    key _DefectAffectedObjectTP.DefectInternalID,
    @ObjectModel.readOnly: true
    key _DefectAffectedObjectTP.DefectAffectedObject,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.Defect,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.DefectAffectedObjectType,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.Material,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.DefectAffectedObjectQuantity,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.DefectAffcdObjQuantityUnit,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.Batch,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.QltyTaskFollowUpAction,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.QltyTaskFllwUpActionSts,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.QualityTask,
    @ObjectModel.readOnly: true
    _DefectAffectedObjectTP.DefectAffcdObjIsDefective,
    // Assiciation for ACL

    _Defect
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECTAFFECTEDOBJECTTP"
],
"ASSOCIATED":
[
"C_DEFECTFDP",
"E_DEFECTAFFECTEDOBJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More