C_DefectRecordAffectedObject

DDL: C_DEFECTRECORDAFFECTEDOBJECT SQL: CDEFRECAFFCDOBJ Type: view CONSUMPTION

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)

SourceAliasJoin Type
I_DefectAffectedObjectTP _DefectAffectedObjectTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DefectRecord _Defect $projection.DefectInternalID = _Defect.DefectInternalID

Annotations (17)

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

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