I_INSPECTIONISSUESBYORDER

CDS View

Inspection Issues By Order

I_INSPECTIONISSUESBYORDER is a CDS View in S/4HANA. Inspection Issues By Order. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MPEInspIssuesByProdnOrder view_entity from CONSUMPTION Inspection Issues by Production Order

Fields (2)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 1
OrderInternalBillOfOperations OrderInternalBillOfOperations 1 
@AbapCatalog.sqlViewName: 'IINSPISSBYORDER'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Issues By Order'
@VDM.viewType: #COMPOSITE
define view I_InspectionIssuesByOrder as select distinct from I_InspectionLot 

  association [0..1] to P_OrdCharcWithRjcn    as _OrdCharcWithRjcn
   on     $projection.OrderInternalBillOfOperations  = _OrdCharcWithRjcn.OrderInternalBillOfOperations

  association [0..1] to P_OrdUsgeDcsnWithRjcn    as _OrdUsgeDcsnWithRjcn
    on     $projection.OrderInternalBillOfOperations = _OrdUsgeDcsnWithRjcn.OrderInternalBillOfOperations

  association [0..1] to P_OrdInspPtWithRjcn as _OrdInspPtWithRjcn
    on     $projection.OrderInternalBillOfOperations = _OrdInspPtWithRjcn.OrderInternalBillOfOperations
       
{
    key I_InspectionLot.OrderInternalBillOfOperations,
        I_InspectionLot.ManufacturingOrder,

   case
    when _OrdCharcWithRjcn.OrderInternalBillOfOperations is not null
    then 'X' 
    else ' ' 
  end as InspHasRejectedCharc,
  
   case
    when _OrdInspPtWithRjcn.OrderInternalBillOfOperations is not null
    then 'X' 
    else ' ' 
  end as InspHasRejectedInspSubset,
  
  case
    when _OrdUsgeDcsnWithRjcn.OrderInternalBillOfOperations is not null
    then 'X' 
    else ' ' 
  end as InspHasRejectedInspLot
}
// Don't return records which are not related to an order

where     OrderInternalBillOfOperations <> '0000000000' // AUFPL, NUMC 10

      and ManufacturingOrder            <> ''           // AUFNR, CHAR 12

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONLOT",
"P_ORDCHARCWITHRJCN",
"P_ORDINSPPTWITHRJCN",
"P_ORDUSGEDCSNWITHRJCN"
],
"ASSOCIATED":
[
"P_ORDCHARCWITHRJCN",
"P_ORDINSPPTWITHRJCN",
"P_ORDUSGEDCSNWITHRJCN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More