C_SFIMfgDefectDcsnScrap

DDL: C_SFIMFGDEFECTDCSNSCRAP SQL: CSFIMFGDEFSCRAP Type: view CONSUMPTION Package: MPE_EXEC_NON_CONFORMANCE

View for SFI with decision Scrap

C_SFIMfgDefectDcsnScrap is a Consumption CDS View that provides data about "View for SFI with decision Scrap" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrdDefectDecision, I_Defect_TP) and exposes 2 fields with key field ShopFloorItem. Part of development package MPE_EXEC_NON_CONFORMANCE.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrdDefectDecision DefectDecision inner
I_Defect_TP DefectTP inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CSFIMFGDEFSCRAP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for SFI with decision Scrap view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem InspectionSubset ShopFloorItem
Defect 
@AbapCatalog.sqlViewName: 'CSFIMFGDEFSCRAP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'View for SFI with decision Scrap'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM: {viewType: #CONSUMPTION}
define view C_SFIMfgDefectDcsnScrap
  as select distinct from I_InspectionSubset     as InspectionSubset
    inner join            I_Defect_TP            as DefectTP       on  DefectTP.InspectionLot               = InspectionSubset.InspectionLot
                                                                   and DefectTP.InspPlanOperationInternalID = InspectionSubset.InspPlanOperationInternalID
                                                                   and DefectTP.InspectionSubsetInternalID  = InspectionSubset.InspectionSubsetInternalID
    inner join            I_MfgOrdDefectDecision as DefectDecision on  DefectDecision.Notification     = DefectTP.DefectInternalID
                                                                   and DefectDecision.NotificationItem = '0000'
{
  key InspectionSubset.ShopFloorItem,
      max(DefectTP.Defect) as Defect
}
where
      DefectDecision.MfgDefectDecision            =  '2'
  and InspectionSubset.InspectionSubsetInternalID <> '000000'
group by
  ShopFloorItem

Learn More