C_DefectRecordAffectedObject
Object Affected by Defect
C_DefectRecordAffectedObject is a Consumption CDS View that provides data about "Object Affected by Defect" in SAP S/4HANA. It reads from 1 data source (I_DefectAffectedObjectTP) and exposes 21 fields with key fields DefectInternalID, DefectAffectedObject. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DefectAffectedObjectTP | _DefectAffectedObjectTP | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | C_DefectRecord | _Defect | $projection.DefectInternalID = _Defect.DefectInternalID |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CDEFRECAFFCDOBJ | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Object Affected by Defect | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.representativeKey | DefectAffectedObject | view | |
| ObjectModel.compositionRoot | false | view | |
| ObjectModel.transactionalProcessingDelegated | true | view | |
| ObjectModel.createEnabled | false | view | |
| ObjectModel.updateEnabled | EXTERNAL_CALCULATION | view | |
| ObjectModel.deleteEnabled | false | view | |
| Metadata.allowExtensions | true | view |
Fields (21)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DefectInternalID | I_DefectAffectedObjectTP | DefectInternalID | |
| KEY | DefectAffectedObject | I_DefectAffectedObjectTP | DefectAffectedObject | |
| DefectAffectedObjectType | I_DefectAffectedObjectTP | DefectAffectedObjectType | ||
| Material | I_DefectAffectedObjectTP | Material | ||
| ProductName | ||||
| DefectAffectedObjectQuantity | I_DefectAffectedObjectTP | DefectAffectedObjectQuantity | ||
| QltyTaskFollowUpAction | I_DefectAffectedObjectTP | QltyTaskFollowUpAction | ||
| QltyTaskFllwUpActionSts | I_DefectAffectedObjectTP | QltyTaskFllwUpActionSts | ||
| QualityTask | I_DefectAffectedObjectTP | QualityTask | ||
| QualityTaskInternalId | I_DefectAffectedObjectTP | QualityTaskInternalId | ||
| QltyTskFllwUpActnSimlnRslt | I_DefectAffectedObjectTP | QltyTskFllwUpActnSimlnRslt | ||
| DefectAffcdObjQuantityUnit | I_DefectAffectedObjectTP | DefectAffcdObjQuantityUnit | ||
| Batch | I_DefectAffectedObjectTP | Batch | ||
| Plant | _Defect | Plant | ||
| DefectAffcdObjIsDefective | I_DefectAffectedObjectTP | DefectAffcdObjIsDefective | ||
| _Defect | _Defect | |||
| _DefectAffcdObjQuantityUnit | I_DefectAffectedObjectTP | _DefectAffcdObjQuantityUnit | ||
| _Product | _Product | |||
| _QltyTskFllwUpActnSimlnRslt | _QltyTskFllwUpActnSimlnRslt | |||
| _QltyTaskFollowUpAction | I_DefectAffectedObjectTP | _QltyTaskFollowUpAction | ||
| _QltyTaskFllwUpActionSts | I_DefectAffectedObjectTP | _QltyTaskFllwUpActionSts |
@AbapCatalog.sqlViewName: 'CDEFRECAFFCDOBJ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Object Affected by Defect'
@VDM: {
viewType: #CONSUMPTION
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #M,
serviceQuality: #C },
representativeKey: 'DefectAffectedObject',
semanticKey: [ 'DefectInternalID', 'DefectAffectedObject' ],
// Begin Draft 2.0
compositionRoot: false,
transactionalProcessingDelegated:true,
createEnabled: false,
updateEnabled: 'EXTERNAL_CALCULATION',
deleteEnabled: false
// End Draft
}
@Metadata.allowExtensions: true
define view C_DefectRecordAffectedObject as select from I_DefectAffectedObjectTP as _DefectAffectedObjectTP
association [1..1] to C_DefectRecord as _Defect on $projection.DefectInternalID = _Defect.DefectInternalID
{
@ObjectModel.foreignKey.association: '_Defect'
key _DefectAffectedObjectTP.DefectInternalID,
key _DefectAffectedObjectTP.DefectAffectedObject,
_DefectAffectedObjectTP.DefectAffectedObjectType,
@ObjectModel.text.element: ['ProductName']
@Consumption: {
valueHelpDefinition: [
{ entity: { name: 'I_ProductVH',
element: 'Product' }
},
{ entity: { name: 'I_ProductPlantVH',
element: 'Product' },
qualifier: 'vh_productplant_vh',
additionalBinding: [{ localElement: 'Plant', element: 'Plant', usage: #FILTER }]
}
],
semanticObject: 'Material'
}
_DefectAffectedObjectTP.Material,
@ObjectModel.readOnly: true
_DefectAffectedObjectTP._Product._Text[1: Language = $session.system_language ].ProductName,
_DefectAffectedObjectTP.DefectAffectedObjectQuantity,
_DefectAffectedObjectTP.QltyTaskFollowUpAction,
_DefectAffectedObjectTP.QltyTaskFllwUpActionSts,
_DefectAffectedObjectTP.QualityTask,
_DefectAffectedObjectTP.QualityTaskInternalId,
_DefectAffectedObjectTP.QltyTskFllwUpActnSimlnRslt,
@ObjectModel.sort.enabled: false
@ObjectModel.filter.enabled: false
@Consumption: {
valueHelpDefinition: [
{ entity: { name: 'I_ProductUnitsOfMeasureVH',
element: 'AlternativeUnit' },
additionalBinding: [{ localElement: 'Material',
element: 'Product' }]
},
{ entity: { name: 'I_UnitOfMeasureStdVH',
element: 'UnitOfMeasure' },
qualifier: 'vh_uom_stdvh'
}
]
}
_DefectAffectedObjectTP.DefectAffcdObjQuantityUnit,
@Consumption: {
semanticObject: 'Batch',
valueHelpDefinition: [
{ entity: { name: 'I_BatchVH', element: 'Batch' },
additionalBinding: [{ element: 'Plant', localElement: 'Plant', usage: #FILTER }, { element: 'Material', localElement: 'Material' }]
}]
}
_DefectAffectedObjectTP.Batch,
// Necessary for value help of Batch
@ObjectModel.readOnly: true
_Defect.Plant,
@ObjectModel.readOnly: true
@Semantics.booleanIndicator: true
_DefectAffectedObjectTP.DefectAffcdObjIsDefective,
// Associations
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
_Defect,
_DefectAffectedObjectTP._DefectAffcdObjQuantityUnit,
_Product,
_QltyTskFllwUpActnSimlnRslt,
_DefectAffectedObjectTP._QltyTaskFollowUpAction,
_DefectAffectedObjectTP._QltyTaskFllwUpActionSts
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_DEFECTRECORD",
"I_DEFECTAFFECTEDOBJECTTP",
"I_PRODUCT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"C_DEFECTRECORD",
"I_PRODUCT",
"I_QLTYTASKFLLWUPACTIONSTS",
"I_QLTYTASKFOLLOWUPACTION",
"I_QLTYTSKFLLWUPACTNSIMLNRSLT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_DEFECTAFFECTEDOBJECTTP"
],
"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