P_EWM_QltyInspectionEmbedded

DDL: P_EWM_QLTYINSPECTIONEMBEDDED Type: view_entity COMPOSITE

P_EWM_QltyInspectionEmbedded is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_Defect, I_InspectionLotUUID, I_InspectionPartialLotUUID) and exposes 6 fields with key field QualityInspectionDocUUID.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_Defect I_Defect from
I_InspectionLotUUID I_InspectionLotUUID union_all
I_InspectionPartialLotUUID I_InspectionPartialLotUUID union_all

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY QualityInspectionDocUUID
QualityInspectionDocument
QualityInspectionDocument
QualityInspectionDocument
QualityInspectionDocument
InspectionPartialLot 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #TRANSACTIONAL
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_EWM_QltyInspectionEmbedded as select from I_Defect {
  key cast( DefectUUID as /scwm/de_inspid preserving type ) as QualityInspectionDocUUID,
      cast( Defect as /scwm/de_qentity_extid ) as QualityInspectionDocument,
      cast( '000000' as ewm_de_inspectionpartiallot preserving type ) as InspectionPartialLot
}where DefectUUID <> hextobin('00000000000000000000000000000000')

union all select from I_InspectionLotUUID {
  key cast( InspectionLotUUID as /scwm/de_inspid preserving type ) as QualityInspectionDocUUID,
  cast( InspectionLot as /scwm/de_qentity_extid ) as QualityInspectionDocument,
        cast( '000000' as ewm_de_inspectionpartiallot preserving type ) as InspectionPartialLot
} where InspectionLotUUID <> hextobin('00000000000000000000000000000000')

union all select distinct from I_InspectionOutcomeItemBasic {
  key cast( InspectionOutcomeUUID as /scwm/de_inspid preserving type ) as QualityInspectionDocUUID,
      cast( InspectionDocument as /scwm/de_qentity_extid ) as QualityInspectionDocument,
      cast( '000000' as ewm_de_inspectionpartiallot preserving type ) as InspectionPartialLot
} where InspectionOutcomeUUID <> hextobin('00000000000000000000000000000000')

union all select from I_InspectionPartialLotUUID {
  key cast( InspectionPartialLotUUID as /scwm/de_inspid preserving type )  as QualityInspectionDocUUID,
      cast( InspectionLot  as /scwm/de_qentity_extid ) as QualityInspectionDocument,
     cast( InspectionPartialLot as ewm_de_inspectionpartiallot preserving type ) as InspectionPartialLot
} where InspectionPartialLotUUID <> hextobin('00000000000000000000000000000000')
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECT",
"I_INSPECTIONLOTUUID",
"I_INSPECTIONOUTCOMEITEMBASIC",
"I_INSPECTIONPARTIALLOTUUID"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More